XTOSS

1 XTOSS XML Team 2005, XML Team Solutions, Inc. MySQL3 2005-11-09 2005-11-09 Verdana,8,,0,0,-11 192,192,192 0 1 4 1 1 (FK) 0 -NN 0 Events Group 728 343 1128 1253 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 217 1602 1120 2363 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 16 338 418 899 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 19 933 416 1254 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 19 71 1133 328 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX211 438 371 712 547 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX2111 436 745 692 998 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 21 1276 1124 1594 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 22 2387 1114 3761 0 0 255,255,225 0,0,0 0,0,0 1 Legend 291 14 XTOSS — XML Team Open Sports Schema Released under GPL at http://www.xtoss.org -- © 2005 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 2 1 NOTE1 1032 364 Event Tables 0 255,255,255 0,0,0 128,128,128 0 1 NOTE3 237 1617 Baseball Stats 0 255,255,255 0,0,0 128,128,128 0 1 NOTE11 34 355 Player Tables 0 255,255,255 0,0,0 128,128,128 0 1 NOTE31 30 83 Document Tables 0 255,255,255 0,0,0 128,128,128 0 1 NOTE32 51 2412 American Football Stats 0 255,255,255 0,0,0 128,128,128 0 1 events9628620,0,0255,255,255128,128,128255,255,2551255,128,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 event_key VARCHAR VARCHAR(40) 0 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 site_key INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(40) Normalized to UTC 0 0 0 40 site_alignment VARCHAR VARCHAR(40) 0 0 0 40 event_status VARCHAR VARCHAR(40) 0 0 0 40 duration VARCHAR VARCHAR(40) 0 0 0 40 attendance VARCHAR VARCHAR(40) 0 0 0 40

injury_phases334000,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 player_id INTEGER INTEGER 1 0 0 0 0 0 injury_status VARCHAR VARCHAR(40) 0 0 0 40 injury_type VARCHAR VARCHAR(40) 0 0 0 40 injury_comment VARCHAR VARCHAR(40) 0 0 0 40 disabled_list VARCHAR VARCHAR(40) 0 0 0 40 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_date_time VARCHAR VARCHAR(40) 0 0 0 40 season_id INTEGER INTEGER 1 0 0 0 0 0

baseball_pitching_stats47918280,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 runs_allowed VARCHAR VARCHAR(40) 0 0 0 40 home_runs_allowed VARCHAR VARCHAR(40) 0 0 0 40 innings_pitched VARCHAR VARCHAR(40) 0 0 0 40 hits VARCHAR VARCHAR(40) 0 0 0 40 earned_runs VARCHAR VARCHAR(40) 0 0 0 40 unearned_runs VARCHAR VARCHAR(40) 0 0 0 40 bases_on_balls VARCHAR VARCHAR(40) 0 0 0 40 bases_on_balls_intentional VARCHAR VARCHAR(40) 0 0 0 40 strikeouts VARCHAR VARCHAR(40) 0 0 0 40 strikeout_to_bb_ratio VARCHAR VARCHAR(40) 0 0 0 40 number_of_pitches VARCHAR VARCHAR(40) 0 0 0 40 era VARCHAR VARCHAR(40) 0 0 0 40 inherited_runners_scored VARCHAR VARCHAR(40) 0 0 0 40 pick_offs VARCHAR VARCHAR(40) 0 0 0 40 errors_hit_with_pitch VARCHAR VARCHAR(40) 0 0 0 40 errors_wild_pitch VARCHAR VARCHAR(40) 0 0 0 40 balks VARCHAR VARCHAR(40) 0 0 0 40 wins VARCHAR VARCHAR(40) 0 0 0 40 losses VARCHAR VARCHAR(40) 0 0 0 40 saves VARCHAR VARCHAR(40) 0 0 0 40 shutouts VARCHAR VARCHAR(40) 0 0 0 40 games_complete VARCHAR VARCHAR(40) 0 0 0 40 games_finished VARCHAR VARCHAR(40) 0 0 0 40 winning_percentage VARCHAR VARCHAR(40) 0 0 0 40 event_credit VARCHAR VARCHAR(40) 0 0 0 40 save_credit VARCHAR VARCHAR(40) 0 0 0 40

players_events9894980,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 player_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0 score VARCHAR VARCHAR(40) 0 0 0 40

affiliations_events7457670,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0

documents455820,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 doc_id VARCHAR VARCHAR(40) 1 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) 0 0 0 40 title VARCHAR VARCHAR(40) player | team | league | etc. 0 0 0 40 language VARCHAR VARCHAR(40) 0 0 0 40 priority VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 0 40 revision_id VARCHAR VARCHAR(40) 0 0 0 40 stats_coverage VARCHAR VARCHAR(40) 0 0 0 40 fixture_id INTEGER INTEGER 1 0 0 0 0 0 sportsml_path VARCHAR VARCHAR(40) 0 0 0 40 abstract VARCHAR VARCHAR(40) 0 0 0 40

fixtures7831050,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per fixture_key + publisher_id 1 1 0 0 0 0 fixture_key VARCHAR VARCHAR(40) 0 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 name VARCHAR VARCHAR(40) player | team | league | etc. 0 0 0 40 doc_class_id INTEGER INTEGER 1 0 0 0 0 0

doc_classes999880,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 name VARCHAR VARCHAR(40) player | team | league | etc. 0 0 0 40

latest_revisions531160,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 revision_id INTEGER INTEGER 1 0 0 0 0 0 latest_document_id INTEGER INTEGER 1 0 0 0 0 0

teams_documents2282340,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 team_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

affiliations_documents6492410,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

