KBO Players

Tables (8)

attack_stat (Untitled4)

  • player_id — Foreign key → player.player_id — NOT NULL
  • season_id — Foreign key → season.season_id — NOT NULL
  • g
  • oWAR
  • dWAR
  • ePA
  • AB
  • R
  • H (HR)
  • RBI
  • SB
  • CS
  • GDP
  • AVG
  • OBP
  • SLG
  • wRC

defense_stat (Untitled7)

  • player_id — Foreign key → player.player_id — NOT NULL
  • season_id — Foreign key → season.season_id — NOT NULL
  • G
  • GS
  • ASS
  • E
  • RF9
  • Err RAA
  • POSAdj
  • 종합 RAA (RAA)
  • WAAwoPOS

fa_vote (Untitled6)

  • vote_id — Primary key — NOT NULL
  • player_id (player_id2) — Foreign key → player.player_id — NOT NULL
  • voted_amount
  • vote_date
  • voter_session_id

player (Untitled2)

  • player_id — Primary key — NOT NULL
  • team_id — Foreign key → team.team_id — NOT NULL
  • pos_id — Foreign key → position_detail.pos_id — NOT NULL
  • name
  • weight
  • height
  • birth_date (birthd_date)
  • signing_bonus
  • draft_rank
  • uniform_number (number)
  • career

position_detail (Untitled5)

  • pos_id — Primary key — NOT NULL
  • pos_name
  • pos_category

salary (Untitled3)

  • salary_id — Primary key — NOT NULL
  • player_id — Foreign key → player.player_id — NOT NULL
  • season_id — Foreign key → season.season_id — NOT NULL
  • amount (amount\)

season (Untitled)

  • season_id — Primary key — NOT NULL
  • year

team

  • team_id — Primary key — NOT NULL
  • team_name
  • region