+ scoringsystem INTEGER NOT NULL REFERENCES scoringsystems,
+
+ 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,
+
+ UNIQUE (tournament, player),
+ PRIMARY KEY (tournament, ranking)