american_football_defensive_stats33324070,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 tackles_total VARCHAR VARCHAR(40) 0 0 0 40 tackles_solo VARCHAR VARCHAR(40) 0 0 0 40 tackles_assists VARCHAR VARCHAR(40) 0 0 0 40 interceptions_total VARCHAR VARCHAR(40) 0 0 0 40 interceptions_yards VARCHAR VARCHAR(40) 0 0 0 40 interceptions_average VARCHAR VARCHAR(40) 0 0 0 40 interceptions_longest VARCHAR VARCHAR(40) 0 0 0 40 interceptions_touchdown VARCHAR VARCHAR(40) 0 0 0 40 quarterback_hurries VARCHAR VARCHAR(40) 0 0 0 40 sacks_total VARCHAR VARCHAR(40) 0 0 0 40 sacks_yards VARCHAR VARCHAR(40) 0 0 0 40 passes_defensed VARCHAR VARCHAR(40) 0 0 0 40

american_football_down_progress_stats4325900,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 first_downs_total VARCHAR VARCHAR(40) 0 0 0 40 first_downs_pass VARCHAR VARCHAR(40) 0 0 0 40 first_downs_run VARCHAR VARCHAR(40) 0 0 0 40 first_downs_penalty VARCHAR VARCHAR(40) 0 0 0 40 conversions_third_down VARCHAR VARCHAR(40) 0 0 0 40 conversions_third_down_attempts VARCHAR VARCHAR(40) 0 0 0 40 conversions_third_down_percentage VARCHAR VARCHAR(40) 0 0 0 40 conversions_fourth_down VARCHAR VARCHAR(40) 0 0 0 40 conversions_fourth_down_attempts VARCHAR VARCHAR(40) 0 0 0 40 conversions_fourth_down_percentage VARCHAR VARCHAR(40) 0 0 0 40

american_football_fumbles_stats4231980,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 fumbles_committed VARCHAR VARCHAR(40) 0 0 0 40 fumbles_forced VARCHAR VARCHAR(40) 0 0 0 40 fumbles_recovered VARCHAR VARCHAR(40) 0 0 0 40 fumbles_lost VARCHAR VARCHAR(40) 0 0 0 40 fumbles_yards_gained VARCHAR VARCHAR(40) 0 0 0 40 fumbles_own_committed VARCHAR VARCHAR(40) 0 0 0 40 fumbles_own_recovered VARCHAR VARCHAR(40) 0 0 0 40 fumbles_own_lost VARCHAR VARCHAR(40) 0 0 0 40 fumbles_own_yards_gained VARCHAR VARCHAR(40) 0 0 0 40 fumbles_opposing_committed VARCHAR VARCHAR(40) 0 0 0 40 fumbles_opposing_recovered VARCHAR VARCHAR(40) 0 0 0 40 fumbles_opposing_lost VARCHAR VARCHAR(40) 0 0 0 40 fumbles_opposing_yards_gained VARCHAR VARCHAR(40) 0 0 0 40

american_football_offensive_stats4236260,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 offensive_plays_yards VARCHAR VARCHAR(40) 0 0 0 40 offensive_plays_number VARCHAR VARCHAR(40) 0 0 0 40 offensive_plays_average_yards_per VARCHAR VARCHAR(40) 0 0 0 40 possession_duration VARCHAR VARCHAR(40) 0 0 0 40 turnovers_giveaway VARCHAR VARCHAR(40) 0 0 0 40

american_football_rushing_stats4234750,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 rushes_attempts VARCHAR VARCHAR(40) 0 0 0 40 rushes_yards VARCHAR VARCHAR(40) 0 0 0 40 rushes_touchdowns VARCHAR VARCHAR(40) 0 0 0 40 rushing_average_yards_per VARCHAR VARCHAR(40) 0 0 0 40 rushes_first_down VARCHAR VARCHAR(40) 0 0 0 40 rushes_longest VARCHAR VARCHAR(40) 0 0 0 40

american_football_penalties_stats32932150,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 penalties_total VARCHAR VARCHAR(40) 0 0 0 40 penalty_yards VARCHAR VARCHAR(40) 0 0 0 40 penalty_first_downs VARCHAR VARCHAR(40) 0 0 0 40

american_football_passing_stats4228190,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 passes_attempts VARCHAR VARCHAR(40) 0 0 0 40 passes_completions VARCHAR VARCHAR(40) 0 0 0 40 passes_percentage VARCHAR VARCHAR(40) 0 0 0 40 passes_yards_gross VARCHAR VARCHAR(40) 0 0 0 40 passes_yards_net VARCHAR VARCHAR(40) 0 0 0 40 passes_yards_lost VARCHAR VARCHAR(40) 0 0 0 40 passes_touchdowns VARCHAR VARCHAR(40) 0 0 0 40 passes_touchdowns_percentage VARCHAR VARCHAR(40) 0 0 0 40 passes_interceptions VARCHAR VARCHAR(40) 0 0 0 40 passes_interceptions_percentage VARCHAR VARCHAR(40) 0 0 0 40 passes_longest VARCHAR VARCHAR(40) 0 0 0 40 passes_average_yards_per VARCHAR VARCHAR(40) 0 0 0 40 passer_rating VARCHAR VARCHAR(40) 0 0 0 40 receptions_total VARCHAR VARCHAR(40) 0 0 0 40 receptions_yards VARCHAR VARCHAR(40) 0 0 0 40 receptions_touchdowns VARCHAR VARCHAR(40) 0 0 0 40 receptions_first_down VARCHAR VARCHAR(40) 0 0 0 40 receptions_longest VARCHAR VARCHAR(40) 0 0 0 40 receptions_average_yards_per VARCHAR VARCHAR(40) 0 0 0 40

american_football_sacks_against_stats32536760,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 sacks_against_yards VARCHAR VARCHAR(40) 0 0 0 40 sacks_against_total VARCHAR VARCHAR(40) 0 0 0 40

