CREATE TABLE MATCH (
mid INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT ,
home_tid INTEGER NOT NULL REFERENCES team( tid ) ,
away_tid INTEGER NOT NULL REFERENCES team( tid ) ,
week INTEGER NOT NULL ,
UNIQUE (
home_tid,
away_tid,
week
)
);