aSD

Tables (50)

cities

  • city_id — INT
  • nation_id — INT
  • state_id — INT
  • name — VARCHAR(80)
  • abbreviation — VARCHAR(10)
  • latitude — DOUBLE
  • longitude — DOUBLE
  • population — INT
  • main_language_id — INT

coaches

  • coach_id — INT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • nick_name — VARCHAR(50)
  • age — SMALLINT
  • date_of_birth — DATE
  • city_of_birth_id — INT
  • nation_id — INT
  • weight — SMALLINT
  • height — SMALLINT
  • position — SMALLINT
  • experience — SMALLINT
  • occupation — SMALLINT
  • team_id — INT
  • former_player_id — INT
  • quick_left — SMALLINT
  • contract_salary — INT
  • contract_years — SMALLINT
  • contract_extension_salary — INT
  • contract_extension_years — SMALLINT
  • scout_major — SMALLINT
  • scout_minor — SMALLINT
  • scout_international — SMALLINT
  • scout_amateur — SMALLINT
  • scout_amateur_preference — SMALLINT
  • teach_hitting — SMALLINT
  • teach_pitching — SMALLINT
  • teach_fielding — SMALLINT
  • handle_veterans — SMALLINT
  • handle_rookies — SMALLINT
  • handle_players — SMALLINT
  • strategy_knowledge — SMALLINT
  • heal_legs — SMALLINT
  • heal_arms — SMALLINT
  • heal_back — SMALLINT
  • heal_other — SMALLINT
  • heal_rest — SMALLINT
  • management_style — SMALLINT
  • personality — SMALLINT
  • hitting_focus — SMALLINT
  • pitching_focus — SMALLINT
  • training_focus — SMALLINT
  • teach_running — SMALLINT
  • prevent_legs — SMALLINT
  • prevent_arms — SMALLINT
  • prevent_back — SMALLINT
  • prevent_other — SMALLINT
  • stealing — INT
  • running — INT
  • pinchrun — INT
  • pinchhit_pos — INT
  • pinchhit_pitch — INT
  • hook_start — INT
  • hook_relief — INT
  • closer — INT
  • lr_matchup — INT
  • bunt_hit — INT
  • bunt — INT
  • hit_run — INT
  • run_hit — INT
  • … +26

continents

  • continent_id — INT
  • name — VARCHAR(50)
  • abbreviation — VARCHAR(50)
  • demonym — VARCHAR(50)
  • population — INT
  • main_language_id — INT

divisions

  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • name — VARCHAR(50)
  • gender — INT

game_logs

  • game_id — INT
  • type — SMALLINT
  • line — INT
  • text — VARCHAR(255)

games

  • game_id — INT
  • league_id — INT
  • home_team — INT
  • away_team — INT
  • attendance — INT
  • date — DATE
  • time — SMALLINT
  • game_type — SMALLINT
  • played — TINYINT
  • dh — TINYINT
  • innings — SMALLINT
  • runs0 — SMALLINT
  • runs1 — SMALLINT
  • hits0 — SMALLINT
  • hits1 — SMALLINT
  • errors0 — SMALLINT
  • errors1 — SMALLINT
  • winning_pitcher — INT
  • losing_pitcher — INT
  • save_pitcher — INT
  • starter0 — INT
  • starter1 — INT

games_score

  • game_id — INT
  • team — SMALLINT
  • inning — SMALLINT
  • score — SMALLINT

human_manager_history

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • best_hitter_id — INT
  • best_pitcher_id — INT
  • best_rookie_id — INT
  • manager_id — INT
  • made_playoffs — TINYINT
  • won_playoffs — TINYINT
  • fired — TINYINT
  • position_in_division — SMALLINT

human_manager_history_batting_stats

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • pa — INT
  • ab — INT
  • h — INT
  • k — INT
  • tb — INT
  • s — INT
  • d — INT
  • t — INT
  • hr — INT
  • sb — INT
  • cs — INT
  • rbi — INT
  • r — INT
  • bb — INT
  • ibb — INT
  • hp — INT
  • sh — INT
  • sf — INT
  • ci — INT
  • gdp — INT
  • g — INT
  • gs — INT
  • ebh — INT
  • pitches_seen — INT
  • avg — DOUBLE
  • obp — DOUBLE
  • slg — DOUBLE
  • rc — DOUBLE
  • rc27 — DOUBLE
  • iso — DOUBLE
  • tavg — DOUBLE
  • woba — DOUBLE
  • ops — DOUBLE
  • sbp — DOUBLE
  • ws — DOUBLE

human_manager_history_fielding_stats_stats

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • position — SMALLINT
  • g — INT
  • gs — INT
  • tc — INT
  • a — INT
  • po — INT
  • e — INT
  • dp — INT
  • tp — INT
  • pb — INT
  • sba — INT
  • rto — INT
  • er — INT
  • ip — INT
  • ipf — INT
  • pct — DOUBLE
  • range — DOUBLE
  • rtop — DOUBLE
  • cera — DOUBLE

human_manager_history_financials

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • gate_revenue — INT
  • media_revenue — INT
  • merchandising_revenue — INT
  • other_revenue — INT
  • revenue_sharing — INT
  • playoff_revenue — INT
  • cash — INT
  • player_expenses — INT
  • staff_expenses — INT
  • stadium_expenses — INT
  • attendance — INT
  • fan_interest — SMALLINT
  • fan_loyalty — SMALLINT
  • fan_modifier — SMALLINT
  • ticket_price — DOUBLE
  • budget — INT
  • market — SMALLINT
  • owner_expectation — SMALLINT

