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
);