UNIQUE ( season, tournamentname )
);
+CREATE TABLE tournamentparticipation (
+ tournament INTEGER NOT NULL REFERENCES tournaments,
+ player INTEGER NOT NULL REFERENCES players,
+ paid BOOLEAN NOT NULL,
+
+ PRIMARY KEY ( tournament, player )
+);
+
CREATE TABLE tournamentrankings (
tournament INTEGER NOT NULL REFERENCES tournaments,
ranking INTEGER NOT NULL,
player INTEGER NOT NULL REFERENCES players,
- points INTEGER
+ points INTEGER,
UNIQUE (tournament, player),
PRIMARY KEY (tournament, ranking)