location VARCHAR NOT NULL,
"date" DATE NOT NULL,
machine INTEGER NOT NULL REFERENCES machines,
- scoringsystem INTEGER NOT NULL REFERENCES scoringsystems
+ scoringsystem INTEGER NOT NULL REFERENCES scoringsystems,
+
+ UNIQUE ( season, name )
);
CREATE TABLE rounds (