human_manager_history_pitching_stats

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • ab — INT
  • ip — INT
  • bf — INT
  • tb — INT
  • ha — INT
  • k — INT
  • rs — INT
  • bb — INT
  • r — INT
  • er — INT
  • gb — INT
  • fb — INT
  • pi — INT
  • ipf — INT
  • g — INT
  • gs — INT
  • w — INT
  • l — INT
  • s — INT
  • sa — INT
  • da — INT
  • sh — INT
  • sf — INT
  • ta — INT
  • hra — INT
  • bk — INT
  • ci — INT
  • iw — INT
  • wp — INT
  • hp — INT
  • gf — INT
  • dp — INT
  • qs — INT
  • svo — INT
  • bs — INT
  • ra — INT
  • cg — INT
  • sho — INT
  • sb — INT
  • cs — INT
  • hld — INT
  • r9 — DOUBLE
  • avg — DOUBLE
  • obp — DOUBLE
  • slg — DOUBLE
  • ops — DOUBLE
  • h9 — DOUBLE
  • k9 — DOUBLE
  • hr9 — DOUBLE
  • bb9 — DOUBLE
  • cgp — DOUBLE
  • cera — DOUBLE
  • … +14

human_manager_history_record

  • human_manager_id — INT
  • team_id — INT
  • year — SMALLINT
  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • g — SMALLINT
  • w — SMALLINT
  • l — SMALLINT
  • pos — SMALLINT
  • pct — DOUBLE
  • gb — DOUBLE
  • streak — SMALLINT
  • magic_number — SMALLINT

human_managers

  • human_manager_id — INT
  • is_commish — TINYINT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • nick_name — VARCHAR(50)
  • age — SMALLINT
  • date_of_birth — DATE
  • city_of_birth_id — INT
  • nation_id — INT
  • second_nation_id — INT
  • weight — SMALLINT
  • height — SMALLINT
  • retired — TINYINT
  • free_agent — TINYINT
  • league_id — INT
  • last_league_id — INT
  • team_id — INT
  • last_team_id — INT
  • organization_id — INT
  • last_organization_id — INT
  • language_ids0 — INT
  • language_ids1 — INT
  • uniform_number — SMALLINT
  • experience — SMALLINT
  • person_type — SMALLINT
  • bats — SMALLINT
  • throws — SMALLINT
  • personality_greed — SMALLINT
  • personality_loyalty — SMALLINT
  • personality_play_for_winner — SMALLINT
  • personality_work_ethic — SMALLINT
  • personality_intelligence — SMALLINT
  • personality_leader — SMALLINT

language_data

  • parent_table — INT
  • parent_id — INT
  • language_id — INT
  • percentage — INT

languages

  • language_id — INT
  • name — VARCHAR(50)

league_events

  • league_id — INT
  • start_date — DATE
  • type — INT
  • event_over — TINYINT
  • deleted — TINYINT
  • name — VARCHAR(50)
  • gender — INT
  • needs_human_action — TINYINT

league_history

  • league_id — INT
  • sub_league_id — INT
  • year — INT
  • best_hitter_id — INT
  • best_pitcher_id — INT
  • best_rookie_id — INT
  • best_manager_id — INT
  • best_fielder_id0 — INT
  • best_fielder_id1 — INT
  • best_fielder_id2 — INT
  • best_fielder_id3 — INT
  • best_fielder_id4 — INT
  • best_fielder_id5 — INT
  • best_fielder_id6 — INT
  • best_fielder_id7 — INT
  • best_fielder_id8 — INT
  • best_fielder_id9 — INT

league_history_all_star

  • league_id — INT
  • sub_league_id — INT
  • year — INT
  • all_star_pos — INT
  • all_star — INT

league_history_batting_stats

  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • pa — INT
  • ab — INT
  • h — INT
  • k — INT
  • tb — INT
  • s — INT
  • d — INT
  • t — INT
  • hr — INT
  • sb — INT
  • cs — INT
  • rbi — INT
  • r — INT
  • bb — INT
  • ibb — INT
  • hp — INT
  • sh — INT
  • sf — INT
  • ci — INT
  • gdp — INT
  • g — INT
  • gs — INT
  • ebh — INT
  • pitches_seen — INT
  • avg — DOUBLE
  • obp — DOUBLE
  • slg — DOUBLE
  • rc — DOUBLE
  • rc27 — DOUBLE
  • iso — DOUBLE
  • woba — DOUBLE
  • ops — DOUBLE
  • sbp — DOUBLE
  • ws — DOUBLE
  • kp — DOUBLE
  • bbp — DOUBLE
  • wpa — DOUBLE
  • babip — DOUBLE

league_history_fielding_stats

  • year — SMALLINT
  • team_id — INT
  • league_id — INT
  • sub_league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • position — SMALLINT
  • g — INT
  • gs — INT
  • tc — INT
  • a — INT
  • po — INT
  • e — INT
  • dp — INT
  • tp — INT
  • pb — INT
  • sba — INT
  • rto — INT
  • er — INT
  • ip — INT
  • ipf — INT
  • pct — DOUBLE
  • range — DOUBLE
  • rtop — DOUBLE
  • cera — DOUBLE
  • zr — DOUBLE
  • plays — INT
  • plays_base — INT
  • roe — INT
  • eff — INT

