mlbti
Tables (15)
batters
- uid — int — Primary key — NOT NULL
- season — int — Primary key — NOT NULL
- player_uid — int — Foreign key → peoples.uid — NOT NULL
- teams_uid — int
- team_name — varchar(60)
- name — varchar(60)
- birthday — varchar(60)
- height — float
- weight — float
- position — varchar(10)
- left_hit_num — int
- right_hit_num — int
- left_twob_hit_num — int
- right_twob_hit_num — int
- left_threeb_hit_num — int
- right_threeb_hit_num — int
- left_hr_num — int
- right_hr_num — int
- left_pa_num — int
- right_pa_num — int
- left_at_bat_num — int
- right_at_bat_num — int
- left_r — int
- right_r — int
- left_rbi — int
- right_rbi — int
- right_game_num — int
- left_game_num — int
- left_ops — float
- right_ops — float
- left_bb_num — int
- right_bb_num — int
- left_ao_num — int
- right_ao_num — int
- left_dp_num — int
- right_dp_num — int
- left_sh_num — int
- right_sh_num — int
- left_sf_num — int
- right_sf_num — int
- left_ibb_num — int
- right_ibb_num — int
- player_weather_tmi — varchar(3000)
- average — float
- standard_deviation — float
- education — varchar(300)
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
cheering_comments
- uid — int — Primary key — NOT NULL
- game_uid — int — Foreign key → game_raw_datas.game_uid
- home_team_name — varchar(60)
- home_comments_num — varchar(60)
- away_team_name — varchar(60)
- away_comments_num — varchar(60)
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
game_raw_datas
- uid — int — Primary key — NOT NULL
- game_uid — int
- game_raw_data — json
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
notices
- uid — int — Primary key — NOT NULL
- title — varchar(60)
- author — varchar(60)
- content — varchar(60)
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
peoples
- uid — int — Primary key — NOT NULL
- fullName — varchar(60)
- link — varchar(45)
- firstName — varchar(45)
- lastName — varchar(45)
- birthDate — varchar(45)
- currentAge — varchar(45)
- birthCity — varchar(45)
- birthStateProvince — varchar(45)
- birthCountry — varchar(45)
- height — varchar(45)
- active — varchar(45)
- primaryPositionCode — varchar(45)
- primaryPositionName — varchar(45)
- primaryPositionType — varchar(45)
- primaryPositionAbbreviation — varchar(45)
- useName — varchar(45)
- middleName — varchar(45)
- boxscoreName — varchar(45)
- nickName — varchar(45)
- gender — varchar(45)
- isPlayer — varchar(45)
- isVerified — varchar(45)
- deathDate — varchar(45)
- deathCity — varchar(45)
- deathStateProvince — varchar(45)
- deathCountry — varchar(45)
- lastPlayedDate — varchar(45)
- mlbDebutDate — varchar(45)
- batSideCode — varchar(45)
- batSideDescription — varchar(45)
- pitchHandCode — varchar(45)
- pitchHandDescription — varchar(45)
- nameFirstLast — varchar(60)
- nameSlug — varchar(100)
- firstLastName — varchar(60)
- lastFirstName — varchar(60)
- lastInitName — varchar(45)
- initLastName — varchar(45)
- fullFMLName — varchar(60)
- fullLFMName — varchar(60)
- strikeZoneTop — varchar(45)
- strikeZoneBottom — varchar(45)
- primaryNumber — varchar(45)
- weight — varchar(45)
pitchers
- uid — int — Primary key — NOT NULL
- season — int — Primary key — NOT NULL
- player_uid — int — Foreign key → peoples.uid — NOT NULL
- team_uid — int
- team_name — varchar(60)
- name — varchar(60)
- birthday — varchar(60)
- height — float
- weight — float
- position — varchar(10)
- left_hit_num — int
- right_hit_num — int
- left_twob_hit_num — int
- right_twob_hit_num — int
- left_threeb_hit_num — int
- right_threeb_hit_num — int
- left_hr_num — int
- right_hr_num — int
- left_pa_num — int
- right_pa_num — int
- left_er — int
- right_er — int
- left_not_my_earned — run`
- right_not_my_earned — run`
- left_not_my_earned_run — int
- right_not_my_earned_run — int
- left_game_num — int
- right_game_num — int
- left_four_ball_num — int
- right_four_ball_num — int
- left_fly_out_num — int
- right_fly_out_num — int
- left_double_play_num — int
- right_double_play_num — int
- left_ibb_num — int
- right_ibb_num — int
- player_weather_tmi — varchar(3000)
- average — float
- standard_deviation — float
- education — varchar(300)
- win_num — int
- lose_num — int
- hold_num — int
- save_num — int
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
player_play_records
- uid — int — Primary key — NOT NULL
- batter_id — int
- name — varchar(60)
- season — int
- game_uid — int
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
schedules
- game_id — int — Primary key — NOT NULL
- game_datetime — varchar(45) — Primary key — NOT NULL
- game_date — varchar(45)
- game_type — varchar(45)
- status — varchar(45)
- away_name — varchar(45)
- home_name — varchar(45)
- away_id — varchar(45)
- home_id — varchar(45)
- doubleheader — varchar(45)
- game_num — varchar(45)
- home_probable_pitcher — varchar(45)
- away_probable_pitcher — varchar(45)
- home_pitcher_note — varchar(1000)
- away_pitcher_note — varchar(1000)
- away_score — varchar(45)
- home_score — varchar(45)
- current_inning — varchar(45)
- inning_state — varchar(45)
- venue_id — varchar(45)
- venue_name — varchar(45)
- winning_team — varchar(45)
- losing_team — varchar(45)
- winning_pitcher — varchar(45)
- losing_pitcher — varchar(45)
- save_pitcher — varchar(45)
- summary — varchar(1000)
simulation_results
- uid — int — Primary key — NOT NULL
- simulation_result — json
- game_uid — int — Foreign key → game_raw_datas.game_uid
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
team_detail_batters
- uid — int — Primary key — NOT NULL
- team_details_uid — int — Foreign key → team_details.uid
- game_num — int
- hit_num — int
- twob_hit_num — int
- threeb_hit_num — int
- hr_num — int
- tba_num — int
- score — int
- rbi — int
- ops — int
- bb_num — int
- ao_num — int
- double_play_num — int
- sb_num — int
- sf_num — int
- ibb_num — int
- avg — float
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
team_detail_pitchers
- uid — int — Primary key — NOT NULL
- team_details_uid — int — Foreign key → team_details.uid
- game_num — int
- era — float
- cg_num — int
- sho_num — int
- sv_num — int
- svo_num — int
- ip_num — float
- hit_num — int
- score — int
- er_num — int
- hr_num — int
- bb_num — int
- so_num — int
- whip_num — float
- ibb_num — int
- hbp_num — int
- win_num — int
- lose_num — int
- hold_num — int
- avg — float
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
team_details
- uid — int — Primary key — NOT NULL
- season — int — Primary key — NOT NULL
- team_uid — int — Primary key — NOT NULL
- team_name — varchar(60)
- avg — float
- standard_deviation — float
- rank — int
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
teams
- id — int — Primary key — NOT NULL
- name — varchar(45)
- season — varchar(45)
- allStarStatus — varchar(45)
- venueId — int
- venueName — varchar(45)
- teamCode — varchar(45)
- abbreviation — varchar(45)
- teamName — varchar(45)
- locationName — varchar(45)
- firstYearOfPlay — int
- leagueId — int
- leagueName — varchar(45)
- divisionId — int
- divisionName — varchar(45)
- sportId — int
- sportName — varchar(45)
- shortName — varchar(45)
- parentOrgName — varchar(45)
- parentOrgId — int
- franchiseName — varchar(45)
- clubName — varchar(45)
- active — tinyint(1)
- logo — varchar(400)
user_teams
- uid — int — Primary key — NOT NULL
- contents — varchar(60)
- peoples_uid — int — Foreign key → peoples.uid
- team_index — int
- position — varchar(20)
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL
users
- uid — int — Primary key — NOT NULL
- email — varchar(60) — NOT NULL
- nickname — varchar(60) — NOT NULL
- password — varchar(60) — NOT NULL
- grade — varchar(10)
- user_teams_uid — int — Foreign key → user_teams.uid
- creater — varchar(20)
- updater — varchar(20)
- create_time — timestamp
- update_time — timestamp — NOT NULL