FOREIGN KEY (tournament, round, parallel, player) REFERENCES roundparticipation (tournament, round, parallel, player),
PRIMARY KEY (tournament, round, parallel, player, songnumber)
);
+
+CREATE TABLE randomsongsused (
+ song INTEGER NOT NULL PRIMARY KEY REFERENCES songs
+);