51 lines
1.5 KiB
SQL
51 lines
1.5 KiB
SQL
CREATE TABLE IF NOT EXISTS game (
|
|
"id" SERIAL PRIMARY KEY,
|
|
"gamePk" INT,
|
|
"link" TEXT,
|
|
"gameType" TEXT,
|
|
"season" INT,
|
|
"gameDate" TEXT,
|
|
"officialDate" TIMESTAMP,
|
|
"status_abstractGameState" TEXT,
|
|
"status_codedGameState" TEXT,
|
|
"status_detailedState" TEXT,
|
|
"status_statusCode" TEXT,
|
|
"status_startTimeTBD" BOOLEAN,
|
|
"status_abstractGameCode" TEXT,
|
|
"teams_away_leagueRecord_wins" INT,
|
|
"teams_away_leagueRecord_losses" INT,
|
|
"teams_away_leagueRecord_pct" NUMERIC(4, 3),
|
|
"teams_away_score" INT,
|
|
"teams_away_teamId" INT,
|
|
"teams_away_isWinner" BOOLEAN,
|
|
"teams_away_splitSquad" BOOLEAN,
|
|
"teams_away_seriesNumber" INT,
|
|
"teams_home_leagueRecord_wins" INT,
|
|
"teams_home_leagueRecord_losses" INT,
|
|
"teams_home_leagueRecord_pct" NUMERIC(4, 3),
|
|
"teams_home_score" INT,
|
|
"teams_home_teamId" INT,
|
|
"teams_home_isWinner" BOOLEAN,
|
|
"teams_home_splitSquad" BOOLEAN,
|
|
"teams_home_seriesNumber" INT,
|
|
"venueId" INT,
|
|
"content_link" TEXT,
|
|
"isTie" BOOLEAN,
|
|
"gameNumber" INT,
|
|
"publicFacing" BOOLEAN,
|
|
"doubleHeader" TEXT,
|
|
"gamedayType" TEXT,
|
|
"tiebreaker" TEXT,
|
|
"calendarEventID" TEXT,
|
|
"seasonDisplay" INT,
|
|
"dayNight" TEXT,
|
|
"scheduledInnings" INT,
|
|
"reverseHomeAwayStatus" BOOLEAN,
|
|
"inningBreakLength" INT,
|
|
"gamesInSeries" INT,
|
|
"seriesGameNumber" INT,
|
|
"seriesDescription" TEXT,
|
|
"recordSource" TEXT,
|
|
"ifNecessary" TEXT,
|
|
"ifNecessaryDescription" TEXT
|
|
); |