CREATE TABLE Team (
	TeamID INT NOT NULL AUTO_INCREMENT,
	ClubRef INT NOT NULL,
	Division INT(2),
	CoachRef INT NOT NULL,
	PRIMARY KEY(TeamID) 
	FOREIGN KEY(ClubRef) REFERENCES Club(ClubID),
	FOREIGN KEY(CoachRef) REFERENCES Coach(CoachID)
);

CREATE TABLE Club(
	ClubID INT NOT NULL AUTO_INCREMENT,
	Name VARCHAR(255) NOT NULL
	HomeGround VARCHAR(255) NOT NULL,
	PRIMARY KEY(ClubID)
);

CREATE TABLE Coach(
	CoachID INT NOT NULL AUTO_INCREMENT,
	FName VARCHAR(255) NOT NULL,
	LName  VARCHAR(255),
	Phone VARCHAR(8)
	PRIMARY KEY(CoachID)
);

CREATE TABLE Game(
	GameID
	#DatePlayed
	HomeID INT NOT NULL,
	AwayID INT NOT NULL,
	#Division INT(2) NOT NULL,
	Ground VARCHAR(255) NOT NULL,
	GameTime TIME NOT NULL,
	AwayScr INT,
	HomeScr INT,
	PRIMARY KEY(GameID),
	FOREIGN KEY(HomeID) REFERENCES Club(TeamID),
	FOREIGN KEY(AwayID) REFERENCES Club(TeamID)
);