league_history_pitching_stats

  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • ab — INT
  • ip — INT
  • bf — INT
  • tb — INT
  • ha — INT
  • k — INT
  • rs — INT
  • bb — INT
  • r — INT
  • er — INT
  • gb — INT
  • fb — INT
  • pi — INT
  • ipf — INT
  • g — INT
  • gs — INT
  • w — INT
  • l — INT
  • s — INT
  • sa — INT
  • da — INT
  • sh — INT
  • sf — INT
  • ta — INT
  • hra — INT
  • bk — INT
  • ci — INT
  • iw — INT
  • wp — INT
  • hp — INT
  • gf — INT
  • dp — INT
  • qs — INT
  • svo — INT
  • bs — INT
  • ra — INT
  • ir — INT
  • irs — INT
  • cg — INT
  • sho — INT
  • sb — INT
  • cs — INT
  • hld — INT
  • r9 — DOUBLE
  • avg — DOUBLE
  • obp — DOUBLE
  • slg — DOUBLE
  • ops — DOUBLE
  • h9 — DOUBLE
  • k9 — DOUBLE
  • hr9 — DOUBLE
  • bb9 — DOUBLE
  • cgp — DOUBLE
  • fip — DOUBLE
  • … +15

league_playoff_fixtures

  • league_id — INT
  • team_id0 — INT
  • team_id1 — INT
  • winner — INT
  • finished — TINYINT
  • best_of — SMALLINT
  • played — SMALLINT
  • round — SMALLINT
  • result0 — SMALLINT
  • result1 — SMALLINT

league_playoffs

  • league_id — INT
  • play_off_mode — SMALLINT
  • round — SMALLINT
  • max_round — SMALLINT
  • num_wild_cards — SMALLINT
  • best_of0 — SMALLINT
  • best_of1 — SMALLINT
  • best_of2 — SMALLINT
  • best_of3 — SMALLINT
  • best_of4 — SMALLINT
  • best_of5 — SMALLINT
  • best_of6 — SMALLINT
  • best_of7 — SMALLINT
  • best_of8 — SMALLINT
  • best_of9 — SMALLINT
  • best_of10 — SMALLINT
  • best_of11 — SMALLINT
  • best_of12 — SMALLINT
  • best_of13 — SMALLINT
  • best_of14 — SMALLINT
  • best_of15 — SMALLINT
  • best_of16 — SMALLINT
  • best_of17 — SMALLINT
  • best_of18 — SMALLINT
  • best_of19 — SMALLINT
  • best_of20 — SMALLINT
  • best_of21 — SMALLINT
  • best_of22 — SMALLINT
  • best_of23 — SMALLINT
  • best_of24 — SMALLINT
  • best_of25 — SMALLINT
  • best_of26 — SMALLINT
  • best_of27 — SMALLINT
  • best_of28 — SMALLINT
  • best_of29 — SMALLINT
  • best_of30 — SMALLINT
  • best_of31 — SMALLINT
  • best_of32 — SMALLINT
  • best_of33 — SMALLINT
  • best_of34 — SMALLINT
  • best_of35 — SMALLINT
  • best_of36 — SMALLINT
  • best_of37 — SMALLINT
  • best_of38 — SMALLINT
  • best_of39 — SMALLINT
  • best_of40 — SMALLINT
  • best_of41 — SMALLINT
  • best_of42 — SMALLINT
  • best_of43 — SMALLINT
  • best_of44 — SMALLINT
  • best_of45 — SMALLINT
  • best_of46 — SMALLINT
  • best_of47 — SMALLINT
  • best_of48 — SMALLINT
  • best_of49 — SMALLINT
  • round_names0 — VARCHAR(30)
  • round_names1 — VARCHAR(30)
  • round_names2 — VARCHAR(30)
  • round_names3 — VARCHAR(30)
  • round_names4 — VARCHAR(30)
  • … +49

leagues

  • league_id — INT
  • name — VARCHAR(50)
  • abbr — VARCHAR(50)
  • nation_id — INT
  • language_id — INT
  • gender — INT
  • historical_league — TINYINT
  • logo_file_name — VARCHAR(200)
  • players_path — VARCHAR(200)
  • start_date — DATE
  • preferred_start_date — DATE
  • pitcher_award_name — VARCHAR(50)
  • mvp_award_name — VARCHAR(50)
  • rookie_award_name — VARCHAR(50)
  • defense_award_name — VARCHAR(50)
  • fictional_players — TINYINT
  • start_fantasy_draft — TINYINT
  • trading_deadline — TINYINT
  • winter_meetings — TINYINT
  • arbitration_offering — TINYINT
  • show_draft_pool — TINYINT
  • rosters_expanded — TINYINT
  • draft_date — DATE
  • rule_5_draft_date — DATE
  • roster_expand_date — DATE
  • trade_deadline_date — DATE
  • allstar_date — DATE
  • days_until_deadline — INT
  • next_draft_type — INT
  • parent_league_id — INT
  • league_state — SMALLINT
  • season_year — INT
  • historical_year — SMALLINT
  • league_level — SMALLINT
  • stats_detail — INT
  • historical_import_path — VARCHAR(200)
  • foreigner_percentage — SMALLINT
  • was_ootp6 — TINYINT
  • was_65 — TINYINT
  • allstar_game — TINYINT
  • auto_schedule_allstar — TINYINT
  • allstar_team_id0 — INT
  • allstar_team_id1 — INT
  • schedule_file_1 — VARCHAR(200)
  • schedule_file_2 — VARCHAR(200)
  • rules_rule_5 — TINYINT
  • rules_minor_league_options — TINYINT
  • rules_trading — TINYINT
  • rules_draft_pick_trading — TINYINT
  • rules_financials — TINYINT
  • rules_amateur_draft — TINYINT
  • rules_fa_compensation — TINYINT
  • rules_schedule_balanced — TINYINT
  • rules_schedule_inter_league — TINYINT
  • rules_schedule_force_start_day — TINYINT
  • rules_trades_other_leagues — TINYINT
  • rules_free_agents_from_other_leagues — TINYINT
  • rules_free_agents_leave_other_leagues — TINYINT
  • rules_allstar_game — TINYINT
  • rules_spring_training — TINYINT
  • … +96

