2 XML Team 2005, XML Team Solutions, Inc. Concept MySQL3 2006-03-02 2006-03-02 Verdana,8,,0,0,-11 192,192,192 0 1 4 0 1 (FK) 0 0 -NN 0 0 primary_id INTEGER INTEGER 0 1 0 1 NOTE3 231 1738 93 22 Baseball Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 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_stats3323691401120,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 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 392 966 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 219 1721 903 761 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 17 366 402 666 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 19 1044 397 321 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 20 78 1114 273 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX211 428 384 295 215 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 27 1381 1103 318 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 28 2523 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 360 6 308 64 XTOSS — XML Team Open Sports Schema - Draft 7 Released under GPL at http://www.xtoss.org © 2006 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 1 2 1 NOTE1 1033 372 85 22 Event Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE11 28 376 92 22 Person Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE31 29 85 111 22 Document Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE32 57 2548 147 22 American Football Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 documents459841632500,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 doc_id VARCHAR VARCHAR(40) 1 0 40 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 date_time DATETIME DATETIME Timestamp for when this document was originally published. 0 0 title VARCHAR VARCHAR(40) person | team | league | etc. 0 0 40 0 language VARCHAR VARCHAR(40) 0 0 40 0 priority VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 40 0 revision_id VARCHAR VARCHAR(40) 0 0 40 0 stats_coverage VARCHAR VARCHAR(40) 0 0 40 0 document_fixture_id INTEGER INTEGER 1 0 0 0 0 0 source_id INTEGER INTEGER An alternative publisher_id for "republishers" of information. 0 0 0 0 0 0 db_loading_date_time VARCHAR VARCHAR(40) Timestamp for when this document was loaded into the DB. 0 0 40 0 document_fixtures782931541120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per fixture_key + publisher_id 1 1 fixture_key VARCHAR VARCHAR(40) 0 0 40 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 name VARCHAR VARCHAR(40) person | team | league | etc. 0 0 40 0 document_class_id INTEGER INTEGER 1 0 0 0 0 0 document_classes98589138580,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 name VARCHAR VARCHAR(40) person | team | league | etc. 0 0 40 0 latest_revisions51120157580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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_documents272248137580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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_documents664264167580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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_stats34325552492560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 tackles_total VARCHAR VARCHAR(40) 0 0 40 0 tackles_solo VARCHAR VARCHAR(40) 0 0 40 0 tackles_assists VARCHAR VARCHAR(40) 0 0 40 0 interceptions_total VARCHAR VARCHAR(40) 0 0 40 0 interceptions_yards VARCHAR VARCHAR(40) 0 0 40 0 interceptions_average VARCHAR VARCHAR(40) 0 0 40 0 interceptions_longest VARCHAR VARCHAR(40) 0 0 40 0 interceptions_touchdown VARCHAR VARCHAR(40) 0 0 40 0 quarterback_hurries VARCHAR VARCHAR(40) 0 0 40 0 sacks_total VARCHAR VARCHAR(40) 0 0 40 0 sacks_yards VARCHAR VARCHAR(40) 0 0 40 0 passes_defensed VARCHAR VARCHAR(40) 0 0 40 0 american_football_down_progress_stats4927262852200,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 first_downs_total VARCHAR VARCHAR(40) 0 0 40 0 first_downs_pass VARCHAR VARCHAR(40) 0 0 40 0 first_downs_run VARCHAR VARCHAR(40) 0 0 40 0 first_downs_penalty VARCHAR VARCHAR(40) 0 0 40 0 conversions_third_down VARCHAR VARCHAR(40) 0 0 40 0 conversions_third_down_attempts VARCHAR VARCHAR(40) 0 0 40 0 conversions_third_down_percentage VARCHAR VARCHAR(40) 0 0 40 0 conversions_fourth_down VARCHAR VARCHAR(40) 0 0 40 0 conversions_fourth_down_attempts VARCHAR VARCHAR(40) 0 0 40 0 conversions_fourth_down_percentage VARCHAR VARCHAR(40) 0 0 40 0 american_football_fumbles_stats4733512372740,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 fumbles_committed VARCHAR VARCHAR(40) 0 0 40 0 fumbles_forced VARCHAR VARCHAR(40) 0 0 40 0 fumbles_recovered VARCHAR VARCHAR(40) 0 0 40 0 fumbles_lost VARCHAR VARCHAR(40) 0 0 40 0 fumbles_yards_gained VARCHAR VARCHAR(40) 0 0 40 0 fumbles_own_committed VARCHAR VARCHAR(40) 0 0 40 0 fumbles_own_recovered VARCHAR VARCHAR(40) 0 0 40 0 fumbles_own_lost VARCHAR VARCHAR(40) 0 0 40 0 fumbles_own_yards_gained VARCHAR VARCHAR(40) 0 0 40 0 fumbles_opposing_committed VARCHAR VARCHAR(40) 0 0 40 0 fumbles_opposing_recovered VARCHAR VARCHAR(40) 0 0 40 0 fumbles_opposing_lost VARCHAR VARCHAR(40) 0 0 40 0 fumbles_opposing_yards_gained VARCHAR VARCHAR(40) 0 0 40 0 american_football_offensive_stats33136752461300,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 offensive_plays_yards VARCHAR VARCHAR(40) 0 0 40 0 offensive_plays_number VARCHAR VARCHAR(40) 0 0 40 0 offensive_plays_average_yards_per VARCHAR VARCHAR(40) 0 0 40 0 possession_duration VARCHAR VARCHAR(40) 0 0 40 0 turnovers_giveaway VARCHAR VARCHAR(40) 0 0 40 0 american_football_rushing_stats5036492341480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 rushes_attempts VARCHAR VARCHAR(40) 0 0 40 0 rushes_yards VARCHAR VARCHAR(40) 0 0 40 0 rushes_touchdowns VARCHAR VARCHAR(40) 0 0 40 0 rushing_average_yards_per VARCHAR VARCHAR(40) 0 0 40 0 rushes_first_down VARCHAR VARCHAR(40) 0 0 40 0 rushes_longest VARCHAR VARCHAR(40) 0 0 40 0 american_football_penalties_stats3353451245940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 penalties_total VARCHAR VARCHAR(40) 0 0 40 0 penalty_yards VARCHAR VARCHAR(40) 0 0 40 0 penalty_first_downs VARCHAR VARCHAR(40) 0 0 40 0 american_football_passing_stats4829552353820,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 passes_attempts VARCHAR VARCHAR(40) 0 0 40 0 passes_completions VARCHAR VARCHAR(40) 0 0 40 0 passes_percentage VARCHAR VARCHAR(40) 0 0 40 0 passes_yards_gross VARCHAR VARCHAR(40) 0 0 40 0 passes_yards_net VARCHAR VARCHAR(40) 0 0 40 0 passes_yards_lost VARCHAR VARCHAR(40) 0 0 40 0 passes_touchdowns VARCHAR VARCHAR(40) 0 0 40 0 passes_touchdowns_percentage VARCHAR VARCHAR(40) 0 0 40 0 passes_interceptions VARCHAR VARCHAR(40) 0 0 40 0 passes_interceptions_percentage VARCHAR VARCHAR(40) 0 0 40 0 passes_longest VARCHAR VARCHAR(40) 0 0 40 0 passes_average_yards_per VARCHAR VARCHAR(40) 0 0 40 0 passer_rating VARCHAR VARCHAR(40) 0 0 40 0 receptions_total VARCHAR VARCHAR(40) 0 0 40 0 receptions_yards VARCHAR VARCHAR(40) 0 0 40 0 receptions_touchdowns VARCHAR VARCHAR(40) 0 0 40 0 receptions_first_down VARCHAR VARCHAR(40) 0 0 40 0 receptions_longest VARCHAR VARCHAR(40) 0 0 40 0 receptions_average_yards_per VARCHAR VARCHAR(40) 0 0 40 0 american_football_sacks_against_stats3183579278760,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 sacks_against_yards VARCHAR VARCHAR(40) 0 0 40 0 sacks_against_total VARCHAR VARCHAR(40) 0 0 40 0 american_football_scoring_stats63534532333460,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 touchdowns_total VARCHAR VARCHAR(40) 0 0 40 0 touchdowns_passing VARCHAR VARCHAR(40) 0 0 40 0 touchdowns_rushing VARCHAR VARCHAR(40) 0 0 40 0 touchdowns_special_teams VARCHAR VARCHAR(40) 0 0 40 0 touchdowns_defensive VARCHAR VARCHAR(40) 0 0 40 0 extra_points_attempts VARCHAR VARCHAR(40) 0 0 40 0 extra_points_made VARCHAR VARCHAR(40) 0 0 40 0 extra_points_missed VARCHAR VARCHAR(40) 0 0 40 0 extra_points_blocked VARCHAR VARCHAR(40) 0 0 40 0 field_goal_attempts VARCHAR VARCHAR(40) 0 0 40 0 field_goals_made VARCHAR VARCHAR(40) 0 0 40 0 field_goals_missed VARCHAR VARCHAR(40) 0 0 40 0 field_goals_blocked VARCHAR VARCHAR(40) 0 0 40 0 safeties_against VARCHAR VARCHAR(40) 0 0 40 0 two_point_conversions_attempts VARCHAR VARCHAR(40) 0 0 40 0 two_point_conversions_made VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_total VARCHAR VARCHAR(40) 0 0 40 0 american_football_special_teams_stats36528652795620,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 returns_punt_total VARCHAR VARCHAR(40) 0 0 40 0 returns_punt_yards VARCHAR VARCHAR(40) 0 0 40 0 returns_punt_average VARCHAR VARCHAR(40) 0 0 40 0 returns_punt_longest VARCHAR VARCHAR(40) 0 0 40 0 returns_punt_touchdown VARCHAR VARCHAR(40) 0 0 40 0 returns_kickoff_total VARCHAR VARCHAR(40) 0 0 40 0 returns_kickoff_yards VARCHAR VARCHAR(40) 0 0 40 0 returns_kickoff_average VARCHAR VARCHAR(40) 0 0 40 0 returns_kickoff_longest VARCHAR VARCHAR(40) 0 0 40 0 returns_kickoff_touchdown VARCHAR VARCHAR(40) 0 0 40 0 returns_total VARCHAR VARCHAR(40) 0 0 40 0 returns_yards VARCHAR VARCHAR(40) 0 0 40 0 punts_total VARCHAR VARCHAR(40) 0 0 40 0 punts_yards_gross VARCHAR VARCHAR(40) 0 0 40 0 punts_yards_net VARCHAR VARCHAR(40) 0 0 40 0 punts_longest VARCHAR VARCHAR(40) 0 0 40 0 punts_inside_20 VARCHAR VARCHAR(40) 0 0 40 0 punts_inside_20_percentage VARCHAR VARCHAR(40) 0 0 40 0 punts_average VARCHAR VARCHAR(40) 0 0 40 0 punts_blocked VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_total VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_total_percentage VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_kickoffs VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_kickoffs_percentage VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_punts VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_punts_percentage VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_interceptions VARCHAR VARCHAR(40) 0 0 40 0 touchbacks_interceptions_percentage VARCHAR VARCHAR(40) 0 0 40 0 fair_catches VARCHAR VARCHAR(40) 0 0 40 0 core_stats1821791781480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 score VARCHAR VARCHAR(40) 0 0 40 0 score_opposing VARCHAR VARCHAR(40) 0 0 40 0 score_attempts VARCHAR VARCHAR(40) 0 0 40 0 score_attempts_opposing VARCHAR VARCHAR(40) 0 0 40 0 score_percentage VARCHAR VARCHAR(40) 0 0 40 0 score_percentage_opposing VARCHAR VARCHAR(40) 0 0 40 0 team_american_football_stats5425842181300,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 yards_per_attempt VARCHAR VARCHAR(40) 0 0 40 0 average_starting_position VARCHAR VARCHAR(40) 0 0 40 0 timeouts VARCHAR VARCHAR(40) 0 0 40 0 time_of_possession VARCHAR VARCHAR(40) 0 0 40 0 turnover_ratio VARCHAR VARCHAR(40) 0 0 40 0 persons_documents50207149580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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 persons_events_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 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 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 persons_events_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 teams_events_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 teams_events_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 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 document_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 document_fixtures documents id document_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 document_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 document_fixtures document_fixtures_events id document_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 document_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 document_classes document_fixtures id document_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 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 person_league_phases id league_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 persons2083781902740,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,128 id @primary_id Unique per person_key + publisher_id 1 1 person_key VARCHAR VARCHAR(40) 1 0 40 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 gender VARCHAR VARCHAR(40) 0 0 40 0 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 birth_date VARCHAR VARCHAR(40) 0 0 40 0 death_date VARCHAR VARCHAR(40) 0 0 40 0 birth_location_id INTEGER INTEGER 0 0 0 0 0 0 hometown_location_id INTEGER INTEGER 0 0 0 0 0 0 residence_location_id INTEGER INTEGER 0 0 0 0 0 0 death_location_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_seasons779569154580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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 document_fixtures_events9121161193940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 document_fixture_id INTEGER INTEGER 1 0 0 0 0 0 event_id INTEGER INTEGER 1 0 0 0 0 0 latest_document_id INTEGER INTEGER 1 0 0 0 0 0 affiliations_teams451254136580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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_phases3410991761480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 NOTE111 31 1075 85 22 Team Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_odds_lines69014101562560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(40) 0 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 40 0 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 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 numerator VARCHAR VARCHAR(40) 0 0 40 0 denominator VARCHAR VARCHAR(40) 0 0 40 0 prediction VARCHAR VARCHAR(40) 0 0 40 0 payout_calculation VARCHAR VARCHAR(40) 0 0 40 0 payout_amount VARCHAR VARCHAR(40) 0 0 40 0 wagering_moneylines9714451612380,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(40) 0 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 40 0 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 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 vigorish VARCHAR VARCHAR(40) 0 0 40 0 line VARCHAR VARCHAR(40) 0 0 40 0 line_opening VARCHAR VARCHAR(40) 0 0 40 0 prediction VARCHAR VARCHAR(40) 0 0 40 0 NOTE1111 68 1399 134 22 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 stats2418071311480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 stat_type VARCHAR VARCHAR(40) name of the table that has this stat_id as its id 0 0 40 0 stat_id INTEGER INTEGER 1 0 0 0 0 0 stat_holder_type VARCHAR VARCHAR(40) person | team | conference | league | etc. 0 0 40 0 stat_holder_id INTEGER INTEGER id of that person, team, etc. 0 0 0 0 0 0 stat_coverage_type VARCHAR VARCHAR(40) event | sub_season | league_phase | lifetime 0 0 40 0 stat_coverage_id INTEGER INTEGER id of that event, sub_season, etc. 0 0 0 0 0 0 stat_stage VARCHAR VARCHAR(40) intermediate | final ??? 1 0 40 0 baseball_action_plays91017721842740,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 notation VARCHAR VARCHAR(40) 0 0 40 0 notation_yaml TEXT TEXT 0 0 comment VARCHAR VARCHAR(255) 0 0 255 0 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 40 0 wagering_straight_spread_lines88314242292380,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(40) 0 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 40 0 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 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 vigorish VARCHAR VARCHAR(40) 0 0 40 0 value VARCHAR VARCHAR(40) 0 0 40 0 value_opening VARCHAR VARCHAR(40) 0 0 40 0 prediction VARCHAR VARCHAR(40) 0 0 40 0 Note 1000 1734 105 22 Baseball Actions 0 255,255,255 0,0,0 192,192,192 1 2 1 NOTE321 946 2606 159 22 American Football Actions 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_event_states60825912302560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 chronology VARCHAR VARCHAR(40) current | historic 1 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 publisher_key VARCHAR VARCHAR(40) 1 0 40 0 period_value INTEGER INTEGER 0 0 0 0 0 0 period_time_elapsed VARCHAR VARCHAR(40) 0 0 40 0 period_time_remaining VARCHAR VARCHAR(40) 0 0 40 0 clock_state VARCHAR VARCHAR(40) 0 0 40 0 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 40 0 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_plays85426432391660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 score_attempt_type VARCHAR VARCHAR(40) 0 0 40 0 drive_result VARCHAR VARCHAR(40) 0 0 40 0 points INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(255) 0 0 255 0 american_football_action_play_participants78728923071480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 score_type VARCHAR VARCHAR(40) 0 0 40 0 field_line INTEGER INTEGER 0 0 0 0 0 0 yardage INTEGER INTEGER 0 0 0 0 0 0 baseball_action_substitutions89621702132380,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 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 255 0 comment VARCHAR VARCHAR(255) 0 0 255 0 baseball_defensive_stats48017491852020,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 double_plays VARCHAR VARCHAR(40) 0 0 40 0 triple_plays VARCHAR VARCHAR(40) 0 0 40 0 putouts VARCHAR VARCHAR(40) 0 0 40 0 assists VARCHAR VARCHAR(40) 0 0 40 0 errors VARCHAR VARCHAR(40) 0 0 40 0 fielding_percentage VARCHAR VARCHAR(40) 0 0 40 0 defensive_average VARCHAR VARCHAR(40) 0 0 40 0 errors_passed_ball VARCHAR VARCHAR(40) 0 0 40 0 errors_catchers_interference VARCHAR VARCHAR(40) 0 0 40 0 baseball_offensive_stats23217902176340,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 average VARCHAR VARCHAR(40) 0 0 40 0 runs_scored VARCHAR VARCHAR(40) 0 0 40 0 at_bats VARCHAR VARCHAR(40) 0 0 40 0 hits VARCHAR VARCHAR(40) 0 0 40 0 rbi VARCHAR VARCHAR(40) 0 0 40 0 total_bases VARCHAR VARCHAR(40) 0 0 40 0 slugging_percentage VARCHAR VARCHAR(40) 0 0 40 0 bases_on_balls VARCHAR VARCHAR(40) 0 0 40 0 strikeouts VARCHAR VARCHAR(40) 0 0 40 0 left_on_base VARCHAR VARCHAR(40) 0 0 40 0 left_in_scoring_position VARCHAR VARCHAR(40) 0 0 40 0 singles VARCHAR VARCHAR(40) 0 0 40 0 doubles VARCHAR VARCHAR(40) 0 0 40 0 triples VARCHAR VARCHAR(40) 0 0 40 0 home_runs VARCHAR VARCHAR(40) 0 0 40 0 grand_slams VARCHAR VARCHAR(40) 0 0 40 0 at_bats_per_rbi VARCHAR VARCHAR(40) 0 0 40 0 plate_appearances_per_rbi VARCHAR VARCHAR(40) 0 0 40 0 at_bats_per_home_run VARCHAR VARCHAR(40) 0 0 40 0 plate_appearances_per_home_run VARCHAR VARCHAR(40) 0 0 40 0 sac_flies VARCHAR VARCHAR(40) 0 0 40 0 sac_bunts VARCHAR VARCHAR(40) 0 0 40 0 grounded_into_double_play VARCHAR VARCHAR(40) 0 0 40 0 moved_up VARCHAR VARCHAR(40) 0 0 40 0 on_base_percentage VARCHAR VARCHAR(40) 0 0 40 0 stolen_bases VARCHAR VARCHAR(40) 0 0 40 0 stolen_bases_caught VARCHAR VARCHAR(40) 0 0 40 0 stolen_bases_average VARCHAR VARCHAR(40) 0 0 40 0 hit_by_pitch VARCHAR VARCHAR(40) 0 0 40 0 defensive_interferance_reaches VARCHAR VARCHAR(40) 0 0 40 0 on_base_plus_slugging VARCHAR VARCHAR(40) 0 0 40 0 plate_appearances VARCHAR VARCHAR(40) 0 0 40 0 hits_extra_base VARCHAR VARCHAR(40) 0 0 40 0 wagering_total_score_lines29214111992740,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(40) 0 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 40 0 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 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 vigorish VARCHAR VARCHAR(40) 0 0 40 0 line_over VARCHAR VARCHAR(40) 0 0 40 0 line_under VARCHAR VARCHAR(40) 0 0 40 0 total VARCHAR VARCHAR(40) 0 0 40 0 total_opening VARCHAR VARCHAR(40) 0 0 40 0 prediction VARCHAR VARCHAR(40) 0 0 40 0 teams23111091222200,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 team_key VARCHAR VARCHAR(40) 1 0 40 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 first_name VARCHAR VARCHAR(40) 0 0 40 0 last_name VARCHAR VARCHAR(40) 0 0 40 0 full_name VARCHAR VARCHAR(40) 0 0 40 0 alias VARCHAR VARCHAR(40) 0 0 40 0 abbreviation VARCHAR VARCHAR(40) 0 0 40 0 short_name VARCHAR VARCHAR(40) 0 0 40 0 home_site_id INTEGER INTEGER 0 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0 basketball_defensive_stats4739421981120,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 steals_total CHAR CHAR(20) 0 0 20 0 steals_per_game CHAR CHAR(20) 0 0 20 0 blocks_total CHAR CHAR(20) 0 0 20 0 blocks_per_game CHAR CHAR(20) 0 0 20 0 basketball_event_states66239081791480,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 100 0 chronology CHAR CHAR(20) 0 0 20 0 event_id CHAR CHAR(100) 0 0 100 0 publisher_key CHAR CHAR(40) 0 0 40 0 period_value CHAR CHAR(20) 0 0 20 0 period_time_elapsed CHAR CHAR(20) 0 0 20 0 period_time_remaining CHAR CHAR(20) 0 0 20 0 basketball_offensive_stats27438752315080,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 field_goals_per_game VARCHAR VARCHAR(40) 0 0 40 0 field_goals_attempted_per_game VARCHAR VARCHAR(40) 0 0 40 0 field_goals_percentage_adjusted VARCHAR VARCHAR(40) 0 0 40 0 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 40 0 three_pointers_per_game CHAR CHAR(20) 0 0 20 0 three_pointers_attempted_per_game CHAR CHAR(20) 0 0 20 0 free_throws_made CHAR CHAR(20) 0 0 20 0 free_throws_attempted CHAR CHAR(20) 0 0 20 0 free_throws_percentage CHAR CHAR(20) 0 0 20 0 free_throws_per_game CHAR CHAR(20) 0 0 20 0 free_throws_attempted_per_game CHAR CHAR(20) 0 0 20 0 points_scored_total CHAR CHAR(20) 0 0 20 0 points_scored_per_game CHAR CHAR(20) 0 0 20 0 assists_total CHAR CHAR(20) 0 0 20 0 assists_per_game CHAR CHAR(20) 0 0 20 0 turnovers_total CHAR CHAR(20) 0 0 20 0 turnovers_per_game CHAR CHAR(20) 0 0 20 0 points_scored_off_turnovers CHAR CHAR(20) 0 0 20 0 points_scored_in_paint CHAR CHAR(20) 0 0 20 0 points_scored_on_second_chance CHAR CHAR(20) 0 0 20 0 points_scored_on_fast_break CHAR CHAR(20) 0 0 20 0 basketball_rebounding_stats4340792081840,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 rebounds_total CHAR CHAR(20) 0 0 20 0 rebounds_per_game CHAR CHAR(20) 0 0 20 0 rebounds_defensive CHAR CHAR(20) 0 0 20 0 rebounds_offensive CHAR CHAR(20) 0 0 20 0 team_rebounds_total CHAR CHAR(20) 0 0 20 0 team_rebounds_per_game CHAR CHAR(20) 0 0 20 0 team_rebounds_defensive CHAR CHAR(20) 0 0 20 0 team_rebounds_offensive CHAR CHAR(20) 0 0 20 0 ice_hockey_defensive_stats4045392042920,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 255 0 shots_power_play_allowed CHAR CHAR(20) 0 0 20 0 shots_penalty_shot_allowed CHAR CHAR(20) 0 0 20 0 goals_power_play_allowed CHAR CHAR(20) 0 0 20 0 goals_penalty_shot_allowed CHAR CHAR(20) 0 0 20 0 goals_against_average CHAR CHAR(20) 0 0 20 0 saves CHAR CHAR(20) 0 0 20 0 save_percentage CHAR CHAR(20) 0 0 20 0 penalty_killing_amount CHAR CHAR(20) 0 0 20 0 penalty_killing_percentage CHAR CHAR(20) 0 0 20 0 shots_blocked CHAR CHAR(20) 0 0 20 0 takeaways CHAR CHAR(20) 0 0 20 0 shutouts CHAR CHAR(20) 0 0 20 0 minutes_penalty_killing CHAR CHAR(20) 0 0 20 0 hits CHAR CHAR(20) 0 0 20 0 ice_hockey_event_states65644501851480,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 100 0 chronology CHAR CHAR(20) 0 0 20 0 event_id CHAR CHAR(100) 0 0 100 0 publisher_key CHAR CHAR(40) 0 0 40 0 period_value CHAR CHAR(20) 0 0 20 0 period_time_elapsed CHAR CHAR(20) 0 0 20 0 period_time_remaining CHAR CHAR(20) 0 0 20 0 ice_hockey_offensive_stats27144442014360,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 255 0 goals_game_winning CHAR CHAR(20) 0 0 20 0 goals_game_tying CHAR CHAR(20) 0 0 20 0 goals_power_play CHAR CHAR(20) 0 0 20 0 goals_short_handed CHAR CHAR(20) 0 0 20 0 goals_even_strength CHAR CHAR(20) 0 0 20 0 goals_empty_net CHAR CHAR(20) 0 0 20 0 goals_overtime CHAR CHAR(20) 0 0 20 0 goals_shootout CHAR CHAR(20) 0 0 20 0 goals_penalty_shot CHAR CHAR(20) 0 0 20 0 assists CHAR CHAR(20) 0 0 20 0 points CHAR CHAR(20) 0 0 20 0 power_play_amount CHAR CHAR(20) 0 0 20 0 power_play_percentage CHAR CHAR(20) 0 0 20 0 shots_penalty_shot_taken CHAR CHAR(20) 0 0 20 0 shots_penalty_shot_missed CHAR CHAR(20) 0 0 20 0 shots_penalty_shot_percentage CHAR CHAR(20) 0 0 20 0 giveaways CHAR CHAR(20) 0 0 20 0 minutes_power_play CHAR CHAR(20) 0 0 20 0 faceoff_wins CHAR CHAR(20) 0 0 20 0 faceoff_losses CHAR CHAR(20) 0 0 20 0 faceoff_win_percentage CHAR CHAR(20) 0 0 20 0 scoring_chances CHAR CHAR(20) 0 0 20 0 Groupbox 17 3855 1082 540 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 21 4416 1074 479 0 0 255,255,225 0,0,0 0,0,0 1 Note2 42 3897 104 22 Basketball Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Note4 47 4450 109 22 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 roles15066479940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 role_key VARCHAR VARCHAR(40) player | coach | manager | owner| umpire | etc. 1 0 40 0 role_name VARCHAR VARCHAR(40) Display name for the key 0 0 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 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_names254071141660,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,128 id @primary_id Unique per person_key + publisher_id 1 1 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 40 0 given_name VARCHAR VARCHAR(40) 0 0 40 0 middle_name VARCHAR VARCHAR(40) 0 0 40 0 family_name VARCHAR VARCHAR(40) 0 0 40 0 nickname VARCHAR VARCHAR(40) 0 0 40 0 full_name VARCHAR VARCHAR(40) 0 0 40 0 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_documents946212141580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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_phases295861111840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 person_id INTEGER INTEGER 1 0 0 0 0 0 injury_status VARCHAR VARCHAR(40) 0 0 40 0 injury_type VARCHAR VARCHAR(40) 0 0 40 0 injury_comment VARCHAR VARCHAR(40) 0 0 40 0 disabled_list VARCHAR VARCHAR(40) 0 0 40 0 start_date_time VARCHAR VARCHAR(40) 0 0 40 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 season_id INTEGER INTEGER 1 0 0 0 0 0 person_league_phases2396891691660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 role VARCHAR VARCHAR(40) 0 0 40 0 person_event_metadata2238891781120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 status VARCHAR VARCHAR(40) benched | started | played | scratched 0 0 40 0 weight VARCHAR VARCHAR(40) 0 0 40 0 role_id INTEGER INTEGER 1 0 0 0 0 0 position_id INTEGER INTEGER 1 0 0 0 0 0 team_phases307831552380,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 regular_position_id INTEGER INTEGER 0 0 0 0 0 0 start_date_time VARCHAR VARCHAR(40) 0 0 40 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 height VARCHAR VARCHAR(40) 0 0 40 0 weight VARCHAR VARCHAR(40) 0 0 40 0 affiliations4438021352200,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 affiliation_key VARCHAR VARCHAR(40) 1 0 40 0 name VARCHAR VARCHAR(40) 0 0 40 0 alias VARCHAR VARCHAR(40) 0 0 40 0 abbreviation VARCHAR VARCHAR(40) 0 0 40 0 tier VARCHAR VARCHAR(40) division | conference | caliber | organization | sport 0 0 40 0 parent_id INTEGER INTEGER 0 0 0 0 0 0 start_season_id VARCHAR VARCHAR(40) 0 0 40 0 start_date_time VARCHAR VARCHAR(40) 0 0 40 0 end_season_id VARCHAR VARCHAR(40) 0 0 40 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 positions46767089940,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 abbreviation VARCHAR VARCHAR(20) 1 0 20 0 name VARCHAR VARCHAR(40) 0 0 40 0 seasons4364301151300,0,0255,255,2550,0,0255,255,2551255,128,00010,0,0255,255,255128,128,128 id @primary_id Unique per season_key + publisher_id 1 1 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 40 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 sub_seasons5714131331430,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per season_id + type 1 1 sub_season_key VARCHAR VARCHAR(40) 0 0 40 0 season_id INTEGER INTEGER 1 0 0 0 0 0 type VARCHAR VARCHAR(40) pre | regular | post | exhibition | all-start 1 0 40 0 start_date_time VARCHAR VARCHAR(40) 0 0 40 0 end_date_time VARCHAR VARCHAR(40) 0 0 40 0 IDX_%TAB_NAME%_1 Default Default 0 sub_season_key persons_events_subscores7653741961120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 event_id VARCHAR VARCHAR(40) 0 0 40 0 person_id INTEGER INTEGER 1 0 0 0 0 0 period VARCHAR VARCHAR(40) 0 0 40 0 score VARCHAR VARCHAR(40) 0 0 40 0 persons_events988498122940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 person_id INTEGER INTEGER 1 0 0 0 0 0 event_id INTEGER INTEGER 1 0 0 0 0 0 score VARCHAR VARCHAR(40) 0 0 40 0 weather_conditions9706261461480,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 event_id VARCHAR VARCHAR(40) 0 0 40 0 temperature VARCHAR VARCHAR(40) 0 0 40 0 humidity VARCHAR VARCHAR(40) 0 0 40 0 clouds VARCHAR VARCHAR(40) 0 0 40 0 wind_direction VARCHAR VARCHAR(40) 0 0 40 0 wind_velocity VARCHAR VARCHAR(40) 0 0 40 0 events9848381152020,0,0255,255,255128,128,128255,255,2551255,128,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 event_key VARCHAR VARCHAR(40) 0 0 40 0 name VARCHAR VARCHAR(80) 0 0 80 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time DATETIME DATETIME Normalized to UTC 0 0 site_id INTEGER INTEGER 1 0 0 0 0 0 site_alignment VARCHAR VARCHAR(40) 0 0 40 0 event_status VARCHAR VARCHAR(40) 0 0 40 0 duration VARCHAR VARCHAR(40) 0 0 40 0 attendance VARCHAR VARCHAR(40) 0 0 40 0 affiliations_events768763140580,0,0255,255,255128,128,128255,255,2551192,192,1920010,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 teams_events_subscores79110201841120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 score VARCHAR VARCHAR(40) 0 0 40 0 publishers6031086109760,0,0255,255,255128,128,128255,255,2551128,255,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 publisher_key VARCHAR VARCHAR(40) 1 0 40 0 publisher_name VARCHAR VARCHAR(40) 0 0 40 0 sites44011171481580,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 alias VARCHAR VARCHAR(40) 0 0 40 0 location_id INTEGER INTEGER 0 0 0 0 0 0 wagering_runlines50914121392560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(40) 0 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(40) Time that line was set 0 0 40 0 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 40 0 comment VARCHAR VARCHAR(40) 0 0 40 0 vigorish VARCHAR VARCHAR(40) 0 0 40 0 line VARCHAR VARCHAR(40) 0 0 40 0 line_opening VARCHAR VARCHAR(40) 0 0 40 0 value VARCHAR VARCHAR(40) 0 0 40 0 prediction VARCHAR VARCHAR(40) 0 0 40 0 baseball_action_contact_details65522852291660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_action_pitch_id INTEGER INTEGER 1 0 0 0 0 0 location VARCHAR VARCHAR(40) 0 0 40 0 strength VARCHAR VARCHAR(40) hard | soft | grounder | etc. 0 0 40 0 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 40 0 trajectory_formula VARCHAR VARCHAR(40) formula describing this path 0 0 40 0 baseball_action_pitches68420731822020,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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 40 0 pitch_location VARCHAR VARCHAR(40) 0 0 40 0 pitch_type VARCHAR VARCHAR(40) 0 0 40 0 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 40 0 trajectory_formula VARCHAR VARCHAR(40) formula describing this path 0 0 40 0 baseball_event_states69517421663100,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 chronology VARCHAR VARCHAR(40) current | historic 1 0 40 0 event_id INTEGER INTEGER 1 0 0 0 0 0 publisher_id VARCHAR VARCHAR(40) change to FK for publishers table 1 0 40 0 inning_value INTEGER INTEGER 0 0 0 0 0 0 inning_half VARCHAR VARCHAR(40) top | bottom 0 0 40 0 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 40 0 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 addresses6127351003260,0,0255,255,255128,128,128255,255,2551128,128,1281000,0,0255,255,255128,128,128 id @primary_id 1 1 location_id INTEGER INTEGER 1 0 0 0 0 0 language VARCHAR VARCHAR(40) 0 0 40 0 suite VARCHAR VARCHAR(40) 0 0 40 0 floor VARCHAR VARCHAR(40) 0 0 40 0 building VARCHAR VARCHAR(40) 0 0 40 0 street_number VARCHAR VARCHAR(40) 0 0 40 0 street_prefix VARCHAR VARCHAR(40) 0 0 40 0 street VARCHAR VARCHAR(40) 0 0 40 0 street_suffix VARCHAR VARCHAR(40) 0 0 40 0 neighborhood VARCHAR VARCHAR(40) 0 0 40 0 district VARCHAR VARCHAR(40) 0 0 40 0 locality VARCHAR VARCHAR(40) 0 0 40 0 county VARCHAR VARCHAR(40) 0 0 40 0 region VARCHAR VARCHAR(40) 0 0 40 0 postal_code VARCHAR VARCHAR(40) 0 0 40 0 country VARCHAR VARCHAR(40) 0 0 40 0 locations6016171241100,0,0255,255,255128,128,128255,255,2551128,128,1281000,0,0255,255,255128,128,128 id @primary_id 1 1 timezone VARCHAR VARCHAR(40) In tz format, see: http://www.twinsun.com/tz/tz-link.htm 0 0 40 0 latitude VARCHAR VARCHAR(40) 0 0 40 0 longitude VARCHAR VARCHAR(40) 0 0 40 0 country_code VARCHAR VARCHAR(40) 0 0 40 0 Groupbox3 595 611 137 459 0 0 255,255,225 0,0,0 192,192,192 1 document_contents25693144920,0,0255,255,255128,128,128255,255,2551192,192,1920000,0,0255,255,255128,128,128 id @primary_id 1 1 document_id VARCHAR VARCHAR(40) 1 0 40 0 sportsml MEDIUMTEXT MEDIUMTEXT 0 0 abstract TEXT TEXT 0 0 Relation1 0 0 0 0 0 0 0 0 documents document_contents id document_id 3 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 key_aliases59711831151300,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,128 id @primary_id 1 1 publisher_id INTEGER INTEGER 1 0 0 0 0 0 key_type VARCHAR VARCHAR(40) person | team | league | etc. 0 0 40 0 key_value VARCHAR VARCHAR(40) A person_key, team_key, etc. 0 0 40 0 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 40 0 baseball_pitching_stats46619601735080,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 runs_allowed VARCHAR VARCHAR(40) 0 0 40 0 home_runs_allowed VARCHAR VARCHAR(40) 0 0 40 0 innings_pitched VARCHAR VARCHAR(40) 0 0 40 0 hits VARCHAR VARCHAR(40) 0 0 40 0 earned_runs VARCHAR VARCHAR(40) 0 0 40 0 unearned_runs VARCHAR VARCHAR(40) 0 0 40 0 bases_on_balls VARCHAR VARCHAR(40) 0 0 40 0 bases_on_balls_intentional VARCHAR VARCHAR(40) 0 0 40 0 strikeouts VARCHAR VARCHAR(40) 0 0 40 0 strikeout_to_bb_ratio VARCHAR VARCHAR(40) 0 0 40 0 number_of_pitches VARCHAR VARCHAR(40) 0 0 40 0 era VARCHAR VARCHAR(40) 0 0 40 0 inherited_runners_scored VARCHAR VARCHAR(40) 0 0 40 0 pick_offs VARCHAR VARCHAR(40) 0 0 40 0 errors_hit_with_pitch VARCHAR VARCHAR(40) 0 0 40 0 errors_wild_pitch VARCHAR VARCHAR(40) 0 0 40 0 balks VARCHAR VARCHAR(40) 0 0 40 0 wins VARCHAR VARCHAR(40) 0 0 40 0 losses VARCHAR VARCHAR(40) 0 0 40 0 saves VARCHAR VARCHAR(40) 0 0 40 0 shutouts VARCHAR VARCHAR(40) 0 0 40 0 games_complete VARCHAR VARCHAR(40) 0 0 40 0 games_finished VARCHAR VARCHAR(40) 0 0 40 0 winning_percentage VARCHAR VARCHAR(40) 0 0 40 0 event_credit VARCHAR VARCHAR(40) 0 0 40 0 save_credit VARCHAR VARCHAR(40) 0 0 40 0 teams_events7738631101120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 team_id INTEGER INTEGER 1 0 0 0 0 0 event_id INTEGER INTEGER 1 0 0 0 0 0 alignment VARCHAR VARCHAR(40) 0 0 40 0 score VARCHAR VARCHAR(40) 0 0 40 0