american_football_scoring_stats32833170,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 touchdowns_total VARCHAR VARCHAR(40) 0 0 0 40 touchdowns_passing VARCHAR VARCHAR(40) 0 0 0 40 touchdowns_rushing VARCHAR VARCHAR(40) 0 0 0 40 touchdowns_special_teams VARCHAR VARCHAR(40) 0 0 0 40 touchdowns_defensive VARCHAR VARCHAR(40) 0 0 0 40 extra_points_attempts VARCHAR VARCHAR(40) 0 0 0 40 extra_points_made VARCHAR VARCHAR(40) 0 0 0 40 extra_points_missed VARCHAR VARCHAR(40) 0 0 0 40 extra_points_blocked VARCHAR VARCHAR(40) 0 0 0 40 field_goal_attempts VARCHAR VARCHAR(40) 0 0 0 40 field_goals_made VARCHAR VARCHAR(40) 0 0 0 40 field_goals_missed VARCHAR VARCHAR(40) 0 0 0 40 field_goals_blocked VARCHAR VARCHAR(40) 0 0 0 40 safeties_against VARCHAR VARCHAR(40) 0 0 0 40 two_point_conversions_attempts VARCHAR VARCHAR(40) 0 0 0 40 two_point_conversions_made VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_total VARCHAR VARCHAR(40) 0 0 0 40

american_football_special_teams_stats33026640,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 returns_punt_total VARCHAR VARCHAR(40) 0 0 0 40 returns_punt_yards VARCHAR VARCHAR(40) 0 0 0 40 returns_punt_average VARCHAR VARCHAR(40) 0 0 0 40 returns_punt_longest VARCHAR VARCHAR(40) 0 0 0 40 returns_punt_touchdown VARCHAR VARCHAR(40) 0 0 0 40 returns_kickoff_total VARCHAR VARCHAR(40) 0 0 0 40 returns_kickoff_yards VARCHAR VARCHAR(40) 0 0 0 40 returns_kickoff_average VARCHAR VARCHAR(40) 0 0 0 40 returns_kickoff_longest VARCHAR VARCHAR(40) 0 0 0 40 returns_kickoff_touchdown VARCHAR VARCHAR(40) 0 0 0 40 returns_total VARCHAR VARCHAR(40) 0 0 0 40 returns_yards VARCHAR VARCHAR(40) 0 0 0 40 punts_total VARCHAR VARCHAR(40) 0 0 0 40 punts_yards_gross VARCHAR VARCHAR(40) 0 0 0 40 punts_yards_net VARCHAR VARCHAR(40) 0 0 0 40 punts_longest VARCHAR VARCHAR(40) 0 0 0 40 punts_inside_20 VARCHAR VARCHAR(40) 0 0 0 40 punts_inside_20_percentage VARCHAR VARCHAR(40) 0 0 0 40 punts_average VARCHAR VARCHAR(40) 0 0 0 40 punts_blocked VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_total VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_total_percentage VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_kickoffs VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_kickoffs_percentage VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_punts VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_punts_percentage VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_interceptions VARCHAR VARCHAR(40) 0 0 0 40 touchbacks_interceptions_percentage VARCHAR VARCHAR(40) 0 0 0 40 fair_catches VARCHAR VARCHAR(40) 0 0 0 40

core_stats1520610,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 score VARCHAR VARCHAR(40) 0 0 0 40 score_opposing VARCHAR VARCHAR(40) 0 0 0 40 score_attempts VARCHAR VARCHAR(40) 0 0 0 40 score_attempts_opposing VARCHAR VARCHAR(40) 0 0 0 40 score_percentage VARCHAR VARCHAR(40) 0 0 0 40 score_percentage_opposing VARCHAR VARCHAR(40) 0 0 0 40

team_american_football_stats4824480,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 yards_per_attempt VARCHAR VARCHAR(40) 0 0 0 40 average_starting_position VARCHAR VARCHAR(40) 0 0 0 40 timeouts VARCHAR VARCHAR(40) 0 0 0 40 time_of_possession VARCHAR VARCHAR(40) 0 0 0 40 turnover_ratio VARCHAR VARCHAR(40) 0 0 0 40

players_documents531910,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 player_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

