baseball

Tables (3)

Game

  • game_id — int — Primary key — NOT NULL
  • home_score — int
  • away_score — int
  • home_id — int — Foreign key → Team.team_id — NOT NULL
  • away_id — int — Foreign key → Team.team_id — NOT NULL

Inning

  • inning_id — int — Primary key — NOT NULL
  • game_id — int — Foreign key → Game.game_id — NOT NULL
  • innning_number — int
  • home_inning_score — int
  • away_inning_score — int

Team

  • team_id — int — Primary key — NOT NULL
  • team_name — varchar
  • team_ops — float
  • team_era — float