nations

  • nation_id — INT
  • name — VARCHAR(50)
  • short_name — VARCHAR(50)
  • abbreviation — VARCHAR(50)
  • demonym — VARCHAR(50)
  • population — INT
  • gender — INT
  • baseball_quality — INT
  • continent_id — INT
  • main_language_id — INT
  • quality_total — INT
  • capital_id — INT
  • use_hardcoded_ml_player_origins — TINYINT
  • this_is_the_usa — TINYINT

parks

  • park_id — INT
  • dimensions_x — SMALLINT
  • dimensions_y — SMALLINT
  • batter_left_x — SMALLINT
  • batter_left_y — SMALLINT
  • batter_right_x — SMALLINT
  • batter_right_y — SMALLINT
  • bases_x0 — SMALLINT
  • bases_x1 — SMALLINT
  • bases_x2 — SMALLINT
  • bases_y0 — SMALLINT
  • bases_y1 — SMALLINT
  • bases_y2 — SMALLINT
  • positions_x0 — SMALLINT
  • positions_x1 — SMALLINT
  • positions_x2 — SMALLINT
  • positions_x3 — SMALLINT
  • positions_x4 — SMALLINT
  • positions_x5 — SMALLINT
  • positions_x6 — SMALLINT
  • positions_x7 — SMALLINT
  • positions_x8 — SMALLINT
  • positions_x9 — SMALLINT
  • positions_y0 — SMALLINT
  • positions_y1 — SMALLINT
  • positions_y2 — SMALLINT
  • positions_y3 — SMALLINT
  • positions_y4 — SMALLINT
  • positions_y5 — SMALLINT
  • positions_y6 — SMALLINT
  • positions_y7 — SMALLINT
  • positions_y8 — SMALLINT
  • positions_y9 — SMALLINT
  • avg — DOUBLE
  • avg_l — DOUBLE
  • avg_r — DOUBLE
  • d — DOUBLE
  • t — DOUBLE
  • hr — DOUBLE
  • hr_r — DOUBLE
  • hr_l — DOUBLE
  • temperature0 — SMALLINT
  • temperature1 — SMALLINT
  • temperature2 — SMALLINT
  • temperature3 — SMALLINT
  • temperature4 — SMALLINT
  • temperature5 — SMALLINT
  • temperature6 — SMALLINT
  • temperature7 — SMALLINT
  • temperature8 — SMALLINT
  • temperature9 — SMALLINT
  • temperature10 — SMALLINT
  • temperature11 — SMALLINT
  • rain0 — SMALLINT
  • rain1 — SMALLINT
  • rain2 — SMALLINT
  • rain3 — SMALLINT
  • rain4 — SMALLINT
  • rain5 — SMALLINT
  • rain6 — SMALLINT
  • … +33

players

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • first_name — VARCHAR(50)
  • last_name — VARCHAR(50)
  • nick_name — VARCHAR(50)
  • age — SMALLINT
  • date_of_birth — DATE
  • city_of_birth_id — INT
  • nation_id — INT
  • second_nation_id — INT
  • weight — SMALLINT
  • height — SMALLINT
  • retired — TINYINT
  • free_agent — TINYINT
  • last_league_id — INT
  • last_team_id — INT
  • organization_id — INT
  • last_organization_id — INT
  • language_ids0 — INT
  • language_ids1 — INT
  • uniform_number — SMALLINT
  • experience — SMALLINT
  • person_type — SMALLINT
  • bats — SMALLINT
  • throws — SMALLINT
  • personality_greed — SMALLINT
  • personality_loyalty — SMALLINT
  • personality_play_for_winner — SMALLINT
  • personality_work_ethic — SMALLINT
  • personality_intelligence — SMALLINT
  • personality_leader — SMALLINT
  • historical_id — VARCHAR(50)
  • historical_team_id — VARCHAR(50)
  • best_contract_offer_id — INT
  • injury_is_injured — TINYINT
  • injury_dtd_injury — TINYINT
  • injury_career_ending — TINYINT
  • injury_dl_left — SMALLINT
  • injury_left — SMALLINT
  • dtd_injury_effect — SMALLINT
  • injury_id — INT
  • prone_overall — SMALLINT
  • prone_leg — SMALLINT
  • prone_back — SMALLINT
  • prone_arm — SMALLINT
  • fatigue_pitches0 — SMALLINT
  • fatigue_pitches1 — SMALLINT
  • fatigue_pitches2 — SMALLINT
  • fatigue_pitches3 — SMALLINT
  • fatigue_pitches4 — SMALLINT
  • fatigue_pitches5 — SMALLINT
  • fatigue_points — SMALLINT
  • fatigue_played_today — TINYINT
  • running_ratings_speed — SMALLINT
  • running_ratings_stealing — SMALLINT
  • running_ratings_baserunning — SMALLINT
  • position — SMALLINT
  • role — SMALLINT
  • college — TINYINT
  • … +39

players_at_bat_batting_stats

  • player_id — INT
  • game_id — INT
  • opponent_player_id — INT
  • team_id — INT
  • sac — TINYINT
  • balls — SMALLINT
  • strikes — SMALLINT
  • result — SMALLINT
  • base1 — TINYINT
  • base2 — TINYINT
  • base3 — TINYINT
  • close — TINYINT
  • pinch — TINYINT
  • inning — SMALLINT
  • outs — SMALLINT
  • sb — SMALLINT
  • cs — SMALLINT
  • rbi — SMALLINT
  • r — SMALLINT
  • spot — SMALLINT

