sad

Tables (4)

Game

  • game_id — INTEGER — Primary key
  • home_team_id — INTEGER
  • away_team_id — INTEGER
  • game_date — DATE

Player

  • player_id — INTEGER — Primary key
  • team_id — INTEGER
  • name — VARCHAR(255) — NOT NULL
  • position — VARCHAR(50)
  • uniform_number — INTEGER
  • team_id (team_id2) — INTEGER — Foreign key → Team.team_id

Stat

  • stat_id — INTEGER — Primary key
  • game_id — INTEGER
  • player_id — INTEGER
  • runs — INTEGER
  • hits — INTEGER
  • errors — INTEGER
  • game_id (game_id2) — INTEGER — Foreign key → Game.game_id
  • player_id (player_id2) — INTEGER — Foreign key → Player.player_id

Team

  • team_id — INTEGER — Primary key
  • name — VARCHAR(255) — NOT NULL
  • city — VARCHAR(255) — NOT NULL