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