4 XML Team 2007, XML Team Solutions, Inc. 8 MySQL4 8000 6000 2007-03-11 2007-03-11 Verdana,8,,0,0,-11,clWindowText 192,192,192 0 1 4 0 1 * 1 (FK) 0 -NN 0 1 1 30 1 0 0 0 0 primary_id INTEGER INTEGER 0 0 0 0 boolean_domain INTEGER INTEGER 0 0 0 0 FK_american_football_event_states_event_id__events_id events american_football_event_states 926;600;2055;600;2055;880; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_american_football_event_states_team_in_possession_id__teams_id teams american_football_event_states 392;1097;1112;1097;1112;1024;1860;1024; 0 0 0 0 0 0 id team_in_possession_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_defensive_players_player_id__persons_id persons baseball_defensive_players 400;432;1933;432;1933;730; 0 0 0 0 0 0 id player_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_substitutions_person_original_id__persons_id persons baseball_action_substitutions 400;429;2030;429; 0 0 0 0 0 0 id person_original_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_substitutions_person_replacing_id__persons_id persons baseball_action_substitutions 400;431;2030;431; 0 0 0 0 0 0 id person_replacing_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_event_states_event_id__events_id events baseball_event_states 926;676;1726;676;1726;483; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_baseball_event_states_pitcher_id__persons_id persons baseball_event_states 400;430;1640;430; 0 0 0 0 0 0 id pitcher_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_event_states_batter_id__persons_id persons baseball_event_states 400;427;1640;427; 0 0 0 0 0 0 id batter_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_event_states_runner_on_first_id__persons_id persons baseball_event_states 400;430;1640;430; 0 0 0 0 0 0 id runner_on_first_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_event_states_runner_on_third_id__persons_id persons baseball_event_states 400;431;1640;431; 0 0 0 0 0 0 id runner_on_third_id 0 0 0 None None 0,0,0 0,0,0 FK_baseball_event_states_runner_on_second_id__persons_id persons baseball_event_states 400;427;1640;427; 0 0 0 0 0 0 id runner_on_second_id 0 0 0 None None 0,0,0 0,0,0 FK_persons_hometown_location_id__locations_id locations persons 610;648;400;648; 0 0 0 0 0 0 id hometown_location_id 0 0 0 None None 0,0,0 0,0,0 FK_persons_residence_location_id__locations_id locations persons 610;650;400;650; 0 0 0 0 0 0 id residence_location_id 0 0 0 None None 0,0,0 0,0,0 FK_persons_death_location_id__locations_id locations persons 610;649;400;649; 0 0 0 0 0 0 id death_location_id 0 0 0 None None 0,0,0 0,0,0 FK_standings_publisher_id__publishers_id publishers standings 457;1310;457;1474;153;1474;153;1780; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_media_creation_location_id__locations_id locations media 657;716;657;1238;851;1238;851;1780; 0 0 0 0 0 0 id creation_location_id 0 0 1 None None 0,0,0 0,0,0 FK_documents_media_document_id__documents_id documents documents_media 568;341;568;1050;990;1050;990;1760; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_media_captions_caption_author_id__persons_id persons media_captions 347;670;347;1344;932;1344;932;2020; 0 0 0 0 0 0 id caption_author_id 0 0 1 None None 0,0,0 0,0,0 FK_media_keywords_media_id__media_id media media_keywords 920;1810;984;1810;984;1798;1080;1798; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_affiliations_media_affiliation_id__affiliations_id affiliations affiliations_media 511;1114;511;1517;1130;1517;1130;1860; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_media_person_id__persons_id persons persons_media 368;670;368;1299;1130;1299;1130;1940; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_teams_media_team_id__teams_id teams teams_media 360;1198;360;1630;1143;1630;1143;2020; 0 0 0 0 0 0 id team_id 0 0 1 None None 0,0,0 0,0,0 FK_events_media_event_id__events_id events events_media 879;783;879;1429;1141;1429;1141;2120; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_media_media_id__media_id media persons_media 920;1900;983;1900;983;1974;1080;1974; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_teams_media_media_id__media_id media teams_media 920;1930;993;1930;993;2065;1100;2065; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_events_media_media_id__media_id media events_media 920;1960;991;1960;991;2154;1080;2154; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_media_publisher_id__publishers_id publishers media 511;1310;511;1473;821;1473;821;1780; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_media_credit_id__persons_id persons media 326;670;326;1217;782;1217;782;1780; 0 0 0 0 0 0 id credit_id 0 0 1 None None 0,0,0 0,0,0 FK_document_package_entry_document_id__documents_id documents document_package_entry 487;341;487;1134;553;1134;553;1920; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_standing_subgroups_affiliation_id__affiliations_id affiliations standing_subgroups 484;1114;484;1607;146;1607;146;2040; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_standings_sub_season_id__sub_seasons_id sub_seasons standings 629;517;629;1173;127;1173;127;1780; 0 0 0 0 0 0 id sub_season_id 0 0 1 None None 0,0,0 0,0,0 FK_standings_affiliation_id__affiliations_id affiliations standings 457;1114;457;1475;83;1475;83;1780; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 NOTE3 1220 80 97 23 Baseball Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 FK_core_person_stats_position_id__positions_id positions core_person_stats 557;893;747;893;747;1199;970;1199; 0 0 0 0 0 0 id position_id 0 0 1 None None 0,0,0 0,0,0 Events Group 760 360 378 593 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 1200 60 1064 787 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 20 360 389 666 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 20 1040 397 269 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 20 80 1126 273 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX211 420 360 324 215 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 20 1320 1103 396 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 1280 860 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 360 0 319 68 XTOSS — XML Team Open Sports Schema - Draft 13 Released under GPL at http://www.xtoss.org © 2007 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 1 2 1 NOTE1 1040 370 89 23 Event Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE11 20 360 96 23 Person Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE31 20 80 115 23 Document Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 documents46090182251 id @primary_id 1 1 doc_id VARCHAR VARCHAR(75) 0 1 75 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 date_time DATE DATE Timestamp for when this document was originally published. 0 0 title VARCHAR VARCHAR(255) person | team | league | etc. 0 0 255 0 language VARCHAR VARCHAR(100) 0 0 100 0 priority VARCHAR VARCHAR(100) event | sub_season | league_phase | lifetime 0 0 100 0 revision_id VARCHAR VARCHAR(75) 0 0 75 0 stats_coverage VARCHAR VARCHAR(100) 0 0 100 0 document_fixture_id INTEGER INTEGER 0 1 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(100) Timestamp for when this document was loaded into the DB. 0 0 100 0 IDX_documents_1 IDX_%ENTITY_NAME%_1 Default Default 0 doc_id IDX_documents_3 IDX_%ENTITY_NAME%_3 Default Default 0 date_time IDX_documents_4 IDX_%ENTITY_NAME%_4 Default Default 0 priority IDX_documents_5 IDX_%ENTITY_NAME%_5 Default Default 0 revision_id IDX_FK_documents_document_fixture_id__document_fixtures_id IDX_FK_documents_document_fixture_id__document_fixtures_id Default Default 0 document_fixture_id FK_documents_document_fixture_id__document_fixtures_id IDX_FK_documents_publisher_id__publishers_id IDX_FK_documents_publisher_id__publishers_id Default Default 0 publisher_id FK_documents_publisher_id__publishers_id IDX_FK_documents_source_id__publishers_id IDX_FK_documents_source_id__publishers_id Default Default 0 source_id FK_documents_source_id__publishers_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 document_fixtures780100164118 id @primary_id Unique per fixture_key + publisher_id 1 1 fixture_key VARCHAR VARCHAR(100) 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 name VARCHAR VARCHAR(100) OUTMODED.... should use display_names instead 0 0 100 0 document_class_id INTEGER INTEGER 0 1 0 0 0 0 IDX_document_fixtures_1 IDX_%ENTITY_NAME%_1 Default Default 0 fixture_key IDX_FK_document_fixtures_document_class_id__document_classes_id IDX_FK_document_fixtures_document_class_id__document_classes_id Default Default 0 document_class_id FK_document_fixtures_document_class_id__document_classes_id IDX_FK_document_fixtures_publisher_id__publishers_id IDX_FK_document_fixtures_publisher_id__publishers_id Default Default 0 publisher_id FK_document_fixtures_publisher_id__publishers_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 document_classes98010013661 id @primary_id 1 1 name VARCHAR VARCHAR(100) event-summary, news, statistics, etc. Should be called document_class_key, really. 0 0 100 0 IDX_document_classes_1 IDX_%ENTITY_NAME%_1 Default Default 0 name 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 latest_revisions6012016780 id @primary_id 1 1 revision_id VARCHAR VARCHAR(75) a string from the SportsML 0 1 75 0 latest_document_id INTEGER INTEGER 0 1 0 0 0 0 IDX_FK_latest_revisions_latest_document_id__documents_id IDX_FK_latest_revisions_latest_document_id__documents_id Default Default 0 latest_document_id FK_latest_revisions_latest_document_id__documents_id IDX_latest_revisions_1 IDX_%ENTITY_NAME%_1 Default Default 0 revision_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 teams_documents28024013661 team_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 affiliations_documents66026016561 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_fumbles_stats13201740235289 id @primary_id 1 1 fumbles_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_forced VARCHAR VARCHAR(100) 0 0 100 0 fumbles_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_yards_gained VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_yards_gained VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_yards_gained VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_offensive_stats16002000244137 id @primary_id 1 1 offensive_plays_yards VARCHAR VARCHAR(100) 0 0 100 0 offensive_plays_number VARCHAR VARCHAR(100) 0 0 100 0 offensive_plays_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 possession_duration VARCHAR VARCHAR(100) 0 0 100 0 turnovers_giveaway VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_rushing_stats16001820232156 id @primary_id 1 1 rushes_attempts VARCHAR VARCHAR(100) 0 0 100 0 rushes_yards VARCHAR VARCHAR(100) 0 0 100 0 rushes_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 rushing_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 rushes_first_down VARCHAR VARCHAR(100) 0 0 100 0 rushes_longest VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_penalties_stats1940190024399 id @primary_id 1 1 penalties_total VARCHAR VARCHAR(100) 0 0 100 0 penalty_yards VARCHAR VARCHAR(100) 0 0 100 0 penalty_first_downs VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_passing_stats13201320233403 id @primary_id 1 1 passes_attempts VARCHAR VARCHAR(100) 0 0 100 0 passes_completions VARCHAR VARCHAR(100) 0 0 100 0 passes_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_gross VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_net VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_lost VARCHAR VARCHAR(100) 0 0 100 0 passes_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 passes_touchdowns_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_interceptions VARCHAR VARCHAR(100) 0 0 100 0 passes_interceptions_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_longest VARCHAR VARCHAR(100) 0 0 100 0 passes_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 passer_rating VARCHAR VARCHAR(100) 0 0 100 0 receptions_total VARCHAR VARCHAR(100) 0 0 100 0 receptions_yards VARCHAR VARCHAR(100) 0 0 100 0 receptions_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 receptions_first_down VARCHAR VARCHAR(100) 0 0 100 0 receptions_longest VARCHAR VARCHAR(100) 0 0 100 0 receptions_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_sacks_against_stats1960204027680 id @primary_id 1 1 sacks_against_yards VARCHAR VARCHAR(100) 0 0 100 0 sacks_against_total VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_scoring_stats19401500231365 id @primary_id 1 1 touchdowns_total VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_passing VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_rushing VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_special_teams VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_defensive VARCHAR VARCHAR(100) 0 0 100 0 extra_points_attempts VARCHAR VARCHAR(100) 0 0 100 0 extra_points_made VARCHAR VARCHAR(100) 0 0 100 0 extra_points_missed VARCHAR VARCHAR(100) 0 0 100 0 extra_points_blocked VARCHAR VARCHAR(100) 0 0 100 0 field_goal_attempts VARCHAR VARCHAR(100) 0 0 100 0 field_goals_made VARCHAR VARCHAR(100) 0 0 100 0 field_goals_missed VARCHAR VARCHAR(100) 0 0 100 0 field_goals_blocked VARCHAR VARCHAR(100) 0 0 100 0 safeties_against VARCHAR VARCHAR(100) 0 0 100 0 two_point_conversions_attempts VARCHAR VARCHAR(100) 0 0 100 0 two_point_conversions_made VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_total VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 team_american_football_stats1340920216137 id @primary_id 1 1 yards_per_attempt VARCHAR VARCHAR(100) 0 0 100 0 average_starting_position VARCHAR VARCHAR(100) 0 0 100 0 timeouts VARCHAR VARCHAR(100) 0 0 100 0 time_of_possession VARCHAR VARCHAR(100) 0 0 100 0 turnover_ratio VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 persons_documents4022014761 person_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_weather_conditions_event_id__events_id events weather_conditions 926;759;960;759; 0 0 0 0 0 0 id event_id 1 2 1 None None 255,128,192 0,0,0 FK_persons_current_injury_phase_id__injury_phases_id injury_phases persons 189;466;200;466; 0 0 0 0 0 0 id current_injury_phase_id 1 3 0 None None 0,0,0 0,0,0 FK_persons_publisher_id__publishers_id publishers persons 445;1230;445;760;400;760;400;670; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_events_publisher_id__publishers_id publishers events 505;1230;505;917;825;917;825;783; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_person_phases_person_id__persons_id persons person_phases 200;670;200;700; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,128,255 0,0,0 FK_injury_phases_person_id__persons_id persons injury_phases 200;466;189;466; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,128,255 0,0,0 FK_persons_current_team_phase_id__person_phases_id person_phases persons 200;700;200;670; 0 0 0 0 0 0 id current_team_phase_id 1 3 0 None None 0,0,0 0,0,0 FK_sites_publisher_id__publishers_id publishers sites 537;1230;551;1230;551;1219; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_injury_phases_season_id__seasons_id seasons injury_phases 430;442;189;442; 0 0 0 0 0 0 id season_id 1 0 1 None None 255,128,0 0,0,0 FK_events_sub_seasons_event_id__events_id events events_sub_seasons 852;783;852;815;883;815;883;880; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_team_affiliation_phases_team_id__teams_id teams team_affiliation_phases 260;1157;214;1157; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_team_affiliation_phases_affiliation_id__affiliations_id affiliations team_affiliation_phases 430;1094;214;1094;214;1100; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_teams_home_site_id__sites_id sites teams 430;1120;392;1120; 0 0 0 0 0 0 id home_site_id 0 0 0 None None 0,0,0 0,0,0 FK_teams_publisher_id__publishers_id publishers teams 430;1281;392;1281;392;1198; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 128,255,128 0,0,0 FK_seasons_publisher_id__publishers_id publishers seasons 460;1230;460;832;522;832;522;507; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_affiliations_events_event_id__events_id events affiliations_events 858;783;858;800; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_affiliations_events_affiliation_id__affiliations_id affiliations affiliations_events 576;1012;658;1012;658;832;780;832; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_team_affiliation_phases_start_season_id__seasons_id seasons team_affiliation_phases 466;507;466;846;102;846;102;1100; 0 0 0 0 0 0 id start_season_id 0 0 1 None None 255,128,0 0,0,0 FK_team_affiliation_phases_end_season_id__seasons_id seasons team_affiliation_phases 478;507;478;846;160;846;160;1100; 0 0 0 0 0 0 id end_season_id 0 0 1 None None 255,128,0 0,0,0 FK_person_phases_start_season_id__seasons_id seasons person_phases 442;507;442;712;205;712; 0 0 0 0 0 0 id start_season_id 0 0 1 None None 255,128,0 0,0,0 FK_person_phases_end_season_id__seasons_id seasons person_phases 454;507;454;712;205;712; 0 0 0 0 0 0 id end_season_id 0 0 1 None None 255,128,0 0,0,0 FK_sub_seasons_season_id__seasons_id seasons sub_seasons 576;416;590;416; 0 0 0 0 0 0 id season_id 1 0 1 None None 0,0,0 0,0,0 FK_events_sub_seasons_sub_season_id__sub_seasons_id sub_seasons events_sub_seasons 668;517;668;728;840;728;840;880; 0 0 0 0 0 0 id sub_season_id 0 0 1 None None 0,0,0 0,0,0 FK_document_fixtures_publisher_id__publishers_id publishers document_fixtures 520;1230;520;654;833;654;833;218; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_documents_publisher_id__publishers_id publishers documents 475;1230;475;719;514;719;514;341; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_documents_document_fixture_id__document_fixtures_id document_fixtures documents 780;163;642;163; 0 0 0 0 0 0 id document_fixture_id 1 0 1 None None 0,0,0 0,0,0 FK_teams_documents_document_id__documents_id documents teams_documents 460;298;437;298;437;280;416;280; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_teams_documents_team_id__teams_id teams teams_documents 340;1080;340;301; 0 0 0 0 0 0 id team_id 0 0 1 None None 0,0,0 0,0,0 FK_affiliations_documents_document_id__documents_id documents affiliations_documents 642;305;660;305; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_affiliations_documents_affiliation_id__affiliations_id affiliations affiliations_documents 511;920;511;661;747;661;747;321; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_document_fixtures_events_event_id__events_id events document_fixtures_events 926;783;1044;783;1044;820; 0 0 0 0 0 0 id event_id 1 0 1 None None 255,128,192 0,0,0 FK_document_fixtures_events_document_fixture_id__document_fixtures_id document_fixtures document_fixtures_events 882;218;882;518;1082;518;1082;820; 0 0 0 0 0 0 id document_fixture_id 1 0 1 None None 0,0,0 0,0,0 FK_document_fixtures_events_latest_document_id__documents_id documents document_fixtures_events 595;341;595;577;988;577;988;820; 0 0 0 0 0 0 id latest_document_id 1 0 1 None None 0,0,0 0,0,0 FK_document_fixtures_document_class_id__document_classes_id document_classes document_fixtures 980;132;956;132;956;146;944;146; 0 0 0 0 0 0 id document_class_id 1 0 1 None None 0,0,0 0,0,0 FK_wagering_moneylines_event_id__events_id events wagering_moneylines 789;783;789;1088;246;1088;246;1340; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wagering_moneylines_team_id__teams_id teams wagering_moneylines 287;1198;287;1340; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wagering_straight_spread_lines_event_id__events_id events wagering_straight_spread_lines 861;783;861;1076;994;1076;994;1340; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wagering_straight_spread_lines_team_id__teams_id teams wagering_straight_spread_lines 392;1165;616;1165;616;1472;880;1472; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wagering_odds_lines_event_id__events_id events wagering_odds_lines 834;783;834;1077;778;1077;778;1340; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wagering_odds_lines_team_id__teams_id teams wagering_odds_lines 392;1182;521;1182;521;1473;700;1473; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wagering_total_score_lines_team_id__teams_id teams wagering_total_score_lines 360;1198;360;1340; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wagering_runlines_event_id__events_id events wagering_runlines 816;783;816;1078;632;1078;632;1340; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wagering_runlines_team_id__teams_id teams wagering_runlines 340;1198;340;1323;586;1323;586;1340; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_latest_revisions_latest_document_id__documents_id documents latest_revisions 460;194;334;194;334;162;227;162; 0 0 0 0 0 0 id latest_document_id 1 3 1 None None 0,0,0 0,0,0 FK_teams_league_id__affiliations_id affiliations teams 430;966;389;966;389;1080; 0 0 0 0 0 0 id league_id 0 0 0 None None 0,0,0 0,0,0 FK_seasons_league_id__affiliations_id affiliations seasons 474;920;474;507; 0 0 0 0 0 0 id league_id 1 0 1 None None 0,0,0 0,0,0 FK_persons_documents_document_id__documents_id documents persons_documents 460;246;187;246; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_documents_person_id__persons_id persons persons_documents 200;402;122;402;122;281; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_substitutions_baseball_event_state_id__baseball_event_states_id baseball_event_states baseball_action_substitutions 1819;338;1939;338;1939;469;2030;469; 0 0 0 0 0 0 id baseball_event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_plays_baseball_event_state_id__baseball_event_states_id baseball_event_states baseball_action_plays 1819;209;1939;209;1939;243;2030;243; 0 0 0 0 0 0 id baseball_event_state_id 1 0 1 None None 0,0,0 0,0,0 FK_baseball_action_substitutions_person_original_position_id__positions_id positions baseball_action_substitutions 557;851;1343;851;1343;535;2030;535; 0 0 0 0 0 0 id person_original_position_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_substitutions_person_replacing_position_id__positions_id positions baseball_action_substitutions 557;872;1343;872;1343;601;2030;601; 0 0 0 0 0 0 id person_replacing_position_id 0 0 0 None None 0,0,0 0,0,0 FK_person_phases_regular_position_id__positions_id positions person_phases 430;910;430;952;205;952; 0 0 0 0 0 0 id regular_position_id 1 0 1 None None 0,0,0 0,0,0 FK_wagering_total_score_lines_event_id__events_id events wagering_total_score_lines 798;783;798;1072;452;1072;452;1340; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 document_fixtures_events940820191118 id @primary_id 1 1 document_fixture_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 latest_document_id INTEGER INTEGER 0 1 0 0 0 0 last_update DATE DATE 0 0 IDX_FK_document_fixtures_events_document_fixture_id__document_fixtures_id IDX_FK_document_fixtures_events_document_fixture_id__document_fixtures_id Default Default 0 document_fixture_id FK_document_fixtures_events_document_fixture_id__document_fixtures_id IDX_FK_document_fixtures_events_event_id__events_id IDX_FK_document_fixtures_events_event_id__events_id Default Default 0 event_id FK_document_fixtures_events_event_id__events_id IDX_FK_document_fixtures_events_latest_document_id__documents_id IDX_FK_document_fixtures_events_latest_document_id__documents_id Default Default 0 latest_document_id FK_document_fixtures_events_latest_document_id__documents_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 NOTE111 40 1060 89 23 Team Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_odds_lines7001340162270 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 numerator VARCHAR VARCHAR(100) 0 0 100 0 denominator VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 payout_calculation VARCHAR VARCHAR(100) 0 0 100 0 payout_amount VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 baseball_action_plays2030100222289 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 0 1 0 0 0 0 play_type VARCHAR VARCHAR(100) 0 0 100 0 notation VARCHAR VARCHAR(100) 0 0 100 0 notation_yaml TEXT TEXT 0 0 baseball_defensive_group_id INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(100) 0 0 100 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(100) 0 0 100 0 IDX_baseball_action_plays_1 IDX_%ENTITY_NAME%_1 Default Default 0 play_type IDX_FK_baseball_action_plays_baseball_event_state_id__baseball_event_states_id IDX_FK_baseball_action_plays_baseball_event_state_id__baseball_event_states_id Default Default 0 baseball_event_state_id FK_baseball_action_plays_baseball_event_state_id__baseball_event_states_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 wagering_straight_spread_lines8801340227251 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line_value VARCHAR VARCHAR(100) 0 0 100 0 line_value_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 Note 2140 70 109 23 Baseball Actions 0 255,255,255 0,0,0 192,192,192 1 2 1 NOTE321 2200 940 163 23 American Football Actions 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_event_states1860880228270 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state SMALLINT SMALLINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 period_value INTEGER INTEGER 0 0 0 0 0 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0 clock_state VARCHAR VARCHAR(100) 0 0 100 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(100) home | away 0 0 100 0 field_line INTEGER INTEGER 0 0 0 0 0 0 IDX_american_football_event_states_1 IDX_%ENTITY_NAME%_1 Default Default 0 current_state IDX_FK_american_football_event_states_event_id__events_id IDX_FK_american_football_event_states_event_id__events_id Default Default 0 event_id FK_american_football_event_states_event_id__events_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_american_football_action_plays_american_football_event_state_id__american_football_event_states_id american_football_event_states american_football_action_plays 2088;1005;2110;1005; 0 0 0 0 0 0 id american_football_event_state_id 1 0 1 None None 0,0,0 0,0,0 FK_american_football_action_participants_american_football_action_play_id__american_football_action_plays_id american_football_action_plays american_football_action_participants 2229;1156;2229;1218;2197;1218;2197;1260; 0 0 0 0 0 0 id american_football_action_play_id 1 0 1 None None 0,0,0 0,0,0 FK_american_football_action_participants_person_id__persons_id persons american_football_action_participants 400;542;1233;542;1233;1337;2060;1337; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,0,0 0,0,0 american_football_action_plays21101000249156 id @primary_id 1 1 american_football_event_state_id INTEGER INTEGER 0 1 0 0 0 0 play_type VARCHAR VARCHAR(100) 0 0 100 0 score_attempt_type VARCHAR VARCHAR(100) 0 0 100 0 drive_result VARCHAR VARCHAR(100) 0 0 100 0 points INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(100) 0 0 100 0 IDX_american_football_action_plays_1 IDX_%ENTITY_NAME%_1 Default Default 0 play_type IDX_american_football_action_plays_2 IDX_%ENTITY_NAME%_2 Default Default 0 score_attempt_type IDX_american_football_action_plays_3 IDX_%ENTITY_NAME%_3 Default Default 0 drive_result IDX_FK_american_football_action_plays_american_football_event_state_id__american_football_event_states_id IDX_FK_american_football_action_plays_american_football_event_state_id__american_football_event_states_id Default Default 0 american_football_event_state_id FK_american_football_action_plays_american_football_event_state_id__american_football_event_states_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_action_participants20601260269156 id @primary_id 1 1 american_football_action_play_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER Unique per person_key + publisher_id 0 1 0 0 0 0 participant_role VARCHAR VARCHAR(100) 0 1 100 0 score_type VARCHAR VARCHAR(100) 0 0 100 0 field_line INTEGER INTEGER 0 0 0 0 0 0 yardage INTEGER INTEGER 0 0 0 0 0 0 IDX_american_football_action_participants_1 IDX_%ENTITY_NAME%_1 Default Default 0 participant_role IDX_american_football_action_participants_2 IDX_%ENTITY_NAME%_2 Default Default 0 score_type IDX_FK_american_football_action_participants_american_football_action_play_id__american_football_action_plays_id IDX_FK_american_football_action_participants_american_football_action_play_id__american_football_action_plays_id Default Default 0 american_football_action_play_id FK_american_football_action_participants_american_football_action_play_id__american_football_action_plays_id IDX_FK_american_football_action_participants_person_id__persons_id IDX_FK_american_football_action_participants_person_id__persons_id Default Default 0 person_id FK_american_football_action_participants_person_id__persons_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 baseball_defensive_stats144080183213 id @primary_id 1 1 double_plays VARCHAR VARCHAR(100) 0 0 100 0 triple_plays VARCHAR VARCHAR(100) 0 0 100 0 putouts VARCHAR VARCHAR(100) 0 0 100 0 assists VARCHAR VARCHAR(100) 0 0 100 0 errors VARCHAR VARCHAR(100) 0 0 100 0 fielding_percentage VARCHAR VARCHAR(100) 0 0 100 0 defensive_average VARCHAR VARCHAR(100) 0 0 100 0 errors_passed_ball VARCHAR VARCHAR(100) 0 0 100 0 errors_catchers_interference VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 baseball_offensive_stats1210140215612 id @primary_id 1 1 average VARCHAR VARCHAR(100) 0 0 100 0 runs_scored VARCHAR VARCHAR(100) 0 0 100 0 at_bats VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0 rbi VARCHAR VARCHAR(100) 0 0 100 0 total_bases VARCHAR VARCHAR(100) 0 0 100 0 slugging_percentage VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls VARCHAR VARCHAR(100) 0 0 100 0 strikeouts VARCHAR VARCHAR(100) 0 0 100 0 left_on_base VARCHAR VARCHAR(100) 0 0 100 0 left_in_scoring_position VARCHAR VARCHAR(100) 0 0 100 0 singles VARCHAR VARCHAR(100) 0 0 100 0 doubles VARCHAR VARCHAR(100) 0 0 100 0 triples VARCHAR VARCHAR(100) 0 0 100 0 home_runs VARCHAR VARCHAR(100) 0 0 100 0 grand_slams VARCHAR VARCHAR(100) 0 0 100 0 at_bats_per_rbi VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances_per_rbi VARCHAR VARCHAR(100) 0 0 100 0 at_bats_per_home_run VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances_per_home_run VARCHAR VARCHAR(100) 0 0 100 0 sac_flies VARCHAR VARCHAR(100) 0 0 100 0 sac_bunts VARCHAR VARCHAR(100) 0 0 100 0 grounded_into_double_play VARCHAR VARCHAR(100) 0 0 100 0 moved_up VARCHAR VARCHAR(100) 0 0 100 0 on_base_percentage VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases_caught VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases_average VARCHAR VARCHAR(100) 0 0 100 0 hit_by_pitch VARCHAR VARCHAR(100) 0 0 100 0 defensive_interferance_reaches VARCHAR VARCHAR(100) 0 0 100 0 on_base_plus_slugging VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances VARCHAR VARCHAR(100) 0 0 100 0 hits_extra_base VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 wagering_total_score_lines3201340197289 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line_over VARCHAR VARCHAR(100) 0 0 100 0 line_under VARCHAR VARCHAR(100) 0 0 100 0 total VARCHAR VARCHAR(100) 0 0 100 0 total_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 basketball_defensive_stats13202280196118 id @primary_id 1 1 steals_total VARCHAR VARCHAR(100) 0 0 100 0 steals_per_game VARCHAR VARCHAR(100) 0 0 100 0 blocks_total VARCHAR VARCHAR(100) 0 0 100 0 blocks_per_game VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 basketball_event_states18202260177156 id @primary_id 1 1 chronology VARCHAR VARCHAR(100) 0 0 100 0 event_id INTEGER INTEGER 0 0 0 0 0 0 publisher_key VARCHAR VARCHAR(100) 0 0 100 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 basketball_offensive_stats15402220229536 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(100) 0 0 100 0 field_goals_per_game VARCHAR VARCHAR(100) 0 0 100 0 field_goals_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 field_goals_percentage_adjusted VARCHAR VARCHAR(100) 0 0 100 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(100) 0 0 100 0 three_pointers_per_game VARCHAR VARCHAR(100) 0 0 100 0 three_pointers_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 free_throws_made VARCHAR VARCHAR(100) 0 0 100 0 free_throws_attempted VARCHAR VARCHAR(100) 0 0 100 0 free_throws_percentage VARCHAR VARCHAR(100) 0 0 100 0 free_throws_per_game VARCHAR VARCHAR(100) 0 0 100 0 free_throws_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 points_scored_total VARCHAR VARCHAR(100) 0 0 100 0 points_scored_per_game VARCHAR VARCHAR(100) 0 0 100 0 assists_total VARCHAR VARCHAR(100) 0 0 100 0 assists_per_game VARCHAR VARCHAR(100) 0 0 100 0 turnovers_total VARCHAR VARCHAR(100) 0 0 100 0 turnovers_per_game VARCHAR VARCHAR(100) 0 0 100 0 points_scored_off_turnovers VARCHAR VARCHAR(100) 0 0 100 0 points_scored_in_paint VARCHAR VARCHAR(100) 0 0 100 0 points_scored_on_second_chance VARCHAR VARCHAR(100) 0 0 100 0 points_scored_on_fast_break VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 basketball_rebounding_stats13202440206194 id @primary_id 1 1 rebounds_total VARCHAR VARCHAR(100) 0 0 100 0 rebounds_per_game VARCHAR VARCHAR(100) 0 0 100 0 rebounds_defensive VARCHAR VARCHAR(100) 0 0 100 0 rebounds_offensive VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_total VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_per_game VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_defensive VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_offensive VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 ice_hockey_defensive_stats13402840202308 id @primary_id 1 1 shots_power_play_allowed VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_power_play_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_against_average VARCHAR VARCHAR(100) 0 0 100 0 saves VARCHAR VARCHAR(100) 0 0 100 0 save_percentage VARCHAR VARCHAR(100) 0 0 100 0 penalty_killing_amount VARCHAR VARCHAR(100) 0 0 100 0 penalty_killing_percentage VARCHAR VARCHAR(100) 0 0 100 0 shots_blocked VARCHAR VARCHAR(100) 0 0 100 0 takeaways VARCHAR VARCHAR(100) 0 0 100 0 shutouts VARCHAR VARCHAR(100) 0 0 100 0 minutes_penalty_killing VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 ice_hockey_event_states18602820183156 id @primary_id 1 1 chronology VARCHAR VARCHAR(100) 0 0 100 0 event_id INTEGER INTEGER 0 0 0 0 0 0 publisher_key VARCHAR VARCHAR(100) 0 0 100 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 ice_hockey_offensive_stats16002780199460 id @primary_id 1 1 goals_game_winning VARCHAR VARCHAR(100) 0 0 100 0 goals_game_tying VARCHAR VARCHAR(100) 0 0 100 0 goals_power_play VARCHAR VARCHAR(100) 0 0 100 0 goals_short_handed VARCHAR VARCHAR(100) 0 0 100 0 goals_even_strength VARCHAR VARCHAR(100) 0 0 100 0 goals_empty_net VARCHAR VARCHAR(100) 0 0 100 0 goals_overtime VARCHAR VARCHAR(100) 0 0 100 0 goals_shootout VARCHAR VARCHAR(100) 0 0 100 0 goals_penalty_shot VARCHAR VARCHAR(100) 0 0 100 0 assists VARCHAR VARCHAR(100) 0 0 100 0 points VARCHAR VARCHAR(100) 0 0 100 0 power_play_amount VARCHAR VARCHAR(100) 0 0 100 0 power_play_percentage VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_taken VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_missed VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_percentage VARCHAR VARCHAR(100) 0 0 100 0 giveaways VARCHAR VARCHAR(100) 0 0 100 0 minutes_power_play VARCHAR VARCHAR(100) 0 0 100 0 faceoff_wins VARCHAR VARCHAR(100) 0 0 100 0 faceoff_losses VARCHAR VARCHAR(100) 0 0 100 0 faceoff_win_percentage VARCHAR VARCHAR(100) 0 0 100 0 scoring_chances VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 Groupbox 1280 2200 1082 540 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 1280 2760 1074 479 0 0 255,255,225 0,0,0 0,0,0 1 Note2 1300 2240 108 23 Basketball Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Note4 1340 2780 113 23 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 roles2407007799 id @primary_id 1 1 role_key VARCHAR VARCHAR(100) player | coach | manager | owner| umpire | etc. 0 1 100 0 role_name VARCHAR VARCHAR(100) Display name for the key 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 IDX_roles_1 IDX_%ENTITY_NAME%_1 Default Default 0 role_key 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_person_phases_role_id__roles_id roles person_phases 240;715;205;715; 0 0 0 0 0 0 id role_id 0 0 1 None None 0,0,0 0,0,0 FK_person_event_metadata_role_id__roles_id roles person_event_metadata 317;799;317;860; 0 0 0 0 0 0 id role_id 1 0 0 None None 0,0,0 0,0,0 FK_person_event_metadata_position_id__positions_id positions person_event_metadata 430;864;396;864; 0 0 0 0 0 0 id position_id 1 0 0 None None 0,0,0 0,0,0 FK_key_aliases_publisher_id__publishers_id publishers key_aliases 537;1230;537;1210;600;1210; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 0,0,0 0,0,0 FK_baseball_action_contact_details_baseball_action_pitch_id__baseball_action_pitches_id baseball_action_pitches baseball_action_contact_details 2002;620;2020;620;2020;660; 0 0 0 0 0 0 id baseball_action_pitch_id 0 0 1 None None 0,0,0 0,0,0 FK_documents_source_id__publishers_id publishers documents 490;1230;490;341; 0 0 0 0 0 0 id source_id 1 0 0 None None 0,0,0 0,0,0 events_documents96022013961 event_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_events_documents_event_id__events_id events events_documents 837;570;837;408;1036;408;1036;281; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_events_documents_document_id__documents_id documents events_documents 642;222;784;222;784;244;960;244; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 injury_phases40440149194 id @primary_id 1 1 person_id INTEGER INTEGER 0 1 0 0 0 0 injury_status VARCHAR VARCHAR(100) 0 0 100 0 injury_type VARCHAR VARCHAR(100) 0 0 100 0 injury_comment VARCHAR VARCHAR(100) 0 0 100 0 disabled_list VARCHAR VARCHAR(100) 0 0 100 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 season_id INTEGER INTEGER 0 1 0 0 0 0 IDX_FK_injury_phases_person_id__persons_id IDX_FK_injury_phases_person_id__persons_id Default Default 0 person_id FK_injury_phases_person_id__persons_id IDX_FK_injury_phases_season_id__seasons_id IDX_FK_injury_phases_season_id__seasons_id Default Default 0 season_id FK_injury_phases_season_id__seasons_id IDX_injury_phases_2 IDX_%ENTITY_NAME%_2 Default Default 0 injury_status IDX_injury_phases_3 IDX_%ENTITY_NAME%_3 Default Default 0 start_date_time IDX_injury_phases_4 IDX_%ENTITY_NAME%_4 Default Default 0 end_date_time 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 person_phases40700165308 id @primary_id 1 1 person_id INTEGER INTEGER 0 1 0 0 0 0 membership_type VARCHAR VARCHAR(40) teams | affiliations 0 0 40 0 membership_id INTEGER INTEGER the team_id or affiliation_id 0 1 0 0 0 0 role_id INTEGER INTEGER 0 1 0 0 0 0 role_status VARCHAR VARCHAR(40) further metadata on the role (free-agent, signed, retired | drafted | playing) 0 0 40 0 phase_status VARCHAR VARCHAR(40) active | inactive 0 0 40 0 uniform_number VARCHAR VARCHAR(20) 0 0 20 0 regular_position_id INTEGER INTEGER 0 1 0 0 0 0 start_date_time DATE DATE 0 0 start_season_id INTEGER INTEGER 0 1 0 0 0 0 end_date_time DATE DATE 0 0 end_season_id INTEGER INTEGER 0 1 0 0 0 0 height VARCHAR VARCHAR(100) 0 0 100 0 weight VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_person_phases_person_id__persons_id IDX_FK_person_phases_person_id__persons_id Default Default 0 person_id FK_person_phases_person_id__persons_id IDX_FK_person_phases_regular_position_id__positions_id IDX_FK_person_phases_regular_position_id__positions_id Default Default 0 regular_position_id FK_person_phases_regular_position_id__positions_id IDX_person_phases_1 IDX_%ENTITY_NAME%_1 Default Default 0 membership_type IDX_person_phases_2 IDX_%ENTITY_NAME%_2 Default Default 0 membership_id IDX_person_phases_3 IDX_%ENTITY_NAME%_3 Default Default 0 phase_status 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 positions43083012780 id @primary_id 1 1 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 abbreviation VARCHAR VARCHAR(20) 0 1 20 0 IDX_FK_positions_affiliation_id__affiliations_id IDX_FK_positions_affiliation_id__affiliations_id Default Default 0 affiliation_id FK_positions_affiliation_id__affiliations_id IDX_positions_1 IDX_%ENTITY_NAME%_1 Default Default 0 abbreviation 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 seasons430370146137 id @primary_id Unique per season_key + publisher_id 1 1 season_key INTEGER INTEGER 0 1 0 0 0 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 league_id INTEGER INTEGER 0 1 0 0 0 0 start_date_time DATE DATE 0 0 end_date_time DATE DATE 0 0 IDX_FK_seasons_league_id__affiliations_id IDX_FK_seasons_league_id__affiliations_id Default Default 0 league_id FK_seasons_league_id__affiliations_id IDX_FK_seasons_publisher_id__publishers_id IDX_FK_seasons_publisher_id__publishers_id Default Default 0 publisher_id FK_seasons_publisher_id__publishers_id IDX_seasons_1 IDX_%ENTITY_NAME%_1 Default Default 0 season_key 0,0,0255,255,2550,0,0255,255,2551255,128,00010,0,0255,255,255128,128,1281 sub_seasons590380155137 id INTEGER INTEGER Unique per season_id + type 1 1 0 0 0 0 sub_season_key VARCHAR VARCHAR(100) 0 1 100 0 season_id INTEGER INTEGER 0 1 0 0 0 0 sub_season_type VARCHAR VARCHAR(100) pre | regular | post | exhibition | all-star 0 1 100 0 start_date_time DATE DATE 0 0 end_date_time DATE DATE 0 0 IDX_FK_sub_seasons_season_id__seasons_id IDX_FK_sub_seasons_season_id__seasons_id Default Default 0 season_id FK_sub_seasons_season_id__seasons_id IDX_sub_seasons_1 IDX_%ENTITY_NAME%_1 Default Default 0 sub_season_key IDX_sub_seasons_2 IDX_%ENTITY_NAME%_2 Default Default 0 sub_season_type 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 events780570146213 id @primary_id 1 1 event_key VARCHAR VARCHAR(100) 0 1 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 start_date_time DATE DATE Normalized to UTC 0 0 site_id INTEGER INTEGER 0 0 0 0 0 0 site_alignment VARCHAR VARCHAR(100) 0 0 100 0 event_status VARCHAR VARCHAR(100) 0 0 100 0 duration VARCHAR VARCHAR(100) 0 0 100 0 attendance VARCHAR VARCHAR(100) 0 0 100 0 last_update DATE DATE 0 0 IDX_events_1 IDX_%ENTITY_NAME%_1 Default Default 0 event_key IDX_FK_events_publisher_id__publishers_id IDX_FK_events_publisher_id__publishers_id Default Default 0 publisher_id FK_events_publisher_id__publishers_id IDX_FK_events_site_id__sites_id IDX_FK_events_site_id__sites_id Default Default 0 site_id FK_events_site_id__sites_id 0,0,0255,255,255128,128,128255,255,2551255,128,1920010,0,0255,255,255128,128,1281 wagering_runlines5401340138270 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line VARCHAR VARCHAR(100) 0 0 100 0 line_opening VARCHAR VARCHAR(100) 0 0 100 0 line_value VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 baseball_action_contact_details2020660227175 id @primary_id 1 1 baseball_action_pitch_id INTEGER INTEGER 0 1 0 0 0 0 location VARCHAR VARCHAR(100) 0 0 100 0 strength VARCHAR VARCHAR(100) hard | soft | grounder | etc. 0 0 100 0 velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0 trajectory_coordinates VARCHAR VARCHAR(100) yaml array of coordinates? 0 0 100 0 trajectory_formula VARCHAR VARCHAR(100) formula describing this path 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_events_site_id__sites_id sites events 487;1120;487;985;807;985;807;783; 0 0 0 0 0 0 id site_id 1 0 0 None None 0,0,0 0,0,0 locations61060091116 id @primary_id 1 1 timezone VARCHAR VARCHAR(100) In tz format, see: http://www.twinsun.com/tz/tz-link.htm 0 0 100 0 latitude VARCHAR VARCHAR(100) 0 0 100 0 longitude VARCHAR VARCHAR(100) 0 0 100 0 country_code VARCHAR VARCHAR(100) 0 0 100 0 IDX_locations_1 IDX_%ENTITY_NAME%_1 Default Default 0 country_code 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 Groupbox3 590 590 156 497 0 0 255,255,225 0,0,0 192,192,192 1 document_contents26010014297 id @primary_id 1 1 document_id INTEGER INTEGER 0 1 0 0 0 0 sportsml VARCHAR VARCHAR(40) 0 0 40 0 abstract TEXT TEXT 0 0 IDX_FK_document_contents_document_id__documents_id IDX_FK_document_contents_document_id__documents_id Default Default 0 document_id FK_document_contents_document_id__documents_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920000,0,0255,255,255128,128,1281 FK_document_contents_document_id__documents_id documents document_contents 460;142;402;142; 0 0 0 0 0 0 id document_id 1 3 1 None None 0,0,0 0,0,0 baseball_pitching_stats1440300171536 id @primary_id 1 1 runs_allowed VARCHAR VARCHAR(100) 0 0 100 0 home_runs_allowed VARCHAR VARCHAR(100) 0 0 100 0 innings_pitched VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0 earned_runs VARCHAR VARCHAR(100) 0 0 100 0 unearned_runs VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls_intentional VARCHAR VARCHAR(100) 0 0 100 0 strikeouts VARCHAR VARCHAR(100) 0 0 100 0 strikeout_to_bb_ratio VARCHAR VARCHAR(100) 0 0 100 0 number_of_pitches VARCHAR VARCHAR(100) 0 0 100 0 era VARCHAR VARCHAR(100) 0 0 100 0 inherited_runners_scored VARCHAR VARCHAR(100) 0 0 100 0 pick_offs VARCHAR VARCHAR(100) 0 0 100 0 errors_hit_with_pitch VARCHAR VARCHAR(100) 0 0 100 0 errors_wild_pitch VARCHAR VARCHAR(100) 0 0 100 0 balks VARCHAR VARCHAR(100) 0 0 100 0 wins VARCHAR VARCHAR(100) 0 0 100 0 losses VARCHAR VARCHAR(100) 0 0 100 0 saves VARCHAR VARCHAR(100) 0 0 100 0 shutouts VARCHAR VARCHAR(100) 0 0 100 0 games_complete VARCHAR VARCHAR(100) 0 0 100 0 games_finished VARCHAR VARCHAR(100) 0 0 100 0 winning_percentage VARCHAR VARCHAR(100) 0 0 100 0 event_credit VARCHAR VARCHAR(100) 0 0 100 0 save_credit VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 standings401780177268 id INTEGER INTEGER 1 1 0 0 0 0 affiliation_id INTEGER INTEGER eg, ID for league-key 0 1 0 0 0 0 standing_type VARCHAR VARCHAR(100) division | conference | playoffs | wild-card | etc. 0 0 100 0 sub_season_id INTEGER INTEGER 0 1 0 0 0 0 last_updated VARCHAR VARCHAR(100) date timestamp that these standings were last updated 0 0 100 0 duration_scope VARCHAR VARCHAR(100) regulation | overtime | etc. Indicates class of events included statistics apply to. 0 0 100 0 competition_scope VARCHAR VARCHAR(100) 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 100 0 competition_scope_id VARCHAR VARCHAR(100) a team_id, a position_id, a division_id, etc. The ID for kind of competition standing is limited to 0 0 100 0 alignment_scope VARCHAR VARCHAR(100) all | home | away | etc. Indicates that the included statistics apply only to events played either at home or away 0 0 100 0 site_scope VARCHAR VARCHAR(100) all | indoors | outdoors | carpet | clay | etc. 0 0 100 0 scoping_label VARCHAR VARCHAR(100) A textual description for the scope (when all else fails...) 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 source VARCHAR VARCHAR(100) pre-published | real-time 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 standing_subgroups40204014678 id INTEGER INTEGER 1 1 0 0 0 0 standing_id INTEGER INTEGER 0 1 0 0 0 0 affiliation_id INTEGER INTEGER id for, say, American League East division 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 outcome_totals2201740181382 id INTEGER INTEGER 1 1 0 0 0 0 standing_subgroup_id INTEGER INTEGER 0 1 0 0 0 0 outcome_holder_type VARCHAR VARCHAR(100) team | player | etc 0 0 100 0 outcome_holder_id INTEGER INTEGER the team_id or player_id or etc 0 0 0 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 wins VARCHAR VARCHAR(100) 0 0 100 0 losses VARCHAR VARCHAR(100) 0 0 100 0 ties VARCHAR VARCHAR(100) 0 0 100 0 undecideds VARCHAR VARCHAR(100) 0 0 100 0 winning_percentage VARCHAR VARCHAR(100) 0 0 100 0 points_scored_for VARCHAR VARCHAR(100) 0 0 100 0 points_scored_against VARCHAR VARCHAR(100) 0 0 100 0 points_difference VARCHAR VARCHAR(100) games back, for baseball 0 0 100 0 standing_points VARCHAR VARCHAR(100) 0 0 100 0 streak_type VARCHAR VARCHAR(100) win | loss | tie | score | assist | point 0 0 100 0 streak_duration VARCHAR VARCHAR(100) number of days 0 0 100 0 streak_total VARCHAR VARCHAR(100) number of games 0 0 100 0 streak_start DATE DATE 0 0 streak_end DATE DATE 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 Groupbox4 20 1740 368 392 0 0 255,255,225 0,0,0 192,192,192 1 periods95042017097 id @primary_id 1 1 participant_event_id INTEGER INTEGER 0 1 0 0 0 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 score VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_periods_participant_event_id__participants_events_id IDX_FK_periods_participant_event_id__participants_events_id Default Default 0 participant_event_id FK_periods_participant_event_id__participants_events_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 sub_periods96053015597 id @primary_id 1 1 period_id INTEGER INTEGER 0 1 0 0 0 0 sub_period_value VARCHAR VARCHAR(100) 0 0 100 0 score VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_sub_periods_period_id__periods_id IDX_FK_sub_periods_period_id__periods_id Default Default 0 period_id FK_sub_periods_period_id__periods_id Especially 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,1281 participants_events780380146173 id @primary_id 1 1 participant_type VARCHAR VARCHAR(100) 0 1 100 0 participant_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 alignment VARCHAR VARCHAR(100) 0 0 100 0 score VARCHAR VARCHAR(100) 0 0 100 0 event_outcome VARCHAR VARCHAR(100) 0 0 100 0 rank INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_participants_events_event_id__events_id IDX_FK_participants_events_event_id__events_id Default Default 0 event_id FK_participants_events_event_id__events_id IDX_participants_events_1 IDX_%ENTITY_NAME%_1 Default Default 0 participant_type IDX_participants_events_2 IDX_%ENTITY_NAME%_2 Default Default 0 participant_id IDX_participants_events_3 IDX_%ENTITY_NAME%_3 Default Default 0 alignment IDX_participants_events_4 IDX_%ENTITY_NAME%_4 Default Default 0 event_outcome 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 events_sub_seasons78088015261 event_id INTEGER INTEGER 1 1 0 0 0 0 sub_season_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 affiliations_events78080013861 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 document_packages440180014897 id INTEGER INTEGER 1 1 0 0 0 0 package_key VARCHAR VARCHAR(100) eg, top-news-nba 0 0 100 0 package_name VARCHAR VARCHAR(100) eg, "Top NBA News" 0 0 100 0 date_time DATE DATE time this package was originally published 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 document_package_entry4201920184135 id INTEGER INTEGER 1 1 0 0 0 0 document_package_id INTEGER INTEGER 0 1 0 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 document_id INTEGER INTEGER 0 1 0 0 0 0 headline VARCHAR VARCHAR(100) 0 0 100 0 short_headline VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 Groupbox5 400 1740 226 379 0 0 255,255,225 0,0,0 192,192,192 1 Note5 420 1740 177 23 Document Packages 0 255,255,255 0,0,0 192,192,192 1 2 1 Note6 40 1740 118 23 Standings Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 documents_media920176015497 id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 media_caption_id INTEGER INTEGER 0 1 0 0 0 0 identifies 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,1281 media7401780180211 id INTEGER INTEGER 1 1 0 0 0 0 object_id INTEGER INTEGER parallel to the doc_id... the original unique ID provided by the publisher 0 0 0 0 0 0 source_id INTEGER INTEGER an ID that was used upstream from the current publisher's object_id 0 0 0 0 0 0 revision_id INTEGER INTEGER 0 0 0 0 0 0 media_type VARCHAR VARCHAR(100) photo | audio | video 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) 0 0 100 0 credit_id INTEGER INTEGER 0 1 0 0 0 0 db_loading_date_time VARCHAR VARCHAR(100) 0 0 100 0 creation_location_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 media_captions9002020156154 id INTEGER INTEGER 1 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 caption_type VARCHAR VARCHAR(100) main | headline | name, to give three common examples, from longest to shortest length 0 0 100 0 caption VARCHAR VARCHAR(100) 0 0 100 0 caption_author_id INTEGER INTEGER 0 1 0 0 0 0 language VARCHAR VARCHAR(100) 0 0 100 0 caption_size VARCHAR VARCHAR(100) size of caption, in characters 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 media_contents6802000118211 id INTEGER INTEGER 1 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 object VARCHAR VARCHAR(100) 0 0 100 0 format VARCHAR VARCHAR(100) 0 0 100 0 mime_type VARCHAR VARCHAR(100) 0 0 100 0 height VARCHAR VARCHAR(100) 0 0 100 0 width VARCHAR VARCHAR(100) 0 0 100 0 duration VARCHAR VARCHAR(100) 0 0 100 0 file_size VARCHAR VARCHAR(100) 0 0 100 0 resolution VARCHAR VARCHAR(100) main | thumbnail | low-bandwidth | high-bandwidth 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 media_keywords1080176012578 id INTEGER INTEGER 1 1 0 0 0 0 keyword VARCHAR VARCHAR(100) 0 0 100 0 media_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 teams_media1100202010659 team_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 affiliations_media1060186013259 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 persons_media1080194011459 person_id INTEGER INTEGER Unique per person_key + publisher_id 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 events_media1080212010659 event_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 Groupbox6 740 1720 479 480 0 0 255,255,225 0,0,0 192,192,192 1 Note7 740 1740 90 23 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats13203300199327 id @primary_id 1 1 services_played VARCHAR VARCHAR(100) 0 0 100 0 matches_played VARCHAR VARCHAR(100) 0 0 100 0 aces VARCHAR VARCHAR(100) 0 0 100 0 first_services_good VARCHAR VARCHAR(100) 0 0 100 0 first_services_good_pct VARCHAR VARCHAR(100) 0 0 100 0 first_service_points_won VARCHAR VARCHAR(100) 0 0 100 0 first_service_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 second_service_points_won VARCHAR VARCHAR(100) 0 0 100 0 second_service_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 service_games_played VARCHAR VARCHAR(100) 0 0 100 0 service_games_won VARCHAR VARCHAR(100) 0 0 100 0 service_games_won_pct VARCHAR VARCHAR(100) 0 0 100 0 break_points_played VARCHAR VARCHAR(100) 0 0 100 0 break_points_saved VARCHAR VARCHAR(100) 0 0 100 0 break_points_saved_pct VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 tennis_event_states18803300149175 id @primary_id 1 1 tennis_set VARCHAR VARCHAR(100) set is a reserved word in SQL 0 0 100 0 game VARCHAR VARCHAR(100) 0 0 100 0 server_person_id INTEGER INTEGER 0 0 0 0 0 0 server_score VARCHAR VARCHAR(100) 0 0 100 0 receiver_person_id INTEGER INTEGER 0 0 0 0 0 0 receiver_score VARCHAR VARCHAR(100) 0 0 100 0 service_number VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 tennis_return_stats15603300241270 id @primary_id 1 1 returns_played VARCHAR VARCHAR(100) 0 0 100 0 matches_played VARCHAR VARCHAR(100) 0 0 100 0 first_service_return_points_won VARCHAR VARCHAR(100) 0 0 100 0 first_service_return_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 second_service_return_points_won VARCHAR VARCHAR(100) 0 0 100 0 second_service_return_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 return_games_played VARCHAR VARCHAR(100) 0 0 100 0 return_games_won VARCHAR VARCHAR(100) 0 0 100 0 return_games_won_pct VARCHAR VARCHAR(100) 0 0 100 0 break_points_played VARCHAR VARCHAR(100) 0 0 100 0 break_points_converted VARCHAR VARCHAR(100) 0 0 100 0 break_points_converted_pct VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 Groupbox11 1260 4240 1074 596 0 0 255,255,225 0,0,0 0,0,0 1 Note41 1300 3280 109 23 Tennis Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Groupbox7 760 960 384 313 0 0 255,255,225 0,0,0 192,192,192 1 core_stats950970176156 id @primary_id 1 1 score VARCHAR VARCHAR(100) 0 0 100 0 score_opposing VARCHAR VARCHAR(100) 0 0 100 0 score_attempts VARCHAR VARCHAR(100) 0 0 100 0 score_attempts_opposing VARCHAR VARCHAR(100) 0 0 100 0 score_percentage VARCHAR VARCHAR(100) 0 0 100 0 score_percentage_opposing VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 core_person_stats9701140141118 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 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 stats7901030134175 id @primary_id 1 1 stat_repository_type VARCHAR VARCHAR(100) name of the table that has this stat_id as its id 0 0 100 0 stat_repository_id INTEGER INTEGER id in that table for this row 0 1 0 0 0 0 stat_holder_type VARCHAR VARCHAR(100) persons | teams | affiliations | etc. 0 0 100 0 stat_holder_id INTEGER INTEGER id of that person, team, etc. 0 0 0 0 0 0 stat_coverage_type VARCHAR VARCHAR(100) events | sub_seasons | affiliations | *_phases | etc. 0 0 100 0 stat_coverage_id INTEGER INTEGER id of that event, sub_season, etc. 0 0 0 0 0 0 context VARCHAR VARCHAR(40) event if this is a confirmed stat, event-play if an unofficial mid-game update, etc. 0 1 40 0 IDX_stats_1 IDX_%ENTITY_NAME%_1 Default Default 0 stat_repository_type IDX_stats_2 IDX_%ENTITY_NAME%_2 Default Default 0 stat_repository_id IDX_stats_3 IDX_%ENTITY_NAME%_3 Default Default 0 stat_holder_type IDX_stats_4 IDX_%ENTITY_NAME%_4 Default Default 0 stat_holder_id IDX_stats_5 IDX_%ENTITY_NAME%_5 Default Default 0 stat_coverage_type IDX_stats_6 IDX_%ENTITY_NAME%_6 Default Default 0 stat_coverage_id IDX_stats_7 IDX_%ENTITY_NAME%_7 Default Default 0 context 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 NOTE322 780 980 147 23 Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 FK_standing_subgroups_standing_id__standings_id standings standing_subgroups 97;2040; 0 0 0 0 0 0 id standing_id 0 0 1 None None 0,0,0 0,0,0 FK_outcome_totals_standing_subgroup_id__standing_subgroups_id standing_subgroups outcome_totals 186;2078;197;2078;197;1934;220;1934; 0 0 0 0 0 0 id standing_subgroup_id 0 0 1 None None 0,0,0 0,0,0 FK_document_package_entry_document_package_id__document_packages_id document_packages document_package_entry 515;1897;515;1916;497;1916;497;1920; 0 0 0 0 0 0 id document_package_id 0 0 1 None None 0,0,0 0,0,0 FK_media_contents_media_id__media_id media media_contents 787;1991;787;2000; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_documents_media_media_id__media_id media documents_media 920;1807; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_documents_media_media_caption_id__media_captions_id media_captions documents_media 1008;2020;1008;1934;994;1934;994;1857; 0 0 0 0 0 0 id media_caption_id 0 0 1 None None 0,0,0 0,0,0 FK_media_captions_media_id__media_id media media_captions 844;1991;844;2012;965;2012;965;2020; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_affiliations_media_media_id__media_id media affiliations_media 920;1870;979;1870;979;1895;1060;1895; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 tennis_action_points2120328015299 id @primary_id 1 1 sub_period_id VARCHAR VARCHAR(100) 0 0 100 0 sequence_number VARCHAR VARCHAR(100) 0 0 100 0 win_type VARCHAR VARCHAR(100) forced | unforced 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 tennis_action_volleys21203420159175 id @primary_id 1 1 sequence_number VARCHAR VARCHAR(100) 1 == first_service | 2 == second_service | 3 == return | 4 == the_next_volley | etc. 0 0 100 0 tennis_action_points_id INTEGER INTEGER 0 0 0 0 0 0 landing_location VARCHAR VARCHAR(100) for things like hawkeye coordinates 0 0 100 0 swing_type VARCHAR VARCHAR(100) forward | backhand 0 0 100 0 result VARCHAR VARCHAR(100) winner | out | returned | let 0 0 100 0 spin_type VARCHAR VARCHAR(100) 0 0 100 0 trajectory_details VARCHAR VARCHAR(100) 0 0 100 0 One 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,1281 baseball_defensive_players179073022097 id @primary_id 1 1 baseball_defensive_group_id INTEGER INTEGER 0 1 0 0 0 0 player_id INTEGER INTEGER 0 1 0 0 0 0 position_id INTEGER INTEGER 0 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 baseball_defensive_group160072018740 id @primary_id 1 1 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 american_football_down_progress_stats13001080283232 id @primary_id 1 1 first_downs_total VARCHAR VARCHAR(100) 0 0 100 0 first_downs_pass VARCHAR VARCHAR(100) 0 0 100 0 first_downs_run VARCHAR VARCHAR(100) 0 0 100 0 first_downs_penalty VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down_attempts VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down_percentage VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down_attempts VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down_percentage VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 NOTE32 1360 880 151 23 American Football Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_defensive_stats1600880247270 id @primary_id 1 1 tackles_total VARCHAR VARCHAR(100) 0 0 100 0 tackles_solo VARCHAR VARCHAR(100) 0 0 100 0 tackles_assists VARCHAR VARCHAR(100) 0 0 100 0 interceptions_total VARCHAR VARCHAR(100) 0 0 100 0 interceptions_yards VARCHAR VARCHAR(100) 0 0 100 0 interceptions_average VARCHAR VARCHAR(100) 0 0 100 0 interceptions_longest VARCHAR VARCHAR(100) 0 0 100 0 interceptions_touchdown VARCHAR VARCHAR(100) 0 0 100 0 quarterback_hurries VARCHAR VARCHAR(100) 0 0 100 0 sacks_total VARCHAR VARCHAR(100) 0 0 100 0 sacks_yards VARCHAR VARCHAR(100) 0 0 100 0 passes_defensed VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_special_teams_stats16401220277593 id @primary_id 1 1 returns_punt_total VARCHAR VARCHAR(100) 0 0 100 0 returns_punt_yards VARCHAR VARCHAR(100) 0 0 100 0 returns_punt_average VARCHAR VARCHAR(100) 0 0 100 0 returns_punt_longest VARCHAR VARCHAR(100) 0 0 100 0 returns_punt_touchdown VARCHAR VARCHAR(100) 0 0 100 0 returns_kickoff_total VARCHAR VARCHAR(100) 0 0 100 0 returns_kickoff_yards VARCHAR VARCHAR(100) 0 0 100 0 returns_kickoff_average VARCHAR VARCHAR(100) 0 0 100 0 returns_kickoff_longest VARCHAR VARCHAR(100) 0 0 100 0 returns_kickoff_touchdown VARCHAR VARCHAR(100) 0 0 100 0 returns_total VARCHAR VARCHAR(100) 0 0 100 0 returns_yards VARCHAR VARCHAR(100) 0 0 100 0 punts_total VARCHAR VARCHAR(100) 0 0 100 0 punts_yards_gross VARCHAR VARCHAR(100) 0 0 100 0 punts_yards_net VARCHAR VARCHAR(100) 0 0 100 0 punts_longest VARCHAR VARCHAR(100) 0 0 100 0 punts_inside_20 VARCHAR VARCHAR(100) 0 0 100 0 punts_inside_20_percentage VARCHAR VARCHAR(100) 0 0 100 0 punts_average VARCHAR VARCHAR(100) 0 0 100 0 punts_blocked VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_total VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_total_percentage VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_kickoffs VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_kickoffs_percentage VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_punts VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_punts_percentage VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_interceptions VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_interceptions_percentage VARCHAR VARCHAR(100) 0 0 100 0 fair_catches VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_affiliations_publisher_id__publishers_id publishers affiliations 439;1230;439;1114; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 0,0,0 0,0,0 FK_team_affiliation_phases_role_id__roles_id roles team_affiliation_phases 255;799;255;1177;214;1177; 0 0 0 0 0 0 id role_id 0 0 0 None None 0,0,0 0,0,0 FK_person_event_metadata_person_id__persons_id persons person_event_metadata 213;670;213;860;220;860; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,0,0 0,0,0 FK_person_event_metadata_event_id__events_id events person_event_metadata 780;598;366;598;366;860; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 person_event_metadata220860176156 id @primary_id 1 1 person_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 status VARCHAR VARCHAR(100) benched | started | played | scratched 0 0 100 0 weight VARCHAR VARCHAR(100) 0 0 100 0 role_id INTEGER INTEGER 0 0 0 0 0 0 position_id INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_person_event_metadata_event_id__events_id IDX_FK_person_event_metadata_event_id__events_id Default Default 0 event_id FK_person_event_metadata_event_id__events_id IDX_FK_person_event_metadata_person_id__persons_id IDX_FK_person_event_metadata_person_id__persons_id Default Default 0 person_id FK_person_event_metadata_person_id__persons_id IDX_FK_person_event_metadata_position_id__positions_id IDX_FK_person_event_metadata_position_id__positions_id Default Default 0 position_id FK_person_event_metadata_position_id__positions_id IDX_FK_person_event_metadata_role_id__roles_id IDX_FK_person_event_metadata_role_id__roles_id Default Default 0 role_id FK_person_event_metadata_role_id__roles_id IDX_person_event_metadata_1 IDX_%ENTITY_NAME%_1 Default Default 0 status 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 bookmakers80160014999 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_key VARCHAR VARCHAR(100) 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 location_id INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_bookmakers_publisher_id__publishers_id publishers bookmakers 430;1273;140;1273;140;1600; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_wagering_moneylines_bookmaker_id__bookmakers_id bookmakers wagering_moneylines 173;1600;173;1591; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wagering_total_score_lines_bookmaker_id__bookmakers_id bookmakers wagering_total_score_lines 229;1600;229;1366;320;1366; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wagering_runlines_bookmaker_id__bookmakers_id bookmakers wagering_runlines 229;1600;229;1362;540;1362; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wagering_odds_lines_bookmaker_id__bookmakers_id bookmakers wagering_odds_lines 229;1600;229;1367;700;1367; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wagering_straight_spread_lines_bookmaker_id__bookmakers_id bookmakers wagering_straight_spread_lines 229;1600;229;1362;880;1362; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 team_affiliation_phases401100174194 id @primary_id 1 1 team_id INTEGER INTEGER 0 1 0 0 0 0 start_season_id INTEGER INTEGER 0 1 0 0 0 0 end_season_id INTEGER INTEGER 0 1 0 0 0 0 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 phase_status VARCHAR VARCHAR(40) active | inactive 0 0 40 0 role_id INTEGER INTEGER identifies the relationship between a minor league team and parent MLB ballclub 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 teams2601080132118 id @primary_id 1 1 team_key VARCHAR VARCHAR(100) 0 1 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 home_site_id INTEGER INTEGER 0 0 0 0 0 0 league_id INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,1281 NOTE1111 300 1680 138 23 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_moneylines1401340159251 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line VARCHAR VARCHAR(100) 0 0 100 0 line_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_bookmakers_location_id__locations_id locations bookmakers 668;716;668;1654;229;1654; 0 0 0 0 0 0 id location_id 0 0 0 None None 0,0,0 0,0,0 Groupbox111 1280 3260 1074 386 0 0 255,255,225 0,0,0 0,0,0 1 Note411 1320 3700 109 23 Soccer Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 soccer_event_states19403700152156 id @primary_id 1 1 event_id VARCHAR VARCHAR(100) 0 0 100 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0 minutes_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_minute_elapsed VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 soccer_offensive_stats14403680197517 id @primary_id 1 1 goals_game_winning VARCHAR VARCHAR(100) 0 0 100 0 goals_game_tying VARCHAR VARCHAR(100) 0 0 100 0 goals_overtime VARCHAR VARCHAR(100) 0 0 100 0 goals_shootout VARCHAR VARCHAR(100) 0 0 100 0 goals_total VARCHAR VARCHAR(100) 0 0 100 0 assists_game_winning VARCHAR VARCHAR(100) 0 0 100 0 assists_game_tying VARCHAR VARCHAR(100) 0 0 100 0 assists_overtime VARCHAR VARCHAR(100) 0 0 100 0 assists_total VARCHAR VARCHAR(100) 0 0 100 0 points VARCHAR VARCHAR(100) 0 0 100 0 shots_total VARCHAR VARCHAR(100) 0 0 100 0 shots_on_goal_total VARCHAR VARCHAR(100) 0 0 100 0 shots_hit_frame VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_taken VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_scored VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_missed VARCHAR VARCHAR(40) 0 0 40 0 shots_penalty_shot_percentage VARCHAR VARCHAR(40) 0 0 40 0 shots_shootout_taken VARCHAR VARCHAR(40) 0 0 40 0 shots_shootout_scored VARCHAR VARCHAR(40) 0 0 40 0 shots_shootout_missed VARCHAR VARCHAR(40) 0 0 40 0 shots_shootout_percentage VARCHAR VARCHAR(40) 0 0 40 0 giveaways VARCHAR VARCHAR(40) 0 0 40 0 offsides VARCHAR VARCHAR(40) 0 0 40 0 corner_kicks VARCHAR VARCHAR(40) 0 0 40 0 hat_tricks VARCHAR VARCHAR(40) 0 0 40 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 soccer_defensive_stats16803700176270 id @primary_id 1 1 shots_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_against_average VARCHAR VARCHAR(100) 0 0 100 0 goals_against_total VARCHAR VARCHAR(100) 0 0 100 0 saves VARCHAR VARCHAR(100) 0 0 100 0 save_percentage VARCHAR VARCHAR(100) 0 0 100 0 catches_punches VARCHAR VARCHAR(100) 0 0 100 0 shots_on_goal_total VARCHAR VARCHAR(100) 0 0 100 0 shots_shootout_total VARCHAR VARCHAR(100) 0 0 100 0 shots_shootout_allowed VARCHAR VARCHAR(100) 0 0 100 0 shots_blocked VARCHAR VARCHAR(100) 0 0 100 0 shutouts VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 soccer_foul_stats16803980150175 id @primary_id 1 1 fouls_suffered VARCHAR VARCHAR(100) 0 0 100 0 fouls_commited VARCHAR VARCHAR(100) 0 0 100 0 cautions_total VARCHAR VARCHAR(100) 0 0 100 0 cautions_pending VARCHAR VARCHAR(100) 0 0 100 0 caution_points_total VARCHAR VARCHAR(100) 0 0 100 0 caution_points_pending VARCHAR VARCHAR(100) 0 0 100 0 ejections_total VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 Groupbox112 1280 3660 1074 556 0 0 255,255,225 0,0,0 0,0,0 1 Note4111 1300 4280 123 23 Motor Racing Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 motor_racing_event_states19804280197137 id @primary_id 1 1 event_id VARCHAR VARCHAR(100) 0 0 100 0 lap VARCHAR VARCHAR(100) 0 0 100 0 laps_remaining VARCHAR VARCHAR(100) 0 0 100 0 time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 flag_state VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 publishers430123010780 id @primary_id 1 1 publisher_key VARCHAR VARCHAR(100) 0 1 100 0 publisher_name VARCHAR VARCHAR(100) 0 0 100 0 IDX_publishers_1 IDX_%ENTITY_NAME%_1 Default Default 0 publisher_key 0,0,0255,255,255128,128,128255,255,2551128,255,1280010,0,0255,255,255128,128,1281 motor_racing_race_stats14804280181536 id @primary_id 1 1 time_behind_leader VARCHAR VARCHAR(100) 0 0 100 0 laps_behind_leader VARCHAR VARCHAR(100) 0 0 100 0 time_ahead_follower VARCHAR VARCHAR(100) 0 0 100 0 laps_ahead_follower VARCHAR VARCHAR(100) 0 0 100 0 time VARCHAR VARCHAR(100) 0 0 100 0 points VARCHAR VARCHAR(100) 0 0 100 0 points_rookie VARCHAR VARCHAR(100) 0 0 100 0 bonus VARCHAR VARCHAR(100) 0 0 100 0 laps_completed VARCHAR VARCHAR(100) 0 0 100 0 laps_leading_total VARCHAR VARCHAR(100) 0 0 100 0 distance_leading VARCHAR VARCHAR(100) 0 0 100 0 distance_completed VARCHAR VARCHAR(100) 0 0 100 0 distance_units VARCHAR VARCHAR(40) 0 0 40 0 speed_average VARCHAR VARCHAR(40) 0 0 40 0 speed_units VARCHAR VARCHAR(40) 0 0 40 0 status VARCHAR VARCHAR(40) 0 0 40 0 finishes_top_5 VARCHAR VARCHAR(40) 0 0 40 0 finishes_top_10 VARCHAR VARCHAR(40) 0 0 40 0 starts VARCHAR VARCHAR(40) 0 0 40 0 finishes VARCHAR VARCHAR(40) 0 0 40 0 non_finishes VARCHAR VARCHAR(40) 0 0 40 0 wins VARCHAR VARCHAR(40) 0 0 40 0 races_leading VARCHAR VARCHAR(40) 0 0 40 0 money VARCHAR VARCHAR(40) 0 0 40 0 money_units VARCHAR VARCHAR(40) 0 0 40 0 leads_total VARCHAR VARCHAR(40) 0 0 40 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 motor_racing_qualifying_stats17004280217175 id @primary_id 1 1 grid VARCHAR VARCHAR(100) 0 0 100 0 pole_position VARCHAR VARCHAR(100) 0 0 100 0 pole_wins VARCHAR VARCHAR(100) 0 0 100 0 qualifying_speed VARCHAR VARCHAR(100) 0 0 100 0 qualifying_speed_units VARCHAR VARCHAR(100) 0 0 100 0 qualifying_time VARCHAR VARCHAR(100) 0 0 100 0 qualifying_position VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 affiliations430920146194 id @primary_id 1 1 affiliation_key VARCHAR VARCHAR(100) 0 1 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 tier VARCHAR VARCHAR(100) division | conference | caliber | organization | sport 0 0 100 0 parent_id INTEGER INTEGER 0 0 0 0 0 0 start_season_id INTEGER INTEGER 0 0 0 0 0 0 start_date_time DATE DATE 0 0 end_season_id INTEGER INTEGER 0 0 0 0 0 0 end_date_time DATE DATE 0 0 IDX_affiliations_1 IDX_%ENTITY_NAME%_1 Default Default 0 affiliation_key IDX_affiliations_2 IDX_%ENTITY_NAME%_2 Default Default 0 tier IDX_FK_affiliations_publisher_id__publishers_id IDX_FK_affiliations_publisher_id__publishers_id Default Default 0 publisher_id FK_affiliations_publisher_id__publishers_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_persons_current_league_phase_id__person_phases_id person_phases persons 200;700;200;670; 0 0 0 0 0 0 id current_league_phase_id 1 0 0 None None 0,0,0 0,0,0 persons200400200270 id @primary_id Unique per person_key + publisher_id 1 1 person_key VARCHAR VARCHAR(100) 0 1 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 gender VARCHAR VARCHAR(20) 0 0 20 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(30) 0 0 30 0 death_date VARCHAR VARCHAR(30) 0 0 30 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 IDX_FK_persons_current_injury_phase_id__injury_phases_id IDX_FK_persons_current_injury_phase_id__injury_phases_id Default Default 0 current_injury_phase_id FK_persons_current_injury_phase_id__injury_phases_id IDX_FK_persons_current_league_phase_id__person_phases_id IDX_FK_persons_current_league_phase_id__person_phases_id Default Default 0 current_league_phase_id FK_persons_current_league_phase_id__person_phases_id IDX_FK_persons_current_team_phase_id__person_phases_id IDX_FK_persons_current_team_phase_id__person_phases_id Default Default 0 current_team_phase_id FK_persons_current_team_phase_id__person_phases_id IDX_FK_persons_publisher_id__publishers_id IDX_FK_persons_publisher_id__publishers_id Default Default 0 publisher_id FK_persons_publisher_id__publishers_id IDX_persons_1 IDX_%ENTITY_NAME%_1 Default Default 0 person_key 0,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,1281 FK_persons_birth_location_id__locations_id locations persons 610;649;400;649; 0 0 0 0 0 0 id birth_location_id 0 0 0 None None 0,0,0 0,0,0 display_names430590112230 id @primary_id 1 1 language VARCHAR VARCHAR(100) 0 1 100 0 entity_type VARCHAR VARCHAR(100) person | team | affiliation tier | site | position 0 1 100 0 entity_id INTEGER INTEGER 0 1 0 0 0 0 full_name VARCHAR VARCHAR(100) 0 0 100 0 first_name VARCHAR VARCHAR(100) 0 0 100 0 middle_name VARCHAR VARCHAR(100) 0 0 100 0 last_name VARCHAR VARCHAR(100) 0 0 100 0 alias VARCHAR VARCHAR(100) 0 0 100 0 abbreviation VARCHAR VARCHAR(100) 0 0 100 0 short_name VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 FK_positions_affiliation_id__affiliations_id affiliations positions 474;920;474;910; 0 0 0 0 0 0 id affiliation_id 1 0 1 None None 0,0,0 0,0,0 FK_affiliations_parent_id__affiliations_id affiliations affiliations 466;1114;466;1158;601;1158;601;973;576;973; 0 0 0 0 0 0 id parent_id 0 0 0 None None 0,0,0 0,0,0 FK_sites_location_id__locations_id locations sites 661;716;661;1177;555;1177; 0 0 0 0 0 0 id location_id 1 0 0 None None 0,0,0 0,0,0 sites430112012599 id @primary_id 1 1 site_key INTEGER INTEGER 0 1 0 0 0 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 location_id INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_sites_location_id__locations_id IDX_FK_sites_location_id__locations_id Default Default 0 location_id FK_sites_location_id__locations_id IDX_FK_sites_publisher_id__publishers_id IDX_FK_sites_publisher_id__publishers_id Default Default 0 publisher_id FK_sites_publisher_id__publishers_id IDX_sites_1 IDX_%ENTITY_NAME%_1 Default Default 0 site_key 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 addresses600730138344 id @primary_id 1 1 location_id INTEGER INTEGER 0 1 0 0 0 0 language VARCHAR VARCHAR(100) 0 0 100 0 suite VARCHAR VARCHAR(100) 0 0 100 0 floor VARCHAR VARCHAR(100) 0 0 100 0 building VARCHAR VARCHAR(100) 0 0 100 0 street_number VARCHAR VARCHAR(100) 0 0 100 0 street_prefix VARCHAR VARCHAR(100) 0 0 100 0 street VARCHAR VARCHAR(100) 0 0 100 0 street_suffix VARCHAR VARCHAR(100) 0 0 100 0 neighborhood VARCHAR VARCHAR(100) 0 0 100 0 district VARCHAR VARCHAR(100) 0 0 100 0 locality VARCHAR VARCHAR(100) city or town 0 0 100 0 county VARCHAR VARCHAR(100) 0 0 100 0 region VARCHAR VARCHAR(100) state or province 0 0 100 0 postal_code VARCHAR VARCHAR(100) 0 0 100 0 country VARCHAR VARCHAR(100) 0 0 100 0 IDX_addresses_1 IDX_%ENTITY_NAME%_1 Default Default 0 locality IDX_addresses_2 IDX_%ENTITY_NAME%_2 Default Default 0 region IDX_addresses_3 IDX_%ENTITY_NAME%_3 Default Default 0 postal_code IDX_FK_addresses_location_id__locations_id IDX_FK_addresses_location_id__locations_id Default Default 0 location_id FK_addresses_location_id__locations_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 key_aliases6001130133137 id @primary_id 1 1 publisher_id INTEGER INTEGER 0 1 0 0 0 0 alias_type VARCHAR VARCHAR(100) persons | teams | affiliations | events | etc. 0 0 100 0 alias_id INTEGER INTEGER A person_id, team_id, etc. 0 0 0 0 0 0 alias_key VARCHAR VARCHAR(100) A person_key, team_key, etc. 0 0 100 0 common_key VARCHAR VARCHAR(100) Locally generated key that is the same for all rows that are aliases for the same thing. 0 0 100 0 IDX_FK_key_aliases_publisher_id__publishers_id IDX_FK_key_aliases_publisher_id__publishers_id Default Default 0 publisher_id FK_key_aliases_publisher_id__publishers_id IDX_key_aliases_1 IDX_%ENTITY_NAME%_1 Default Default 0 alias_type IDX_key_aliases_2 IDX_%ENTITY_NAME%_2 Default Default 0 alias_id IDX_key_aliases_3 IDX_%ENTITY_NAME%_3 Default Default 0 alias_key IDX_key_aliases_4 IDX_%ENTITY_NAME%_4 Default Default 0 common_key 0,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,1281 FK_addresses_location_id__locations_id locations addresses 631;716;631;730; 0 0 0 0 0 0 id location_id 1 0 1 None None 0,0,0 0,0,0 weather_conditions960640144156 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 temperature VARCHAR VARCHAR(100) 0 0 100 0 humidity VARCHAR VARCHAR(100) 0 0 100 0 clouds VARCHAR VARCHAR(100) 0 0 100 0 wind_direction VARCHAR VARCHAR(100) 0 0 100 0 wind_velocity VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_weather_conditions_event_id__events_id IDX_FK_weather_conditions_event_id__events_id Default Default 0 event_id FK_weather_conditions_event_id__events_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_participants_events_event_id__events_id events participants_events 883;570;883;553; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_periods_participant_event_id__participants_events_id participants_events periods 926;429;950;429; 0 0 0 0 0 0 id participant_event_id 1 0 1 None None 0,0,0 0,0,0 FK_sub_periods_period_id__periods_id periods sub_periods 1004;517;1004;530; 0 0 0 0 0 0 id period_id 1 0 1 None None 0,0,0 0,0,0 baseball_event_states164080179403 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state SMALLINT SMALLINT true if this is the current state of the event 0 0 0 0 0 0 sequence_number INTEGER INTEGER the unique serial number for this state 0 0 0 0 0 0 at_bat_number INTEGER INTEGER the unique serial number for this at bat 0 0 0 0 0 0 inning_value INTEGER INTEGER 0 0 0 0 0 0 inning_half VARCHAR VARCHAR(100) top | bottom 0 0 100 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 runner_on_first SMALLINT SMALLINT 0 0 0 0 0 0 runner_on_second SMALLINT SMALLINT 0 0 0 0 0 0 runner_on_third SMALLINT SMALLINT 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(100) left | right 0 0 100 0 IDX_baseball_event_states_1 IDX_%ENTITY_NAME%_1 Default Default 0 current_state IDX_FK_baseball_event_states_event_id__events_id IDX_FK_baseball_event_states_event_id__events_id Default Default 0 event_id FK_baseball_event_states_event_id__events_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 baseball_action_substitutions2030400222251 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 0 1 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 person_type VARCHAR VARCHAR(100) player | associate | official - NOT NEEDED? 0 0 100 0 person_original_id INTEGER INTEGER 0 1 0 0 0 0 person_original_position_id INTEGER INTEGER 0 1 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(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_baseball_action_pitches_baseball_event_state_id__baseball_event_states_id baseball_event_states baseball_action_pitches 1796;483;1796;500; 0 0 0 0 0 0 id baseball_event_state_id 1 0 1 None None 0,0,0 0,0,0 FK_baseball_action_pitches_baseball_defensive_group_id__baseball_defensive_group_id baseball_defensive_group baseball_action_pitches 1781;720;1781;713; 0 0 0 0 0 0 id baseball_defensive_group_id 1 0 0 None None 0,0,0 0,0,0 baseball_action_pitches1780500222213 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 0 1 0 0 0 0 baseball_defensive_group_id INTEGER INTEGER 0 0 0 0 0 0 umpire_call VARCHAR VARCHAR(100) 0 0 100 0 pitch_location VARCHAR VARCHAR(100) 0 0 100 0 pitch_type VARCHAR VARCHAR(100) 0 0 100 0 pitch_velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0 trajectory_coordinates VARCHAR VARCHAR(100) yaml array of coordinates? 0 0 100 0 trajectory_formula VARCHAR VARCHAR(100) formula describing this path 0 0 100 0 IDX_baseball_action_pitches_1 IDX_%ENTITY_NAME%_1 Default Default 0 umpire_call IDX_baseball_action_pitches_2 IDX_%ENTITY_NAME%_2 Default Default 0 pitch_type IDX_FK_baseball_action_pitches_baseball_defensive_group_id__baseball_defensive_group_id IDX_FK_baseball_action_pitches_baseball_defensive_group_id__baseball_defensive_group_id Default Default 0 baseball_defensive_group_id FK_baseball_action_pitches_baseball_defensive_group_id__baseball_defensive_group_id IDX_FK_baseball_action_pitches_baseball_event_state_id__baseball_event_states_id IDX_FK_baseball_action_pitches_baseball_event_state_id__baseball_event_states_id Default Default 0 baseball_event_state_id FK_baseball_action_pitches_baseball_event_state_id__baseball_event_states_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_baseball_defensive_players_baseball_defensive_group_id__baseball_defensive_group_id baseball_defensive_group baseball_defensive_players 1787;749;1790;749; 0 0 0 0 0 0 id baseball_defensive_group_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_defensive_players_position_id__positions_id positions baseball_defensive_players 557;861;1925;861;1925;827; 0 0 0 0 0 0 id position_id 0 0 1 None None 0,0,0 0,0,0