4 XML Team 2007, XML Team Solutions, Inc. 8 MySQL3 8000 6000 2007-03-12 2007-03-12 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_ame_foo_eve_sta_eve_id__eve_id events american_football_event_states 926;600;2055;600;2055;880; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_eve_sta_tea_in_pos_id__tea_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 %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_def_pla_pla_id__per_id persons baseball_defensive_players 400;432;1933;432;1933;730; 0 0 0 0 0 0 id player_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_per_ori_id__per_id persons baseball_action_substitutions 400;429;2030;429; 0 0 0 0 0 0 id person_original_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_per_rep_id__per_id persons baseball_action_substitutions 400;431;2030;431; 0 0 0 0 0 0 id person_replacing_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_eve_id__eve_id events baseball_event_states 926;676;1726;676;1726;483; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_bas_eve_sta_pit_id__per_id persons baseball_event_states 400;430;1640;430; 0 0 0 0 0 0 id pitcher_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_bat_id__per_id persons baseball_event_states 400;427;1640;427; 0 0 0 0 0 0 id batter_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_run_on_fir_id__per_id persons baseball_event_states 400;430;1640;430; 0 0 0 0 0 0 id runner_on_first_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_run_on_thi_id__per_id persons baseball_event_states 400;431;1640;431; 0 0 0 0 0 0 id runner_on_third_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_run_on_sec_id__per_id persons baseball_event_states 400;427;1640;427; 0 0 0 0 0 0 id runner_on_second_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_per_hom_loc_id__loc_id locations persons 610;648;400;648; 0 0 0 0 0 0 id hometown_location_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_per_res_loc_id__loc_id locations persons 610;650;400;650; 0 0 0 0 0 0 id residence_location_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_per_dea_loc_id__loc_id locations persons 610;649;400;649; 0 0 0 0 0 0 id death_location_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_sta_pub_id__pub_id publishers standings 457;1310;457;1474;143;1474;143;1780; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_cre_loc_id__loc_id locations media 657;716;657;1238;811;1238;811;1790; 0 0 0 0 0 0 id creation_location_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_doc_id__doc_id documents documents_media 568;341;568;1050;990;1050;990;1770; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_cap_cap_aut_id__per_id persons media_captions 347;670;347;1344;932;1344;932;2030; 0 0 0 0 0 0 id caption_author_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_key_med_id__med_id media media_keywords 880;1820;1080;1820; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_aff_med_aff_id__aff_id affiliations affiliations_media 511;1114;511;1517;1130;1517;1130;1870; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_per_med_per_id__per_id persons persons_media 368;670;368;1299;1130;1299;1130;1950; 0 0 0 0 0 0 id person_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_tea_id__tea_id teams teams_media 360;1198;360;1630;1143;1630;1143;2030; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_eve_id__eve_id events events_media 879;783;879;1429;1141;1429;1141;2130; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_per_med_med_id__med_id media persons_media 880;1910;983;1910;983;1984;1080;1984; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_med_id__med_id media teams_media 880;1940;993;1940;993;2075;1100;2075; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_med_id__med_id media events_media 880;1970;991;1970;991;2164;1080;2164; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_pub_id__pub_id publishers media 511;1310;511;1473;781;1473;781;1790; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_cre_id__per_id persons media 326;670;326;1217;742;1217;742;1790; 0 0 0 0 0 0 id credit_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_pac_ent_doc_id__doc_id documents document_package_entry 487;341;487;1134;583;1134;583;1910; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_sta_sub_aff_id__aff_id affiliations standing_subgroups 484;1114;484;1607;156;1607;156;2070; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_sta_sub_sea_id__sub_sea_id sub_seasons standings 629;517;629;1173;117;1173;117;1780; 0 0 0 0 0 0 id sub_season_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_sta_aff_id__aff_id affiliations standings 457;1114;457;1475;73;1475;73;1780; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 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_cor_per_sta_pos_id__pos_id positions core_person_stats 557;893;747;893;747;1199;970;1199; 0 0 0 0 0 0 id position_id %RELATION_NAME% 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 11 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 documents460901822510,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 doc_id IDX_documents_3 Default Default 0 date_time IDX_documents_4 Default Default 0 priority IDX_documents_5 Default Default 0 revision_id IDX_FK_doc_doc_fix_id__doc_fix_id Default Default 0 document_fixture_id FK_doc_doc_fix_id__doc_fix_id IDX_FK_doc_pub_id__pub_id Default Default 0 publisher_id FK_doc_pub_id__pub_id IDX_FK_doc_sou_id__pub_id Default Default 0 source_id FK_doc_sou_id__pub_id document_fixtures7801001641180,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 fixture_key IDX_FK_doc_fix_doc_cla_id__doc_cla_id Default Default 0 document_class_id FK_doc_fix_doc_cla_id__doc_cla_id IDX_FK_doc_fix_pub_id__pub_id Default Default 0 publisher_id FK_doc_fix_pub_id__pub_id document_classes980100136610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 name latest_revisions60120167800,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_lat_rev_lat_doc_id__doc_id Default Default 0 latest_document_id FK_lat_rev_lat_doc_id__doc_id IDX_latest_revisions_1 Default Default 0 revision_id affiliations_documents660260165610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 american_football_fumbles_stats132017402352890,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_offensive_stats160020002441370,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_rushing_stats160018202321560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_penalties_stats19401900243990,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_passing_stats132013202334030,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_sacks_against_stats19602040276800,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_scoring_stats194015002313650,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 team_american_football_stats13409202161370,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 persons_documents40220147610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 person_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 FK_wea_con_eve_id__eve_id events weather_conditions 926;759;960;759; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 2 1 None None 255,128,192 0,0,0 FK_per_cur_inj_pha_id__inj_pha_id injury_phases persons 189;466;200;466; 0 0 0 0 0 0 id current_injury_phase_id %RELATION_NAME% 1 3 0 None None 0,0,0 0,0,0 FK_per_pub_id__pub_id publishers persons 445;1230;445;760;400;760;400;670; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_eve_pub_id__pub_id publishers events 505;1230;505;917;825;917;825;783; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_per_pha_per_id__per_id persons person_phases 200;670;200;700; 0 0 0 0 0 0 id person_id %RELATION_NAME% 1 0 1 None None 0,128,255 0,0,0 FK_inj_pha_per_id__per_id persons injury_phases 200;466;189;466; 0 0 0 0 0 0 id person_id %RELATION_NAME% 1 0 1 None None 0,128,255 0,0,0 FK_per_cur_tea_pha_id__per_pha_id person_phases persons 200;700;200;670; 0 0 0 0 0 0 id current_team_phase_id %RELATION_NAME% 1 3 0 None None 0,0,0 0,0,0 FK_sit_pub_id__pub_id publishers sites 537;1230;551;1230;551;1219; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_inj_pha_sea_id__sea_id seasons injury_phases 430;442;189;442; 0 0 0 0 0 0 id season_id %RELATION_NAME% 1 0 1 None None 255,128,0 0,0,0 FK_eve_sub_sea_eve_id__eve_id events events_sub_seasons 852;783;852;815;883;815;883;880; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_tea_aff_pha_tea_id__tea_id teams team_affiliation_phases 260;1157;214;1157; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_tea_aff_pha_aff_id__aff_id affiliations team_affiliation_phases 430;1094;214;1094;214;1100; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_tea_hom_sit_id__sit_id sites teams 430;1120;392;1120; 0 0 0 0 0 0 id home_site_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_tea_pub_id__pub_id publishers teams 430;1281;392;1281;392;1198; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 0 0 1 None None 128,255,128 0,0,0 FK_sea_pub_id__pub_id publishers seasons 460;1230;460;832;522;832;522;507; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_aff_eve_eve_id__eve_id events affiliations_events 858;783;858;800; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_aff_eve_aff_id__aff_id affiliations affiliations_events 576;1012;658;1012;658;832;780;832; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_tea_aff_pha_sta_sea_id__sea_id seasons team_affiliation_phases 466;507;466;846;102;846;102;1100; 0 0 0 0 0 0 id start_season_id %RELATION_NAME% 0 0 1 None None 255,128,0 0,0,0 FK_tea_aff_pha_end_sea_id__sea_id seasons team_affiliation_phases 478;507;478;846;160;846;160;1100; 0 0 0 0 0 0 id end_season_id %RELATION_NAME% 0 0 1 None None 255,128,0 0,0,0 FK_per_pha_sta_sea_id__sea_id seasons person_phases 442;507;442;712;205;712; 0 0 0 0 0 0 id start_season_id %RELATION_NAME% 0 0 1 None None 255,128,0 0,0,0 FK_per_pha_end_sea_id__sea_id seasons person_phases 454;507;454;712;205;712; 0 0 0 0 0 0 id end_season_id %RELATION_NAME% 0 0 1 None None 255,128,0 0,0,0 FK_sub_sea_sea_id__sea_id seasons sub_seasons 576;416;590;416; 0 0 0 0 0 0 id season_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_eve_sub_sea_sub_sea_id__sub_sea_id sub_seasons events_sub_seasons 668;517;668;728;840;728;840;880; 0 0 0 0 0 0 id sub_season_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_fix_pub_id__pub_id publishers document_fixtures 520;1230;520;654;833;654;833;218; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_doc_pub_id__pub_id publishers documents 475;1230;475;719;514;719;514;341; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 128,255,128 0,0,0 FK_doc_doc_fix_id__doc_fix_id document_fixtures documents 780;163;642;163; 0 0 0 0 0 0 id document_fixture_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_tea_doc_doc_id__doc_id documents teams_documents 460;298;437;298;437;280;416;280; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_tea_doc_tea_id__tea_id teams teams_documents 340;1080;340;301; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_aff_doc_doc_id__doc_id documents affiliations_documents 642;305;660;305; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_aff_doc_aff_id__aff_id affiliations affiliations_documents 511;920;511;661;747;661;747;321; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_fix_eve_eve_id__eve_id events document_fixtures_events 926;783;1044;783;1044;820; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 0 1 None None 255,128,192 0,0,0 FK_doc_fix_eve_doc_fix_id__doc_fix_id document_fixtures document_fixtures_events 882;218;882;518;1082;518;1082;820; 0 0 0 0 0 0 id document_fixture_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_doc_fix_eve_lat_doc_id__doc_id documents document_fixtures_events 595;341;595;577;988;577;988;820; 0 0 0 0 0 0 id latest_document_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_doc_fix_doc_cla_id__doc_cla_id document_classes document_fixtures 980;132;956;132;956;146;944;146; 0 0 0 0 0 0 id document_class_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_wag_mon_eve_id__eve_id events wagering_moneylines 789;783;789;1088;246;1088;246;1340; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_wag_mon_tea_id__tea_id teams wagering_moneylines 287;1198;287;1340; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_wag_str_spr_lin_eve_id__eve_id events wagering_straight_spread_lines 861;783;861;1076;994;1076;994;1340; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_wag_str_spr_lin_tea_id__tea_id teams wagering_straight_spread_lines 392;1165;616;1165;616;1472;880;1472; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_wag_odd_lin_eve_id__eve_id events wagering_odds_lines 834;783;834;1077;778;1077;778;1340; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_wag_odd_lin_tea_id__tea_id teams wagering_odds_lines 392;1182;521;1182;521;1473;700;1473; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_wag_tot_sco_lin_tea_id__tea_id teams wagering_total_score_lines 360;1198;360;1340; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_wag_run_eve_id__eve_id events wagering_runlines 816;783;816;1078;632;1078;632;1340; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 FK_wag_run_tea_id__tea_id teams wagering_runlines 340;1198;340;1323;586;1323;586;1340; 0 0 0 0 0 0 id team_id %RELATION_NAME% 0 0 1 None None 255,0,0 0,0,0 FK_lat_rev_lat_doc_id__doc_id documents latest_revisions 460;194;334;194;334;162;227;162; 0 0 0 0 0 0 id latest_document_id %RELATION_NAME% 1 3 1 None None 0,0,0 0,0,0 FK_tea_lea_id__aff_id affiliations teams 430;966;389;966;389;1080; 0 0 0 0 0 0 id league_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_sea_lea_id__aff_id affiliations seasons 474;920;474;507; 0 0 0 0 0 0 id league_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_per_doc_doc_id__doc_id documents persons_documents 460;246;187;246; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_per_doc_per_id__per_id persons persons_documents 200;402;122;402;122;281; 0 0 0 0 0 0 id person_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_bas_eve_sta_id__bas_eve_sta_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 %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_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 %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_per_ori_pos_id__pos_id positions baseball_action_substitutions 557;851;1343;851;1343;535;2030;535; 0 0 0 0 0 0 id person_original_position_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_per_rep_pos_id__pos_id positions baseball_action_substitutions 557;872;1343;872;1343;601;2030;601; 0 0 0 0 0 0 id person_replacing_position_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_per_pha_reg_pos_id__pos_id positions person_phases 430;910;430;952;205;952; 0 0 0 0 0 0 id regular_position_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_wag_tot_sco_lin_eve_id__eve_id events wagering_total_score_lines 798;783;798;1072;452;1072;452;1340; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 255,128,192 0,0,0 document_fixtures_events9408201911180,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_doc_fix_eve_doc_fix_id__doc_fix_id Default Default 0 document_fixture_id FK_doc_fix_eve_doc_fix_id__doc_fix_id IDX_FK_doc_fix_eve_eve_id__eve_id Default Default 0 event_id FK_doc_fix_eve_eve_id__eve_id IDX_FK_doc_fix_eve_lat_doc_id__doc_id Default Default 0 latest_document_id FK_doc_fix_eve_lat_doc_id__doc_id NOTE111 40 1060 89 23 Team Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_odds_lines70013401622700,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 baseball_action_plays20301002222890,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 play_type IDX_FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id Default Default 0 baseball_event_state_id FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id wagering_straight_spread_lines88013402272510,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 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_states18608802282700,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 current_state IDX_FK_ame_foo_eve_sta_eve_id__eve_id Default Default 0 event_id FK_ame_foo_eve_sta_eve_id__eve_id FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_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 %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_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 %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_act_par_per_id__per_id persons american_football_action_participants 400;542;1233;542;1233;1337;2060;1337; 0 0 0 0 0 0 id person_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 american_football_action_plays211010002491560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 play_type IDX_american_football_action_plays_2 Default Default 0 score_attempt_type IDX_american_football_action_plays_3 Default Default 0 drive_result IDX_FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id Default Default 0 american_football_event_state_id FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id american_football_action_participants206012602691560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 participant_role IDX_american_football_action_participants_2 Default Default 0 score_type IDX_FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id Default Default 0 american_football_action_play_id FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id IDX_FK_ame_foo_act_par_per_id__per_id Default Default 0 person_id FK_ame_foo_act_par_per_id__per_id baseball_defensive_stats1440801832130,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 baseball_offensive_stats12101402156120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 wagering_total_score_lines32013401972890,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 basketball_defensive_stats132022801961180,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 basketball_event_states182022601771560,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 basketball_offensive_stats154022202295360,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 basketball_rebounding_stats132024402061940,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 ice_hockey_defensive_stats134028402023080,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 ice_hockey_event_states186028201831560,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 ice_hockey_offensive_stats160027801994600,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 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 roles24070077990,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 role_key FK_per_pha_rol_id__rol_id roles person_phases 240;715;205;715; 0 0 0 0 0 0 id role_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_per_eve_met_rol_id__rol_id roles person_event_metadata 317;799;317;860; 0 0 0 0 0 0 id role_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 FK_per_eve_met_pos_id__pos_id positions person_event_metadata 430;864;396;864; 0 0 0 0 0 0 id position_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 FK_key_ali_pub_id__pub_id publishers key_aliases 537;1230;537;1210;600;1210; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_bas_act_con_det_bas_act_pit_id__bas_act_pit_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 %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_sou_id__pub_id publishers documents 490;1230;490;341; 0 0 0 0 0 0 id source_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 events_documents960220139610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 event_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 FK_eve_doc_eve_id__eve_id events events_documents 837;570;837;408;1036;408;1036;281; 0 0 0 0 0 0 id event_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_eve_doc_doc_id__doc_id documents events_documents 642;222;784;222;784;244;960;244; 0 0 0 0 0 0 id document_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 injury_phases404401491940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_inj_pha_per_id__per_id Default Default 0 person_id FK_inj_pha_per_id__per_id IDX_FK_inj_pha_sea_id__sea_id Default Default 0 season_id FK_inj_pha_sea_id__sea_id IDX_injury_phases_2 Default Default 0 injury_status IDX_injury_phases_3 Default Default 0 start_date_time IDX_injury_phases_4 Default Default 0 end_date_time person_phases407001653080,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_per_pha_per_id__per_id Default Default 0 person_id FK_per_pha_per_id__per_id IDX_FK_per_pha_reg_pos_id__pos_id Default Default 0 regular_position_id FK_per_pha_reg_pos_id__pos_id IDX_person_phases_1 Default Default 0 membership_type IDX_person_phases_2 Default Default 0 membership_id IDX_person_phases_3 Default Default 0 phase_status positions430830127800,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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_pos_aff_id__aff_id Default Default 0 affiliation_id FK_pos_aff_id__aff_id IDX_positions_1 Default Default 0 abbreviation seasons4303701461370,0,0255,255,2550,0,0255,255,2551255,128,00010,0,0255,255,255128,128,1281 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_sea_lea_id__aff_id Default Default 0 league_id FK_sea_lea_id__aff_id IDX_FK_sea_pub_id__pub_id Default Default 0 publisher_id FK_sea_pub_id__pub_id IDX_seasons_1 Default Default 0 season_key sub_seasons5903801551370,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 id @primary_id Unique per season_id + type 1 1 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_sea_sea_id__sea_id Default Default 0 season_id FK_sub_sea_sea_id__sea_id IDX_sub_seasons_1 Default Default 0 sub_season_key IDX_sub_seasons_2 Default Default 0 sub_season_type events7805701462130,0,0255,255,255128,128,128255,255,2551255,128,1920010,0,0255,255,255128,128,1281 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 Default Default 0 event_key IDX_FK_eve_pub_id__pub_id Default Default 0 publisher_id FK_eve_pub_id__pub_id IDX_FK_eve_sit_id__sit_id Default Default 0 site_id FK_eve_sit_id__sit_id wagering_runlines54013401382700,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 baseball_action_contact_details20206602271750,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 FK_eve_sit_id__sit_id sites events 487;1120;487;985;807;985;807;783; 0 0 0 0 0 0 id site_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 locations610600911160,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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 Default Default 0 country_code Groupbox3 590 590 156 497 0 0 255,255,225 0,0,0 192,192,192 1 document_contents260100142970,0,0255,255,255128,128,128255,255,2551192,192,1920000,0,0255,255,255128,128,1281 id @primary_id 1 1 document_id INTEGER INTEGER 0 1 0 0 0 0 sportsml VARCHAR VARCHAR(100) 0 0 100 0 abstract TEXT TEXT 0 0 IDX_FK_doc_con_doc_id__doc_id Default Default 0 document_id FK_doc_con_doc_id__doc_id FK_doc_con_doc_id__doc_id documents document_contents 460;142;402;142; 0 0 0 0 0 0 id document_id %RELATION_NAME% 1 3 1 None None 0,0,0 0,0,0 baseball_pitching_stats14403001715360,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 standing_subgroups502070146780,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 outcome_totals22017901813820,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 Groupbox4 20 1740 388 466 0 0 255,255,225 0,0,0 192,192,192 1 periods950420170970,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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_per_par_eve_id__par_eve_id Default Default 0 participant_event_id FK_per_par_eve_id__par_eve_id sub_periods96053015597Especially 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 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_per_per_id__per_id Default Default 0 period_id FK_sub_per_per_id__per_id participants_events7803801461730,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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_par_eve_eve_id__eve_id Default Default 0 event_id FK_par_eve_eve_id__eve_id IDX_participants_events_1 Default Default 0 participant_type IDX_participants_events_2 Default Default 0 participant_id IDX_participants_events_3 Default Default 0 alignment IDX_participants_events_4 Default Default 0 event_outcome events_sub_seasons780880152610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 event_id INTEGER INTEGER 1 1 0 0 0 0 sub_season_id INTEGER INTEGER 1 1 0 0 0 0 affiliations_events780800138610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0 document_packages4701790148970,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 document_package_entry45019101841350,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 Groupbox5 420 1730 227 376 0 0 255,255,225 0,0,0 192,192,192 1 Note5 450 1730 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_media920177015497identifies 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 id @primary_id 1 1 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 media70017901802110,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 media_captions90020301561540,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 media_contents70020101182110,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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 media_keywords10801770125780,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 keyword VARCHAR VARCHAR(100) 0 0 100 0 media_id INTEGER INTEGER 0 1 0 0 0 0 teams_media11002030106590,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 team_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 affiliations_media10601870132590,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 persons_media10801950114590,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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 events_media10802130106590,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 event_id INTEGER INTEGER 0 1 0 0 0 0 media_id INTEGER INTEGER 0 1 0 0 0 0 Groupbox6 660 1730 554 497 0 0 255,255,225 0,0,0 192,192,192 1 Note7 740 1750 90 23 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats132033001993270,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 tennis_event_states188033001491750,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 tennis_return_stats156033002412700,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 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_stats9509701761560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 core_person_stats97011401411180,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 stats79010301341750,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 stat_repository_type IDX_stats_2 Default Default 0 stat_repository_id IDX_stats_3 Default Default 0 stat_holder_type IDX_stats_4 Default Default 0 stat_holder_id IDX_stats_5 Default Default 0 stat_coverage_type IDX_stats_6 Default Default 0 stat_coverage_id IDX_stats_7 Default Default 0 context NOTE322 780 980 147 23 Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 FK_sta_sub_sta_id__sta_id standings standing_subgroups 107;2048;107;2070; 0 0 0 0 0 0 id standing_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_out_tot_sta_sub_id__sta_sub_id standing_subgroups outcome_totals 195;2070;195;1984;220;1984; 0 0 0 0 0 0 id standing_subgroup_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_pac_ent_doc_pac_id__doc_pac_id document_packages document_package_entry 545;1887;545;1906;527;1906;527;1910; 0 0 0 0 0 0 id document_package_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_con_med_id__med_id media media_contents 757;2001;757;2010; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_med_id__med_id media documents_media 880;1805;920;1805; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_med_cap_id__med_cap_id media_captions documents_media 1008;2030;1008;1944;994;1944;994;1867; 0 0 0 0 0 0 id media_caption_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_med_cap_med_id__med_id media media_captions 804;2001;804;2022;965;2022;965;2030; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_aff_med_med_id__med_id media affiliations_media 880;1880;979;1880;979;1905;1060;1905; 0 0 0 0 0 0 id media_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 tennis_action_points21203280152990,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 tennis_action_volleys21203420159175One 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 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 baseball_defensive_players1790730220970,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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 baseball_defensive_group1600720187400,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 american_football_down_progress_stats130010802832320,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 NOTE32 1360 880 151 23 American Football Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_defensive_stats16008802472700,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 american_football_special_teams_stats164012202775930,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 FK_aff_pub_id__pub_id publishers affiliations 439;1230;439;1114; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_tea_aff_pha_rol_id__rol_id roles team_affiliation_phases 255;799;255;1177;214;1177; 0 0 0 0 0 0 id role_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_per_eve_met_per_id__per_id persons person_event_metadata 213;670;213;860;220;860; 0 0 0 0 0 0 id person_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_per_eve_met_eve_id__eve_id events person_event_metadata 780;598;366;598;366;860; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 person_event_metadata2208601761560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_per_eve_met_eve_id__eve_id Default Default 0 event_id FK_per_eve_met_eve_id__eve_id IDX_FK_per_eve_met_per_id__per_id Default Default 0 person_id FK_per_eve_met_per_id__per_id IDX_FK_per_eve_met_pos_id__pos_id Default Default 0 position_id FK_per_eve_met_pos_id__pos_id IDX_FK_per_eve_met_rol_id__rol_id Default Default 0 role_id FK_per_eve_met_rol_id__rol_id IDX_person_event_metadata_1 Default Default 0 status bookmakers801600149990,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 FK_boo_pub_id__pub_id publishers bookmakers 430;1273;140;1273;140;1600; 0 0 0 0 0 0 id publisher_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_wag_mon_boo_id__boo_id bookmakers wagering_moneylines 173;1600;173;1591; 0 0 0 0 0 0 id bookmaker_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_wag_tot_sco_lin_boo_id__boo_id bookmakers wagering_total_score_lines 229;1600;229;1366;320;1366; 0 0 0 0 0 0 id bookmaker_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_wag_run_boo_id__boo_id bookmakers wagering_runlines 229;1600;229;1362;540;1362; 0 0 0 0 0 0 id bookmaker_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_wag_odd_lin_boo_id__boo_id bookmakers wagering_odds_lines 229;1600;229;1367;700;1367; 0 0 0 0 0 0 id bookmaker_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_wag_str_spr_lin_boo_id__boo_id bookmakers wagering_straight_spread_lines 229;1600;229;1362;880;1362; 0 0 0 0 0 0 id bookmaker_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 team_affiliation_phases4011001741940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 teams26010801321180,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,1281 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 NOTE1111 300 1680 138 23 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_moneylines14013401592510,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 FK_boo_loc_id__loc_id locations bookmakers 668;716;668;1654;229;1654; 0 0 0 0 0 0 id location_id %RELATION_NAME% 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_states194037001521560,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 soccer_offensive_stats144036801975170,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 soccer_defensive_stats168037001762700,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 soccer_foul_stats168039801501750,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 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_states198042801971370,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 publishers4301230107800,0,0255,255,255128,128,128255,255,2551128,255,1280010,0,0255,255,255128,128,1281 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 Default Default 0 publisher_key motor_racing_race_stats148042801815360,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 motor_racing_qualifying_stats170042802171750,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,1281 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 affiliations4309201461940,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 affiliation_key IDX_affiliations_2 Default Default 0 tier IDX_FK_aff_pub_id__pub_id Default Default 0 publisher_id FK_aff_pub_id__pub_id FK_per_cur_lea_pha_id__per_pha_id person_phases persons 200;700;200;670; 0 0 0 0 0 0 id current_league_phase_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 persons2004002002700,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,1281 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_per_cur_inj_pha_id__inj_pha_id Default Default 0 current_injury_phase_id FK_per_cur_inj_pha_id__inj_pha_id IDX_FK_per_cur_lea_pha_id__per_pha_id Default Default 0 current_league_phase_id FK_per_cur_lea_pha_id__per_pha_id IDX_FK_per_cur_tea_pha_id__per_pha_id Default Default 0 current_team_phase_id FK_per_cur_tea_pha_id__per_pha_id IDX_FK_per_pub_id__pub_id Default Default 0 publisher_id FK_per_pub_id__pub_id IDX_persons_1 Default Default 0 person_key FK_per_bir_loc_id__loc_id locations persons 610;649;400;649; 0 0 0 0 0 0 id birth_location_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 display_names4305901122300,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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 FK_pos_aff_id__aff_id affiliations positions 474;920;474;910; 0 0 0 0 0 0 id affiliation_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_aff_par_id__aff_id affiliations affiliations 466;1114;466;1158;601;1158;601;973;576;973; 0 0 0 0 0 0 id parent_id %RELATION_NAME% 0 0 0 None None 0,0,0 0,0,0 FK_sit_loc_id__loc_id locations sites 661;716;661;1177;555;1177; 0 0 0 0 0 0 id location_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 sites4301120125990,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_sit_loc_id__loc_id Default Default 0 location_id FK_sit_loc_id__loc_id IDX_FK_sit_pub_id__pub_id Default Default 0 publisher_id FK_sit_pub_id__pub_id IDX_sites_1 Default Default 0 site_key addresses6007301383440,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 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 Default Default 0 locality IDX_addresses_2 Default Default 0 region IDX_addresses_3 Default Default 0 postal_code IDX_FK_add_loc_id__loc_id Default Default 0 location_id FK_add_loc_id__loc_id key_aliases60011301331370,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,1281 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_ali_pub_id__pub_id Default Default 0 publisher_id FK_key_ali_pub_id__pub_id IDX_key_aliases_1 Default Default 0 alias_type IDX_key_aliases_2 Default Default 0 alias_id IDX_key_aliases_3 Default Default 0 alias_key IDX_key_aliases_4 Default Default 0 common_key FK_add_loc_id__loc_id locations addresses 631;716;631;730; 0 0 0 0 0 0 id location_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 weather_conditions9606401441560,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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_wea_con_eve_id__eve_id Default Default 0 event_id FK_wea_con_eve_id__eve_id FK_par_eve_eve_id__eve_id events participants_events 883;570;883;553; 0 0 0 0 0 0 id event_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_per_par_eve_id__par_eve_id participants_events periods 926;429;950;429; 0 0 0 0 0 0 id participant_event_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_sub_per_per_id__per_id periods sub_periods 1004;517;1004;530; 0 0 0 0 0 0 id period_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 baseball_event_states1640801794030,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 current_state IDX_FK_bas_eve_sta_eve_id__eve_id Default Default 0 event_id FK_bas_eve_sta_eve_id__eve_id baseball_action_substitutions20304002222510,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id baseball_event_states baseball_action_pitches 1796;483;1796;500; 0 0 0 0 0 0 id baseball_event_state_id %RELATION_NAME% 1 0 1 None None 0,0,0 0,0,0 FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id baseball_defensive_group baseball_action_pitches 1781;720;1781;713; 0 0 0 0 0 0 id baseball_defensive_group_id %RELATION_NAME% 1 0 0 None None 0,0,0 0,0,0 baseball_action_pitches17805002222130,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 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 Default Default 0 umpire_call IDX_baseball_action_pitches_2 Default Default 0 pitch_type IDX_FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id Default Default 0 baseball_defensive_group_id FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id IDX_FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id Default Default 0 baseball_event_state_id FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id FK_bas_def_pla_bas_def_gro_id__bas_def_gro_id baseball_defensive_group baseball_defensive_players 1787;749;1790;749; 0 0 0 0 0 0 id baseball_defensive_group_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 FK_bas_def_pla_pos_id__pos_id positions baseball_defensive_players 557;861;1925;861;1925;827; 0 0 0 0 0 0 id position_id %RELATION_NAME% 0 0 1 None None 0,0,0 0,0,0 teams_documents280240136610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 team_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 standings3017801772680,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,1281 id @primary_id 1 1 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