REL5 0 0 0 0 0 0 0 0 events weather_conditions id event_id 2 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL8 0 0 0 0 0 0 0 0 events events_players_subscores id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL31 0 0 0 0 0 0 0 0 sites events site_key site_key 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL25 0 0 0 0 0 0 0 0 injury_phases players id current_injury_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL36 0 0 0 0 0 0 0 0 publishers players id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL35 0 0 0 0 0 0 0 0 publishers events id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL37 0 0 0 0 0 0 0 0 players team_phases id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL26 0 0 0 0 0 0 0 0 players player_league_phases id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL34 0 0 0 0 0 0 0 0 players injury_phases id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL38 0 0 0 0 0 0 0 0 team_phases players id current_team_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL39 0 0 0 0 0 0 0 0 player_league_phases players id current_league_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL2 0 0 0 0 0 0 0 0 events players_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL7 0 0 0 0 0 0 0 0 players players_events id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL1 0 0 0 0 0 0 0 0 players events_players_subscores id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL6 0 0 0 0 0 0 0 0 events events_teams_subscores id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL9 0 0 0 0 0 0 0 0 teams events_teams_subscores id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL10 0 0 0 0 0 0 0 0 publishers sites id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL40 0 0 0 0 0 0 0 0 seasons injury_phases id season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL22 0 0 0 0 0 0 0 0 events events_sub_seasons id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL24 0 0 0 0 0 0 0 0 teams team_affiliation_phases id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL43 0 0 0 0 0 0 0 0 affiliations team_affiliation_phases id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL44 0 0 0 0 0 0 0 0 sites teams id home_site_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL19 0 0 0 0 0 0 0 0 publishers teams id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL45 0 0 0 0 0 0 0 0 publishers seasons id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL46 0 0 0 0 0 0 0 0 teams affiliations_teams id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL47 0 0 0 0 0 0 0 0 affiliations affiliations_teams id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL11 0 0 0 0 0 0 0 0 events affiliations_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL15 0 0 0 0 0 0 0 0 affiliations affiliations_events id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL12 0 0 0 0 0 0 0 0 seasons team_affiliation_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL16 0 0 0 0 0 0 0 0 seasons team_affiliation_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL17 0 0 0 0 0 0 0 0 seasons player_league_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL18 0 0 0 0 0 0 0 0 seasons player_league_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL20 0 0 0 0 0 0 0 0 seasons team_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL21 0 0 0 0 0 0 0 0 seasons team_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL23 0 0 0 0 0 0 0 0 teams team_phases id team_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL28 0 0 0 0 0 0 0 0 seasons sub_seasons id season_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL48 0 0 0 0 0 0 0 0 sub_seasons events_sub_seasons id sub_season_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL42 0 0 0 0 0 0 0 0 events teams_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL49 0 0 0 0 0 0 0 0 teams teams_events id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL50 0 0 0 0 0 0 0 0 publishers fixtures id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL51 0 0 0 0 0 0 0 0 publishers documents id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL52 0 0 0 0 0 0 0 0 fixtures documents id fixture_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL58 0 0 0 0 0 0 0 0 documents teams_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL59 0 0 0 0 0 0 0 0 teams teams_documents id team_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL60 0 0 0 0 0 0 0 0 documents affiliations_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL61 0 0 0 0 0 0 0 0 affiliations affiliations_documents id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL62 0 0 0 0 0 0 0 0 events fixtures_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL63 0 0 0 0 0 0 0 0 fixtures fixtures_events id fixture_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL64 0 0 0 0 0 0 0 0 documents fixtures_events id latest_document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL65 0 0 0 0 0 0 0 0 doc_classes fixtures id doc_class_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL53 0 0 0 0 0 0 0 0 events wagering_moneylines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL66 0 0 0 0 0 0 0 0 teams wagering_moneylines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL67 0 0 0 0 0 0 0 0 players wagering_moneylines id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL68 0 0 0 0 0 0 0 0 events wagering_straight_spread_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL69 -2 0 0 0 0 0 0 0 teams wagering_straight_spread_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL70 0 0 0 0 0 0 0 0 players wagering_straight_spread_lines id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL71 0 0 0 0 0 0 0 0 events wagering_odds_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL72 0 0 0 0 0 0 0 0 teams wagering_odds_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL73 0 0 0 0 0 0 0 0 players wagering_odds_lines id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL75 0 0 0 0 0 0 0 0 teams wagering_total_score_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL77 0 0 0 0 0 0 0 0 events wagering_runlines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL78 0 0 0 0 0 0 0 0 teams wagering_runlines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL79 0 0 0 0 0 0 0 0 players wagering_runlines id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL54 0 0 0 0 0 0 0 0 documents latest_revisions id latest_document_id 3 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL3 0 0 0 0 0 0 0 0 affiliations teams id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL4 0 0 0 0 0 0 0 0 affiliations seasons id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL27 0 0 0 0 0 0 0 0 affiliations player_league_phases id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL13 0 0 0 0 0 0 0 0 players players_stats id player_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL29 0 0 0 0 0 0 0 0 teams teams_stats id team_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL30 0 0 0 0 0 0 0 0 affiliations affiliations_stats id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL32 0 0 0 0 0 0 0 0 documents players_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL33 0 0 0 0 0 0 0 0 players players_documents id player_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 core_player_stats2122250,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 time_played INTEGER INTEGER in seconds 0 0 0 0 0 0 events_played INTEGER INTEGER 0 0 0 0 0 0 events_started INTEGER INTEGER 0 0 0 0 0 0

Rel 0 0 0 0 0 0 0 0 baseball_event_states baseball_action_substitutions id baseball_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel14 0 0 0 0 0 0 0 0 baseball_event_states baseball_action_plays id baseball_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel41 0 0 0 0 0 0 0 0 positions baseball_action_substitutions id person_original_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel55 0 0 0 0 0 0 0 0 positions baseball_action_substitutions id person_replacing_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel56 0 0 0 0 0 0 0 0 baseball_event_states baseball_action_pitches id baseball_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel57 0 0 0 0 0 0 0 0 baseball_action_plays baseball_action_pitches id baseball_action_play_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel80 0 0 0 0 0 0 0 0 positions team_phases id regular_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 players2083520,0,0255,255,255128,128,128255,255,25510,128,25510,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per player_key + publisher_id 1 1 0 0 0 0 player_key VARCHAR VARCHAR(40) 1 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 given_name VARCHAR VARCHAR(40) 0 0 0 40 middle_name VARCHAR VARCHAR(40) 0 0 0 40 family_name VARCHAR VARCHAR(40) 0 0 0 40 nickname VARCHAR VARCHAR(40) 0 0 0 40 full_name VARCHAR VARCHAR(40) 0 0 0 40 birth_date VARCHAR VARCHAR(40) 0 0 0 40 gender VARCHAR VARCHAR(40) 0 0 0 40 birth_city VARCHAR VARCHAR(40) 0 0 0 40 birth_state VARCHAR VARCHAR(40) 0 0 0 40 birth_country VARCHAR VARCHAR(40) 0 0 0 40 death_date VARCHAR VARCHAR(40) 0 0 0 40 current_injury_phase_id INTEGER INTEGER 0 0 0 0 0 0 current_team_phase_id INTEGER INTEGER 0 0 0 0 0 0 current_league_phase_id INTEGER INTEGER 0 0 0 0 0 0

team_phases316410,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 player_id INTEGER INTEGER 1 0 0 0 0 0 team_id INTEGER INTEGER 1 0 0 0 0 0 uniform_number VARCHAR VARCHAR(40) 0 0 0 40 regular_position_id INTEGER INTEGER 0 0 0 0 0 0 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_season_id INTEGER INTEGER 1 0 0 0 0 0 height VARCHAR VARCHAR(40) 0 0 0 40 weight VARCHAR VARCHAR(40) 0 0 0 40 id1 INTEGER INTEGER 1 0 0 0 0 0

