scheduled_games

88 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: game_date, game_date (date)

CREATE TABLE scheduled_games (
    game_id INTEGER PRIMARY KEY,
    home_team_id INTEGER NOT NULL,
    away_team_id INTEGER NOT NULL,
    game_date DATE NOT NULL,
    FOREIGN KEY (home_team_id) REFERENCES team(team_id),
    FOREIGN KEY (away_team_id) REFERENCES team(team_id)
);