COACHPRIMARY KEY (COACH_NUMBER); FOREIGN KEY (TEAM_NUMBER_FK) REFERENCES ORGANIZATOR (TEAM_NUMBER); TABLE TEAM
(_NUMBER INTEGER NOT NULL, _NAME VARCHAR (255) NOT NULL, _COLOUR CHAR (18) NOT NULL, VARCHAR (255) NOT NULL, KEY (TEAM_NUMBER)
); TABLE MATCH
(_NUMBER INTEGER NOT NULL, _DATE DATE NOT NULL, _MATCH VARCHAR (255) NOT NULL, KEY (MATCH_NUMBER)
); TABLE COACHFOREIGN KEY (FIRST_TEAM_FK) REFERENCES ORGANIZATOR (FIRST_TEAM); FOREIGN KEY (TURNIR_NUMBER_FK) REFERENCES ORGANIZATOR (TURNIR_NUMBER); FOREIGN KEY (TEAM_NUMBER_FK) REFERENCES ORGANIZATOR (TEAM_NUMBER); TABLE TURNIR
(_NUMBER INTEGER NOT NULL, _FOND VARCHAR (18,4) NOT NULL, _DATE DATE NOT NULL, DATETIME NOT NULL, KEY (TURNIR_NUMBER)
);
