6 XML Team 2008, XML Team Solutions, Inc. 8 MYSQL3 8000 6000 2009-04-03 2009-04-03 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_event_action_substitutions positions event_action_substitutions 271;1065;271;3432;890;3432; 0 0 0 0 0 0 id person_original_position_id 0 0 1 None None 0,0,0 0,0,0 FK_positions_event_action_substitutions1 positions event_action_substitutions 285;1065;285;3465;890;3465; 0 0 0 0 0 0 id person_replacing_position_id 0 0 1 None None 0,0,0 0,0,0 FK_events_event_states events event_states 780;631;756;631;756;3000; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_event_states_event_action_substitutions event_states event_action_substitutions 661;3213;661;3403;890;3403; 0 0 0 0 0 0 id event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_event_action_substitutions persons event_action_substitutions 299;593;299;3409;890;3409; 0 0 0 0 0 0 id person_original_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_event_action_substitutions1 persons event_action_substitutions 330;593;330;3446;890;3446; 0 0 0 0 0 0 id person_replacing_id 0 0 1 None None 0,0,0 0,0,0 FK_event_states_event_action_participants event_states event_action_participants 830;3020;1016;3020;1016;3205; 0 0 0 0 0 0 id event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_event_states_event_action_penalties event_states event_action_penalties 721;3213;721;3455; 0 0 0 0 0 0 id event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_persons_event_action_participants persons event_action_participants 233;593;233;3251;900;3251; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_positions_soccer_action_substitutions1 positions soccer_action_substitutions 306;1065;306;4427;2100;4427; 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;4407;2100;4407; 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;4458;2100;4458; 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;4388;2100;4388; 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;4404;1860;4404; 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;4543;1640;4543; 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 1718;4373;1718;4400; 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 1829;4339;1860;4339; 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;4244;2080;4244; 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;3163;1745;3163; 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;227;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 169;1840;169;1832;900;1832; 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 169;1840;169;1832;720;1832; 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;650;827;3523;2255;3523; 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;650;865;4285;1640;4285; 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;650;875;3474;1695;3474; 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;650;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;650;825;2287;1740;2287; 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 172;1228;1765;1228;1765;1169; 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;771;1238;771;2300; 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;2280; 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;892;1344;892;2540; 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 840;2330;1040;2330; 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;1279;281;1517;1090;1517;1090;2380; 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;1090;1299;1090;2460; 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 140;1319;140;1630;1103;1630;1103;2540; 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;650;879;1429;1101;1429;1101;2640; 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 840;2420;943;2420;943;2494;1040;2494; 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 840;2450;953;2450;953;2585;1060;2585; 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 840;2480;951;2480;951;2674;1040;2674; 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;741;1473;741;2300; 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;702;1217;702;2300; 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;553;1134;553;2440; 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;1279;254;1607;126;1607;126;2500; 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;2280; 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 200;1276;63;1276;63;2280; 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 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 398 756 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 0 1780 1132 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 23 Released under GPL at http://www.sportsdb.org © 2009 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(255) 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 255 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 925;650;925;1010;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;650; 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 215;593;215;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;650;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 40;1319;40;1340; 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;1279;200;1396;186;1396; 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;172;514;172;1220; 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;172;825;172;1220; 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 825;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;1180;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;58;1067;58;1340; 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;58;1067;58;1340; 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;227;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 120;1220;120;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;1180;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;650;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;650;789;1088;286;1088;286;1800; 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 122;1319;122;1800;180;1800; 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;650;861;1076;1014;1076;1014;1800; 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 171;1319;171;1800;900;1800; 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 824;650;824;1800; 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 148;1319;148;1800;720;1800; 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 140;1319;140;1800;340;1800; 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;650;816;1078;652;1078;652;1800; 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 172;1319;172;1804;560;1804; 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;1180;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;227;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;650;798;1072;472;1072;472;1800; 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_lines7201800162270 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(255) 0 0 255 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_lines9001800227251 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(255) 0 0 255 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_american_football_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_american_football_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 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_states17402200188175 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_basketball_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_basketball_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 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_stats14802200229536 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_stats12402820202479 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 goaltender_wins INTEGER INTEGER 0 0 0 0 0 0 goaltender_losses INTEGER INTEGER 0 0 0 0 0 0 goaltender_ties INTEGER INTEGER 0 0 0 0 0 0 goals_allowed INTEGER INTEGER 0 0 0 0 0 0 shots_allowed 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 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 IDX_ice_hockey_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_ice_hockey_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 ice_hockey_offensive_stats14902780199460 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 754 561 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 1200 2765 1074 573 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;205;630;205;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;960;382;960;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 events780380146270 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 event_number VARCHAR VARCHAR(32) 0 0 32 0 round_number VARCHAR VARCHAR(32) 0 0 32 0 time_certainty VARCHAR VARCHAR(100) 0 0 100 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_contents260100142135 id @primary_id 1 1 document_id INTEGER INTEGER 0 1 0 0 0 0 sportsml VARCHAR VARCHAR(200) 0 0 200 0 sportsml_blob TEXT TEXT 0 0 abstract TEXT TEXT 0 0 abstract_blob 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_subgroups202500177192 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_totals2002240181477 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 DATETIME DATETIME 0 0 streak_end DATETIME DATETIME 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 0 2220 391 512 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_packages440232014897 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_entry4202440184135 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 Note5 420 2280 177 23 Document Packages 0 255,255,255 0,0,0 192,192,192 1 2 1 Note6 20 2240 118 23 Standings Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 documents_media860228015497 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 media6602300180211 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_captions8602540156154 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_keywords1040228012578 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_media1060254010659 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_media1020238013259 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_media1040246011459 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_media1040264010659 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 640 2240 538 518 0 0 255,255,225 0,0,0 192,192,192 1 Note7 700 2260 90 23 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats12203415199612 id @primary_id 1 1 services_played INTEGER INTEGER 0 0 0 0 0 0 matches_played INTEGER INTEGER 0 0 0 0 0 0 aces INTEGER INTEGER 0 0 0 0 0 0 first_services_good INTEGER INTEGER 0 0 0 0 0 0 first_services_good_pct INTEGER INTEGER 0 0 0 0 0 0 first_service_points_won INTEGER INTEGER 0 0 0 0 0 0 first_service_points_won_pct INTEGER INTEGER 0 0 0 0 0 0 second_service_points_won INTEGER INTEGER 0 0 0 0 0 0 second_service_points_won_pct INTEGER INTEGER 0 0 0 0 0 0 service_games_played INTEGER INTEGER 0 0 0 0 0 0 service_games_won INTEGER INTEGER 0 0 0 0 0 0 service_games_won_pct INTEGER INTEGER 0 0 0 0 0 0 break_points_played INTEGER INTEGER 0 0 0 0 0 0 break_points_saved INTEGER INTEGER 0 0 0 0 0 0 break_points_saved_pct INTEGER INTEGER 0 0 0 0 0 0 service_points_won INTEGER INTEGER 0 0 0 0 0 0 service_points_won_pct INTEGER INTEGER 0 0 0 0 0 0 double_faults INTEGER INTEGER 0 0 0 0 0 0 first_service_top_speed VARCHAR VARCHAR(100) 0 0 100 0 second_services_good INTEGER INTEGER 0 0 0 0 0 0 second_services_good_pct INTEGER INTEGER 0 0 0 0 0 0 second_service_top_speed VARCHAR VARCHAR(100) 0 0 100 0 net_points_won INTEGER INTEGER 0 0 0 0 0 0 net_points_played INTEGER INTEGER 0 0 0 0 0 0 points_won INTEGER INTEGER 0 0 0 0 0 0 winners INTEGER INTEGER 0 0 0 0 0 0 unforced_errors INTEGER INTEGER 0 0 0 0 0 0 winners_forehand INTEGER INTEGER 0 0 0 0 0 0 winners_backhand INTEGER INTEGER 0 0 0 0 0 0 winners_volley 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 tennis_event_states16953390166251 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 IDX_tennis_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_tennis_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 tennis_return_stats14353390241422 id @primary_id 1 1 returns_played INTEGER INTEGER 0 0 0 0 0 0 matches_played INTEGER INTEGER 0 0 0 0 0 0 first_service_return_points_won INTEGER INTEGER 0 0 0 0 0 0 first_service_return_points_won_pct INTEGER INTEGER 0 0 0 0 0 0 second_service_return_points_won INTEGER INTEGER 0 0 0 0 0 0 second_service_return_points_won_pct INTEGER INTEGER 0 0 0 0 0 0 return_games_played INTEGER INTEGER 0 0 0 0 0 0 return_games_won INTEGER INTEGER 0 0 0 0 0 0 return_games_won_pct INTEGER INTEGER 0 0 0 0 0 0 break_points_played INTEGER INTEGER 0 0 0 0 0 0 break_points_converted INTEGER INTEGER 0 0 0 0 0 0 break_points_converted_pct INTEGER INTEGER 0 0 0 0 0 0 net_points_won INTEGER INTEGER 0 0 0 0 0 0 net_points_played INTEGER INTEGER 0 0 0 0 0 0 points_won INTEGER INTEGER 0 0 0 0 0 0 winners INTEGER INTEGER 0 0 0 0 0 0 unforced_errors INTEGER INTEGER 0 0 0 0 0 0 winners_forehand INTEGER INTEGER 0 0 0 0 0 0 winners_backhand INTEGER INTEGER 0 0 0 0 0 0 winners_volley 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 Groupbox11 2040 3370 422 749 0 0 255,255,225 0,0,0 0,0,0 1 Note41 1235 3385 109 23 Tennis Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Groupbox7 410 1150 342 522 0 0 255,255,225 0,0,0 192,192,192 1 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;2415;77;2500; 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;2500;197;2460;200;2460; 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;2417;500;2440; 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 717;2511;717;2520; 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 840;2315;860;2315; 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 968;2540;968;2454;944;2454;944;2377; 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 764;2511;764;2532;925;2532;925;2540; 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 840;2390;939;2390;939;2415;1020;2415; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 tennis_action_points1695365515299 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_volleys17753775159175 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;1180; 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;176;714;176;1340; 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 bookmakers20184014999 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;80;868;80;1840; 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 169;1861;180;1861; 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 169;1840;169;1831;340;1831; 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 169;1840;169;1827;560;1827; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 team_phases401340146194 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 teams40122013299 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 IDX_teams_team_key IDX_%ENTITY_NAME%_team_key Default ; ; 0 team_key 0,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,12810,0,0 NOTE1111 20 1800 138 23 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_moneylines1801800159251 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(255) 0 0 255 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;1894;169;1894; 0 0 0 0 0 0 id location_id 0 0 0 None None 0,0,0 0,0,0 Groupbox111 1195 3370 815 670 0 0 255,255,225 0,0,0 0,0,0 1 Note411 1220 4160 109 23 Soccer Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 soccer_event_states16404160189213 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 IDX_soccer_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_soccer_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 soccer_offensive_stats14004160197517 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_stats12204200176270 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_stats12404500150175 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 1200 4140 1136 566 0 0 255,255,225 0,0,0 0,0,0 1 motor_racing_event_states22553430197194 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 IDX_motor_racing_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_motor_racing_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 motor_racing_race_stats20603385181536 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_stats20603935217175 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;1180;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;622;960;622; 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 DECIMAL DECIMAL(4,1) the unique serial number for this state 0 0 4 1 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_baseball_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_baseball_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 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 standings202280138135 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 109;1220;109;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_lines3401800197289 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(255) 0 0 255 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_runlines5601800138270 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(255) 0 0 255 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_stats1495326018061 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_stats12252595165118 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_contents6602520118211 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;1279;205;1340; 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;1279;205;1340; 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;204;1067;204;1340; 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;204;1067;204;1340; 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 affiliations200118014099 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_phases2001340181175 id @primary_id 1 1 affiliation_id INTEGER INTEGER 0 1 0 0 0 0 root_id INTEGER INTEGER 0 0 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 DECIMAL DECIMAL(4,1) 0 0 4 1 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 DECIMAL DECIMAL(4,1) 0 0 4 1 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_plays20102820211460 id @primary_id 1 1 ice_hockey_event_state_id INTEGER INTEGER 0 1 0 0 0 0 play_key VARCHAR VARCHAR(100) 0 0 100 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 penalty_type VARCHAR VARCHAR(100) 0 0 100 0 penalty_length VARCHAR VARCHAR(100) 0 0 100 0 penalty_code VARCHAR VARCHAR(100) 0 0 100 0 recipient_type VARCHAR VARCHAR(100) 0 0 100 0 team_id INTEGER INTEGER 0 0 0 0 0 0 strength VARCHAR VARCHAR(100) 0 0 100 0 location_x VARCHAR VARCHAR(100) 0 0 100 0 location_y VARCHAR VARCHAR(100) 0 0 100 0 location_zone VARCHAR VARCHAR(100) 0 0 100 0 shootout_shot_order INTEGER INTEGER 0 0 0 0 0 0 goal_order INTEGER INTEGER 0 0 0 0 0 0 shot_type VARCHAR VARCHAR(100) 0 0 100 0 shot_distance VARCHAR VARCHAR(100) 0 0 100 0 goal_zone VARCHAR VARCHAR(100) 0 0 100 0 empty_net VARCHAR VARCHAR(100) 0 0 100 0 goal_awarded 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;2875;2010;2875; 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_participants17453115224175 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 goals_to_date INTEGER INTEGER 0 0 0 0 0 0 assists_to_date INTEGER INTEGER 0 0 0 0 0 0 points_to_date 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 2010;3045;1786;3045;1786;3115; 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_plays18604160184137 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_participants2080418019399 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,1280010,0,0255,255,255128,128,12810,0,0 soccer_action_substitutions21004300222194 id @primary_id 1 1 soccer_event_state_id INTEGER INTEGER 0 1 0 0 0 0 person_type VARCHAR VARCHAR(100) 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_replacing_id INTEGER INTEGER 0 1 0 0 0 0 person_replacing_position_id INTEGER INTEGER 0 1 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,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 soccer_action_penalties16404400184175 id @primary_id 1 1 soccer_event_state_id INTEGER INTEGER 0 1 0 0 0 0 penalty_type VARCHAR VARCHAR(100) 0 0 100 0 penalty_level VARCHAR VARCHAR(100) 0 0 100 0 caution_value VARCHAR VARCHAR(100) 0 0 100 0 recipient_type VARCHAR VARCHAR(100) 0 0 100 0 recipient_id INTEGER INTEGER 0 1 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 FK_soccer_event_states_soccer_action_substitutions soccer_event_states soccer_action_substitutions 1829;4333;2100;4333; 0 0 0 0 0 0 id soccer_event_state_id 0 0 1 None None 0,0,0 0,0,0 FK_soccer_action_plays_soccer_action_participants soccer_action_plays soccer_action_participants 2044;4180;2080;4180; 0 0 0 0 0 0 id soccer_action_play_id 0 0 1 None None 0,0,0 0,0,0 FK_soccer_event_states_soccer_action_plays soccer_event_states soccer_action_plays 1829;4176;1860;4176; 0 0 0 0 0 0 id soccer_event_state_id 0 0 1 None None 0,0,0 0,0,0 seasons790930146137 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 0 0 0 0 0 start_date_time DATETIME DATETIME 0 0 end_date_time DATETIME DATETIME 0 0 IDX_FK_sea_lea_id__aff_id IDX_FK_sea_lea_id__aff_id Default ; ; 0 league_id FK_sea_lea_id__aff_id IDX_FK_sea_pub_id__pub_id IDX_FK_sea_pub_id__pub_id Default 0 publisher_id FK_sea_pub_id__pub_id IDX_seasons_1 IDX_seasons_1 Default 0 season_key 0,0,0255,255,2550,0,0255,255,2551255,128,00010,0,0255,255,255128,128,12810,0,0 NOTE112 455 380 104 23 Location Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 Events Group111 20 1160 374 586 0 0 255,255,225 0,0,0 0,0,0 1 NOTE1112 445 815 129 23 Utility Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE111 60 1180 129 23 Organization Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 person_phases40660187441 id @primary_id 1 1 person_id INTEGER INTEGER the person whose phase this is 0 1 0 0 0 0 membership_type VARCHAR VARCHAR(40) teams | affiliations 0 1 40 0 membership_id INTEGER INTEGER the team_id or affiliation_id 0 1 0 0 0 0 role_id INTEGER INTEGER the role the person has in this team or affiliation 0 0 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 where person usually plays. 0 0 0 0 0 0 regular_position_depth VARCHAR VARCHAR(40) indicates whether player is first string or second string in that regular position 0 0 40 0 height VARCHAR VARCHAR(100) 0 0 100 0 weight VARCHAR VARCHAR(100) 0 0 100 0 start_date_time DATETIME DATETIME if NULL, indicates phase start is unknown 0 0 start_season_id INTEGER INTEGER if NULL, indicates phase start is unknown 0 0 0 0 0 0 end_date_time DATETIME DATETIME if NULL, indicates person is still a member 0 0 end_season_id INTEGER INTEGER if NULL, indicates person is still a member 0 0 0 0 0 0 entry_reason VARCHAR VARCHAR(40) 0 0 40 0 exit_reason VARCHAR VARCHAR(40) 0 0 40 0 selection_level INTEGER INTEGER 0 0 0 0 0 0 selection_sublevel INTEGER INTEGER 0 0 0 0 0 0 selection_overall INTEGER INTEGER 0 0 0 0 0 0 duration VARCHAR VARCHAR(32) 0 0 32 0 IDX_FK_per_pha_per_id__per_id IDX_FK_per_pha_per_id__per_id Default 0 person_id FK_per_pha_per_id__per_id IDX_FK_per_pha_reg_pos_id__pos_id IDX_FK_per_pha_reg_pos_id__pos_id Default 0 regular_position_id FK_per_pha_reg_pos_id__pos_id IDX_person_phases_1 IDX_person_phases_1 Default 0 membership_type IDX_person_phases_2 IDX_person_phases_2 Default 0 membership_id IDX_person_phases_3 IDX_person_phases_3 Default 0 phase_status 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 person_event_metadata230735178232 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 health VARCHAR VARCHAR(100) 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 team_id INTEGER INTEGER 0 0 0 0 0 0 lineup_slot INTEGER INTEGER 0 0 0 0 0 0 lineup_slot_sequence INTEGER INTEGER 0 0 0 0 0 0 IDX_FK_per_eve_met_eve_id__eve_id IDX_FK_per_eve_met_eve_id__eve_id Default 0 event_id FK_per_eve_met_eve_id__eve_id IDX_FK_per_eve_met_per_id__per_id IDX_FK_per_eve_met_per_id__per_id Default 0 person_id FK_per_eve_met_per_id__per_id IDX_FK_per_eve_met_pos_id__pos_id IDX_FK_per_eve_met_pos_id__pos_id Default 0 position_id FK_per_eve_met_pos_id__pos_id IDX_FK_per_eve_met_rol_id__rol_id IDX_FK_per_eve_met_rol_id__rol_id Default 0 role_id FK_per_eve_met_rol_id__rol_id IDX_FK_teams_person_event_metadata IDX_FK_teams_person_event_metadata Default 0 team_id FK_per_eve_met_tea_id__tea_id IDX_person_event_metadata_1 IDX_person_event_metadata_1 Default 0 status 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 stats4201190147213 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 stat_membership_type VARCHAR VARCHAR(40) 0 0 40 0 stat_membership_id INTEGER INTEGER 0 0 0 0 0 0 context VARCHAR VARCHAR(40) event if this is a confirmed stat, event-play if an unofficial mid-game update, etc. 0 1 40 0 IDX_stats_1 IDX_stats_1 Default 0 stat_repository_type IDX_stats_2 IDX_stats_2 Default 0 stat_repository_id IDX_stats_3 IDX_stats_3 Default 0 stat_holder_type IDX_stats_4 IDX_stats_4 Default 0 stat_holder_id IDX_stats_5 IDX_stats_5 Default 0 stat_coverage_type IDX_stats_6 IDX_stats_6 Default 0 stat_coverage_id IDX_stats_7 IDX_stats_7 Default 0 context IDX_stats_8 IDX_%ENTITY_NAME%_8 Default ; ; 0 stat_coverage_type IDX_stats_9 IDX_%ENTITY_NAME%_9 Default ; ; 0 stat_coverage_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 american_football_team_stats1245920216137 id @primary_id 1 1 yards_per_attempt VARCHAR VARCHAR(100) 0 0 100 0 average_starting_position VARCHAR VARCHAR(100) 0 0 100 0 timeouts VARCHAR VARCHAR(100) 0 0 100 0 time_of_possession VARCHAR VARCHAR(100) 0 0 100 0 turnover_ratio VARCHAR VARCHAR(100) 0 0 100 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,12810,0,0 soccer_action_fouls18604320184194 id @primary_id 1 1 soccer_event_state_id INTEGER INTEGER 0 1 0 0 0 0 foul_name VARCHAR VARCHAR(100) 0 0 100 0 foul_result VARCHAR VARCHAR(100) 0 0 100 0 foul_type VARCHAR VARCHAR(100) 0 0 100 0 fouler_id VARCHAR VARCHAR(100) 0 0 100 0 recipient_type VARCHAR VARCHAR(100) 0 0 100 0 recipient_id INTEGER INTEGER 0 1 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 Groupbox51 615 2920 518 743 0 0 255,255,225 0,0,0 192,192,192 1 EventStates 655 2940 181 23 Generic Event State Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 event_states6353000195213 id @primary_id 1 1 event_id INTEGER INTEGER 0 1 0 0 0 0 current_state INTEGER INTEGER 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_minutes_elapsed VARCHAR VARCHAR(100) 0 0 100 0 context VARCHAR VARCHAR(40) 0 0 40 0 IDX_event_states_context IDX_%ENTITY_NAME%_context Default ; ; 0 context IDX_event_states_seq_num IDX_%ENTITY_NAME%_seq_num Default ; ; 0 sequence_number 0,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 event_action_fouls6503235141194 id @primary_id 1 1 event_state_id INTEGER INTEGER 0 1 0 0 0 0 foul_name VARCHAR VARCHAR(100) 0 0 100 0 foul_result VARCHAR VARCHAR(100) 0 0 100 0 foul_type VARCHAR VARCHAR(100) 0 0 100 0 fouler_id VARCHAR VARCHAR(100) 0 0 100 0 recipient_type VARCHAR VARCHAR(100) 0 0 100 0 recipient_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 FK_event_states_event_action_fouls event_states event_action_fouls 755;3213;755;3235; 0 0 0 0 0 0 id event_state_id 0 0 1 None None 0,0,0 0,0,0 event_action_plays9403005170137 id @primary_id 1 1 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_event_states_event_action_plays event_states event_action_plays 830;3055;940;3055; 0 0 0 0 0 0 id event_state_id 0 0 1 None None 0,0,0 0,0,0 event_action_participants9003205187118 id @primary_id 1 1 event_state_id INTEGER INTEGER 0 1 0 0 0 0 event_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,1280010,0,0255,255,255128,128,12810,0,0 FK_event_action_plays_event_action_participants event_action_plays event_action_participants 1002;3142;1002;3205; 0 0 0 0 0 0 id event_action_play_id 0 0 1 None None 0,0,0 0,0,0 event_action_penalties6503455169175 id @primary_id 1 1 event_state_id INTEGER INTEGER 0 1 0 0 0 0 penalty_type VARCHAR VARCHAR(100) 0 0 100 0 penalty_level VARCHAR VARCHAR(100) 0 0 100 0 caution_level VARCHAR VARCHAR(100) 0 0 100 0 recipient_type VARCHAR VARCHAR(100) 0 0 100 0 recipient_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 event_action_substitutions8903375222175 id @primary_id 1 1 event_state_id INTEGER INTEGER 0 1 0 0 0 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_replacing_id INTEGER INTEGER 0 1 0 0 0 0 person_replacing_position_id INTEGER INTEGER 0 1 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,2551128,128,1280010,0,0255,255,255128,128,12810,0,0 Groupbox52 400 2240 212 358 0 0 255,255,225 0,0,0 192,192,192 1 tennis_set_stats18753390124194 id @primary_id 1 1 net_points_won INTEGER INTEGER 0 0 0 0 0 0 net_points_played INTEGER INTEGER 0 0 0 0 0 0 points_won INTEGER INTEGER 0 0 0 0 0 0 winners INTEGER INTEGER 0 0 0 0 0 0 unforced_errors INTEGER INTEGER 0 0 0 0 0 0 winners_forehand INTEGER INTEGER 0 0 0 0 0 0 winners_backhand INTEGER INTEGER 0 0 0 0 0 0 winners_volley 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 tennis_team_stats16103820137194 id @primary_id 1 1 net_points_won INTEGER INTEGER 0 0 0 0 0 0 net_points_played INTEGER INTEGER 0 0 0 0 0 0 points_won INTEGER INTEGER 0 0 0 0 0 0 winners INTEGER INTEGER 0 0 0 0 0 0 unforced_errors INTEGER INTEGER 0 0 0 0 0 0 winners_forehand INTEGER INTEGER 0 0 0 0 0 0 winners_backhand INTEGER INTEGER 0 0 0 0 0 0 winners_volley 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 tennis_player_stats14603825146194 id @primary_id 1 1 net_points_won INTEGER INTEGER 0 0 0 0 0 0 net_points_played INTEGER INTEGER 0 0 0 0 0 0 points_won INTEGER INTEGER 0 0 0 0 0 0 winners INTEGER INTEGER 0 0 0 0 0 0 unforced_errors INTEGER INTEGER 0 0 0 0 0 0 winners_forehand INTEGER INTEGER 0 0 0 0 0 0 winners_backhand INTEGER INTEGER 0 0 0 0 0 0 winners_volley 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 penalty_stats430142510580 id @primary_id 1 1 count INTEGER INTEGER 0 0 0 0 0 0 type 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 Note81 2260 3390 181 23 Motor Racing Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 rankings401540153213 id @primary_id 1 1 document_fixture_id INTEGER INTEGER 0 0 0 0 0 0 participant_type VARCHAR VARCHAR(100) 0 0 100 0 participant_id INTEGER INTEGER 0 0 0 0 0 0 issuer VARCHAR VARCHAR(100) 0 0 100 0 ranking_type VARCHAR VARCHAR(100) 0 0 100 0 ranking_value VARCHAR VARCHAR(100) 0 0 100 0 ranking_value_previous 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 core_stats5501380179270 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 time_played_event VARCHAR VARCHAR(40) 0 0 40 0 time_played_total VARCHAR VARCHAR(40) 0 0 40 0 time_played_event_average VARCHAR VARCHAR(40) 0 0 40 0 events_played VARCHAR VARCHAR(40) 0 0 40 0 events_started VARCHAR VARCHAR(40) 0 0 40 0 position_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