seasons4503900,0,0255,255,2550,0,0255,255,2551255,128,010,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per season_key + publisher_id 1 1 0 0 0 0 season_key INTEGER INTEGER 1 0 0 0 0 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_date_time VARCHAR VARCHAR(40) 0 0 0 40

REL76 0 0 0 0 0 0 0 0 players wagering_total_score_lines id player_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 sub_seasons5834030,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per season_id + type 1 1 0 0 0 0 season_id INTEGER INTEGER 1 0 0 0 0 0 type VARCHAR VARCHAR(40) pre | regular | post | exhibition | all-start 1 0 0 40 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_date_time VARCHAR VARCHAR(40) 0 0 0 40

events_players_subscores7653740,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 0 40 event_id VARCHAR VARCHAR(40) 0 0 0 40 player_id INTEGER INTEGER 1 0 0 0 0 0 period VARCHAR VARCHAR(40) 0 0 0 40 score VARCHAR VARCHAR(40) 0 0 0 40

weather_conditions9706260,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 event_id VARCHAR VARCHAR(40) 0 0 0 40 temperature VARCHAR VARCHAR(40) 0 0 0 40 humidity VARCHAR VARCHAR(40) 0 0 0 40 clouds VARCHAR VARCHAR(40) 0 0 0 40 wind_direction VARCHAR VARCHAR(40) 0 0 0 40 wind_velocity VARCHAR VARCHAR(40) 0 0 0 40

events_sub_seasons7865720,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 1 0 0 0 0 sub_season_id INTEGER INTEGER 1 1 0 0 0 0

teams_events8038320,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 team_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0 alignment VARCHAR VARCHAR(40) 0 0 0 40 score VARCHAR VARCHAR(40) 0 0 0 40

REL74 0 0 0 0 0 0 0 0 events wagering_total_score_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 events_teams_subscores7439710,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 team_id INTEGER INTEGER 1 0 0 0 0 0 period VARCHAR VARCHAR(40) 0 0 0 40 score VARCHAR VARCHAR(40) 0 0 0 40

fixtures_events88510950,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 fixture_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0 latest_document_id INTEGER INTEGER 1 0 0 0 0 0

affiliations_teams5311400,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 team_id INTEGER INTEGER 1 1 0 0 0 0

team_affiliation_phases3710080,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 team_id INTEGER INTEGER 1 0 0 0 0 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 affiliation_id INTEGER INTEGER 1 0 0 0 0 0

NOTE111 31 964 Team Tables 0 255,255,255 0,0,0 128,128,128 0 1 publishers60111110,0,0255,255,255128,128,128255,255,2551128,255,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 publisher_key VARCHAR VARCHAR(40) 1 0 0 40 publisher_name VARCHAR VARCHAR(40) 0 0 0 40

positions5788220,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 abbreviation VARCHAR VARCHAR(20) 1 0 0 20 name VARCHAR VARCHAR(40) 0 0 0 40

sites43610150,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 site_key INTEGER INTEGER 1 0 0 0 0 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 name VARCHAR VARCHAR(40) 0 0 0 40 country INTEGER INTEGER 1 0 0 0 0 0 state_province INTEGER INTEGER 1 0 0 0 0 0 city VARCHAR VARCHAR(40) 0 0 0 40 postal_code VARCHAR VARCHAR(40) 0 0 0 40 postal_code_extension VARCHAR VARCHAR(40) 0 0 0 40 timezone VARCHAR VARCHAR(40) 0 0 0 40 address_1 VARCHAR VARCHAR(40) 0 0 0 40 address_2 VARCHAR VARCHAR(40) 0 0 0 40 alias VARCHAR VARCHAR(40) 0 0 0 40

affiliations4567870,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 affiliation_key VARCHAR VARCHAR(40) 1 0 0 40 name VARCHAR VARCHAR(40) 0 0 0 40 alias VARCHAR VARCHAR(40) 0 0 0 40 abbreviation VARCHAR VARCHAR(40) 0 0 0 40 type VARCHAR VARCHAR(40) division | conference | caliber | organization | sport 0 0 0 40 parent_id INTEGER INTEGER 0 0 0 0 0 0

wagering_odds_lines66613140,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 0 bookmaker_key VARCHAR VARCHAR(40) 0 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 rotation_number VARCHAR VARCHAR(40) 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 numerator VARCHAR VARCHAR(40) 0 0 0 40 denominator VARCHAR VARCHAR(40) 0 0 0 40 prediction VARCHAR VARCHAR(40) 0 0 0 40 payout_calculation VARCHAR VARCHAR(40) 0 0 0 40 payout_amount VARCHAR VARCHAR(40) 0 0 0 40

wagering_runlines50113030,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 0 bookmaker_key VARCHAR VARCHAR(40) 0 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 rotation_number VARCHAR VARCHAR(40) 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 vigorish VARCHAR VARCHAR(40) 0 0 0 40 line VARCHAR VARCHAR(40) 0 0 0 40 line_opening VARCHAR VARCHAR(40) 0 0 0 40 value VARCHAR VARCHAR(40) 0 0 0 40 prediction VARCHAR VARCHAR(40) 0 0 0 40

wagering_moneylines11513360,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 0 bookmaker_key VARCHAR VARCHAR(40) 0 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 rotation_number VARCHAR VARCHAR(40) 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 vigorish VARCHAR VARCHAR(40) 0 0 0 40 line VARCHAR VARCHAR(40) 0 0 0 40 line_opening VARCHAR VARCHAR(40) 0 0 0 40 prediction VARCHAR VARCHAR(40) 0 0 0 40

