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