players_awards

  • player_id — INT
  • league_id — INT
  • team_id — INT
  • sub_league_id — SMALLINT
  • award_id — SMALLINT
  • year — SMALLINT
  • season — SMALLINT
  • position — SMALLINT
  • day — SMALLINT
  • month — SMALLINT

players_batting

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • batting_ratings_overall_contact — SMALLINT
  • batting_ratings_overall_gap — SMALLINT
  • batting_ratings_overall_eye — SMALLINT
  • batting_ratings_overall_strikeouts — SMALLINT
  • batting_ratings_overall_hp — SMALLINT
  • batting_ratings_overall_power — SMALLINT
  • batting_ratings_overall_babip — SMALLINT
  • batting_ratings_vsr_contact — SMALLINT
  • batting_ratings_vsr_gap — SMALLINT
  • batting_ratings_vsr_eye — SMALLINT
  • batting_ratings_vsr_strikeouts — SMALLINT
  • batting_ratings_vsr_hp — SMALLINT
  • batting_ratings_vsr_power — SMALLINT
  • batting_ratings_vsr_babip — SMALLINT
  • batting_ratings_vsl_contact — SMALLINT
  • batting_ratings_vsl_gap — SMALLINT
  • batting_ratings_vsl_eye — SMALLINT
  • batting_ratings_vsl_strikeouts — SMALLINT
  • batting_ratings_vsl_hp — SMALLINT
  • batting_ratings_vsl_power — SMALLINT
  • batting_ratings_vsl_babip — SMALLINT
  • batting_ratings_talent_contact — SMALLINT
  • batting_ratings_talent_gap — SMALLINT
  • batting_ratings_talent_eye — SMALLINT
  • batting_ratings_talent_strikeouts — SMALLINT
  • batting_ratings_talent_hp — SMALLINT
  • batting_ratings_talent_power — SMALLINT
  • batting_ratings_talent_babip — SMALLINT
  • batting_ratings_misc_bunt — SMALLINT
  • batting_ratings_misc_bunt_for_hit — SMALLINT
  • batting_ratings_misc_hitter_type — SMALLINT
  • batting_ratings_misc_groundball_pct — SMALLINT

players_career_batting_stats

  • player_id — INT
  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • position — SMALLINT
  • ab — SMALLINT
  • h — SMALLINT
  • k — SMALLINT
  • pa — SMALLINT
  • pitches_seen — SMALLINT
  • g — SMALLINT
  • gs — SMALLINT
  • d — SMALLINT
  • t — SMALLINT
  • hr — SMALLINT
  • r — SMALLINT
  • rbi — SMALLINT
  • sb — SMALLINT
  • cs — SMALLINT
  • bb — SMALLINT
  • ibb — SMALLINT
  • gdp — SMALLINT
  • sh — SMALLINT
  • sf — SMALLINT
  • hp — SMALLINT
  • ci — SMALLINT
  • wpa — DOUBLE
  • stint — SMALLINT
  • war — DOUBLE

players_career_fielding_stats

  • player_id — INT
  • year — SMALLINT
  • team_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • position — SMALLINT
  • tc — SMALLINT
  • a — SMALLINT
  • po — SMALLINT
  • er — SMALLINT
  • ip — SMALLINT
  • g — SMALLINT
  • gs — SMALLINT
  • e — SMALLINT
  • dp — SMALLINT
  • tp — SMALLINT
  • pb — SMALLINT
  • sba — SMALLINT
  • rto — SMALLINT
  • ipf — SMALLINT
  • plays — SMALLINT
  • plays_base — SMALLINT
  • roe — SMALLINT
  • zr — DOUBLE

players_career_pitching_stats

  • player_id — INT
  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • ip — SMALLINT
  • ab — SMALLINT
  • tb — SMALLINT
  • ha — SMALLINT
  • k — SMALLINT
  • bf — SMALLINT
  • rs — SMALLINT
  • bb — SMALLINT
  • r — SMALLINT
  • er — SMALLINT
  • gb — SMALLINT
  • fb — SMALLINT
  • pi — SMALLINT
  • ipf — SMALLINT
  • g — SMALLINT
  • gs — SMALLINT
  • w — SMALLINT
  • l — SMALLINT
  • s — SMALLINT
  • sa — SMALLINT
  • da — SMALLINT
  • sh — SMALLINT
  • sf — SMALLINT
  • ta — SMALLINT
  • hra — SMALLINT
  • bk — SMALLINT
  • ci — SMALLINT
  • iw — SMALLINT
  • wp — SMALLINT
  • hp — SMALLINT
  • gf — SMALLINT
  • dp — SMALLINT
  • qs — SMALLINT
  • svo — SMALLINT
  • bs — SMALLINT
  • ra — SMALLINT
  • cg — SMALLINT
  • sho — SMALLINT
  • sb — SMALLINT
  • cs — SMALLINT
  • hld — SMALLINT
  • ir — DOUBLE
  • irs — DOUBLE
  • wpa — DOUBLE
  • stint — SMALLINT
  • outs — SMALLINT
  • war — DOUBLE

