6 XML Team 2008, XML Team Solutions, Inc. 8 MYSQL3 8000 6000 2008-08-07 2008-08-07 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 0 boolean_domain INTEGER INTEGER 0 0 0 0 primary_id INTEGER INTEGER 0 0 0 1 FK_positions_soccer_action_substitutions1 positions soccer_action_substitutions 306;1065;306;4092;2040;4092; 0 0 0 0 0 0 id person_replacing_position_id 0 0 1 None None 0,0,0 0,0,0 FK_positions_soccer_action_substitutions positions soccer_action_substitutions 284;1065;284;4072;2040;4072; 0 0 0 0 0 0 id person_original_position_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_soccer_action_substitutions1 persons soccer_action_substitutions 253;593;253;4123;2040;4123; 0 0 0 0 0 0 id person_replacing_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_soccer_action_substitutions persons soccer_action_substitutions 266;593;266;4053;2040;4053; 0 0 0 0 0 0 id person_original_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_soccer_action_fouls persons soccer_action_fouls 262;593;262;4004;1840;4004; 0 0 0 0 0 0 id recipient_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_soccer_action_penalties persons soccer_action_penalties 249;593;249;4068;1640;4068; 0 0 0 0 0 0 id recipient_id 0 0 1 None None 0,0,0 0,0,0 FK_soccer_event_states_soccer_action_penalties soccer_event_states soccer_action_penalties 1858;3893;1858;3925;1824;3925; 0 0 0 0 0 0 id soccer_event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_soccer_event_states_soccer_action_fouls soccer_event_states soccer_action_fouls 1969;3893;1993;3893;1993;3920; 0 0 0 0 0 0 id soccer_event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_soccer_action_participants persons soccer_action_participants 252;593;252;3904;2060;3904; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_ice_hockey_action_participants persons ice_hockey_action_participants 216;593;216;3093;2000;3093; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_per_pha_end_sea_id__sea_id seasons person_phases 790;944;217;944; 0 0 0 0 0 0 id end_season_id 0 0 0 None None 255,128,0 0,0,0 FK_wag_str_spr_lin_boo_id__boo_id bookmakers wagering_straight_spread_lines 174;1605;174;1597;900;1597; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wag_odd_lin_boo_id__boo_id bookmakers wagering_odds_lines 174;1605;174;1597;725;1597; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_bas_def_pla_pos_id__pos_id positions baseball_defensive_players 377;1016;1750;1016;1750;467; 0 0 0 0 0 0 id position_id 0 0 1 None None 0,0,0 0,0,0 FK_mot_rac_eve_sta_eve_id__eve_id events motor_racing_event_states 827;593;827;4368;1940;4368; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_soc_eve_sta_eve_id__eve_id events soccer_event_states 865;593;865;3805;1780;3805; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_ten_eve_sta_eve_id__eve_id events tennis_event_states 875;593;875;3389;1810;3389; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_ice_hoc_eve_sta_eve_id__eve_id events ice_hockey_event_states 826;593;826;2904;1780;2904; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_bask_eve_sta_eve_id__eve_id events basketball_event_states 825;593;825;2312;1795;2312; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_eve_sta_eve_id__eve_id events american_football_event_states 926;410;1960;410;1960;880; 0 0 0 0 0 0 id event_id 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 167;1168;1765;1168; 0 0 0 0 0 0 id team_in_possession_id 0 0 0 None None 0,0,0 0,0,0 FK_bas_def_pla_pla_id__per_id persons baseball_defensive_players 388;383;1615;383; 0 0 0 0 0 0 id player_id 0 0 1 None None 0,0,0 0,0,0 FK_bas_act_sub_per_ori_id__per_id persons baseball_action_substitutions 388;424;2030;424; 0 0 0 0 0 0 id person_original_id 0 0 0 None None 0,0,0 0,0,0 FK_bas_act_sub_per_rep_id__per_id persons baseball_action_substitutions 388;426;2030;426; 0 0 0 0 0 0 id person_replacing_id 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_eve_id__eve_id events baseball_event_states 926;486;1840;486; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_bas_eve_sta_pit_id__per_id persons baseball_event_states 388;400;1840;400; 0 0 0 0 0 0 id pitcher_id 0 0 0 None None 0,0,0 0,0,0 FK_bas_eve_sta_bat_id__per_id persons baseball_event_states 388;397;1840;397; 0 0 0 0 0 0 id batter_id 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 388;400;1840;400; 0 0 0 0 0 0 id runner_on_first_id 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 388;401;1840;401; 0 0 0 0 0 0 id runner_on_third_id 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 388;397;1840;397; 0 0 0 0 0 0 id runner_on_second_id 0 0 0 None None 0,0,0 0,0,0 FK_per_hom_loc_id__loc_id locations persons 450;643;388;643;388;593; 0 0 0 0 0 0 id hometown_location_id 0 0 0 None None 0,0,0 0,0,0 FK_per_res_loc_id__loc_id locations persons 450;645;388;645;388;593; 0 0 0 0 0 0 id residence_location_id 0 0 0 None None 0,0,0 0,0,0 FK_per_dea_loc_id__loc_id locations persons 450;644;411;644;411;642;388;642;388;593; 0 0 0 0 0 0 id death_location_id 0 0 0 None None 0,0,0 0,0,0 FK_med_cre_loc_id__loc_id locations media 497;701;497;1238;761;1238;761;1960; 0 0 0 0 0 0 id creation_location_id 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;930;1050;930;1940; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_med_cap_cap_aut_id__per_id persons media_captions 352;593;352;1344;882;1344;882;2200; 0 0 0 0 0 0 id caption_author_id 0 0 1 None None 0,0,0 0,0,0 FK_med_key_med_id__med_id media media_keywords 830;1990;1030;1990; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_aff_med_aff_id__aff_id affiliations affiliations_media 281;1224;281;1517;1080;1517;1080;2040; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_per_med_per_id__per_id persons persons_media 373;593;373;1299;1080;1299;1080;2120; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_tea_id__tea_id teams teams_media 135;1259;135;1630;1093;1630;1093;2200; 0 0 0 0 0 0 id team_id 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_eve_id__eve_id events events_media 879;593;879;1429;1091;1429;1091;2300; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_per_med_med_id__med_id media persons_media 830;2080;933;2080;933;2154;1030;2154; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_med_id__med_id media teams_media 830;2110;943;2110;943;2245;1050;2245; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_med_id__med_id media events_media 830;2140;941;2140;941;2334;1030;2334; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_med_pub_id__pub_id publishers media 681;905;681;1473;731;1473;731;1960; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_med_cre_id__per_id persons media 331;593;331;1217;692;1217;692;1960; 0 0 0 0 0 0 id credit_id 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;558;1134;558;2075; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_sta_sub_aff_id__aff_id affiliations standing_subgroups 254;1224;254;1607;126;1607;126;2175; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_sta_sub_sea_id__sub_sea_id sub_seasons standings 790;1203;107;1203;107;1965; 0 0 0 0 0 0 id sub_season_id 0 0 1 None None 0,0,0 0,0,0 FK_sta_aff_id__aff_id affiliations standings 227;1224;227;1475;63;1475;63;1965; 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_cor_per_sta_pos_id__pos_id positions core_person_stats 377;1048;466;1048;466;1375; 0 0 0 0 0 0 id position_id 0 0 0 None None 0,0,0 0,0,0 Events Group 760 365 378 1165 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 1200 60 1064 791 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 20 360 395 731 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 430 800 302 338 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 GROUPBOX22 20 1550 1119 328 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 1185 860 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 285 10 508 64 SportsDB — The Open Sports Database Schema Draft 19 Released under GPL at http://www.sportsdb.org © 2008 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 1 2 1 NOTE1 1040 375 89 23 Event Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE11 30 370 96 23 Person Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE31 30 90 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) the key originally found in the document. Should be globally unique. Not a Foreign Key, even though it ends in _id. 0 1 75 0 publisher_id INTEGER INTEGER the publisher of this document 0 1 0 0 0 0 date_time DATETIME DATETIME 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) a common key that links together different versions of the same document. Generally matches the doc_id of the first published draft of this document. 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 DATETIME DATETIME Timestamp for when this document was loaded into the DB. 0 0 IDX_documents_1 IDX_documents_1 Default 0 doc_id IDX_documents_3 IDX_documents_3 Default 0 date_time IDX_documents_4 IDX_documents_4 Default 0 priority IDX_documents_5 IDX_documents_5 Default 0 revision_id IDX_FK_doc_doc_fix_id__doc_fix_id IDX_FK_doc_doc_fix_id__doc_fix_id Default 0 document_fixture_id FK_doc_doc_fix_id__doc_fix_id IDX_FK_doc_pub_id__pub_id IDX_FK_doc_pub_id__pub_id Default 0 publisher_id FK_doc_pub_id__pub_id IDX_FK_doc_sou_id__pub_id IDX_FK_doc_sou_id__pub_id Default 0 source_id FK_doc_sou_id__pub_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 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_document_fixtures_1 Default 0 fixture_key IDX_FK_doc_fix_doc_cla_id__doc_cla_id IDX_FK_doc_fix_doc_cla_id__doc_cla_id Default 0 document_class_id FK_doc_fix_doc_cla_id__doc_cla_id IDX_FK_doc_fix_pub_id__pub_id IDX_FK_doc_fix_pub_id__pub_id Default 0 publisher_id FK_doc_fix_pub_id__pub_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 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_document_classes_1 Default 0 name 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 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_lat_rev_lat_doc_id__doc_id IDX_FK_lat_rev_lat_doc_id__doc_id Default 0 latest_document_id FK_lat_rev_lat_doc_id__doc_id IDX_latest_revisions_1 IDX_latest_revisions_1 Default 0 revision_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 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,12810,0,0 american_football_fumbles_stats12251740235289 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,12810,0,0 american_football_offensive_stats15052000244137 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,12810,0,0 american_football_rushing_stats15051820232156 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,12810,0,0 american_football_penalties_stats1845190024399 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,12810,0,0 american_football_sacks_against_stats1865204027680 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,12810,0,0 american_football_scoring_stats18451500231365 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,12810,0,0 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,12810,0,0 FK_wea_con_eve_id__eve_id events weather_conditions 926;584;965;584;965;1010; 0 0 0 0 0 0 id event_id 1 2 1 None None 255,128,192 0,0,0 FK_per_pub_id__pub_id publishers persons 600;825;387;825;387;593; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_eve_pub_id__pub_id publishers events 707;828;825;828;825;593; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_per_pha_per_id__per_id persons person_phases 205;593;205;660; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,128,255 0,0,0 FK_inj_pha_per_id__per_id persons injury_phases 205;443;189;443; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,128,255 0,0,0 FK_sit_pub_id__pub_id publishers sites 699;825;699;514;565;514; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_inj_pha_sea_id__sea_id seasons injury_phases 790;972;189;972;189;642; 0 0 0 0 0 0 id season_id 1 0 0 None None 255,128,0 0,0,0 FK_eve_sub_sea_eve_id__eve_id events events_sub_seasons 875;593;875;695; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_tea_aff_pha_tea_id__tea_id teams team_phases 35;1259;35;1280; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_tea_aff_pha_aff_id__aff_id affiliations team_phases 200;1224;200;1341;181;1341; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_hom_sit_id__sit_id sites teams 440;514;167;514;167;1160; 0 0 0 0 0 0 id home_site_id 0 0 0 None None 0,0,0 0,0,0 FK_tea_pub_id__pub_id publishers teams 600;825;167;825;167;1160; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 128,255,128 0,0,0 FK_sea_pub_id__pub_id publishers seasons 707;825;882;825;882;930; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 128,255,128 0,0,0 FK_aff_eve_eve_id__eve_id events affiliations_events 863;593;863;615; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_aff_eve_aff_id__aff_id affiliations affiliations_events 339;1125;339;676;785;676; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_aff_pha_sta_sea_id__sea_id seasons team_phases 790;1067;53;1067;53;1280; 0 0 0 0 0 0 id start_season_id 0 0 0 None None 255,128,0 0,0,0 FK_tea_aff_pha_end_sea_id__sea_id seasons team_phases 790;1067;53;1067;53;1280; 0 0 0 0 0 0 id end_season_id 0 0 0 None None 255,128,0 0,0,0 FK_per_pha_sta_sea_id__sea_id seasons person_phases 790;944;217;944; 0 0 0 0 0 0 id start_season_id 0 0 0 None None 255,128,0 0,0,0 FK_sub_sea_sea_id__sea_id seasons sub_seasons 841;1067;841;1075; 0 0 0 0 0 0 id season_id 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 817;1075;817;756; 0 0 0 0 0 0 id sub_season_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_fix_pub_id__pub_id publishers document_fixtures 690;825;690;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_doc_pub_id__pub_id publishers documents 645;825;645;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_doc_doc_fix_id__doc_fix_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_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 0 0 1 None None 0,0,0 0,0,0 FK_tea_doc_tea_id__tea_id teams teams_documents 115;1160;115;301;280;301; 0 0 0 0 0 0 id team_id 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 0 0 1 None None 0,0,0 0,0,0 FK_aff_doc_aff_id__aff_id affiliations affiliations_documents 281;1125;281;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_doc_fix_eve_eve_id__eve_id events document_fixtures_events 790;593;790;800; 0 0 0 0 0 0 id event_id 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;912;518;912;800; 0 0 0 0 0 0 id document_fixture_id 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;818;577;818;800; 0 0 0 0 0 0 id latest_document_id 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 1 0 1 None None 0,0,0 0,0,0 FK_wag_mon_eve_id__eve_id events wagering_moneylines 789;593;789;1088;296;1088;296;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_mon_tea_id__tea_id teams wagering_moneylines 117;1259;117;1570;190;1570; 0 0 0 0 0 0 id team_id 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;593;861;1076;1014;1076;1014;1575; 0 0 0 0 0 0 id event_id 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 166;1259;166;1575;900;1575; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_odd_lin_eve_id__eve_id events wagering_odds_lines 829;593;829;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_odd_lin_tea_id__tea_id teams wagering_odds_lines 143;1259;143;1570;725;1570; 0 0 0 0 0 0 id team_id 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 135;1259;135;1570;360;1570; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_run_eve_id__eve_id events wagering_runlines 816;593;816;1078;662;1078;662;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_run_tea_id__tea_id teams wagering_runlines 167;1259;167;1570;570;1570; 0 0 0 0 0 0 id team_id 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 1 3 1 None None 0,0,0 0,0,0 FK_sea_lea_id__aff_id affiliations seasons 340;1125;340;1062;790;1062; 0 0 0 0 0 0 id league_id 1 0 0 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 0 0 1 None None 0,0,0 0,0,0 FK_per_doc_per_id__per_id persons persons_documents 207;380;207;281;187;281; 0 0 0 0 0 0 id person_id 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 2019;486;2030;486; 0 0 0 0 0 0 id baseball_event_state_id 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 2019;245;2030;245; 0 0 0 0 0 0 id baseball_event_state_id 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 377;1006;1343;1006;1343;550;2030;550; 0 0 0 0 0 0 id person_original_position_id 0 0 0 None None 0,0,0 0,0,0 FK_bas_act_sub_per_rep_pos_id__pos_id positions baseball_action_substitutions 377;1027;1343;1027;1343;616;2030;616; 0 0 0 0 0 0 id person_replacing_position_id 0 0 0 None None 0,0,0 0,0,0 FK_per_pha_reg_pos_id__pos_id positions person_phases 250;1024;217;1024; 0 0 0 0 0 0 id regular_position_id 1 0 0 None None 0,0,0 0,0,0 FK_wag_tot_sco_lin_eve_id__eve_id events wagering_total_score_lines 798;593;798;1072;492;1072;492;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 document_fixtures_events770800191118 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 DATETIME DATETIME 0 0 IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id Default 0 document_fixture_id FK_doc_fix_eve_doc_fix_id__doc_fix_id IDX_FK_doc_fix_eve_eve_id__eve_id IDX_FK_doc_fix_eve_eve_id__eve_id Default 0 event_id FK_doc_fix_eve_eve_id__eve_id IDX_FK_doc_fix_eve_lat_doc_id__doc_id IDX_FK_doc_fix_eve_lat_doc_id__doc_id Default 0 latest_document_id FK_doc_fix_eve_lat_doc_id__doc_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 wagering_odds_lines7251570162270 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 DATETIME DATETIME Time that line was set 0 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,12810,0,0 baseball_action_plays2030100222308 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 out_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(512) 0 0 512 0 runner_on_first_advance VARCHAR VARCHAR(40) 0 0 40 0 runner_on_second_advance VARCHAR VARCHAR(40) 0 0 40 0 runner_on_third_advance VARCHAR VARCHAR(40) 0 0 40 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_baseball_action_plays_1 Default 0 play_type IDX_baseball_action_plays_2 IDX_%ENTITY_NAME%_2 Default ; ; 0 out_type IDX_FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id IDX_FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id Default 0 baseball_event_state_id FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 wagering_straight_spread_lines9001575227251 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 DATETIME DATETIME Time that line was set 0 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,12810,0,0 Note 2140 70 109 23 Baseball Actions 0 255,255,255 0,0,0 192,192,192 1 2 1 NOTE321 2105 940 163 23 American Football Actions 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_event_states1765880228289 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_american_football_event_states_1 IDX_american_football_event_states_1 Default 0 current_state IDX_FK_ame_foo_eve_sta_eve_id__eve_id IDX_FK_ame_foo_eve_sta_eve_id__eve_id Default 0 event_id FK_ame_foo_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id american_football_event_states american_football_action_plays 1993;1005;2025;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_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id american_football_action_plays american_football_action_participants 2144;1156;2144;1218;2112;1218;2112;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_ame_foo_act_par_per_id__per_id persons american_football_action_participants 388;522;1233;522;1233;1328;1965;1328; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,0,0 0,0,0 american_football_action_plays20251000249156 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(512) 0 0 512 0 IDX_american_football_action_plays_1 IDX_american_football_action_plays_1 Default 0 play_type IDX_american_football_action_plays_2 IDX_american_football_action_plays_2 Default 0 score_attempt_type IDX_american_football_action_plays_3 IDX_american_football_action_plays_3 Default 0 drive_result IDX_FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id IDX_FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id Default 0 american_football_event_state_id FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 american_football_action_participants19651260269194 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 score_credit INTEGER INTEGER 0 0 0 0 0 0 yards_gained INTEGER INTEGER 0 0 0 0 0 0 IDX_american_football_action_participants_1 IDX_american_football_action_participants_1 Default 0 participant_role IDX_american_football_action_participants_2 IDX_american_football_action_participants_2 Default 0 score_type IDX_FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id IDX_FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id 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 IDX_FK_ame_foo_act_par_per_id__per_id Default 0 person_id FK_ame_foo_act_par_per_id__per_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 baseball_defensive_stats163075183213 id @primary_id 1 1 double_plays INTEGER INTEGER 0 0 0 0 0 0 triple_plays INTEGER INTEGER 0 0 0 0 0 0 putouts INTEGER INTEGER 0 0 0 0 0 0 assists INTEGER INTEGER 0 0 0 0 0 0 errors INTEGER INTEGER 0 0 0 0 0 0 fielding_percentage FLOAT FLOAT 0 0 0 0 0 0 defensive_average FLOAT FLOAT 0 0 0 0 0 0 errors_passed_ball INTEGER INTEGER 0 0 0 0 0 0 errors_catchers_interference INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 baseball_offensive_stats1210120215612 id @primary_id 1 1 average FLOAT FLOAT 0 0 0 0 0 0 runs_scored INTEGER INTEGER 0 0 0 0 0 0 at_bats INTEGER INTEGER 0 0 0 0 0 0 hits INTEGER INTEGER 0 0 0 0 0 0 rbi INTEGER INTEGER 0 0 0 0 0 0 total_bases INTEGER INTEGER 0 0 0 0 0 0 slugging_percentage FLOAT FLOAT 0 0 0 0 0 0 bases_on_balls INTEGER INTEGER 0 0 0 0 0 0 strikeouts INTEGER INTEGER 0 0 0 0 0 0 left_on_base INTEGER INTEGER 0 0 0 0 0 0 left_in_scoring_position INTEGER INTEGER 0 0 0 0 0 0 singles INTEGER INTEGER 0 0 0 0 0 0 doubles INTEGER INTEGER 0 0 0 0 0 0 triples INTEGER INTEGER 0 0 0 0 0 0 home_runs INTEGER INTEGER 0 0 0 0 0 0 grand_slams INTEGER INTEGER 0 0 0 0 0 0 at_bats_per_rbi FLOAT FLOAT 0 0 0 0 0 0 plate_appearances_per_rbi FLOAT FLOAT 0 0 0 0 0 0 at_bats_per_home_run FLOAT FLOAT 0 0 0 0 0 0 plate_appearances_per_home_run FLOAT FLOAT 0 0 0 0 0 0 sac_flies INTEGER INTEGER 0 0 0 0 0 0 sac_bunts INTEGER INTEGER 0 0 0 0 0 0 grounded_into_double_play INTEGER INTEGER 0 0 0 0 0 0 moved_up INTEGER INTEGER 0 0 0 0 0 0 on_base_percentage FLOAT FLOAT 0 0 0 0 0 0 stolen_bases INTEGER INTEGER 0 0 0 0 0 0 stolen_bases_caught INTEGER INTEGER 0 0 0 0 0 0 stolen_bases_average FLOAT FLOAT 0 0 0 0 0 0 hit_by_pitch INTEGER INTEGER 0 0 0 0 0 0 defensive_interferance_reaches INTEGER INTEGER 0 0 0 0 0 0 on_base_plus_slugging FLOAT FLOAT 0 0 0 0 0 0 plate_appearances INTEGER INTEGER 0 0 0 0 0 0 hits_extra_base INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 basketball_defensive_stats12252245196118 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,12810,0,0 basketball_event_states17952225188175 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state TINYINT TINYINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_FK_events_basketball_event_states IDX_FK_events_basketball_event_states Default 0 event_id FK_bask_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 basketball_offensive_stats15152200229536 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,12810,0,0 basketball_rebounding_stats12252375206194 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,12810,0,0 ice_hockey_defensive_stats12602845202384 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 goals_empty_net_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_short_handed_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_shootout_allowed VARCHAR VARCHAR(100) 0 0 100 0 shots_shootout_allowed VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 ice_hockey_event_states17802825188175 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state TINYINT TINYINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 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 context VARCHAR VARCHAR(40) 0 0 40 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 ice_hockey_offensive_stats15202785199460 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,12810,0,0 Groupbox 1185 2185 1082 561 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 1200 2765 1074 486 0 0 255,255,225 0,0,0 0,0,0 1 Note2 1205 2205 108 23 Basketball Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Note4 1260 2785 113 23 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 roles2506157799 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_roles_1 Default 0 role_key 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 FK_per_pha_rol_id__rol_id roles person_phases 250;630;195;630;195;660; 0 0 0 0 0 0 id role_id 0 0 0 None None 0,0,0 0,0,0 FK_per_eve_met_rol_id__rol_id roles person_event_metadata 327;714;327;735; 0 0 0 0 0 0 id role_id 1 0 0 None None 0,0,0 0,0,0 FK_per_eve_met_pos_id__pos_id positions person_event_metadata 374;985;374;967; 0 0 0 0 0 0 id position_id 1 0 0 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 1947;640;2025;640;2025;670; 0 0 0 0 0 0 id baseball_action_pitch_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_sou_id__pub_id publishers documents 660;825;660;341;642;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,12810,0,0 FK_eve_doc_eve_id__eve_id events events_documents 926;382;1036;382;1036;281; 0 0 0 0 0 0 id event_id 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 0 0 1 None None 0,0,0 0,0,0 injury_phases40410149232 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 DATETIME DATETIME 0 0 end_date_time DATETIME DATETIME 0 0 season_id INTEGER INTEGER 0 0 0 0 0 0 phase_type VARCHAR VARCHAR(100) 0 0 100 0 injury_side VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_inj_pha_per_id__per_id IDX_FK_inj_pha_per_id__per_id Default 0 person_id FK_inj_pha_per_id__per_id IDX_FK_inj_pha_sea_id__sea_id IDX_FK_inj_pha_sea_id__sea_id Default 0 season_id FK_inj_pha_sea_id__sea_id IDX_injury_phases_2 IDX_injury_phases_2 Default 0 injury_status IDX_injury_phases_3 IDX_injury_phases_3 Default 0 start_date_time IDX_injury_phases_4 IDX_injury_phases_4 Default 0 end_date_time 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 sub_seasons7901075155137 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 DATETIME DATETIME 0 0 end_date_time DATETIME DATETIME 0 0 IDX_FK_sub_sea_sea_id__sea_id IDX_FK_sub_sea_sea_id__sea_id Default 0 season_id FK_sub_sea_sea_id__sea_id IDX_sub_seasons_1 IDX_sub_seasons_1 Default 0 sub_season_key IDX_sub_seasons_2 IDX_sub_seasons_2 Default 0 sub_season_type 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 events780380146213 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 DATETIME DATETIME 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 DATETIME DATETIME 0 0 IDX_events_1 IDX_events_1 Default 0 event_key IDX_FK_eve_pub_id__pub_id IDX_FK_eve_pub_id__pub_id Default 0 publisher_id FK_eve_pub_id__pub_id IDX_FK_eve_sit_id__sit_id IDX_FK_eve_sit_id__sit_id Default 0 site_id FK_eve_sit_id__sit_id 0,0,0255,255,255128,128,128255,255,2551255,128,1920010,0,0255,255,255128,128,12810,0,0 baseball_action_contact_details2025670227175 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 VARCHAR VARCHAR(512) 0 0 512 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,12810,0,0 FK_eve_sit_id__sit_id sites events 565;415;565;391;780;391; 0 0 0 0 0 0 id site_id 1 0 0 None None 0,0,0 0,0,0 Groupbox3 430 365 309 418 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(200) 0 0 200 0 abstract TEXT TEXT 0 0 IDX_FK_doc_con_doc_id__doc_id IDX_FK_doc_con_doc_id__doc_id Default 0 document_id FK_doc_con_doc_id__doc_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920000,0,0255,255,255128,128,12810,0,0 FK_doc_con_doc_id__doc_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 standing_subgroups202175177192 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 alignment_scope VARCHAR VARCHAR(100) 0 0 100 0 competition_scope VARCHAR VARCHAR(100) 0 0 100 0 competition_scope_id VARCHAR VARCHAR(100) 0 0 100 0 duration_scope VARCHAR VARCHAR(100) 0 0 100 0 scoping_label VARCHAR VARCHAR(100) 0 0 100 0 site_scope VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 outcome_totals2101925181477 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 events_played INTEGER INTEGER 0 0 0 0 0 0 games_back VARCHAR VARCHAR(100) 0 0 100 0 result_effect VARCHAR VARCHAR(100) 0 0 100 0 sets_against VARCHAR VARCHAR(100) 0 0 100 0 sets_for VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 Groupbox4 10 1905 391 501 0 0 255,255,225 0,0,0 192,192,192 1 periods950640170154 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 label VARCHAR VARCHAR(100) 0 0 100 0 score_attempts INTEGER INTEGER 0 0 0 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_per_par_eve_id__par_eve_id IDX_FK_per_par_eve_id__par_eve_id Default 0 participant_event_id FK_per_par_eve_id__par_eve_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 sub_periods970815155116 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 score_attempts INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_sub_per_per_id__per_id IDX_FK_sub_per_per_id__per_id Default 0 period_id FK_sub_per_per_id__per_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,12810,0,0 participants_events960415146211 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 result_effect VARCHAR VARCHAR(100) 0 0 100 0 score_attempts INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_par_eve_eve_id__eve_id IDX_FK_par_eve_eve_id__eve_id Default 0 event_id FK_par_eve_eve_id__eve_id IDX_participants_events_1 IDX_participants_events_1 Default 0 participant_type IDX_participants_events_2 IDX_participants_events_2 Default 0 participant_id IDX_participants_events_3 IDX_participants_events_3 Default 0 alignment IDX_participants_events_4 IDX_participants_events_4 Default 0 event_outcome 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 events_sub_seasons77569515261 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,12810,0,0 affiliations_events78561513861 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,12810,0,0 document_packages440195514897 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 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 document_package_entry4252075184135 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 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 Groupbox5 410 1900 208 376 0 0 255,255,225 0,0,0 192,192,192 1 Note5 425 1915 177 23 Document Packages 0 255,255,255 0,0,0 192,192,192 1 2 1 Note6 30 1925 118 23 Standings Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 documents_media860194015497 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 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,12810,0,0 media6501960180211 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 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 DATETIME DATETIME 0 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,12810,0,0 media_captions8502200156154 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 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 media_keywords1030194012578 id @primary_id 1 1 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,12810,0,0 teams_media1050220010659 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,12810,0,0 affiliations_media1010204013259 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,12810,0,0 persons_media1030212011459 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,12810,0,0 events_media1030230010659 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,12810,0,0 Groupbox6 635 1900 526 497 0 0 255,255,225 0,0,0 192,192,192 1 Note7 690 1920 90 23 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats12503305199327 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,12810,0,0 tennis_event_states18103305166251 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state TINYINT TINYINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_FK_events_tennis_event_states IDX_FK_events_tennis_event_states Default 0 event_id FK_ten_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 tennis_return_stats14903305241270 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,12810,0,0 Groupbox11 1220 4235 1074 596 0 0 255,255,225 0,0,0 0,0,0 1 Note41 1230 3285 109 23 Tennis Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Groupbox7 410 1150 336 386 0 0 255,255,225 0,0,0 192,192,192 1 core_stats5601190176156 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,12810,0,0 NOTE322 420 1160 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 77;2100;77;2175; 0 0 0 0 0 0 id standing_id 0 0 1 None None 0,0,0 0,0,0 FK_out_tot_sta_sub_id__sta_sub_id standing_subgroups outcome_totals 197;2175;197;2135;210;2135; 0 0 0 0 0 0 id standing_subgroup_id 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 500;2052;500;2075; 0 0 0 0 0 0 id document_package_id 0 0 1 None None 0,0,0 0,0,0 FK_med_con_med_id__med_id media media_contents 707;2171;707;2180; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_med_id__med_id media documents_media 830;1975;860;1975; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_med_cap_id__med_cap_id media_captions documents_media 958;2200;958;2114;934;2114;934;2037; 0 0 0 0 0 0 id media_caption_id 0 0 1 None None 0,0,0 0,0,0 FK_med_cap_med_id__med_id media media_captions 754;2171;754;2192;915;2192;915;2200; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_aff_med_med_id__med_id media affiliations_media 830;2050;929;2050;929;2075;1010;2075; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 tennis_action_points2050328515299 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,12810,0,0 tennis_action_volleys20503425159175 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,12810,0,0 baseball_defensive_group163030518740 id @primary_id 1 1 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 american_football_down_progress_stats12051080283232 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,12810,0,0 NOTE32 1265 880 151 23 American Football Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_defensive_stats1505880247270 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,12810,0,0 american_football_special_teams_stats15451220277593 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,12810,0,0 FK_aff_pub_id__pub_id publishers affiliations 600;825;340;825;340;1125; 0 0 0 0 0 0 id publisher_id 1 0 1 None None 0,0,0 0,0,0 FK_tea_aff_pha_rol_id__rol_id roles team_phases 250;714;171;714;171;1280; 0 0 0 0 0 0 id role_id 0 0 0 None None 0,0,0 0,0,0 FK_per_eve_met_per_id__per_id persons person_event_metadata 230;593;230;735; 0 0 0 0 0 0 id person_id 1 0 1 None None 0,0,0 0,0,0 FK_per_eve_met_eve_id__eve_id events person_event_metadata 780;408;376;408;376;735; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 bookmakers25160514999 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,12810,0,0 FK_boo_pub_id__pub_id publishers bookmakers 600;868;85;868;85;1605; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_wag_mon_boo_id__boo_id bookmakers wagering_moneylines 174;1626;190;1626; 0 0 0 0 0 0 id bookmaker_id 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 174;1605;174;1596;360;1596; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wag_run_boo_id__boo_id bookmakers wagering_runlines 174;1605;174;1592;570;1592; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 team_phases351280146194 id @primary_id 1 1 team_id INTEGER INTEGER 0 1 0 0 0 0 start_season_id INTEGER INTEGER 0 0 0 0 0 0 end_season_id INTEGER INTEGER 0 0 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,12810,0,0 teams35116013299 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 0,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,12810,0,0 NOTE1111 30 1570 138 23 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_moneylines1901570159251 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 DATETIME DATETIME Time that line was set 0 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,12810,0,0 FK_boo_loc_id__loc_id locations bookmakers 508;701;508;1659;174;1659; 0 0 0 0 0 0 id location_id 0 0 0 None None 0,0,0 0,0,0 Groupbox111 1210 3265 1074 386 0 0 255,255,225 0,0,0 0,0,0 1 Note411 1235 3680 109 23 Soccer Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 soccer_event_states17803680189213 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state TINYINT TINYINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_FK_events_soccer_event_states IDX_FK_events_soccer_event_states Default 0 event_id FK_soc_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 soccer_offensive_stats14153680197517 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,12810,0,0 soccer_defensive_stats12353720176270 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,12810,0,0 soccer_foul_stats12554020150175 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,12810,0,0 Groupbox112 1215 3660 1074 556 0 0 255,255,225 0,0,0 0,0,0 1 Note4111 1260 4275 123 23 Motor Racing Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 motor_racing_event_states19404275197194 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state TINYINT TINYINT 0 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_FK_events_motor_racing_event_states IDX_FK_events_motor_racing_event_states Default 0 event_id FK_mot_rac_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 motor_racing_race_stats14404275181536 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,12810,0,0 motor_racing_qualifying_stats16604275217175 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,12810,0,0 persons205380183213 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 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_pub_id__pub_id IDX_FK_per_pub_id__pub_id Default 0 publisher_id FK_per_pub_id__pub_id IDX_persons_1 IDX_persons_1 Default 0 person_key 0,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,12810,0,0 FK_per_bir_loc_id__loc_id locations persons 450;644;411;644;411;642;388;642;388;593; 0 0 0 0 0 0 id birth_location_id 0 0 0 None None 0,0,0 0,0,0 FK_pos_aff_id__aff_id affiliations positions 295;1125;295;1065; 0 0 0 0 0 0 id affiliation_id 1 0 1 None None 0,0,0 0,0,0 FK_sit_loc_id__loc_id locations sites 526;585;526;514; 0 0 0 0 0 0 id location_id 1 0 0 None None 0,0,0 0,0,0 sites44041512599 id @primary_id 1 1 site_key VARCHAR VARCHAR(128) 0 1 128 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 IDX_FK_sit_loc_id__loc_id Default 0 location_id FK_sit_loc_id__loc_id IDX_FK_sit_pub_id__pub_id IDX_FK_sit_pub_id__pub_id Default 0 publisher_id FK_sit_pub_id__pub_id IDX_sites_1 IDX_sites_1 Default 0 site_key 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 addresses590420138344 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_addresses_1 Default 0 locality IDX_addresses_2 IDX_addresses_2 Default 0 region IDX_addresses_3 IDX_addresses_3 Default 0 postal_code IDX_FK_add_loc_id__loc_id IDX_FK_add_loc_id__loc_id Default 0 location_id FK_add_loc_id__loc_id 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 key_aliases595101012480 id @primary_id 1 1 key_id INTEGER INTEGER A person_id, team_id, etc. Use key_roots.key_type to determine which table this ID is for. 0 1 0 0 0 0 key_root_id INTEGER INTEGER 0 1 0 0 0 0 IDX_key_aliases_2 IDX_key_aliases_2 Default 0 key_id 0,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,12810,0,0 FK_add_loc_id__loc_id locations addresses 541;585;541;548;590;548; 0 0 0 0 0 0 id location_id 1 0 1 None None 0,0,0 0,0,0 weather_conditions9651010161194 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 temperature VARCHAR VARCHAR(100) 0 0 100 0 temperature_units VARCHAR VARCHAR(40) 0 0 40 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 weather_code VARCHAR VARCHAR(100) 0 0 100 0 IDX_FK_wea_con_eve_id__eve_id IDX_FK_wea_con_eve_id__eve_id Default 0 event_id FK_wea_con_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 FK_par_eve_eve_id__eve_id events participants_events 926;593;926;620;960;620; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_per_par_eve_id__par_eve_id participants_events periods 961;626;961;640; 0 0 0 0 0 0 id participant_event_id 1 0 1 None None 0,0,0 0,0,0 FK_sub_per_per_id__per_id periods sub_periods 1019;794;1019;815; 0 0 0 0 0 0 id period_id 1 0 1 None None 0,0,0 0,0,0 baseball_event_states184070179422 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 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_baseball_event_states_1 IDX_baseball_event_states_1 Default 0 current_state IDX_FK_bas_eve_sta_eve_id__eve_id IDX_FK_bas_eve_sta_eve_id__eve_id Default 0 event_id FK_bas_eve_sta_eve_id__eve_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id baseball_defensive_group baseball_action_pitches 1728;345;1728;520; 0 0 0 0 0 0 id baseball_defensive_group_id 1 0 0 None None 0,0,0 0,0,0 FK_bas_def_pla_bas_def_gro_id__bas_def_gro_id baseball_defensive_group baseball_defensive_players 1632;345;1632;370; 0 0 0 0 0 0 id baseball_defensive_group_id 0 0 1 None None 0,0,0 0,0,0 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,12810,0,0 standings201965138135 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 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,12810,0,0 db_info2002906542 version VARCHAR VARCHAR(100) version of this database 0 1 16 100 0 IDX_db_info_1 IDX_db_info_1 Default ; ; 0 version 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 FK_per_eve_met_tea_id__tea_id teams person_event_metadata 104;1160;104;967;230;967; 0 0 0 0 0 0 id team_id 1 0 0 None None 0,0,0 0,0,0 wagering_total_score_lines3601570197289 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 DATETIME DATETIME Time that line was set 0 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,12810,0,0 wagering_runlines5701570138270 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 DATETIME DATETIME Time that line was set 0 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,12810,0,0 ice_hockey_player_stats1770304518061 id @primary_id 1 1 plus_minus VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 basketball_team_stats12352595165118 id @primary_id 1 1 timeouts_left VARCHAR VARCHAR(100) 0 0 100 0 largest_lead VARCHAR VARCHAR(100) 0 0 100 0 fouls_total VARCHAR VARCHAR(100) 0 0 100 0 turnover_margin VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 locations45058591116 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_locations_1 Default 0 country_code 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 publishers60082510780 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_publishers_1 Default 0 publisher_key 0,0,0255,255,255128,128,128255,255,2551128,255,1280010,0,0255,255,255128,128,12810,0,0 media_contents6502180118211 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 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 FK_affiliations_affiliation_phases affiliations affiliation_phases 205;1224;205;1270; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_affiliations_affiliation_phases1 affiliations affiliation_phases 205;1224;205;1270; 0 0 0 0 0 0 id ancestor_affiliation_id 0 0 0 None None 0,0,0 0,0,0 FK_seasons_affiliation_phases seasons affiliation_phases 790;1067;209;1067;209;1270; 0 0 0 0 0 0 id start_season_id 0 0 0 None None 0,0,0 0,0,0 FK_seasons_affiliation_phases1 seasons affiliation_phases 790;1067;209;1067;209;1270; 0 0 0 0 0 0 id end_season_id 0 0 0 None None 0,0,0 0,0,0 display_names450850112268 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 prefix VARCHAR VARCHAR(20) 0 0 20 0 suffix VARCHAR VARCHAR(20) 0 0 20 0 IDX_display_names_1 IDX_%ENTITY_NAME%_1 Default ; ; 0 entity_id IDX_display_names_2 IDX_%ENTITY_NAME%_2 Default ; ; 0 entity_type 0,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,12810,0,0 positions25098512780 id @primary_id 1 1 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 abbreviation VARCHAR VARCHAR(100) 0 1 100 0 IDX_FK_pos_aff_id__aff_id IDX_FK_pos_aff_id__aff_id Default 0 affiliation_id FK_pos_aff_id__aff_id IDX_positions_1 IDX_positions_1 Default 0 abbreviation 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 affiliations200112514099 id @primary_id 1 1 affiliation_key VARCHAR VARCHAR(100) 0 1 100 0 affiliation_type VARCHAR VARCHAR(100) division | conference | caliber | organization | sport 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 IDX_affiliations_1 IDX_affiliations_1 Default 0 affiliation_key IDX_affiliations_2 IDX_affiliations_2 Default 0 affiliation_type IDX_FK_aff_pub_id__pub_id IDX_FK_aff_pub_id__pub_id Default 0 publisher_id FK_aff_pub_id__pub_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 affiliation_phases2051270181156 id @primary_id 1 1 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 ancestor_affiliation_id INTEGER INTEGER 0 0 0 0 0 0 start_season_id INTEGER INTEGER 0 0 0 0 0 0 start_date_time DATETIME DATETIME 0 0 end_season_id INTEGER INTEGER 0 0 0 0 0 0 end_date_time DATETIME DATETIME 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 key_roots6109258261 id @primary_id 1 1 key_type VARCHAR VARCHAR(100) persons | teams | affiliations | events | etc. 0 0 100 0 IDX_key_aliases_1 IDX_key_aliases_1 Default 0 key_type 0,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,12810,0,0 FK_key_roots_key_aliases key_roots key_aliases 631;986;631;1010; 0 0 0 0 0 0 id key_root_id 0 0 1 None None 0,0,0 0,0,0 FK_baseball_action_plays_baseball_action_pitches baseball_action_plays baseball_action_pitches 2141;408;2141;626;1947;626; 0 0 0 0 0 0 id baseball_action_play_id 0 0 1 None None 0,0,0 0,0,0 baseball_action_pitches1725520222270 id @primary_id 1 1 baseball_action_play_id INTEGER INTEGER 0 1 0 0 0 0 sequence_number INTEGER INTEGER 0 0 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 VARCHAR VARCHAR(512) 0 0 512 0 trajectory_coordinates VARCHAR VARCHAR(512) yaml array of coordinates? 0 0 512 0 trajectory_formula VARCHAR VARCHAR(100) formula describing this path 0 0 100 0 ball_type VARCHAR VARCHAR(40) 0 0 40 0 strike_type VARCHAR VARCHAR(40) 0 0 40 0 IDX_baseball_action_pitches_1 IDX_baseball_action_pitches_1 Default 0 umpire_call IDX_baseball_action_pitches_2 IDX_baseball_action_pitches_2 Default 0 pitch_type IDX_FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id IDX_FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id Default 0 baseball_defensive_group_id FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 baseball_action_substitutions2030415222251 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 0 0 0 0 0 person_original_position_id INTEGER INTEGER 0 0 0 0 0 0 person_original_lineup_slot INTEGER INTEGER 0 0 0 0 0 0 person_replacing_id INTEGER INTEGER 0 0 0 0 0 0 person_replacing_position_id INTEGER INTEGER 0 0 0 0 0 0 person_replacing_lineup_slot INTEGER INTEGER 0 0 0 0 0 0 substitution_reason VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(512) 0 0 512 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 baseball_pitching_stats143575171593 id @primary_id 1 1 runs_allowed INTEGER INTEGER 0 0 0 0 0 0 singles_allowed INTEGER INTEGER 0 0 0 0 0 0 doubles_allowed INTEGER INTEGER 0 0 0 0 0 0 triples_allowed INTEGER INTEGER 0 0 0 0 0 0 home_runs_allowed INTEGER INTEGER 0 0 0 0 0 0 innings_pitched VARCHAR VARCHAR(20) 0 0 20 0 hits INTEGER INTEGER 0 0 0 0 0 0 earned_runs INTEGER INTEGER 0 0 0 0 0 0 unearned_runs INTEGER INTEGER 0 0 0 0 0 0 bases_on_balls INTEGER INTEGER 0 0 0 0 0 0 bases_on_balls_intentional INTEGER INTEGER 0 0 0 0 0 0 strikeouts INTEGER INTEGER 0 0 0 0 0 0 strikeout_to_bb_ratio FLOAT FLOAT 0 0 0 0 0 0 number_of_pitches INTEGER INTEGER 0 0 0 0 0 0 era FLOAT FLOAT 0 0 0 0 0 0 inherited_runners_scored INTEGER INTEGER 0 0 0 0 0 0 pick_offs INTEGER INTEGER 0 0 0 0 0 0 errors_hit_with_pitch INTEGER INTEGER 0 0 0 0 0 0 errors_wild_pitch INTEGER INTEGER 0 0 0 0 0 0 balks INTEGER INTEGER 0 0 0 0 0 0 wins INTEGER INTEGER 0 0 0 0 0 0 losses INTEGER INTEGER 0 0 0 0 0 0 saves INTEGER INTEGER 0 0 0 0 0 0 shutouts INTEGER INTEGER 0 0 0 0 0 0 games_complete INTEGER INTEGER 0 0 0 0 0 0 games_finished INTEGER INTEGER 0 0 0 0 0 0 winning_percentage FLOAT FLOAT 0 0 0 0 0 0 event_credit VARCHAR VARCHAR(40) 0 0 40 0 save_credit VARCHAR VARCHAR(40) 0 0 40 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 baseball_defensive_players161537022097 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,12810,0,0 american_football_passing_stats12251320233403 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,12810,0,0 ice_hockey_action_plays20002825211137 id @primary_id 1 1 ice_hockey_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 play_result VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(512) 0 0 512 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 FK_ice_hockey_event_states_ice_hockey_action_plays ice_hockey_event_states ice_hockey_action_plays 1968;2876;2000;2876; 0 0 0 0 0 0 id ice_hockey_event_state_id 0 0 1 None None 0,0,0 0,0,0 ice_hockey_action_participants20003045224118 id @primary_id 1 1 ice_hockey_action_play_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 1 0 0 0 0 participant_role VARCHAR VARCHAR(100) 0 0 100 0 point_credit INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 FK_ice_hockey_action_plays_ice_hockey_action_participants ice_hockey_action_plays ice_hockey_action_participants 2009;2962;2009;3045; 0 0 0 0 0 0 id ice_hockey_action_play_id 0 0 1 None None 0,0,0 0,0,0 awards8001265133232 id @primary_id 1 1 participant_type VARCHAR VARCHAR(100) 0 1 100 0 participant_id INTEGER INTEGER 0 1 0 0 0 0 award_type VARCHAR VARCHAR(100) 0 0 100 0 name VARCHAR VARCHAR(100) 0 0 100 0 total INTEGER INTEGER 0 0 0 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 award_value VARCHAR VARCHAR(100) 0 0 100 0 currency VARCHAR VARCHAR(100) 0 0 100 0 date_coverage_type VARCHAR VARCHAR(100) 0 0 100 0 date_coverage_id INTEGER INTEGER 0 0 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 records9701265133213 id @primary_id 1 1 participant_type VARCHAR VARCHAR(100) 0 0 100 0 participant_id INTEGER INTEGER 0 0 0 0 0 0 record_type VARCHAR VARCHAR(100) 0 0 100 0 record_label VARCHAR VARCHAR(100) 0 0 100 0 record_value VARCHAR VARCHAR(100) 0 0 100 0 previous_value VARCHAR VARCHAR(100) 0 0 100 0 date_coverage_type VARCHAR VARCHAR(100) 0 0 100 0 date_coverage_id INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(512) 0 0 512 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 soccer_action_plays20653680184137 id @primary_id 1 1 soccer_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 play_result VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 soccer_action_participants2060384019399 id @primary_id 1 1 soccer_action_play_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 1 0 0 0 0 participant_role VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551128,128,128