BASEBALL

테이블 (4)

결승타자정보 (TB_batter)

  • BatterID — INT — 기본 키 — NOT NULL
  • GameID — INT — 외래 키 → 경기정보.GameID — NOT NULL
  • Name — VARCHAR(8)
  • AtBats — VARCHAR(8)
  • Hit_Homerun — VARCHAR(16)
  • BB — VARCHAR(8)
  • StrikeOut — VARCHAR(8)
  • RBI — VARCHAR(8)
  • Run — VARCHAR(8)
  • BA — VARCHAR(8)

경기정보 (TB_game)

  • GameID — INT — 기본 키 — NOT NULL
  • PlayedAt — DATETIME
  • AwayTeam — VARCHAR(4)
  • AwayScore — VARCHAR(16)
  • HomeTeam — VARCHAR(4)
  • HomeScore — VARCHAR(16)
  • Stadium — VARCHAR(4)
  • Broadcast — VARCHAR(255)

승리투수정보 (TB_winpitcher)

  • WinPitcherID — INT — 기본 키 — NOT NULL
  • GameID — INT — 외래 키 → 경기정보.GameID — NOT NULL
  • Name — VARCHAR(8)
  • Inning — VARCHAR(8)
  • Hit — VARCHAR(8)
  • BBHP — VARCHAR(8)
  • StrikeOut — VARCHAR(8)
  • Lose_Run — VARCHAR(16)
  • PitchingNumber — VARCHAR(16)
  • Era — VARCHAR(8)

패전투수정보 (TB_losepitcher)

  • LosePitcherID — INT — 기본 키 — NOT NULL
  • GameID — INT — 외래 키 → 경기정보.GameID — NOT NULL
  • Name — VARCHAR(8)
  • Inning — VARCHAR(8)
  • Hit — VARCHAR(8)
  • BBHP — VARCHAR(8)
  • StrikeOut — VARCHAR(8)
  • Lose_Run — VARCHAR(16)
  • PitchingNumber — VARCHAR(16)
  • Era — VARCHAR(8)