kbo_who_are_ya_v1
Tables (5)
BatterStat
- b_stat_id — long — Primary key — NOT NULL
- pa — int
- h — int
- 2b — int
- 3b — int
- hr — int
- sf — int
- bb — int
- ibb — int
- hbp — int
- slg — double
- obp (opb) — double
- wrc_plus — double
League_Stat
- lg_pa — int
- lg_r — int
- lg_h — int
- lg_2b — int
- lg_3b — int
- lg_hr — int
- lg_sf — int
- lg_bb — int
- lg_ibb — int
- lg_hbp — int
- lg_slg — double
- lg_obp — double
- lg_wOBA — double
PitcherStat
- p_stat_id — long — Primary key — NOT NULL
- era — double
- g — int
- cg — int
- sho — int
- w — int
- l — int
- sv — int
- hld — int
- ip — double
- so — int
- bb — int
- r — int
- er — int
- bsv — int
- whip — double
Player
- player_id — Long — Primary key — NOT NULL
- team_id — varchar — Foreign key → Team.team_id — NOT NULL
- stat_id — long — Foreign key → BatterStat.b_stat_id — NOT NULL
- p_stat_id — long — Foreign key → PitcherStat.p_stat_id — NOT NULL
- name — Varchar
- backNumber — Int
- position — Varchar
- playerHand — varchar
- weight — int
- height — int
- Field
Team
- team_id — varchar — Primary key — NOT NULL
- team_name — varchar
- gameCount — int
- parkFactor — double