디비과제

테이블 (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