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