players_contract

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • is_major — TINYINT
  • no_trade — TINYINT
  • last_year_team_option — TINYINT
  • last_year_player_option — TINYINT
  • last_year_vesting_option — TINYINT
  • next_last_year_team_option — TINYINT
  • next_last_year_player_option — TINYINT
  • next_last_year_vesting_option — TINYINT
  • contract_team_id — INT
  • contract_league_id — INT
  • season_year — INT
  • salary0 — INT
  • salary1 — INT
  • salary2 — INT
  • salary3 — INT
  • salary4 — INT
  • salary5 — INT
  • salary6 — INT
  • salary7 — INT
  • salary8 — INT
  • salary9 — INT
  • years — SMALLINT
  • current_year — SMALLINT
  • minimum_pa — SMALLINT
  • minimum_pa_bonus — INT
  • minimum_ip — SMALLINT
  • minimum_ip_bonus — INT
  • mvp_bonus — INT
  • cyyoung_bonus — INT
  • allstar_bonus — INT
  • next_last_year_option_buyout — INT
  • last_year_option_buyout — INT

players_contract_extension

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • is_major — TINYINT
  • no_trade — TINYINT
  • last_year_team_option — TINYINT
  • last_year_player_option — TINYINT
  • last_year_vesting_option — TINYINT
  • next_last_year_team_option — TINYINT
  • next_last_year_player_option — TINYINT
  • next_last_year_vesting_option — TINYINT
  • contract_team_id — INT
  • contract_league_id — INT
  • season_year — INT
  • salary0 — INT
  • salary1 — INT
  • salary2 — INT
  • salary3 — INT
  • salary4 — INT
  • salary5 — INT
  • salary6 — INT
  • salary7 — INT
  • salary8 — INT
  • salary9 — INT
  • years — SMALLINT
  • current_year — SMALLINT
  • minimum_pa — SMALLINT
  • minimum_pa_bonus — INT
  • minimum_ip — SMALLINT
  • minimum_ip_bonus — INT
  • mvp_bonus — INT
  • cyyoung_bonus — INT
  • allstar_bonus — INT
  • next_last_year_option_buyout — INT
  • last_year_option_buyout — INT

players_fielding

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • fielding_ratings_infield_range — SMALLINT
  • fielding_ratings_infield_arm — SMALLINT
  • fielding_ratings_turn_doubleplay — SMALLINT
  • fielding_ratings_outfield_range — SMALLINT
  • fielding_ratings_outfield_arm — SMALLINT
  • fielding_ratings_catcher_arm — SMALLINT
  • fielding_ratings_catcher_ability — SMALLINT
  • fielding_ratings_infield_error — SMALLINT
  • fielding_ratings_outfield_error — SMALLINT
  • fielding_experience0 — SMALLINT
  • fielding_experience1 — SMALLINT
  • fielding_experience2 — SMALLINT
  • fielding_experience3 — SMALLINT
  • fielding_experience4 — SMALLINT
  • fielding_experience5 — SMALLINT
  • fielding_experience6 — SMALLINT
  • fielding_experience7 — SMALLINT
  • fielding_experience8 — SMALLINT
  • fielding_experience9 — SMALLINT
  • fielding_rating_pos1 — SMALLINT
  • fielding_rating_pos2 — SMALLINT
  • fielding_rating_pos3 — SMALLINT
  • fielding_rating_pos4 — SMALLINT
  • fielding_rating_pos5 — SMALLINT
  • fielding_rating_pos6 — SMALLINT
  • fielding_rating_pos7 — SMALLINT
  • fielding_rating_pos8 — SMALLINT
  • fielding_rating_pos9 — SMALLINT

players_game_batting

  • player_id — INT
  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • position — SMALLINT
  • ab — SMALLINT
  • h — SMALLINT
  • k — SMALLINT
  • pa — SMALLINT
  • pitches_seen — SMALLINT
  • g — SMALLINT
  • gs — SMALLINT
  • d — SMALLINT
  • t — SMALLINT
  • hr — SMALLINT
  • r — SMALLINT
  • rbi — SMALLINT
  • sb — SMALLINT
  • cs — SMALLINT
  • bb — SMALLINT
  • ibb — SMALLINT
  • gdp — SMALLINT
  • sh — SMALLINT
  • sf — SMALLINT
  • hp — SMALLINT
  • ci — SMALLINT
  • wpa — DOUBLE
  • stint — SMALLINT

players_game_pitching_stats

  • player_id — INT
  • year — SMALLINT
  • team_id — INT
  • game_id — INT
  • league_id — INT
  • level_id — SMALLINT
  • split_id — SMALLINT
  • ip — SMALLINT
  • ab — SMALLINT
  • tb — SMALLINT
  • ha — SMALLINT
  • k — SMALLINT
  • bf — SMALLINT
  • rs — SMALLINT
  • bb — SMALLINT
  • r — SMALLINT
  • er — SMALLINT
  • gb — SMALLINT
  • fb — SMALLINT
  • pi — SMALLINT
  • ipf — SMALLINT
  • g — SMALLINT
  • gs — SMALLINT
  • w — SMALLINT
  • l — SMALLINT
  • s — SMALLINT
  • sa — SMALLINT
  • da — SMALLINT
  • sh — SMALLINT
  • sf — SMALLINT
  • ta — SMALLINT
  • hra — SMALLINT
  • bk — SMALLINT
  • ci — SMALLINT
  • iw — SMALLINT
  • wp — SMALLINT
  • hp — SMALLINT
  • gf — SMALLINT
  • dp — SMALLINT
  • qs — SMALLINT
  • svo — SMALLINT
  • bs — SMALLINT
  • ra — SMALLINT
  • cg — SMALLINT
  • sho — SMALLINT
  • sb — SMALLINT
  • cs — SMALLINT
  • hld — SMALLINT
  • ir — DOUBLE
  • irs — DOUBLE
  • wpa — DOUBLE
  • stint — SMALLINT
  • outs — SMALLINT