NOTE1111 74 1291 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 0 1 players_stats1316600,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 stat_id INTEGER INTEGER 1 0 0 0 0 0 stat_type VARCHAR VARCHAR(40) intermediate | final ??? 1 0 0 40 player_id INTEGER INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 0 40 stat_coverage_id INTEGER INTEGER 0 0 0 0 0 0

teams_stats1217930,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 stat_id INTEGER INTEGER 1 0 0 0 0 0 stat_type VARCHAR VARCHAR(40) 1 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 0 40 stat_coverage_id INTEGER INTEGER 0 0 0 0 0 0

affiliations_stats1519310,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 stat_id INTEGER INTEGER 1 0 0 0 0 0 stat_type VARCHAR VARCHAR(40) 1 0 0 40 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 0 40 stat_coverage_id INTEGER INTEGER 0 0 0 0 0 0

baseball_action_plays89816450,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 baseball_event_state_id INTEGER INTEGER 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 play_type VARCHAR VARCHAR(40) 0 0 0 40 notation VARCHAR VARCHAR(40) 0 0 0 40 notation_yaml TEXT TEXT 0 0 comment VARCHAR VARCHAR(255) 0 0 0 255 runner_on_first_advance INTEGER INTEGER 0 0 0 0 0 0 runner_on_second_advance INTEGER INTEGER 0 0 0 0 0 0 runner_on_third_advance INTEGER INTEGER 0 0 0 0 0 0 outs_recorded INTEGER INTEGER 0 0 0 0 0 0 rbi INTEGER INTEGER 0 0 0 0 0 0 runs_scored INTEGER INTEGER 0 0 0 0 0 0

baseball_action_pitches90819120,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 baseball_action_play_id INTEGER INTEGER 0 0 0 0 0 0 baseball_event_state_id INTEGER INTEGER 0 0 0 0 0 0 umpire_call VARCHAR VARCHAR(40) 0 0 0 40 pitch_location VARCHAR VARCHAR(40) 0 0 0 40 pitch_type VARCHAR VARCHAR(40) 0 0 0 40 pitch_velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0

wagering_straight_spread_lines84913280,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 0 bookmaker_key VARCHAR VARCHAR(40) 0 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 rotation_number VARCHAR VARCHAR(40) 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 vigorish VARCHAR VARCHAR(40) 0 0 0 40 value VARCHAR VARCHAR(40) 0 0 0 40 value_opening VARCHAR VARCHAR(40) 0 0 0 40 prediction VARCHAR VARCHAR(40) 0 0 0 40

Note 998 1616 Baseball Actions 0 255,255,255 0,0,0 192,192,192 2 1 NOTE321 940 2470 American Football Actions 0 255,255,255 0,0,0 128,128,128 0 1 american_football_event_states59824640,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 chronology VARCHAR VARCHAR(40) current | historic 1 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 publisher_key VARCHAR VARCHAR(40) 1 0 0 40 period_value INTEGER INTEGER 0 0 0 0 0 0 period_time_elapsed VARCHAR VARCHAR(40) 0 0 0 40 period_time_remaining VARCHAR VARCHAR(40) 0 0 0 40 clock_state VARCHAR VARCHAR(40) 0 0 0 40 down INTEGER INTEGER 0 0 0 0 0 0 team_in_possession_id INTEGER INTEGER 0 0 0 0 0 0 distance_for_1st_down INTEGER INTEGER 0 0 0 0 0 0 field_side VARCHAR VARCHAR(40) home | away 0 0 0 40 field_line INTEGER INTEGER 0 0 0 0 0 0

Rel81 0 0 0 0 0 0 0 0 teams american_football_event_states id team_in_possession_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel82 0 0 0 0 0 0 0 0 american_football_event_states american_football_action_plays id american_football_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel83 0 0 0 0 0 0 0 0 american_football_action_plays american_football_action_play_participants id play_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel84 0 0 0 0 0 0 0 0 players american_football_action_play_participants id player_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 american_football_action_plays84825070,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 american_football_event_state_id INTEGER INTEGER 1 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 play_type VARCHAR VARCHAR(40) 0 0 0 40 score_attempt_type VARCHAR VARCHAR(40) 0 0 0 40 drive_result VARCHAR VARCHAR(40) 0 0 0 40 points INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(255) 0 0 0 255

american_football_action_play_participants80827510,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 play_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 role VARCHAR VARCHAR(40) 1 0 0 40 score_type VARCHAR VARCHAR(40) 0 0 0 40 field_line INTEGER INTEGER 0 0 0 0 0 0 yardage INTEGER INTEGER 0 0 0 0 0 0

baseball_action_substitutions88321170,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 baseball_event_state_id INTEGER INTEGER 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 person_type VARCHAR VARCHAR(40) player | associate | official 0 0 0 40 person_original_id INTEGER INTEGER 0 0 0 0 0 0 person_original_position_id INTEGER INTEGER 0 0 0 0 0 0 person_original_lineup_slot INTEGER INTEGER 0 0 0 0 0 0 person_replacing_id INTEGER INTEGER 0 0 0 0 0 0 person_replacing_position_id INTEGER INTEGER 0 0 0 0 0 0 person_replacing_lineup_slot INTEGER INTEGER 0 0 0 0 0 0 substitution_reason VARCHAR VARCHAR(255) 0 0 0 255 comment VARCHAR VARCHAR(255) 0 0 0 255

baseball_event_states70516210,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 chronology VARCHAR VARCHAR(40) current | historic 1 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 publisher_key VARCHAR VARCHAR(40) 1 0 0 40 inning_value INTEGER INTEGER 0 0 0 0 0 0 inning_half VARCHAR VARCHAR(40) top | bottom 0 0 0 40 outs INTEGER INTEGER 0 0 0 0 0 0 balls INTEGER INTEGER 0 0 0 0 0 0 strikes INTEGER INTEGER 0 0 0 0 0 0 runner_on_first_id INTEGER INTEGER 0 0 0 0 0 0 runner_on_second_id INTEGER INTEGER 0 0 0 0 0 0 runner_on_third_id INTEGER INTEGER 0 0 0 0 0 0 runs_this_inning_half INTEGER INTEGER 0 0 0 0 0 0 pitcher_id INTEGER INTEGER 0 0 0 0 0 0 batter_id INTEGER INTEGER 0 0 0 0 0 0 batter_side VARCHAR VARCHAR(40) left | right 0 0 0 40

