chosen BOOLEAN,
score INTEGER CHECK (score IS NULL OR (score >= 0 AND score <= 10000)),
- FOREIGN KEY (song) REFERENCES songs (song),
FOREIGN KEY (song, playmode, difficulty) REFERENCES songratings (song, playmode, difficulty),
FOREIGN KEY (tournament, round, parallel, player) REFERENCES roundparticipation (tournament, round, parallel, player),
- UNIQUE (tournament, round, parallel, player, songnumber),
- PRIMARY KEY (tournament, round, parallel, player, song)
+ PRIMARY KEY (tournament, round, parallel, player, songnumber)
);