players_individual_batting_stats

  • player_id — INT
  • opponent_id — INT
  • ab — SMALLINT
  • h — SMALLINT
  • hr — SMALLINT

players_league_leader

  • player_id — INT
  • league_id — INT
  • sub_league_id — SMALLINT
  • year — SMALLINT
  • category — SMALLINT
  • place — SMALLINT
  • amount — DOUBLE

players_pitching

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • pitching_ratings_overall_stuff — SMALLINT
  • pitching_ratings_overall_control — SMALLINT
  • pitching_ratings_overall_movement — SMALLINT
  • pitching_ratings_overall_balk — SMALLINT
  • pitching_ratings_overall_hp — SMALLINT
  • pitching_ratings_overall_wild_pitch — SMALLINT
  • pitching_ratings_vsr_stuff — SMALLINT
  • pitching_ratings_vsr_control — SMALLINT
  • pitching_ratings_vsr_movement — SMALLINT
  • pitching_ratings_vsr_balk — SMALLINT
  • pitching_ratings_vsr_hp — SMALLINT
  • pitching_ratings_vsr_wild_pitch — SMALLINT
  • pitching_ratings_vsl_stuff — SMALLINT
  • pitching_ratings_vsl_control — SMALLINT
  • pitching_ratings_vsl_movement — SMALLINT
  • pitching_ratings_vsl_balk — SMALLINT
  • pitching_ratings_vsl_hp — SMALLINT
  • pitching_ratings_vsl_wild_pitch — SMALLINT
  • pitching_ratings_talent_stuff — SMALLINT
  • pitching_ratings_talent_control — SMALLINT
  • pitching_ratings_talent_movement — SMALLINT
  • pitching_ratings_talent_balk — SMALLINT
  • pitching_ratings_talent_hp — SMALLINT
  • pitching_ratings_talent_wild_pitch — SMALLINT
  • pitching_ratings_pitches_fastball — SMALLINT
  • pitching_ratings_pitches_slider — SMALLINT
  • pitching_ratings_pitches_curveball — SMALLINT
  • pitching_ratings_pitches_screwball — SMALLINT
  • pitching_ratings_pitches_forkball — SMALLINT
  • pitching_ratings_pitches_changeup — SMALLINT
  • pitching_ratings_pitches_sinker — SMALLINT
  • pitching_ratings_pitches_splitter — SMALLINT
  • pitching_ratings_pitches_knuckleball — SMALLINT
  • pitching_ratings_pitches_cutter — SMALLINT
  • pitching_ratings_pitches_circlechange — SMALLINT
  • pitching_ratings_pitches_knucklecurve — SMALLINT
  • pitching_ratings_pitches_talent_fastball — SMALLINT
  • pitching_ratings_pitches_talent_slider — SMALLINT
  • pitching_ratings_pitches_talent_curveball — SMALLINT
  • pitching_ratings_pitches_talent_screwball — SMALLINT
  • pitching_ratings_pitches_talent_forkball — SMALLINT
  • pitching_ratings_pitches_talent_changeup — SMALLINT
  • pitching_ratings_pitches_talent_sinker — SMALLINT
  • pitching_ratings_pitches_talent_splitter — SMALLINT
  • pitching_ratings_pitches_talent_knuckleball — SMALLINT
  • pitching_ratings_pitches_talent_cutter — SMALLINT
  • pitching_ratings_pitches_talent_circlechange — SMALLINT
  • pitching_ratings_pitches_talent_knucklecurve — SMALLINT
  • pitching_ratings_misc_velocity — SMALLINT
  • pitching_ratings_misc_stamina — SMALLINT
  • pitching_ratings_misc_ground_fly — SMALLINT
  • pitching_ratings_misc_hold — SMALLINT

players_roster_status

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • uniform_number — SMALLINT
  • playing_level — SMALLINT
  • is_active — TINYINT
  • is_on_secondary — TINYINT
  • is_on_dl — TINYINT
  • is_on_dl60 — TINYINT
  • must_be_active — TINYINT
  • just_signed — TINYINT
  • was_on_active — TINYINT
  • was_on_secondary — TINYINT
  • was_on_dl — TINYINT
  • mlb_service_years — SMALLINT
  • secondary_service_years — SMALLINT
  • pro_service_years — SMALLINT
  • mlb_service_days — SMALLINT
  • secondary_service_days — SMALLINT
  • pro_service_days — SMALLINT
  • mlb_service_days_this_year — SMALLINT
  • secondary_service_days_this_year — SMALLINT
  • pro_service_days_this_year — SMALLINT
  • dl_days_this_year — SMALLINT
  • years_protected_from_rule_5 — SMALLINT
  • is_on_waivers — TINYINT
  • designated_for_assignment — TINYINT
  • irrevocable_waivers — TINYINT
  • days_on_waivers — SMALLINT
  • days_on_waivers_left — SMALLINT
  • days_on_dfa_left — SMALLINT
  • claimed_team_id — INT
  • last_day_on_waivers — SMALLINT
  • options_used — SMALLINT
  • option_used_this_year — TINYINT
  • has_received_arbitration — TINYINT
  • was_traded — TINYINT
  • trade_status — SMALLINT

