1 XML Team 2005, XML Team Solutions, Inc. MySQL3 2006-02-03 2006-02-03 Verdana,8,,0,0,-11 192,192,192 0 1 4 1 1 (FK) 0 -NN 0 Rel93 0 0 0 0 0 0 0 0 positions core_person_stats id position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 core_person_stats3323690,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 position_id INTEGER INTEGER optional id, which allows one to record how long the person was at this position 0 0 0 0 0 0 Events Group 736 358 1128 1324 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 219 1721 1122 2482 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 18 358 420 984 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 20 1003 417 1324 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 21 76 1135 349 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX211 437 427 711 603 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX2111 436 738 692 991 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 22 1362 1125 1680 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 28 2523 1120 3897 0 0 255,255,225 0,0,0 0,0,0 1 Legend 361 6 XTOSS — XML Team Open Sports Schema - Draft 6 Released under GPL at http://www.xtoss.org © 2006 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 2 1 NOTE1 1033 372 Event Tables 0 255,255,255 0,0,0 128,128,128 0 1 NOTE3 239 1735 Baseball Stats 0 255,255,255 0,0,0 128,128,128 0 1 NOTE11 37 372 Person 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 57 2548 American Football Stats 0 255,255,255 0,0,0 128,128,128 0 1 baseball_pitching_stats48319590,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 documents457810,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) Timestamp for when this document was originally published. 0 0 0 40 title VARCHAR VARCHAR(40) person | 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 source_id INTEGER INTEGER An alternative publisher_id for "republishers" of information. 1 0 0 0 0 0 db_loading_date_time VARCHAR VARCHAR(40) Timestamp for when this document was loaded into the DB. 0 0 0 40 fixtures832880,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) person | team | league | etc. 0 0 0 40 doc_class_id INTEGER INTEGER 1 0 0 0 0 0 doc_classes1021900,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) person | team | league | etc. 0 0 0 40 latest_revisions521180,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_documents2732460,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_documents6652620,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_stats33925430,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_stats4927260,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_stats4833340,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_stats4837620,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_stats4836110,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_stats33533510,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_stats4829550,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_stats33138120,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_stats33434530,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_stats33628000,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_stats1821790,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_stats5425840,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 persons_documents512050,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 person_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_persons_subscores id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL25 0 0 0 0 0 0 0 0 injury_phases persons 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 persons 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 persons team_phases id person_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 persons person_league_phases id person_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 persons injury_phases id person_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 persons 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 person_league_phases persons 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 persons_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 persons persons_events id person_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 persons events_persons_subscores id person_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 affiliation_phases 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 affiliation_phases 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 affiliation_phases 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 person_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 person_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 affiliation_phases 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 persons wagering_moneylines id person_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 persons wagering_straight_spread_lines id person_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 persons wagering_odds_lines id person_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 persons wagering_runlines id person_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 affiliation_phases 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 affiliation_phases 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 affiliation_phases person_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 persons persons_stats id person_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 affiliation_phases 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 persons_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 persons persons_documents id person_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 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 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 persons2063700,0,0255,255,255128,128,128255,255,25510,128,25510,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per person_key + publisher_id 1 1 0 0 0 0 person_key VARCHAR VARCHAR(40) 1 0 0 40 publisher_id INTEGER INTEGER 1 0 0 0 0 0 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 default_person_name_id INTEGER INTEGER Unique per person_key + publisher_id 1 0 0 0 0 0 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 REL76 0 0 0 0 0 0 0 0 persons wagering_total_score_lines id person_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 events_sub_seasons7615570,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 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 fixtures_events91111450,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_teams4612130,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_phases3510580,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 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_date_time VARCHAR VARCHAR(40) 0 0 0 40 NOTE111 32 1034 Team Tables 0 255,255,255 0,0,0 128,128,128 0 1 wagering_odds_lines66914040,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 | person_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 person_id INTEGER INTEGER Unique per person_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_moneylines11814260,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 | person_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 person_id INTEGER INTEGER Unique per person_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 63 1380 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 0 1 persons_stats1117550,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_table VARCHAR VARCHAR(40) name of the table that has this stat_id as its id 0 0 0 40 stat_type VARCHAR VARCHAR(40) intermediate | final ??? 1 0 0 40 person_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_stats1319100,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_table VARCHAR VARCHAR(40) name of the table that has this stat_id as its id 0 0 0 40 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_stats1820470,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_table VARCHAR VARCHAR(40) name of the table that has this stat_id as its id 0 0 0 40 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_plays91117580,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 earned_runs_scored VARCHAR VARCHAR(40) 0 0 0 40 wagering_straight_spread_lines85214180,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 | person_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 person_id INTEGER INTEGER Unique per person_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 1000 1734 Baseball Actions 0 255,255,255 0,0,0 192,192,192 2 1 NOTE321 946 2606 American Football Actions 0 255,255,255 0,0,0 128,128,128 0 1 american_football_event_states60426000,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 persons american_football_action_play_participants id person_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 american_football_action_plays85426430,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_participants81428870,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 person_id INTEGER INTEGER Unique per person_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_substitutions88722440,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) person | 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_defensive_stats48017550,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_stats23217900,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_lines30113930,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 | person_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 person_id INTEGER INTEGER Unique per person_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 teams23210680,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 basketball_defensive_stats6040230,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_states67539890,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_stats28039800,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_stats5641600,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_stats5146170,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_states66745280,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_stats28245220,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 30 3936 1112 4471 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 32 4494 1106 4973 0 0 255,255,225 0,0,0 0,0,0 1 Note2 55 3978 Basketball Stats 0 255,255,255 0,0,0 192,192,192 2 1 Note4 58 4528 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 2 1 roles1566210,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 role_key VARCHAR VARCHAR(40) player | coach | manager | owner| umpire | etc. 1 0 0 40 role_name VARCHAR VARCHAR(40) Display name for the key 0 0 0 40 comment VARCHAR VARCHAR(40) 0 0 0 40 Rel85 0 0 0 0 0 0 0 0 roles team_phases id role_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 person_names303970,0,0255,255,255128,128,128255,255,25510,128,25510,0,0255,255,255128,128,128 id INTEGER INTEGER Unique per person_key + publisher_id 1 1 0 0 0 0 person_id INTEGER INTEGER Unique per person_key + publisher_id 1 0 0 0 0 0 language VARCHAR VARCHAR(40) en-us for example 0 0 0 40 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 Rel86 0 0 0 0 0 0 0 0 persons person_names id person_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel87 0 0 0 0 0 0 0 0 person_names persons id default_person_name_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel88 0 0 0 0 0 0 0 0 roles person_event_metadata id role_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel89 0 0 0 0 0 0 0 0 positions person_event_metadata id position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel90 0 0 0 0 0 0 0 0 publishers key_aliases id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel91 0 0 0 0 0 0 0 0 baseball_action_pitches baseball_action_contact_details id baseball_action_pitch_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel94 0 0 0 0 0 0 0 0 publishers documents id source_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 events_documents9472100,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 0 0 0 0 0 document_id INTEGER INTEGER 1 0 0 0 0 0 Rel95 0 0 0 0 0 0 0 0 events events_documents id event_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel96 0 0 0 0 0 0 0 0 documents events_documents id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 injury_phases305640,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 person_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 person_league_phases2487030,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 person_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 role VARCHAR VARCHAR(40) 0 0 0 40 person_event_metadata2318700,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 status VARCHAR VARCHAR(40) benched | started | played | scratched 0 0 0 40 weight VARCHAR VARCHAR(40) 0 0 0 40 role_id INTEGER INTEGER 1 0 0 0 0 0 position_id INTEGER INTEGER 1 0 0 0 0 0 team_phases317490,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 person_id INTEGER INTEGER 1 0 0 0 0 0 role_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 affiliation_phases4477600,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 start_season_id VARCHAR VARCHAR(40) 0 0 0 40 start_date_time VARCHAR VARCHAR(40) 0 0 0 40 end_season_id VARCHAR VARCHAR(40) 0 0 0 40 end_date_time VARCHAR VARCHAR(40) 0 0 0 40 positions5798220,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 seasons4484490,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 sub_seasons5834570,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_persons_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 person_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 persons_events9904980,0,0255,255,255128,128,128255,255,2551192,192,19210,0,0255,255,255128,128,128 person_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 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 events9888270,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 start_date_time VARCHAR VARCHAR(40) Normalized to UTC 0 0 0 40 site_id INTEGER INTEGER 1 0 0 0 0 0 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 affiliations_events7687630,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 key_aliases59411650,0,0255,255,255128,128,128255,255,25510,128,25510,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 key_type VARCHAR VARCHAR(40) person | team | league | etc. 0 0 0 40 key_value VARCHAR VARCHAR(40) A person_key, team_key, etc. 0 0 0 40 id_value INTEGER INTEGER A person_id, team_id, etc. 0 0 0 0 0 0 common_key VARCHAR VARCHAR(40) Locally generated key that is the same for all rows that are aliases for the same thing. 0 0 0 40 sites42210460,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 wagering_runlines50413930,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 | person_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 person_id INTEGER INTEGER Unique per person_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 baseball_action_contact_details68120740,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_action_pitch_id INTEGER INTEGER 1 0 0 0 0 0 location VARCHAR VARCHAR(40) 0 0 0 40 strength VARCHAR VARCHAR(40) hard | soft | grounder | etc. 0 0 0 40 velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0 trajectory_coordinates VARCHAR VARCHAR(40) yaml array of coordinates? 0 0 0 40 trajectory_formula VARCHAR VARCHAR(40) formula describing this path 0 0 0 40 baseball_action_pitches91220310,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 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 trajectory_coordinates VARCHAR VARCHAR(40) yaml array of coordinates? 0 0 0 40 trajectory_formula VARCHAR VARCHAR(40) formula describing this path 0 0 0 40 baseball_event_states71717560,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_id VARCHAR VARCHAR(40) change to FK for publishers table 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 Rel56 0 0 0 0 0 0 0 0 sites events id site_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 teams_events7738630,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 events_teams_subscores7649830,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 publishers59310600,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