CREATE TABLE bigscreen.active_tournament (
tournament INTEGER NOT NULL PRIMARY KEY REFERENCES tournaments
);
-CREATE TABLE bigscreen.active_rounds (
+CREATE TABLE bigscreen.active_groups (
tournament INTEGER NOT NULL REFERENCES bigscreen.active_tournament,
round INTEGER NOT NULL,
+ parallel INTEGER NOT NULL,
- PRIMARY KEY ( tournament, round ),
- FOREIGN KEY ( tournament, round ) REFERENCES rounds
+ PRIMARY KEY ( tournament, round, parallel ),
+ FOREIGN KEY ( tournament, round, parallel ) REFERENCES groups
);
);