6 XML Team 2008, XML Team Solutions, Inc. 8 MYSQL3 8000 6000 2008-09-18 2008-09-18 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;2937;920;2937; 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;2970;920;2970; 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 781;631;781;2500; 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 686;2713;686;2908;920;2908; 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;2914;920;2914; 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;2951;920;2951; 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 855;2520;1056;2520;1056;2740; 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 731;2713;731;2900; 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;2786;940;2786; 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;4347;2065;4347; 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;4327;2065;4327; 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;4378;2065;4378; 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;4308;2065;4308; 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;4264;1865;4264; 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;4323;1665;4323; 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 1883;4153;1883;4185;1849;4185; 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 1994;4153;2018;4153;2018;4180; 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;4164;2085;4164; 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;3088;1995;3088; 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 174;1605;174;1597;900;1597; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_wag_odd_lin_boo_id__boo_id bookmakers wagering_odds_lines 174;1605;174;1597;725;1597; 0 0 0 0 0 0 id bookmaker_id 0 0 1 None None 0,0,0 0,0,0 FK_bas_def_pla_pos_id__pos_id positions baseball_defensive_players 377;1016;1750;1016;1750;467; 0 0 0 0 0 0 id position_id 0 0 1 None None 0,0,0 0,0,0 FK_mot_rac_eve_sta_eve_id__eve_id events motor_racing_event_states 827;631;827;4618;2065;4618; 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;631;865;4065;1805;4065; 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;631;875;3359;1690;3359; 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;631;826;2899;1775;2899; 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;631;825;2312;1795;2312; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_eve_sta_eve_id__eve_id events american_football_event_states 926;410;1960;410;1960;880; 0 0 0 0 0 0 id event_id 1 0 1 None None 0,0,0 0,0,0 FK_ame_foo_eve_sta_tea_in_pos_id__tea_id teams american_football_event_states 167;1198;1765;1198;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;761;1238;761;1960; 0 0 0 0 0 0 id creation_location_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_med_doc_id__doc_id documents documents_media 568;341;568;1050;930;1050;930;1940; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_med_cap_cap_aut_id__per_id persons media_captions 352;593;352;1344;882;1344;882;2200; 0 0 0 0 0 0 id caption_author_id 0 0 1 None None 0,0,0 0,0,0 FK_med_key_med_id__med_id media media_keywords 830;1990;1030;1990; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_aff_med_aff_id__aff_id affiliations affiliations_media 281;1254;281;1517;1080;1517;1080;2040; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_per_med_per_id__per_id persons persons_media 373;593;373;1299;1080;1299;1080;2120; 0 0 0 0 0 0 id person_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_tea_id__tea_id teams teams_media 135;1289;135;1630;1093;1630;1093;2200; 0 0 0 0 0 0 id team_id 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_eve_id__eve_id events events_media 879;631;879;1429;1091;1429;1091;2300; 0 0 0 0 0 0 id event_id 0 0 1 None None 0,0,0 0,0,0 FK_per_med_med_id__med_id media persons_media 830;2080;933;2080;933;2154;1030;2154; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_med_med_id__med_id media teams_media 830;2110;943;2110;943;2245;1050;2245; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_eve_med_med_id__med_id media events_media 830;2140;941;2140;941;2334;1030;2334; 0 0 0 0 0 0 id media_id 0 0 1 None None 0,0,0 0,0,0 FK_med_pub_id__pub_id publishers media 681;905;681;1473;731;1473;731;1960; 0 0 0 0 0 0 id publisher_id 0 0 1 None None 0,0,0 0,0,0 FK_med_cre_id__per_id persons media 331;593;331;1217;692;1217;692;1960; 0 0 0 0 0 0 id credit_id 0 0 1 None None 0,0,0 0,0,0 FK_doc_pac_ent_doc_id__doc_id documents document_package_entry 487;341;487;1134;573;1134;573;2100; 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;1254;254;1607;126;1607;126;2175; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_sta_sub_sea_id__sub_sea_id sub_seasons standings 790;1203;107;1203;107;1965; 0 0 0 0 0 0 id sub_season_id 0 0 1 None None 0,0,0 0,0,0 FK_sta_aff_id__aff_id affiliations standings 227;1254;227;1475;63;1475;63;1965; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 NOTE3 1220 80 97 23 Baseball Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 FK_cor_per_sta_pos_id__pos_id positions core_person_stats 377;1048;466;1048;466;1375; 0 0 0 0 0 0 id position_id 0 0 0 None None 0,0,0 0,0,0 Events Group 760 365 378 1165 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 1200 60 1064 791 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 20 360 395 750 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 430 800 302 338 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 20 80 1126 273 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 20 1550 1119 328 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 1185 860 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 285 10 508 64 SportsDB — The Open Sports Database Schema Draft 20 Released under GPL at http://www.sportsdb.org © 2008 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 1 2 1 NOTE1 1040 375 89 23 Event Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE11 30 370 96 23 Person Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE31 30 90 115 23 Document Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 documents46090182251 id @primary_id 1 1 doc_id VARCHAR VARCHAR(75) the key originally found in the document. Should be globally unique. Not a Foreign Key, even though it ends in _id. 0 1 75 0 publisher_id INTEGER INTEGER the publisher of this document 0 1 0 0 0 0 date_time DATETIME DATETIME Timestamp for when this document was originally published. 0 0 title VARCHAR VARCHAR(255) person | team | league | etc. 0 0 255 0 language VARCHAR VARCHAR(100) 0 0 100 0 priority VARCHAR VARCHAR(100) event | sub_season | league_phase | lifetime 0 0 100 0 revision_id VARCHAR VARCHAR(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,1281 document_fixtures780100164118 id @primary_id Unique per fixture_key + publisher_id 1 1 fixture_key VARCHAR VARCHAR(100) 0 0 100 0 publisher_id INTEGER INTEGER 0 1 0 0 0 0 name VARCHAR VARCHAR(100) OUTMODED.... should use display_names instead 0 0 100 0 document_class_id INTEGER INTEGER 0 1 0 0 0 0 IDX_document_fixtures_1 IDX_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,1281 document_classes98010013661 id @primary_id 1 1 name VARCHAR VARCHAR(100) event-summary, news, statistics, etc. Should be called document_class_key, really. 0 0 100 0 IDX_document_classes_1 IDX_document_classes_1 Default 0 name 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 latest_revisions6012016780 id @primary_id 1 1 revision_id VARCHAR VARCHAR(75) a string from the SportsML 0 1 75 0 latest_document_id INTEGER INTEGER 0 1 0 0 0 0 IDX_FK_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,1281 affiliations_documents66026016561 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 american_football_fumbles_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,1281 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,1281 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,1281 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,1281 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,1281 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,1281 persons_documents4022014761 person_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 FK_wea_con_eve_id__eve_id events weather_conditions 925;631;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;631; 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;631;875;695; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_tea_aff_pha_tea_id__tea_id teams team_phases 35;1289;35;1310; 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;1254;200;1371;181;1371; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_hom_sit_id__sit_id sites teams 440;514;167;514;167;1190; 0 0 0 0 0 0 id home_site_id 0 0 0 None None 0,0,0 0,0,0 FK_tea_pub_id__pub_id publishers teams 600;825;167;825;167;1190; 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;1155;339;676;785;676; 0 0 0 0 0 0 id affiliation_id 0 0 1 None None 0,0,0 0,0,0 FK_tea_aff_pha_sta_sea_id__sea_id seasons team_phases 790;1067;53;1067;53;1310; 0 0 0 0 0 0 id start_season_id 0 0 0 None None 255,128,0 0,0,0 FK_tea_aff_pha_end_sea_id__sea_id seasons team_phases 790;1067;53;1067;53;1310; 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 115;1190;115;301;280;301; 0 0 0 0 0 0 id team_id 0 0 1 None None 0,0,0 0,0,0 FK_aff_doc_doc_id__doc_id documents affiliations_documents 642;305;660;305; 0 0 0 0 0 0 id document_id 0 0 1 None None 0,0,0 0,0,0 FK_aff_doc_aff_id__aff_id affiliations affiliations_documents 281;1155;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;631;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;631;789;1088;296;1088;296;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_mon_tea_id__tea_id teams wagering_moneylines 117;1289;117;1570;190;1570; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_str_spr_lin_eve_id__eve_id events wagering_straight_spread_lines 861;631;861;1076;1014;1076;1014;1575; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_str_spr_lin_tea_id__tea_id teams wagering_straight_spread_lines 166;1289;166;1575;900;1575; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_odd_lin_eve_id__eve_id events wagering_odds_lines 829;631;829;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_odd_lin_tea_id__tea_id teams wagering_odds_lines 143;1289;143;1570;725;1570; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_tot_sco_lin_tea_id__tea_id teams wagering_total_score_lines 135;1289;135;1570;360;1570; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_wag_run_eve_id__eve_id events wagering_runlines 816;631;816;1078;662;1078;662;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 FK_wag_run_tea_id__tea_id teams wagering_runlines 167;1289;167;1570;570;1570; 0 0 0 0 0 0 id team_id 0 0 1 None None 255,0,0 0,0,0 FK_lat_rev_lat_doc_id__doc_id documents latest_revisions 460;194;334;194;334;162;227;162; 0 0 0 0 0 0 id latest_document_id 1 3 1 None None 0,0,0 0,0,0 FK_sea_lea_id__aff_id affiliations seasons 340;1155;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;631;798;1072;492;1072;492;1570; 0 0 0 0 0 0 id event_id 0 0 1 None None 255,128,192 0,0,0 document_fixtures_events770800191118 id @primary_id 1 1 document_fixture_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 latest_document_id INTEGER INTEGER 0 1 0 0 0 0 last_update DATETIME DATETIME 0 0 IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id Default 0 document_fixture_id FK_doc_fix_eve_doc_fix_id__doc_fix_id IDX_FK_doc_fix_eve_eve_id__eve_id IDX_FK_doc_fix_eve_eve_id__eve_id Default 0 event_id FK_doc_fix_eve_eve_id__eve_id IDX_FK_doc_fix_eve_lat_doc_id__doc_id IDX_FK_doc_fix_eve_lat_doc_id__doc_id Default 0 latest_document_id FK_doc_fix_eve_lat_doc_id__doc_id 0,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,1281 wagering_odds_lines7251570162270 id @primary_id Unique per bookmaker_key + event_id + date_time + (team_id | person_id) 1 1 bookmaker_id INTEGER INTEGER 0 1 0 0 0 0 event_id INTEGER INTEGER 0 1 0 0 0 0 date_time DATETIME DATETIME Time that line was set 0 0 team_id INTEGER INTEGER 0 1 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 numerator VARCHAR VARCHAR(100) 0 0 100 0 denominator VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 payout_calculation VARCHAR VARCHAR(100) 0 0 100 0 payout_amount VARCHAR VARCHAR(100) <