디비과제
테이블 (4)
Game
- game_id — INTEGER — 기본 키
- home_team_id — INTEGER
- away_team_id — INTEGER
- game_date — DATE
Player
- player_id — INTEGER — 기본 키
- name — VARCHAR(255) — NOT NULL
- position — VARCHAR(50)
- number — INTEGER
- team_id (team_id2) — INTEGER — 외래 키 → Team.team_id
Stat
- stat_id — INTEGER — 기본 키
- runs — INTEGER
- hits — INTEGER
- errors — INTEGER
- player_id (player_id2) — INTEGER — 외래 키 → Player.player_id
- game_id (game_id2) — INTEGER — 외래 키 → Game.game_id
Team
- team_id — INTEGER — 기본 키
- name — VARCHAR(255) — NOT NULL
- city — VARCHAR(255) — NOT NULL