2 XML Team 2006, XML Team Solutions, Inc. 8 MySQL3 2006-03-28 2006-03-28 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 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 Relation27 0 0 0 0 0 0 0 0 publishers standings id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation11 0 0 0 0 0 0 0 0 locations media id creation_location_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation15 0 0 0 0 0 0 0 0 documents documents_media id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation17 0 0 0 0 0 0 0 0 persons media_captions id caption_author_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation18 0 0 0 0 0 0 0 0 media media_keywords id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation19 0 0 0 0 0 0 0 0 affiliations affiliations_media id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation21 0 0 0 0 0 0 0 0 persons persons_media id person_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation23 0 0 0 0 0 0 0 0 teams teams_media id team_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation25 0 0 0 0 0 0 0 0 events events_media id event_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation22 0 0 0 0 0 0 0 0 media persons_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation24 0 0 0 0 0 0 0 0 media teams_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation26 0 0 0 0 0 0 0 0 media events_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation9 0 0 0 0 0 0 0 0 publishers media id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation10 0 0 0 0 0 0 0 0 persons media id credit_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation8 0 0 0 0 0 0 0 0 documents document_package_entry id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation5 0 0 0 0 0 0 0 0 affiliations standing_subgroups id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation3 0 0 0 0 0 0 0 0 sub_seasons standings id sub_season_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation2 0 0 0 0 0 0 0 0 affiliations standings id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 NOTE3 1316 65 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 Events Group 736 358 392 627 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 1304 48 1067 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 1289 862 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 361 6 308 64 XTOSS — XML Team Open Sports Schema - Draft 8 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 1036 368 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 1318 887 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_revisions51120157760,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 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_stats16048942492560,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_stats131010652852200,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_stats130816902372740,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_stats159220142461300,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_stats131119882341480,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_stats15961790245940,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_stats130912942353820,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_stats15791918278760,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_stats189617922333460,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_stats162612042795620,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 team_american_football_stats13159232181300,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_documents48213149580,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 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 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 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 persons2073781902740,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 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_events921806193940,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 baseball_action_plays21371261842740,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 2085 61 105 22 Baseball Actions 0 255,255,255 0,0,0 192,192,192 1 2 1 NOTE321 2207 945 159 22 American Football Actions 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_event_states18699302302560,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_plays21159822391660,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_participants204812313071480,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_substitutions21155082132380,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_stats1565761852020,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_stats13171172176340,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_stats131522831981120,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_states193022491791480,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_stats154222162315080,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_stats131124202081840,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_stats132329012042920,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_states194128021851480,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_stats160027792014360,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 1285 2196 1082 540 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 1289 2757 1074 479 0 0 255,255,225 0,0,0 0,0,0 1 Note2 1310 2238 104 22 Basketball Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Note4 1334 2775 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_phases2386891691660,0,0255,255,255128,128,128255,255,2551128,128,1280010,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 weather_conditions9275861461480,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 events7535391152020,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 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 sites43111671481580,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_details18386172291660,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_pitches18563981822020,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_states1853711663100,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 addresses6127351003260,0,0255,255,255128,128,128255,255,2551128,128,1280000,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,1280000,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_stats15512871735080,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 standings5217781392540,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 affiliation_id VARCHAR VARCHAR(40) eg, ID for league-key 0 0 40 0 type VARCHAR VARCHAR(40) division | conference | playoffs | wild-card | etc. 0 0 40 0 sub_season_id VARCHAR VARCHAR(40) 0 0 40 0 last_updated VARCHAR VARCHAR(40) date timestamp that these standings were last updated 0 0 40 0 duration_scope VARCHAR VARCHAR(40) regulation | overtime | etc. Indicates class of events included statistics apply to. 0 0 40 0 competition_scope VARCHAR VARCHAR(40) NULL (all competitions) | position | team | conference | etc. Indicates that the included statistics apply only to events against particular groups of opponents, such as those in the same division, or v. lefties, v. righties 0 0 40 0 competition_scope_id VARCHAR VARCHAR(40) a team_id, a position_id, a division_id, etc. The ID for kind of competition standing is limited to 0 0 40 0 alignment_scope VARCHAR VARCHAR(40) all | home | away | etc. Indicates that the included statistics apply only to events played either at home or away 0 0 40 0 site_scope VARCHAR VARCHAR(40) all | indoors | outdoors | carpet | clay | etc. 0 0 40 0 scoping_label VARCHAR VARCHAR(40) A textual description for the scope (when all else fails...) 0 0 40 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 source VARCHAR VARCHAR(40) pre-published | real-time 0 0 40 0 standing_subgroups492042148740,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 standing_id VARCHAR VARCHAR(40) 0 0 40 0 affiliation_id VARCHAR VARCHAR(40) id for, say, American League East division 0 0 40 0 outcome_totals21517491693620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 standing_subgroup_id VARCHAR VARCHAR(40) 0 0 40 0 outcome_holder_type VARCHAR VARCHAR(40) team | player | etc 0 0 40 0 outcome_holder_id VARCHAR VARCHAR(40) the team_id or player_id or etc 0 0 40 0 rank VARCHAR VARCHAR(40) 0 0 40 0 wins VARCHAR VARCHAR(40) 0 0 40 0 losses VARCHAR VARCHAR(40) 0 0 40 0 ties VARCHAR VARCHAR(40) 0 0 40 0 undecideds VARCHAR VARCHAR(40) 0 0 40 0 winning_percentage VARCHAR VARCHAR(40) 0 0 40 0 points_scored_for VARCHAR VARCHAR(40) 0 0 40 0 points_scored_against VARCHAR VARCHAR(40) 0 0 40 0 points_difference VARCHAR VARCHAR(40) games back, for baseball 0 0 40 0 standing_points VARCHAR VARCHAR(40) 0 0 40 0 streak_type VARCHAR VARCHAR(40) win | loss | tie | score | assist | point 0 0 40 0 streak_duration VARCHAR VARCHAR(40) number of days 0 0 40 0 streak_total VARCHAR VARCHAR(40) number of games 0 0 40 0 streak_start DATE DATE 0 0 streak_end DATE DATE 0 0 Groupbox4 29 1735 368 392 0 0 255,255,225 0,0,0 192,192,192 1 periods895370132920,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 participant_event_id VARCHAR VARCHAR(40) 0 0 40 0 value VARCHAR VARCHAR(40) 0 0 40 0 score VARCHAR VARCHAR(40) 0 0 40 0 sub_periods8984739692Especially for Tennis. sub_period is for game, period is for set, score is for total number of sets won.0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 period_id VARCHAR VARCHAR(40) 0 0 40 0 value VARCHAR VARCHAR(40) 0 0 40 0 score VARCHAR VARCHAR(40) 0 0 40 0 participants_events7423691461460,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 participant_id VARCHAR VARCHAR(40) 0 0 40 0 participant_type VARCHAR VARCHAR(40) 0 0 40 0 event_id VARCHAR VARCHAR(40) 0 0 40 0 alignment VARCHAR VARCHAR(40) 0 0 40 0 score VARCHAR VARCHAR(40) 0 0 40 0 event_outcome VARCHAR VARCHAR(40) 0 0 40 0 events_sub_seasons754885154580,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 affiliations_events761799140580,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 document_packages4341790150920,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 package_key VARCHAR VARCHAR(40) eg, top-news-nba 0 0 40 0 package_name VARCHAR VARCHAR(40) eg, "Top NBA News" 0 0 40 0 date_time DATETIME DATETIME time this package was originally published 0 0 document_package_entry42919211861280,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 document_package_id VARCHAR VARCHAR(40) 0 0 40 0 rank VARCHAR VARCHAR(40) 0 0 40 0 document_id VARCHAR VARCHAR(40) 0 0 40 0 headline VARCHAR VARCHAR(40) 0 0 40 0 short_headline VARCHAR VARCHAR(40) 0 0 40 0 Groupbox5 409 1735 226 379 0 0 255,255,225 0,0,0 192,192,192 1 Note5 418 1745 177 22 Document Packages 0 255,255,255 0,0,0 192,192,192 1 2 1 Note6 40 1745 118 22 Standings Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 documents_media838175314492identifies the relationship between a document and its zero-or-more Media Objects0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 document_id VARCHAR VARCHAR(40) 0 0 40 0 media_id VARCHAR VARCHAR(40) 0 0 40 0 media_caption_id VARCHAR VARCHAR(40) 0 0 40 0 media66317791582000,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 object_id VARCHAR VARCHAR(40) parallel to the doc_id... the original unique ID provided by the publisher 0 0 40 0 source_id VARCHAR VARCHAR(40) an ID that was used upstream from the current publisher's object_id 0 0 40 0 revision_id VARCHAR VARCHAR(40) 0 0 40 0 type VARCHAR VARCHAR(40) photo | audio | video 0 0 40 0 publisher_id VARCHAR VARCHAR(40) 0 0 40 0 date_time VARCHAR VARCHAR(40) 0 0 40 0 credit_id VARCHAR VARCHAR(40) 0 0 40 0 db_loading_date_time VARCHAR VARCHAR(40) 0 0 40 0 creation_location_id VARCHAR VARCHAR(40) 0 0 40 0 media_captions81620271591640,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 media_id VARCHAR VARCHAR(40) 0 0 40 0 caption_type VARCHAR VARCHAR(40) main | headline | name, to give three common examples, from longest to shortest length 0 0 40 0 caption VARCHAR VARCHAR(40) 0 0 40 0 caption_author_id VARCHAR VARCHAR(40) 0 0 40 0 language VARCHAR VARCHAR(40) 0 0 40 0 size VARCHAR VARCHAR(40) size of caption, in characters 0 0 40 0 media_contents67820031202000,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 media_id VARCHAR VARCHAR(40) 0 0 40 0 object VARCHAR VARCHAR(40) 0 0 40 0 format VARCHAR VARCHAR(40) 0 0 40 0 mime_type VARCHAR VARCHAR(40) 0 0 40 0 height VARCHAR VARCHAR(40) 0 0 40 0 width VARCHAR VARCHAR(40) 0 0 40 0 duration VARCHAR VARCHAR(40) 0 0 40 0 size VARCHAR VARCHAR(40) 0 0 40 0 resolution VARCHAR VARCHAR(40) main | thumbnail | low-bandwidth | high-bandwidth 0 0 40 0 media_keywords9931750127740,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(40) 1 1 40 0 keyword VARCHAR VARCHAR(40) 0 0 40 0 media_id VARCHAR VARCHAR(40) 0 0 40 0 teams_media10112027104640,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 team_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0 affiliations_media9831857134620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0 persons_media9921936116590,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 person_id INTEGER INTEGER Unique per person_key + publisher_id 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0 events_media10072116108630,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0 Groupbox6 651 1729 479 480 0 0 255,255,225 0,0,0 192,192,192 1 Note7 663 1741 86 22 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats132433072123100,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 255 0 services_played CHAR CHAR(20) 0 0 20 0 matches_played CHAR CHAR(20) 0 0 20 0 aces CHAR CHAR(20) 0 0 20 0 first_services_good CHAR CHAR(20) 0 0 20 0 first_services_good_pct CHAR CHAR(20) 0 0 20 0 first_service_points_won CHAR CHAR(20) 0 0 20 0 first_service_points_won_pct CHAR CHAR(20) 0 0 20 0 second_service_points_won CHAR CHAR(20) 0 0 20 0 second_service_points_won_pct CHAR CHAR(20) 0 0 20 0 service_games_played CHAR CHAR(20) 0 0 20 0 service_games_won CHAR CHAR(20) 0 0 20 0 service_games_won_pct CHAR CHAR(20) 0 0 20 0 break_points_played CHAR CHAR(20) 0 0 20 0 break_points_saved CHAR CHAR(20) 0 0 20 0 break_points_saved_pct CHAR CHAR(40) 0 0 40 0 tennis_event_states190832831931660,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 100 0 set CHAR CHAR(20) 0 0 20 0 game CHAR CHAR(100) 0 0 100 0 server_person_id CHAR CHAR(40) 0 0 40 0 server_score CHAR CHAR(20) 0 0 20 0 receiver_person_id CHAR CHAR(20) 0 0 20 0 receiver_score CHAR CHAR(20) 0 0 20 0 service-number CHAR CHAR(40) 0 0 40 0 tennis_return_stats155433102432590,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(255) 1 0 255 0 returns_played CHAR CHAR(20) 0 0 20 0 matches_played CHAR CHAR(20) 0 0 20 0 first_service_return_points_won CHAR CHAR(20) 0 0 20 0 first_service_return_points_won_pct CHAR CHAR(20) 0 0 20 0 second_service_return_points_won CHAR CHAR(20) 0 0 20 0 second_service_return_points_won_pct CHAR CHAR(20) 0 0 20 0 return_games_played CHAR CHAR(20) 0 0 20 0 return_games_won CHAR CHAR(20) 0 0 20 0 return_games_won_pct CHAR CHAR(20) 0 0 20 0 break_points_played CHAR CHAR(20) 0 0 20 0 break_points_converted CHAR CHAR(20) 0 0 20 0 break_points_converted_pct CHAR CHAR(20) 0 0 20 0 Groupbox11 1295 3253 1074 386 0 0 255,255,225 0,0,0 0,0,0 1 Note41 1325 3270 109 22 Tennis Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Groupbox7 750 1001 384 330 0 0 255,255,225 0,0,0 192,192,192 1 core_stats93410351781480,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 core_person_stats91412051401120,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 stats77910361361660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 stat_repository_type VARCHAR VARCHAR(40) name of the table that has this stat_id as its id 0 0 40 0 stat_repository_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 NOTE322 779 1006 147 22 Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 Relation4 0 0 0 0 0 0 0 0 standings standing_subgroups id standing_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation6 0 0 0 0 0 0 0 0 standing_subgroups outcome_totals id standing_subgroup_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation7 0 0 0 0 0 0 0 0 document_packages document_package_entry id document_package_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation12 0 0 0 0 0 0 0 0 media media_contents id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation13 0 0 0 0 0 0 0 0 media documents_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation14 0 0 0 0 0 0 0 0 media_captions documents_media id media_caption_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation16 0 0 0 0 0 0 0 0 media media_captions id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation20 0 0 0 0 0 0 0 0 media affiliations_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 tennis_action_points21443283193960,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 100 0 sub_period_id CHAR CHAR(20) 0 0 20 0 sequence_number CHAR CHAR(100) 0 0 100 0 win_type CHAR CHAR(40) forced | unforced 0 0 40 0 tennis_action_volleys21413392193166One row per time the ball makes contact with a racquet. Including the first serve and the second serve.0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id CHAR CHAR(100) 1 1 100 0 sequence_number CHAR CHAR(100) 1 == first_service | 2 == second_service | 3 == return | 4 == the_next_volley | etc. 0 0 100 0 tennis_action_points_id CHAR CHAR(40) 0 0 40 0 landing_location VARCHAR VARCHAR(40) for things like hawkeye coordinates 0 0 40 0 swing_type VARCHAR VARCHAR(40) forward | backhand 0 0 40 0 result VARCHAR VARCHAR(40) winner | out | returned | let 0 0 40 0 spin_type VARCHAR VARCHAR(40) 0 0 40 0 trajectory_details VARCHAR VARCHAR(40) 0 0 40 0