players_scouted_ratings

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • scouting_coach_id — INT
  • running_ratings_speed — SMALLINT
  • running_ratings_stealing — SMALLINT
  • running_ratings_baserunning — SMALLINT
  • batting_ratings_overall_contact — SMALLINT
  • batting_ratings_overall_gap — SMALLINT
  • batting_ratings_overall_eye — SMALLINT
  • batting_ratings_overall_strikeouts — SMALLINT
  • batting_ratings_overall_hp — SMALLINT
  • batting_ratings_overall_power — SMALLINT
  • batting_ratings_overall_babip — SMALLINT
  • batting_ratings_vsr_contact — SMALLINT
  • batting_ratings_vsr_gap — SMALLINT
  • batting_ratings_vsr_eye — SMALLINT
  • batting_ratings_vsr_strikeouts — SMALLINT
  • batting_ratings_vsr_hp — SMALLINT
  • batting_ratings_vsr_power — SMALLINT
  • batting_ratings_vsr_babip — SMALLINT
  • batting_ratings_vsl_contact — SMALLINT
  • batting_ratings_vsl_gap — SMALLINT
  • batting_ratings_vsl_eye — SMALLINT
  • batting_ratings_vsl_strikeouts — SMALLINT
  • batting_ratings_vsl_hp — SMALLINT
  • batting_ratings_vsl_power — SMALLINT
  • batting_ratings_vsl_babip — SMALLINT
  • batting_ratings_talent_contact — SMALLINT
  • batting_ratings_talent_gap — SMALLINT
  • batting_ratings_talent_eye — SMALLINT
  • batting_ratings_talent_strikeouts — SMALLINT
  • batting_ratings_talent_hp — SMALLINT
  • batting_ratings_talent_power — SMALLINT
  • batting_ratings_talent_babip — SMALLINT
  • batting_ratings_misc_bunt — SMALLINT
  • batting_ratings_misc_bunt_for_hit — SMALLINT
  • batting_ratings_misc_hitter_type — SMALLINT
  • batting_ratings_misc_groundball_pct — SMALLINT
  • pitching_ratings_overall_stuff — SMALLINT
  • pitching_ratings_overall_control — SMALLINT
  • pitching_ratings_overall_movement — SMALLINT
  • pitching_ratings_overall_balk — SMALLINT
  • pitching_ratings_overall_hp — SMALLINT
  • pitching_ratings_overall_wild_pitch — SMALLINT
  • pitching_ratings_vsr_stuff — SMALLINT
  • pitching_ratings_vsr_control — SMALLINT
  • pitching_ratings_vsr_movement — SMALLINT
  • pitching_ratings_vsr_balk — SMALLINT
  • pitching_ratings_vsr_hp — SMALLINT
  • pitching_ratings_vsr_wild_pitch — SMALLINT
  • pitching_ratings_vsl_stuff — SMALLINT
  • pitching_ratings_vsl_control — SMALLINT
  • pitching_ratings_vsl_movement — SMALLINT
  • pitching_ratings_vsl_balk — SMALLINT
  • pitching_ratings_vsl_hp — SMALLINT
  • pitching_ratings_vsl_wild_pitch — SMALLINT
  • pitching_ratings_talent_stuff — SMALLINT
  • pitching_ratings_talent_control — SMALLINT
  • pitching_ratings_talent_movement — SMALLINT
  • … +49

players_streak

  • player_id — INT
  • league_id — INT
  • streak_id — SMALLINT
  • value — SMALLINT
  • has_ended — TINYINT
  • started — DATE
  • ended — DATE

players_value

  • player_id — INT
  • team_id — INT
  • league_id — INT
  • offensive_value — SMALLINT
  • offensive_value_talent — SMALLINT
  • offensive_value_vsl — SMALLINT
  • offensive_value_vsr — SMALLINT
  • pitching_value — SMALLINT
  • pitching_value_talent — SMALLINT
  • pitching_value_vsl — SMALLINT
  • pitching_value_vsr — SMALLINT
  • overall_value — SMALLINT
  • overall_value_vsl — SMALLINT
  • overall_value_vsr — SMALLINT
  • talent_value — SMALLINT
  • career_value — SMALLINT
  • leadoff_value_vsl — SMALLINT
  • leadoff_value_vsr — SMALLINT
  • running_value — SMALLINT
  • stealing_value — SMALLINT
  • season_performance — DOUBLE
  • stats_value — SMALLINT
  • stats_mod — SMALLINT
  • ratings_value — SMALLINT

states

  • state_id — INT
  • nation_id — INT
  • name — VARCHAR(50)
  • abbreviation — VARCHAR(50)
  • population — INT
  • main_language_id — INT

sub_leagues

  • league_id — INT
  • sub_league_id — INT
  • name — VARCHAR(50)
  • abbr — VARCHAR(50)
  • gender — INT
  • designated_hitter — TINYINT

team_relations

  • league_id — INT
  • sub_league_id — INT
  • division_id — INT
  • team_id — INT

trade_history

  • date — DATE
  • summary — VARCHAR(255)
  • message_id — INT
  • team_id_0 — INT
  • player_id_0_0 — INT
  • draft_round_0_0 — INT
  • player_id_0_1 — INT
  • draft_round_0_1 — INT
  • player_id_0_2 — INT
  • draft_round_0_2 — INT
  • player_id_0_3 — INT
  • draft_round_0_3 — INT
  • player_id_0_4 — INT
  • draft_round_0_4 — INT
  • cash_0 — INT
  • team_id_1 — INT
  • player_id_1_0 — INT
  • draft_round_1_0 — INT
  • player_id_1_1 — INT
  • draft_round_1_1 — INT
  • player_id_1_2 — INT
  • draft_round_1_2 — INT
  • player_id_1_3 — INT
  • draft_round_1_3 — INT
  • player_id_1_4 — INT
  • draft_round_1_4 — INT
  • cash_1 — INT