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