Field 	Type 	Null 	Key 	Default 	Extra 	
GameID
	int(11)
	NO
	PRI
	NULL 	auto_increment
GamePk
	int(11)
	YES
	UNI
	NULL 	
Season
	int(11)
	NO
	PRI
	NULL 	
GameDate
	date
	YES
	MUL
	NULL 	
HomeTeam
	varchar(100)
	YES
	MUL
	NULL 	
AwayTeam
	varchar(100)
	YES
	MUL
	NULL 	
VenueID
	int(11)
	YES
		NULL 	
Venue
	varchar(150)
	YES
		NULL 	
DayNight
	varchar(10)
	YES
		NULL 	
GameType
	varchar(10)
	YES
		NULL 	
Status
	varchar(50)
	YES
		NULL 	
HomeScore
	tinyint(3) unsigned
	YES
		NULL 	
AwayScore
	tinyint(3) unsigned
	YES
		NULL 	
Weather
	varchar(255)
	YES
		NULL 	
WinningPitcher
	varchar(100)
	YES
		NULL 	
WinningPitcherID
	int(11)
	YES
		NULL 	
LosingPitcher
	varchar(100)
	YES
		NULL 	
SavePitcher
	varchar(100)
	YES
		NULL 	
BlownSavePitcher
	varchar(100)
	YES
		NULL 	
HomeStarter
	varchar(100)
	YES
		NULL 	
HomeStarterID
	int(11)
	YES
	MUL
	NULL 	
AwayStarter
	varchar(100)
	YES
		NULL 	
AwayStarterID
	int(11)
	YES
	MUL
	NULL 	
LastUpdated
	timestamp
	NO
		current_timestamp()
	on update current_timestamp()
HomeTeamFranchise
	varchar(100)
	YES
		NULL 	
AwayTeamFranchise
	varchar(100)
	YES
		NULL 	
CanonicalHome
	varchar(50)
	YES
		NULL 	
CanonicalAway
	varchar(50)
	YES
		NULL