baseball_defensive_stats47516100,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 double_plays VARCHAR VARCHAR(40) 0 0 0 40 triple_plays VARCHAR VARCHAR(40) 0 0 0 40 putouts VARCHAR VARCHAR(40) 0 0 0 40 assists VARCHAR VARCHAR(40) 0 0 0 40 errors VARCHAR VARCHAR(40) 0 0 0 40 fielding_percentage VARCHAR VARCHAR(40) 0 0 0 40 defensive_average VARCHAR VARCHAR(40) 0 0 0 40 errors_passed_ball VARCHAR VARCHAR(40) 0 0 0 40 errors_catchers_interference VARCHAR VARCHAR(40) 0 0 0 40

baseball_offensive_stats23316760,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 average VARCHAR VARCHAR(40) 0 0 0 40 runs_scored VARCHAR VARCHAR(40) 0 0 0 40 at_bats VARCHAR VARCHAR(40) 0 0 0 40 hits VARCHAR VARCHAR(40) 0 0 0 40 rbi VARCHAR VARCHAR(40) 0 0 0 40 total_bases VARCHAR VARCHAR(40) 0 0 0 40 slugging_percentage VARCHAR VARCHAR(40) 0 0 0 40 bases_on_balls VARCHAR VARCHAR(40) 0 0 0 40 strikeouts VARCHAR VARCHAR(40) 0 0 0 40 left_on_base VARCHAR VARCHAR(40) 0 0 0 40 left_in_scoring_position VARCHAR VARCHAR(40) 0 0 0 40 singles VARCHAR VARCHAR(40) 0 0 0 40 doubles VARCHAR VARCHAR(40) 0 0 0 40 triples VARCHAR VARCHAR(40) 0 0 0 40 home_runs VARCHAR VARCHAR(40) 0 0 0 40 grand_slams VARCHAR VARCHAR(40) 0 0 0 40 at_bats_per_rbi VARCHAR VARCHAR(40) 0 0 0 40 plate_appearances_per_rbi VARCHAR VARCHAR(40) 0 0 0 40 at_bats_per_home_run VARCHAR VARCHAR(40) 0 0 0 40 plate_appearances_per_home_run VARCHAR VARCHAR(40) 0 0 0 40 sac_flies VARCHAR VARCHAR(40) 0 0 0 40 sac_bunts VARCHAR VARCHAR(40) 0 0 0 40 grounded_into_double_play VARCHAR VARCHAR(40) 0 0 0 40 moved_up VARCHAR VARCHAR(40) 0 0 0 40 on_base_percentage VARCHAR VARCHAR(40) 0 0 0 40 stolen_bases VARCHAR VARCHAR(40) 0 0 0 40 stolen_bases_caught VARCHAR VARCHAR(40) 0 0 0 40 stolen_bases_average VARCHAR VARCHAR(40) 0 0 0 40 hit_by_pitch VARCHAR VARCHAR(40) 0 0 0 40 defensive_interferance_reaches VARCHAR VARCHAR(40) 0 0 0 40 on_base_plus_slugging VARCHAR VARCHAR(40) 0 0 0 40 plate_appearances VARCHAR VARCHAR(40) 0 0 0 40 hits_extra_base VARCHAR VARCHAR(40) 0 0 0 40

wagering_total_score_lines29813030,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 0 bookmaker_key VARCHAR VARCHAR(40) 0 0 0 40 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 0 40 team_id INTEGER INTEGER 1 0 0 0 0 0 player_id INTEGER INTEGER Unique per player_key + publisher_id 1 0 0 0 0 0 rotation_number VARCHAR VARCHAR(40) 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 vigorish VARCHAR VARCHAR(40) 0 0 0 40 line_over VARCHAR VARCHAR(40) 0 0 0 40 line_under VARCHAR VARCHAR(40) 0 0 0 40 total VARCHAR VARCHAR(40) 0 0 0 40 total_opening VARCHAR VARCHAR(40) 0 0 0 40 prediction VARCHAR VARCHAR(40) 0 0 0 40

teams2489840,0,0255,255,255128,128,128255,255,2551255,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 team_key VARCHAR VARCHAR(40) 1 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 first_name VARCHAR VARCHAR(40) 0 0 0 40 last_name VARCHAR VARCHAR(40) 0 0 0 40 alias VARCHAR VARCHAR(40) 0 0 0 40 abbreviation VARCHAR VARCHAR(40) 0 0 0 40 short_name VARCHAR VARCHAR(40) 0 0 0 40 home_site_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0

player_league_phases2327170,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 player_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_season_id INTEGER INTEGER 1 0 0 0 0 0

basketball_defensive_stats6139020,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 steals_total CHAR CHAR(20) 0 0 0 20 steals_per_game CHAR CHAR(20) 0 0 0 20 blocks_total CHAR CHAR(20) 0 0 0 20 blocks_per_game CHAR CHAR(20) 0 0 0 20

basketball_event_states67638680,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 0 100 chronology CHAR CHAR(20) 0 0 0 20 event_id CHAR CHAR(100) 0 0 0 100 publisher_key CHAR CHAR(40) 0 0 0 40 period_value CHAR CHAR(20) 0 0 0 20 period_time_elapsed CHAR CHAR(20) 0 0 0 20 period_time_remaining CHAR CHAR(20) 0 0 0 20

basketball_offensive_stats28138590,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 field_goals_made INTEGER INTEGER 0 0 0 0 0 0 field_goals_attempted INTEGER INTEGER 0 0 0 0 0 0 field_goals_percentage VARCHAR VARCHAR(40) 0 0 0 40 field_goals_per_game VARCHAR VARCHAR(40) 0 0 0 40 field_goals_attempted_per_game VARCHAR VARCHAR(40) 0 0 0 40 field_goals_percentage_adjusted VARCHAR VARCHAR(40) 0 0 0 40 three_pointers_made INTEGER INTEGER 0 0 0 0 0 0 three_pointers_attempted INTEGER INTEGER 0 0 0 0 0 0 three_pointers_percentage VARCHAR VARCHAR(40) 0 0 0 40 three_pointers_per_game CHAR CHAR(20) 0 0 0 20 three_pointers_attempted_per_game CHAR CHAR(20) 0 0 0 20 free_throws_made CHAR CHAR(20) 0 0 0 20 free_throws_attempted CHAR CHAR(20) 0 0 0 20 free_throws_percentage CHAR CHAR(20) 0 0 0 20 free_throws_per_game CHAR CHAR(20) 0 0 0 20 free_throws_attempted_per_game CHAR CHAR(20) 0 0 0 20 points_scored_total CHAR CHAR(20) 0 0 0 20 points_scored_per_game CHAR CHAR(20) 0 0 0 20 assists_total CHAR CHAR(20) 0 0 0 20 assists_per_game CHAR CHAR(20) 0 0 0 20 turnovers_total CHAR CHAR(20) 0 0 0 20 turnovers_per_game CHAR CHAR(20) 0 0 0 20 points_scored_off_turnovers CHAR CHAR(20) 0 0 0 20 points_scored_in_paint CHAR CHAR(20) 0 0 0 20 points_scored_on_second_chance CHAR CHAR(20) 0 0 0 20 points_scored_on_fast_break CHAR CHAR(20) 0 0 0 20

basketball_rebounding_stats5740390,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 rebounds_total CHAR CHAR(20) 0 0 0 20 rebounds_per_game CHAR CHAR(20) 0 0 0 20 rebounds_defensive CHAR CHAR(20) 0 0 0 20 rebounds_offensive CHAR CHAR(20) 0 0 0 20 team_rebounds_total CHAR CHAR(20) 0 0 0 20 team_rebounds_per_game CHAR CHAR(20) 0 0 0 20 team_rebounds_defensive CHAR CHAR(20) 0 0 0 20 team_rebounds_offensive CHAR CHAR(20) 0 0 0 20

ice_hockey_defensive_stats5145350,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 0 255 shots_power_play_allowed CHAR CHAR(20) 0 0 0 20 shots_penalty_shot_allowed CHAR CHAR(20) 0 0 0 20 goals_power_play_allowed CHAR CHAR(20) 0 0 0 20 goals_penalty_shot_allowed CHAR CHAR(20) 0 0 0 20 goals_against_average CHAR CHAR(20) 0 0 0 20 saves CHAR CHAR(20) 0 0 0 20 save_percentage CHAR CHAR(20) 0 0 0 20 penalty_killing_amount CHAR CHAR(20) 0 0 0 20 penalty_killing_percentage CHAR CHAR(20) 0 0 0 20 shots_blocked CHAR CHAR(20) 0 0 0 20 takeaways CHAR CHAR(20) 0 0 0 20 shutouts CHAR CHAR(20) 0 0 0 20 minutes_penalty_killing CHAR CHAR(20) 0 0 0 20 hits CHAR CHAR(20) 0 0 0 20

ice_hockey_event_states66744460,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 0 100 chronology CHAR CHAR(20) 0 0 0 20 event_id CHAR CHAR(100) 0 0 0 100 publisher_key CHAR CHAR(40) 0 0 0 40 period_value CHAR CHAR(20) 0 0 0 20 period_time_elapsed CHAR CHAR(20) 0 0 0 20 period_time_remaining CHAR CHAR(20) 0 0 0 20

ice_hockey_offensive_stats28244400,0,0255,255,255128,128,128255,255,2551128,128,12810,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 0 255 goals_game_winning CHAR CHAR(20) 0 0 0 20 goals_game_tying CHAR CHAR(20) 0 0 0 20 goals_power_play CHAR CHAR(20) 0 0 0 20 goals_short_handed CHAR CHAR(20) 0 0 0 20 goals_even_strength CHAR CHAR(20) 0 0 0 20 goals_empty_net CHAR CHAR(20) 0 0 0 20 goals_overtime CHAR CHAR(20) 0 0 0 20 goals_shootout CHAR CHAR(20) 0 0 0 20 goals_penalty_shot CHAR CHAR(20) 0 0 0 20 assists CHAR CHAR(20) 0 0 0 20 points CHAR CHAR(20) 0 0 0 20 power_play_amount CHAR CHAR(20) 0 0 0 20 power_play_percentage CHAR CHAR(20) 0 0 0 20 shots_penalty_shot_taken CHAR CHAR(20) 0 0 0 20 shots_penalty_shot_missed CHAR CHAR(20) 0 0 0 20 shots_penalty_shot_percentage CHAR CHAR(20) 0 0 0 20 giveaways CHAR CHAR(20) 0 0 0 20 minutes_power_play CHAR CHAR(20) 0 0 0 20 faceoff_wins CHAR CHAR(20) 0 0 0 20 faceoff_losses CHAR CHAR(20) 0 0 0 20 faceoff_win_percentage CHAR CHAR(20) 0 0 0 20 scoring_chances CHAR CHAR(20) 0 0 0 20

Groupbox 31 3815 1113 4350 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 32 4412 1106 4891 0 0 255,255,225 0,0,0 0,0,0 1 Note2 56 3857 Basketball Stats 0 255,255,255 0,0,0 192,192,192 2 1 Note4 58 4446 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 2 1