XTOSS

2 XTOSS XML Team 2006, XML Team Solutions, Inc. 8 MySQL3 2006-06-26 2006-06-26 Verdana,8,,0,0,-11,clWindowText 192,192,192 0 1 4 0 1 (FK) 0 0 -NN 0 0 primary_id INTEGER INTEGER 0 1 0 1 boolean_domain INTEGER INTEGER(1) 1 0 0 0 Relation27 0 0 0 0 0 0 0 0 publishers standings id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation11 0 0 0 0 0 0 0 0 locations media id creation_location_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation15 0 0 0 0 0 0 0 0 documents documents_media id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation17 0 0 0 0 0 0 0 0 persons media_captions id caption_author_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation18 0 0 0 0 0 0 0 0 media media_keywords id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation19 0 0 0 0 0 0 0 0 affiliations affiliations_media id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation21 0 0 0 0 0 0 0 0 persons persons_media id person_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation23 0 0 0 0 0 0 0 0 teams teams_media id team_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation25 0 0 0 0 0 0 0 0 events events_media id event_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation22 0 0 0 0 0 0 0 0 media persons_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation24 0 0 0 0 0 0 0 0 media teams_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation26 0 0 0 0 0 0 0 0 media events_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation9 0 0 0 0 0 0 0 0 publishers media id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation10 0 0 0 0 0 0 0 0 persons media id credit_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation8 0 0 0 0 0 0 0 0 documents document_package_entry id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation5 0 0 0 0 0 0 0 0 affiliations standing_subgroups id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation3 0 0 0 0 0 0 0 0 sub_seasons standings id sub_season_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation2 0 0 0 0 0 0 0 0 affiliations standings id affiliation_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 NOTE3 1318 65 93 22 Baseball Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 Rel93 0 0 0 0 0 0 0 0 positions core_person_stats id position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Events Group 736 358 392 627 0 0 255,255,225 0,0,0 255,128,192 1 GROUPBOX2 1306 48 1064 787 0 0 255,255,225 0,0,0 0,0,0 1 Events Group1 17 366 402 666 0 0 255,255,225 0,0,0 0,0,0 1 Events Group11 19 1044 397 321 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX21 20 78 1114 273 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX211 428 384 295 215 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX22 27 1382 1103 318 0 0 255,255,225 0,0,0 0,0,0 1 GROUPBOX23 1289 862 1092 1305 0 0 255,255,225 0,0,0 0,0,0 1 Legend 361 5 315 64 XTOSS — XML Team Open Sports Schema - Draft 10 Released under GPL at http://www.xtoss.org © 2006 XML Team Solutions, Inc. 0 255,255,255 0,0,0 128,128,128 1 2 1 NOTE1 1036 368 85 22 Event Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE11 28 376 92 22 Person Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 NOTE31 29 85 111 22 Document Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 documents459841632640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 doc_id INTEGER INTEGER(255) 1 0 255 0 0 0 publisher_id INTEGER INTEGER 1 0 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 INTEGER INTEGER(255) 0 0 255 0 0 0 stats_coverage VARCHAR VARCHAR(100) 0 0 100 0 document_fixture_id INTEGER INTEGER 1 0 0 0 0 0 source_id INTEGER INTEGER An alternative publisher_id for "republishers" of information. 1 0 0 0 0 0 db_loading_date_time VARCHAR VARCHAR(100) Timestamp for when this document was loaded into the DB. 0 0 100 0

document_fixtures782931541240,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per fixture_key + publisher_id 1 1 fixture_key VARCHAR VARCHAR(100) 0 0 100 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 name VARCHAR VARCHAR(100) person | team | league | etc. 0 0 100 0 document_class_id INTEGER INTEGER 1 0 0 0 0 0

document_classes98589138640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 name VARCHAR VARCHAR(100) person | team | league | etc. 0 0 100 0

latest_revisions51120157840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 revision_id INTEGER INTEGER 1 0 0 0 0 0 latest_document_id INTEGER INTEGER 1 0 0 0 0 0

teams_documents272248142640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 team_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

affiliations_documents664264167640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

american_football_fumbles_stats132117322373040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 fumbles_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_forced VARCHAR VARCHAR(100) 0 0 100 0 fumbles_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_yards_gained VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_own_yards_gained VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_committed VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_recovered VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_lost VARCHAR VARCHAR(100) 0 0 100 0 fumbles_opposing_yards_gained VARCHAR VARCHAR(100) 0 0 100 0

american_football_offensive_stats160020062461440,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 offensive_plays_yards VARCHAR VARCHAR(100) 0 0 100 0 offensive_plays_number VARCHAR VARCHAR(100) 0 0 100 0 offensive_plays_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 possession_duration VARCHAR VARCHAR(100) 0 0 100 0 turnovers_giveaway VARCHAR VARCHAR(100) 0 0 100 0

american_football_rushing_stats160118182341640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 rushes_attempts VARCHAR VARCHAR(100) 0 0 100 0 rushes_yards VARCHAR VARCHAR(100) 0 0 100 0 rushes_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 rushing_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 rushes_first_down VARCHAR VARCHAR(100) 0 0 100 0 rushes_longest VARCHAR VARCHAR(100) 0 0 100 0

american_football_penalties_stats193918912451040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 penalties_total VARCHAR VARCHAR(100) 0 0 100 0 penalty_yards VARCHAR VARCHAR(100) 0 0 100 0 penalty_first_downs VARCHAR VARCHAR(100) 0 0 100 0

american_football_passing_stats132813242353900,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 passes_attempts VARCHAR VARCHAR(100) 0 0 100 0 passes_completions VARCHAR VARCHAR(100) 0 0 100 0 passes_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_gross VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_net VARCHAR VARCHAR(100) 0 0 100 0 passes_yards_lost VARCHAR VARCHAR(100) 0 0 100 0 passes_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 passes_touchdowns_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_interceptions VARCHAR VARCHAR(100) 0 0 100 0 passes_interceptions_percentage VARCHAR VARCHAR(100) 0 0 100 0 passes_longest VARCHAR VARCHAR(100) 0 0 100 0 passes_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0 passer_rating VARCHAR VARCHAR(100) 0 0 100 0 receptions_total VARCHAR VARCHAR(100) 0 0 100 0 receptions_yards VARCHAR VARCHAR(100) 0 0 100 0 receptions_touchdowns VARCHAR VARCHAR(100) 0 0 100 0 receptions_first_down VARCHAR VARCHAR(100) 0 0 100 0 receptions_longest VARCHAR VARCHAR(100) 0 0 100 0 receptions_average_yards_per VARCHAR VARCHAR(100) 0 0 100 0

american_football_sacks_against_stats19562034278840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 sacks_against_yards VARCHAR VARCHAR(100) 0 0 100 0 sacks_against_total VARCHAR VARCHAR(100) 0 0 100 0

american_football_scoring_stats194614962333610,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 touchdowns_total VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_passing VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_rushing VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_special_teams VARCHAR VARCHAR(100) 0 0 100 0 touchdowns_defensive VARCHAR VARCHAR(100) 0 0 100 0 extra_points_attempts VARCHAR VARCHAR(100) 0 0 100 0 extra_points_made VARCHAR VARCHAR(100) 0 0 100 0 extra_points_missed VARCHAR VARCHAR(100) 0 0 100 0 extra_points_blocked VARCHAR VARCHAR(100) 0 0 100 0 field_goal_attempts VARCHAR VARCHAR(100) 0 0 100 0 field_goals_made VARCHAR VARCHAR(100) 0 0 100 0 field_goals_missed VARCHAR VARCHAR(100) 0 0 100 0 field_goals_blocked VARCHAR VARCHAR(100) 0 0 100 0 safeties_against VARCHAR VARCHAR(100) 0 0 100 0 two_point_conversions_attempts VARCHAR VARCHAR(100) 0 0 100 0 two_point_conversions_made VARCHAR VARCHAR(100) 0 0 100 0 touchbacks_total VARCHAR VARCHAR(100) 0 0 100 0

team_american_football_stats13379132181440,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 yards_per_attempt VARCHAR VARCHAR(100) 0 0 100 0 average_starting_position VARCHAR VARCHAR(100) 0 0 100 0 timeouts VARCHAR VARCHAR(100) 0 0 100 0 time_of_possession VARCHAR VARCHAR(100) 0 0 100 0 turnover_ratio VARCHAR VARCHAR(100) 0 0 100 0

persons_documents48213149640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 person_id INTEGER INTEGER 1 1 0 0 0 0 document_id INTEGER INTEGER 1 1 0 0 0 0

REL5 0 0 0 0 0 0 0 0 events weather_conditions id event_id 2 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL25 0 0 0 0 0 0 0 0 injury_phases persons id current_injury_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL36 0 0 0 0 0 0 0 0 publishers persons id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL35 0 0 0 0 0 0 0 0 publishers events id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL37 0 0 0 0 0 0 0 0 persons team_phases id person_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL26 0 0 0 0 0 0 0 0 persons person_league_phases id person_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL34 0 0 0 0 0 0 0 0 persons injury_phases id person_id 0 1 None None 255,255,255 0,128,255 128,128,128 0,0,0 1 0 REL38 0 0 0 0 0 0 0 0 team_phases persons id current_team_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL39 0 0 0 0 0 0 0 0 person_league_phases persons id current_league_phase_id 3 0 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL10 0 0 0 0 0 0 0 0 publishers sites id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL40 0 0 0 0 0 0 0 0 seasons injury_phases id season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL22 0 0 0 0 0 0 0 0 events events_sub_seasons id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL24 0 0 0 0 0 0 0 0 teams team_affiliation_phases id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL43 0 0 0 0 0 0 0 0 affiliations team_affiliation_phases id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL44 0 0 0 0 0 0 0 0 sites teams id home_site_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL19 0 0 0 0 0 0 0 0 publishers teams id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL45 0 0 0 0 0 0 0 0 publishers seasons id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL46 0 0 0 0 0 0 0 0 teams affiliations_teams id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL47 0 0 0 0 0 0 0 0 affiliations affiliations_teams id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL11 0 0 0 0 0 0 0 0 events affiliations_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL15 0 0 0 0 0 0 0 0 affiliations affiliations_events id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL12 0 0 0 0 0 0 0 0 seasons team_affiliation_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL16 0 0 0 0 0 0 0 0 seasons team_affiliation_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL17 0 0 0 0 0 0 0 0 seasons person_league_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL18 0 0 0 0 0 0 0 0 seasons person_league_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL20 0 0 0 0 0 0 0 0 seasons team_phases id start_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL21 0 0 0 0 0 0 0 0 seasons team_phases id end_season_id 0 1 None None 255,255,255 255,128,0 128,128,128 0,0,0 1 0 REL23 0 0 0 0 0 0 0 0 teams team_phases id team_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL28 0 0 0 0 0 0 0 0 seasons sub_seasons id season_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL48 0 0 0 0 0 0 0 0 sub_seasons events_sub_seasons id sub_season_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL50 0 0 0 0 0 0 0 0 publishers document_fixtures id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL51 0 0 0 0 0 0 0 0 publishers documents id publisher_id 0 1 None None 255,255,255 128,255,128 128,128,128 0,0,0 1 0 REL52 0 0 0 0 0 0 0 0 document_fixtures documents id document_fixture_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL58 0 0 0 0 0 0 0 0 documents teams_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL59 0 0 0 0 0 0 0 0 teams teams_documents id team_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL60 0 0 0 0 0 0 0 0 documents affiliations_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL61 0 0 0 0 0 0 0 0 affiliations affiliations_documents id affiliation_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL62 0 0 0 0 0 0 0 0 events document_fixtures_events id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL63 0 0 0 0 0 0 0 0 document_fixtures document_fixtures_events id document_fixture_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL64 0 0 0 0 0 0 0 0 documents document_fixtures_events id latest_document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL65 0 0 0 0 0 0 0 0 document_classes document_fixtures id document_class_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL53 0 0 0 0 0 0 0 0 events wagering_moneylines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL66 0 0 0 0 0 0 0 0 teams wagering_moneylines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL68 0 0 0 0 0 0 0 0 events wagering_straight_spread_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL69 -2 0 0 0 0 0 0 0 teams wagering_straight_spread_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL71 0 0 0 0 0 0 0 0 events wagering_odds_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL72 0 0 0 0 0 0 0 0 teams wagering_odds_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL75 0 0 0 0 0 0 0 0 teams wagering_total_score_lines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL77 0 0 0 0 0 0 0 0 events wagering_runlines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 REL78 0 0 0 0 0 0 0 0 teams wagering_runlines id team_id 0 1 None None 255,255,255 255,0,0 128,128,128 0,0,0 1 0 REL54 0 0 0 0 0 0 0 0 documents latest_revisions id latest_document_id 3 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL3 0 0 0 0 0 0 0 0 affiliations teams id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL4 0 0 0 0 0 0 0 0 affiliations seasons id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL27 0 0 0 0 0 0 0 0 affiliations person_league_phases id league_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL32 0 0 0 0 0 0 0 0 documents persons_documents id document_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 REL33 0 0 0 0 0 0 0 0 persons persons_documents id person_id 0 1 None None 255,255,255 0,0,0 128,128,128 0,0,0 1 0 Rel 0 0 0 0 0 0 0 0 baseball_event_states baseball_action_substitutions id baseball_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel14 0 0 0 0 0 0 0 0 baseball_event_states baseball_action_plays id baseball_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel41 0 0 0 0 0 0 0 0 positions baseball_action_substitutions id person_original_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel55 0 0 0 0 0 0 0 0 positions baseball_action_substitutions id person_replacing_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel80 0 0 0 0 0 0 0 0 positions team_phases id regular_position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 persons2073781902840,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,128 id @primary_id Unique per person_key + publisher_id 1 1 person_key VARCHAR VARCHAR(100) 1 0 100 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 gender VARCHAR VARCHAR(100) 0 0 100 0 current_injury_phase_id INTEGER INTEGER 0 0 0 0 0 0 current_team_phase_id INTEGER INTEGER 0 0 0 0 0 0 current_league_phase_id INTEGER INTEGER 0 0 0 0 0 0 birth_date VARCHAR VARCHAR(100) 0 0 100 0 death_date VARCHAR VARCHAR(100) 0 0 100 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

REL74 0 0 0 0 0 0 0 0 events wagering_total_score_lines id event_id 0 1 None None 255,255,255 255,128,192 128,128,128 0,0,0 1 0 document_fixtures_events9218061931040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 document_fixture_id INTEGER INTEGER 1 0 0 0 0 0 event_id INTEGER INTEGER 1 0 0 0 0 0 latest_document_id INTEGER INTEGER 1 0 0 0 0 0

affiliations_teams1921287138640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 team_id INTEGER INTEGER 1 1 0 0 0 0

team_affiliation_phases3410991761640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 team_id INTEGER INTEGER 1 0 0 0 0 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0

NOTE111 31 1075 85 22 Team Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 wagering_odds_lines69014111562660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 numerator VARCHAR VARCHAR(100) 0 0 100 0 denominator VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0 payout_calculation VARCHAR VARCHAR(100) 0 0 100 0 payout_amount VARCHAR VARCHAR(100) 0 0 100 0

wagering_moneylines6814341612460,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line VARCHAR VARCHAR(100) 0 0 100 0 line_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0

NOTE1111 68 1400 134 22 Wagering Line Tables 0 255,255,255 0,0,0 128,128,128 1 0 1 baseball_action_plays21301141863040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 1 0 0 0 0 0 play_type VARCHAR VARCHAR(100) 0 0 100 0 notation VARCHAR VARCHAR(100) 0 0 100 0 notation_yaml TEXT TEXT 0 0 baseball_defensive_group_id INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(100) 0 0 100 0 runner_on_first_advance INTEGER INTEGER 0 0 0 0 0 0 runner_on_second_advance INTEGER INTEGER 0 0 0 0 0 0 runner_on_third_advance INTEGER INTEGER 0 0 0 0 0 0 outs_recorded INTEGER INTEGER 0 0 0 0 0 0 rbi INTEGER INTEGER 0 0 0 0 0 0 runs_scored INTEGER INTEGER 0 0 0 0 0 0 earned_runs_scored VARCHAR VARCHAR(100) 0 0 100 0

wagering_straight_spread_lines88314102292640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line_value VARCHAR VARCHAR(100) 0 0 100 0 line_value_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0

Note 2087 61 105 22 Baseball Actions 0 255,255,255 0,0,0 192,192,192 1 2 1 NOTE321 2207 945 159 22 American Football Actions 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_event_states18719022302840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 chronology VARCHAR VARCHAR(100) current | historic 1 0 100 0 event_id INTEGER INTEGER 1 0 0 0 0 0 publisher_key VARCHAR VARCHAR(100) 1 0 100 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 1 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

Rel81 0 0 0 0 0 0 0 0 teams american_football_event_states id team_in_possession_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel82 0 0 0 0 0 0 0 0 american_football_event_states american_football_action_plays id american_football_event_state_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel83 0 0 0 0 0 0 0 0 american_football_action_plays american_football_action_participants id play_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel84 0 0 0 0 0 0 0 0 persons american_football_action_participants id person_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 american_football_action_plays212710022391840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 american_football_event_state_id INTEGER INTEGER 1 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 play_type VARCHAR VARCHAR(100) 0 0 100 0 score_attempt_type VARCHAR VARCHAR(100) 0 0 100 0 drive_result VARCHAR VARCHAR(100) 0 0 100 0 points INTEGER INTEGER 0 0 0 0 0 0 comment VARCHAR VARCHAR(100) 0 0 100 0

american_football_action_participants206912552711640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 play_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER Unique per person_key + publisher_id 1 0 0 0 0 0 participant_role VARCHAR VARCHAR(100) 1 0 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

baseball_action_substitutions21304462132640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 1 0 0 0 0 0 sequence_number INTEGER INTEGER 0 0 0 0 0 0 person_type VARCHAR VARCHAR(100) person | associate | official 0 0 100 0 person_original_id INTEGER INTEGER 0 0 0 0 0 0 person_original_position_id INTEGER INTEGER 1 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 1 0 0 0 0 0 person_replacing_lineup_slot INTEGER INTEGER 0 0 0 0 0 0 substitution_reason VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0

baseball_defensive_stats1559621862070,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 double_plays VARCHAR VARCHAR(100) 0 0 100 0 triple_plays VARCHAR VARCHAR(100) 0 0 100 0 putouts VARCHAR VARCHAR(100) 0 0 100 0 assists VARCHAR VARCHAR(100) 0 0 100 0 errors VARCHAR VARCHAR(100) 0 0 100 0 fielding_percentage VARCHAR VARCHAR(100) 0 0 100 0 defensive_average VARCHAR VARCHAR(100) 0 0 100 0 errors_passed_ball VARCHAR VARCHAR(100) 0 0 100 0 errors_catchers_interference VARCHAR VARCHAR(100) 0 0 100 0

baseball_offensive_stats13191172196440,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 average VARCHAR VARCHAR(100) 0 0 100 0 runs_scored VARCHAR VARCHAR(100) 0 0 100 0 at_bats VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0 rbi VARCHAR VARCHAR(100) 0 0 100 0 total_bases VARCHAR VARCHAR(100) 0 0 100 0 slugging_percentage VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls VARCHAR VARCHAR(100) 0 0 100 0 strikeouts VARCHAR VARCHAR(100) 0 0 100 0 left_on_base VARCHAR VARCHAR(100) 0 0 100 0 left_in_scoring_position VARCHAR VARCHAR(100) 0 0 100 0 singles VARCHAR VARCHAR(100) 0 0 100 0 doubles VARCHAR VARCHAR(100) 0 0 100 0 triples VARCHAR VARCHAR(100) 0 0 100 0 home_runs VARCHAR VARCHAR(100) 0 0 100 0 grand_slams VARCHAR VARCHAR(100) 0 0 100 0 at_bats_per_rbi VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances_per_rbi VARCHAR VARCHAR(100) 0 0 100 0 at_bats_per_home_run VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances_per_home_run VARCHAR VARCHAR(100) 0 0 100 0 sac_flies VARCHAR VARCHAR(100) 0 0 100 0 sac_bunts VARCHAR VARCHAR(100) 0 0 100 0 grounded_into_double_play VARCHAR VARCHAR(100) 0 0 100 0 moved_up VARCHAR VARCHAR(100) 0 0 100 0 on_base_percentage VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases_caught VARCHAR VARCHAR(100) 0 0 100 0 stolen_bases_average VARCHAR VARCHAR(100) 0 0 100 0 hit_by_pitch VARCHAR VARCHAR(100) 0 0 100 0 defensive_interferance_reaches VARCHAR VARCHAR(100) 0 0 100 0 on_base_plus_slugging VARCHAR VARCHAR(100) 0 0 100 0 plate_appearances VARCHAR VARCHAR(100) 0 0 100 0 hits_extra_base VARCHAR VARCHAR(100) 0 0 100 0

wagering_total_score_lines28014021992820,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line_over VARCHAR VARCHAR(100) 0 0 100 0 line_under VARCHAR VARCHAR(100) 0 0 100 0 total VARCHAR VARCHAR(100) 0 0 100 0 total_opening VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0

teams23111091221240,0,0255,255,255128,128,128255,255,2551255,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 team_key VARCHAR VARCHAR(100) 1 0 100 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 home_site_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0

basketball_defensive_stats131522831981240,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 steals_total VARCHAR VARCHAR(100) 0 0 100 0 steals_per_game VARCHAR VARCHAR(100) 0 0 100 0 blocks_total VARCHAR VARCHAR(100) 0 0 100 0 blocks_per_game VARCHAR VARCHAR(100) 0 0 100 0

basketball_event_states182522651791640,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 chronology VARCHAR VARCHAR(100) 0 0 100 0 event_id INTEGER INTEGER(100) 0 0 100 0 0 0 publisher_key VARCHAR VARCHAR(100) 0 0 100 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0

basketball_offensive_stats155022112335120,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 field_goals_made INTEGER INTEGER 0 0 0 0 0 0 field_goals_attempted INTEGER INTEGER 0 0 0 0 0 0 field_goals_percentage VARCHAR VARCHAR(100) 0 0 100 0 field_goals_per_game VARCHAR VARCHAR(100) 0 0 100 0 field_goals_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 field_goals_percentage_adjusted VARCHAR VARCHAR(100) 0 0 100 0 three_pointers_made INTEGER INTEGER 0 0 0 0 0 0 three_pointers_attempted INTEGER INTEGER 0 0 0 0 0 0 three_pointers_percentage VARCHAR VARCHAR(100) 0 0 100 0 three_pointers_per_game VARCHAR VARCHAR(100) 0 0 100 0 three_pointers_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 free_throws_made VARCHAR VARCHAR(100) 0 0 100 0 free_throws_attempted VARCHAR VARCHAR(100) 0 0 100 0 free_throws_percentage VARCHAR VARCHAR(100) 0 0 100 0 free_throws_per_game VARCHAR VARCHAR(100) 0 0 100 0 free_throws_attempted_per_game VARCHAR VARCHAR(100) 0 0 100 0 points_scored_total VARCHAR VARCHAR(100) 0 0 100 0 points_scored_per_game VARCHAR VARCHAR(100) 0 0 100 0 assists_total VARCHAR VARCHAR(100) 0 0 100 0 assists_per_game VARCHAR VARCHAR(100) 0 0 100 0 turnovers_total VARCHAR VARCHAR(100) 0 0 100 0 turnovers_per_game VARCHAR VARCHAR(100) 0 0 100 0 points_scored_off_turnovers VARCHAR VARCHAR(100) 0 0 100 0 points_scored_in_paint VARCHAR VARCHAR(100) 0 0 100 0 points_scored_on_second_chance VARCHAR VARCHAR(100) 0 0 100 0 points_scored_on_fast_break VARCHAR VARCHAR(100) 0 0 100 0

basketball_rebounding_stats131424342082040,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 rebounds_total VARCHAR VARCHAR(100) 0 0 100 0 rebounds_per_game VARCHAR VARCHAR(100) 0 0 100 0 rebounds_defensive VARCHAR VARCHAR(100) 0 0 100 0 rebounds_offensive VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_total VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_per_game VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_defensive VARCHAR VARCHAR(100) 0 0 100 0 team_rebounds_offensive VARCHAR VARCHAR(100) 0 0 100 0

ice_hockey_defensive_stats133128492043240,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 0 100 0 shots_power_play_allowed VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_power_play_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_penalty_shot_allowed VARCHAR VARCHAR(100) 0 0 100 0 goals_against_average VARCHAR VARCHAR(100) 0 0 100 0 saves VARCHAR VARCHAR(100) 0 0 100 0 save_percentage VARCHAR VARCHAR(100) 0 0 100 0 penalty_killing_amount VARCHAR VARCHAR(100) 0 0 100 0 penalty_killing_percentage VARCHAR VARCHAR(100) 0 0 100 0 shots_blocked VARCHAR VARCHAR(100) 0 0 100 0 takeaways VARCHAR VARCHAR(100) 0 0 100 0 shutouts VARCHAR VARCHAR(100) 0 0 100 0 minutes_penalty_killing VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0

ice_hockey_event_states186228191851640,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 chronology VARCHAR VARCHAR(100) 0 0 100 0 event_id INTEGER INTEGER(100) 0 0 100 0 0 0 publisher_key VARCHAR VARCHAR(100) 0 0 100 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 period_time_elapsed VARCHAR VARCHAR(100) 0 0 100 0 period_time_remaining VARCHAR VARCHAR(100) 0 0 100 0

ice_hockey_offensive_stats160527742014420,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 0 100 0 goals_game_winning VARCHAR VARCHAR(100) 0 0 100 0 goals_game_tying VARCHAR VARCHAR(100) 0 0 100 0 goals_power_play VARCHAR VARCHAR(100) 0 0 100 0 goals_short_handed VARCHAR VARCHAR(100) 0 0 100 0 goals_even_strength VARCHAR VARCHAR(100) 0 0 100 0 goals_empty_net VARCHAR VARCHAR(100) 0 0 100 0 goals_overtime VARCHAR VARCHAR(100) 0 0 100 0 goals_shootout VARCHAR VARCHAR(100) 0 0 100 0 goals_penalty_shot VARCHAR VARCHAR(100) 0 0 100 0 assists VARCHAR VARCHAR(100) 0 0 100 0 points VARCHAR VARCHAR(100) 0 0 100 0 power_play_amount VARCHAR VARCHAR(100) 0 0 100 0 power_play_percentage VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_taken VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_missed VARCHAR VARCHAR(100) 0 0 100 0 shots_penalty_shot_percentage VARCHAR VARCHAR(100) 0 0 100 0 giveaways VARCHAR VARCHAR(100) 0 0 100 0 minutes_power_play VARCHAR VARCHAR(100) 0 0 100 0 faceoff_wins VARCHAR VARCHAR(100) 0 0 100 0 faceoff_losses VARCHAR VARCHAR(100) 0 0 100 0 faceoff_win_percentage VARCHAR VARCHAR(100) 0 0 100 0 scoring_chances VARCHAR VARCHAR(100) 0 0 100 0

Groupbox 1285 2196 1082 540 0 0 255,255,225 0,0,0 0,0,0 1 Groupbox1 1289 2757 1074 479 0 0 255,255,225 0,0,0 0,0,0 1 Note2 1310 2238 104 22 Basketball Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Note4 1334 2775 109 22 Ice Hockey Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 roles91656901040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 role_key VARCHAR VARCHAR(100) player | coach | manager | owner| umpire | etc. 1 0 100 0 role_name VARCHAR VARCHAR(100) Display name for the key 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0

Rel85 0 0 0 0 0 0 0 0 roles team_phases id role_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel88 0 0 0 0 0 0 0 0 roles person_event_metadata id role_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel89 0 0 0 0 0 0 0 0 positions person_event_metadata id position_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel90 0 0 0 0 0 0 0 0 publishers key_aliases id publisher_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel91 0 0 0 0 0 0 0 0 baseball_action_pitches baseball_action_contact_details id baseball_action_pitch_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel94 0 0 0 0 0 0 0 0 publishers documents id source_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 events_documents946212141640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 0 0 0 0 0 document_id INTEGER INTEGER 1 0 0 0 0 0

Rel95 0 0 0 0 0 0 0 0 events events_documents id event_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 Rel96 0 0 0 0 0 0 0 0 documents events_documents id document_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 injury_phases324381132040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 person_id INTEGER INTEGER 1 0 0 0 0 0 injury_status VARCHAR VARCHAR(100) 0 0 100 0 injury_type VARCHAR VARCHAR(100) 0 0 100 0 injury_comment VARCHAR VARCHAR(100) 0 0 100 0 disabled_list VARCHAR VARCHAR(100) 0 0 100 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 season_id INTEGER INTEGER 1 0 0 0 0 0

person_league_phases2386891691840,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 person_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 person_role VARCHAR VARCHAR(100) 0 0 100 0

person_event_metadata2238891781240,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 status VARCHAR VARCHAR(100) benched | started | played | scratched 0 0 100 0 weight VARCHAR VARCHAR(100) 0 0 100 0 role_id INTEGER INTEGER 1 0 0 0 0 0 position_id INTEGER INTEGER 1 0 0 0 0 0

team_phases307831552640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 person_id INTEGER INTEGER 1 0 0 0 0 0 role_id INTEGER INTEGER 1 0 0 0 0 0 team_id INTEGER INTEGER 1 0 0 0 0 0 uniform_number VARCHAR VARCHAR(100) 0 0 100 0 regular_position_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 start_season_id INTEGER INTEGER 1 0 0 0 0 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_season_id INTEGER INTEGER 1 0 0 0 0 0 height VARCHAR VARCHAR(100) 0 0 100 0 weight VARCHAR VARCHAR(100) 0 0 100 0

positions45586391840,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 abbreviation VARCHAR VARCHAR(20) 1 0 20 0

seasons4364301151440,0,0255,255,2550,0,0255,255,2551255,128,00010,0,0255,255,255128,128,128 id @primary_id Unique per season_key + publisher_id 1 1 season_key INTEGER INTEGER 1 0 0 0 0 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 league_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0

sub_seasons5714121191440,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id Unique per season_id + type 1 1 sub_season_key VARCHAR VARCHAR(100) 0 0 100 0 season_id INTEGER INTEGER 1 0 0 0 0 0 sub_season_type VARCHAR VARCHAR(100) pre | regular | post | exhibition | all-star 1 0 100 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0 IDX_%TAB_NAME%_1 Default Default 0 sub_season_key

weather_conditions9275861461640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 event_id INTEGER INTEGER(255) 1 0 255 0 0 0 temperature VARCHAR VARCHAR(100) 0 0 100 0 humidity VARCHAR VARCHAR(100) 0 0 100 0 clouds VARCHAR VARCHAR(100) 0 0 100 0 wind_direction VARCHAR VARCHAR(100) 0 0 100 0 wind_velocity VARCHAR VARCHAR(100) 0 0 100 0

events7535391152040,0,0255,255,255128,128,128255,255,2551255,128,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 event_key VARCHAR VARCHAR(100) 0 0 100 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 start_date_time DATETIME DATETIME Normalized to UTC 0 0 site_id INTEGER INTEGER 1 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

publishers5981090111840,0,0255,255,255128,128,128255,255,2551128,255,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 publisher_key VARCHAR VARCHAR(100) 1 0 100 0 publisher_name VARCHAR VARCHAR(100) 0 0 100 0

sites44712271151040,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 site_key INTEGER INTEGER 1 0 0 0 0 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 location_id INTEGER INTEGER 0 0 0 0 0 0

wagering_runlines50914131392620,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 event_id INTEGER INTEGER 1 0 0 0 0 0 date_time VARCHAR VARCHAR(100) Time that line was set 0 0 100 0 team_id INTEGER INTEGER 1 0 0 0 0 0 person_id INTEGER INTEGER 0 0 0 0 0 0 rotation_key VARCHAR VARCHAR(100) 0 0 100 0 comment VARCHAR VARCHAR(100) 0 0 100 0 vigorish VARCHAR VARCHAR(100) 0 0 100 0 line VARCHAR VARCHAR(100) 0 0 100 0 line_opening VARCHAR VARCHAR(100) 0 0 100 0 line_value VARCHAR VARCHAR(100) 0 0 100 0 prediction VARCHAR VARCHAR(100) 0 0 100 0

baseball_action_contact_details17626292291840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_action_pitch_id INTEGER INTEGER 1 0 0 0 0 0 location VARCHAR VARCHAR(100) 0 0 100 0 strength VARCHAR VARCHAR(100) hard | soft | grounder | etc. 0 0 100 0 velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0 trajectory_coordinates VARCHAR VARCHAR(100) yaml array of coordinates? 0 0 100 0 trajectory_formula VARCHAR VARCHAR(100) formula describing this path 0 0 100 0

baseball_event_states1777631663870,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 current BOOL BOOL true if this is the current state of the event 1 0 event_id INTEGER INTEGER 1 0 0 0 0 0 sequence_number INTEGER INTEGER the unique serial number for this state 1 0 0 0 0 0 at_bat_number INTEGER INTEGER the unique serial number for this at bat 0 0 0 0 0 0 inning_value INTEGER INTEGER 0 0 0 0 0 0 inning_half VARCHAR VARCHAR(100) top | bottom 0 0 100 0 outs INTEGER INTEGER 0 0 0 0 0 0 balls INTEGER INTEGER 0 0 0 0 0 0 strikes INTEGER INTEGER 0 0 0 0 0 0 runner_on_first_id INTEGER INTEGER 0 0 0 0 0 0 runner_on_second_id INTEGER INTEGER 0 0 0 0 0 0 runner_on_third_id INTEGER INTEGER 0 0 0 0 0 0 runner_on_first BOOL BOOL 0 0 runner_on_second BOOL BOOL 0 0 runner_on_third BOOL BOOL 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

Rel56 0 0 0 0 0 0 0 0 sites events id site_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 0 0 addresses6117331023290,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1 location_id INTEGER INTEGER 1 0 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) 0 0 100 0 county VARCHAR VARCHAR(100) 0 0 100 0 region VARCHAR VARCHAR(100) 0 0 100 0 postal_code VARCHAR VARCHAR(100) 0 0 100 0 country VARCHAR VARCHAR(100) 0 0 100 0

locations609608951120,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 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

Groupbox3 595 605 133 465 0 0 255,255,225 0,0,0 192,192,192 1 document_contents256931441020,0,0255,255,255128,128,128255,255,2551192,192,1920000,0,0255,255,255128,128,128 id @primary_id 1 1 document_id INTEGER INTEGER(255) 1 0 255 0 0 0 sportsml MEDIUMTEXT MEDIUMTEXT 0 0 abstract TEXT TEXT 0 0

Relation1 0 0 0 0 0 0 0 0 documents document_contents id document_id 3 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 key_aliases59711831151440,0,0255,255,255128,128,128255,255,25510,128,2550010,0,0255,255,255128,128,128 id @primary_id 1 1 publisher_id INTEGER INTEGER 1 0 0 0 0 0 key_type VARCHAR VARCHAR(100) person | team | league | etc. 0 0 100 0 key_value VARCHAR VARCHAR(100) A person_key, team_key, etc. 0 0 100 0 id_value INTEGER INTEGER A person_id, team_id, etc. 0 0 0 0 0 0 common_key VARCHAR VARCHAR(100) Locally generated key that is the same for all rows that are aliases for the same thing. 0 0 100 0

baseball_pitching_stats15612821735180,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 runs_allowed VARCHAR VARCHAR(100) 0 0 100 0 home_runs_allowed VARCHAR VARCHAR(100) 0 0 100 0 innings_pitched VARCHAR VARCHAR(100) 0 0 100 0 hits VARCHAR VARCHAR(100) 0 0 100 0 earned_runs VARCHAR VARCHAR(100) 0 0 100 0 unearned_runs VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls VARCHAR VARCHAR(100) 0 0 100 0 bases_on_balls_intentional VARCHAR VARCHAR(100) 0 0 100 0 strikeouts VARCHAR VARCHAR(100) 0 0 100 0 strikeout_to_bb_ratio VARCHAR VARCHAR(100) 0 0 100 0 number_of_pitches VARCHAR VARCHAR(100) 0 0 100 0 era VARCHAR VARCHAR(100) 0 0 100 0 inherited_runners_scored VARCHAR VARCHAR(100) 0 0 100 0 pick_offs VARCHAR VARCHAR(100) 0 0 100 0 errors_hit_with_pitch VARCHAR VARCHAR(100) 0 0 100 0 errors_wild_pitch VARCHAR VARCHAR(100) 0 0 100 0 balks VARCHAR VARCHAR(100) 0 0 100 0 wins VARCHAR VARCHAR(100) 0 0 100 0 losses VARCHAR VARCHAR(100) 0 0 100 0 saves VARCHAR VARCHAR(100) 0 0 100 0 shutouts VARCHAR VARCHAR(100) 0 0 100 0 games_complete VARCHAR VARCHAR(100) 0 0 100 0 games_finished VARCHAR VARCHAR(100) 0 0 100 0 winning_percentage VARCHAR VARCHAR(100) 0 0 100 0 event_credit VARCHAR VARCHAR(100) 0 0 100 0 save_credit VARCHAR VARCHAR(100) 0 0 100 0

standings4817741412560,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id INTEGER INTEGER 1 1 0 0 0 0 affiliation_id INTEGER INTEGER(255) eg, ID for league-key 1 0 255 0 0 0 standing_type VARCHAR VARCHAR(100) division | conference | playoffs | wild-card | etc. 0 0 100 0 sub_season_id VARCHAR VARCHAR(100) 1 0 100 0 last_updated VARCHAR VARCHAR(100) date timestamp that these standings were last updated 0 0 100 0 duration_scope VARCHAR VARCHAR(100) regulation | overtime | etc. Indicates class of events included statistics apply to. 0 0 100 0 competition_scope VARCHAR VARCHAR(100) NULL (all competitions) | position | team | conference | etc. Indicates that the included statistics apply only to events against particular groups of opponents, such as those in the same division, or v. lefties, v. righties 0 0 100 0 competition_scope_id VARCHAR VARCHAR(100) a team_id, a position_id, a division_id, etc. The ID for kind of competition standing is limited to 0 0 100 0 alignment_scope VARCHAR VARCHAR(100) all | home | away | etc. Indicates that the included statistics apply only to events played either at home or away 0 0 100 0 site_scope VARCHAR VARCHAR(100) all | indoors | outdoors | carpet | clay | etc. 0 0 100 0 scoping_label VARCHAR VARCHAR(100) A textual description for the scope (when all else fails...) 0 0 100 0 publisher_id INTEGER INTEGER 1 0 0 0 0 0 source VARCHAR VARCHAR(100) pre-published | real-time 0 0 100 0

standing_subgroups482038148770,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 standing_id INTEGER INTEGER(255) 1 0 255 0 0 0 affiliation_id INTEGER INTEGER(255) id for, say, American League East division 1 0 255 0 0 0

outcome_totals21517491693660,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 standing_subgroup_id INTEGER INTEGER(255) 1 0 255 0 0 0 outcome_holder_type VARCHAR VARCHAR(100) team | player | etc 0 0 100 0 outcome_holder_id INTEGER INTEGER(255) the team_id or player_id or etc 0 0 255 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 wins VARCHAR VARCHAR(100) 0 0 100 0 losses VARCHAR VARCHAR(100) 0 0 100 0 ties VARCHAR VARCHAR(100) 0 0 100 0 undecideds VARCHAR VARCHAR(100) 0 0 100 0 winning_percentage VARCHAR VARCHAR(100) 0 0 100 0 points_scored_for VARCHAR VARCHAR(100) 0 0 100 0 points_scored_against VARCHAR VARCHAR(100) 0 0 100 0 points_difference VARCHAR VARCHAR(100) games back, for baseball 0 0 100 0 standing_points VARCHAR VARCHAR(100) 0 0 100 0 streak_type VARCHAR VARCHAR(100) win | loss | tie | score | assist | point 0 0 100 0 streak_duration VARCHAR VARCHAR(100) number of days 0 0 100 0 streak_total VARCHAR VARCHAR(100) number of games 0 0 100 0 streak_start DATE DATE 0 0 streak_end DATE DATE 0 0

Groupbox4 29 1735 368 392 0 0 255,255,225 0,0,0 192,192,192 1 periods8953701341020,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1 participant_event_id INTEGER INTEGER 0 0 0 0 0 0 period_value VARCHAR VARCHAR(100) 0 0 100 0 score VARCHAR VARCHAR(100) 0 0 100 0

sub_periods898473119102Especially 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,128 id @primary_id 1 1 period_id INTEGER INTEGER 0 0 0 0 0 0 sub_period_value VARCHAR VARCHAR(100) 0 0 100 0 score VARCHAR VARCHAR(100) 0 0 100 0

participants_events7423691461620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1 participant_id INTEGER INTEGER 0 0 0 0 0 0 participant_type VARCHAR VARCHAR(100) 0 0 100 0 event_id INTEGER INTEGER 0 0 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

events_sub_seasons754885154640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 1 0 0 0 0 sub_season_id INTEGER INTEGER 1 1 0 0 0 0

affiliations_events761799140640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 1 0 0 0 0 event_id INTEGER INTEGER 1 1 0 0 0 0

document_packages43417901501020,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 package_key VARCHAR VARCHAR(100) eg, top-news-nba 0 0 100 0 package_name VARCHAR VARCHAR(100) eg, "Top NBA News" 0 0 100 0 date_time DATETIME DATETIME time this package was originally published 0 0

document_package_entry42919211861420,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 document_package_id INTEGER INTEGER(255) 1 0 255 0 0 0 rank VARCHAR VARCHAR(100) 0 0 100 0 document_id INTEGER INTEGER(255) 1 0 255 0 0 0 headline VARCHAR VARCHAR(100) 0 0 100 0 short_headline VARCHAR VARCHAR(100) 0 0 100 0

Groupbox5 409 1735 226 379 0 0 255,255,225 0,0,0 192,192,192 1 Note5 418 1745 177 22 Document Packages 0 255,255,255 0,0,0 192,192,192 1 2 1 Note6 40 1745 118 22 Standings Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 documents_media8381753144102identifies 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,128 id VARCHAR VARCHAR(100) 1 1 100 0 document_id INTEGER INTEGER(255) 1 0 255 0 0 0 media_id INTEGER INTEGER(255) 1 0 255 0 0 0 media_caption_id INTEGER INTEGER(255) 1 0 255 0 0 0

media66317731582100,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 object_id INTEGER INTEGER(255) parallel to the doc_id... the original unique ID provided by the publisher 0 0 255 0 0 0 source_id INTEGER INTEGER(255) an ID that was used upstream from the current publisher's object_id 0 0 255 0 0 0 revision_id INTEGER INTEGER(255) 0 0 255 0 0 0 media_type VARCHAR VARCHAR(100) photo | audio | video 0 0 100 0 publisher_id INTEGER INTEGER(255) 1 0 255 0 0 0 date_time VARCHAR VARCHAR(100) 0 0 100 0 credit_id INTEGER INTEGER(255) 1 0 255 0 0 0 db_loading_date_time VARCHAR VARCHAR(100) 0 0 100 0 creation_location_id INTEGER INTEGER(255) 1 0 255 0 0 0

media_captions81620271461620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 media_id INTEGER INTEGER(255) 1 0 255 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(255) 1 0 255 0 0 0 language VARCHAR VARCHAR(100) 0 0 100 0 caption_size VARCHAR VARCHAR(100) size of caption, in characters 0 0 100 0

media_contents67819961202000,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 media_id INTEGER INTEGER(255) 1 0 255 0 0 0 object VARCHAR VARCHAR(100) 0 0 100 0 format VARCHAR VARCHAR(100) 0 0 100 0 mime_type VARCHAR VARCHAR(100) 0 0 100 0 height VARCHAR VARCHAR(100) 0 0 100 0 width VARCHAR VARCHAR(100) 0 0 100 0 duration VARCHAR VARCHAR(100) 0 0 100 0 file_size VARCHAR VARCHAR(100) 0 0 100 0 resolution VARCHAR VARCHAR(100) main | thumbnail | low-bandwidth | high-bandwidth 0 0 100 0

media_keywords9931750127820,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 keyword VARCHAR VARCHAR(100) 0 0 100 0 media_id INTEGER INTEGER(255) 1 0 255 0 0 0

teams_media10112027104620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 team_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0

affiliations_media9831857134620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 affiliation_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0

persons_media9921936116620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 person_id INTEGER INTEGER Unique per person_key + publisher_id 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0

events_media10072116108620,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 event_id INTEGER INTEGER 1 0 0 0 0 0 media_id INTEGER INTEGER 1 0 0 0 0 0

Groupbox6 651 1729 479 480 0 0 255,255,225 0,0,0 192,192,192 1 Note7 663 1741 86 22 Media Tables 0 255,255,255 0,0,0 192,192,192 1 2 1 tennis_service_stats133833052033190,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 0 100 0 services_played VARCHAR VARCHAR(100) 0 0 100 0 matches_played VARCHAR VARCHAR(100) 0 0 100 0 aces VARCHAR VARCHAR(100) 0 0 100 0 first_services_good VARCHAR VARCHAR(100) 0 0 100 0 first_services_good_pct VARCHAR VARCHAR(100) 0 0 100 0 first_service_points_won VARCHAR VARCHAR(100) 0 0 100 0 first_service_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 second_service_points_won VARCHAR VARCHAR(100) 0 0 100 0 second_service_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 service_games_played VARCHAR VARCHAR(100) 0 0 100 0 service_games_won VARCHAR VARCHAR(100) 0 0 100 0 service_games_won_pct VARCHAR VARCHAR(100) 0 0 100 0 break_points_played VARCHAR VARCHAR(100) 0 0 100 0 break_points_saved VARCHAR VARCHAR(100) 0 0 100 0 break_points_saved_pct VARCHAR VARCHAR(100) 0 0 100 0

tennis_event_states189133121511840,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 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(255) 0 0 255 0 0 0 server_score VARCHAR VARCHAR(100) 0 0 100 0 receiver_person_id INTEGER INTEGER(20) 0 0 20 0 0 0 receiver_score VARCHAR VARCHAR(100) 0 0 100 0 service_number VARCHAR VARCHAR(100) 0 0 100 0

tennis_return_stats158433032452840,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 0 100 0 returns_played VARCHAR VARCHAR(100) 0 0 100 0 matches_played VARCHAR VARCHAR(100) 0 0 100 0 first_service_return_points_won VARCHAR VARCHAR(100) 0 0 100 0 first_service_return_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 second_service_return_points_won VARCHAR VARCHAR(100) 0 0 100 0 second_service_return_points_won_pct VARCHAR VARCHAR(100) 0 0 100 0 return_games_played VARCHAR VARCHAR(100) 0 0 100 0 return_games_won VARCHAR VARCHAR(100) 0 0 100 0 return_games_won_pct VARCHAR VARCHAR(100) 0 0 100 0 break_points_played VARCHAR VARCHAR(100) 0 0 100 0 break_points_converted VARCHAR VARCHAR(100) 0 0 100 0 break_points_converted_pct VARCHAR VARCHAR(100) 0 0 100 0

Groupbox11 1295 3253 1074 386 0 0 255,255,225 0,0,0 0,0,0 1 Note41 1325 3270 109 22 Tennis Stats 0 255,255,255 0,0,0 192,192,192 1 2 1 Groupbox7 750 1001 384 330 0 0 255,255,225 0,0,0 192,192,192 1 core_stats93610161801640,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 score VARCHAR VARCHAR(100) 0 0 100 0 score_opposing VARCHAR VARCHAR(100) 0 0 100 0 score_attempts VARCHAR VARCHAR(100) 0 0 100 0 score_attempts_opposing VARCHAR VARCHAR(100) 0 0 100 0 score_percentage VARCHAR VARCHAR(100) 0 0 100 0 score_percentage_opposing VARCHAR VARCHAR(100) 0 0 100 0

core_person_stats93911951401240,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id @primary_id 1 1 time_played INTEGER INTEGER in seconds 0 0 0 0 0 0 events_played INTEGER INTEGER 0 0 0 0 0 0 events_started INTEGER INTEGER 0 0 0 0 0 0 position_id INTEGER INTEGER optional id, which allows one to record how long the person was at this position 1 0 0 0 0 0

stats77810361381840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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 1 0 0 0 0 0 stat_holder_type VARCHAR VARCHAR(100) person | team | conference | league | 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) event | sub_season | league_phase | lifetime 0 0 100 0 stat_coverage_id INTEGER INTEGER id of that event, sub_season, etc. 0 0 0 0 0 0 final BOOL BOOL true if this is a confirmed stat 1 0

NOTE322 779 1006 147 22 Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 Relation4 0 0 0 0 0 0 0 0 standings standing_subgroups id standing_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation6 0 0 0 0 0 0 0 0 standing_subgroups outcome_totals id standing_subgroup_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation7 0 0 0 0 0 0 0 0 document_packages document_package_entry id document_package_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation12 0 0 0 0 0 0 0 0 media media_contents id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation13 0 0 0 0 0 0 0 0 media documents_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation14 0 0 0 0 0 0 0 0 media_captions documents_media id media_caption_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation16 0 0 0 0 0 0 0 0 media media_captions id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 Relation20 0 0 0 0 0 0 0 0 media affiliations_media id media_id 0 1 None None 255,255,255 0,0,0 192,192,192 0,0,0 1 0 tennis_action_points214432831541040,0,0255,255,255128,128,128255,255,2551128,128,1280010,0,0255,255,255128,128,128 id VARCHAR VARCHAR(100) 1 1 100 0 sub_period_id VARCHAR VARCHAR(100) 0 0 100 0 sequence_number VARCHAR VARCHAR(100) 0 0 100 0 win_type VARCHAR VARCHAR(100) forced | unforced 0 0 100 0

tennis_action_volleys21373415161184One 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,128 id VARCHAR VARCHAR(100) 1 1 100 0 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(255) 0 0 255 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

display_names4506121142420,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1 language VARCHAR VARCHAR(100) 1 0 100 0 entity_id INTEGER INTEGER(255) 1 0 255 0 0 0 entity_type VARCHAR VARCHAR(100) person | team | affiliation tier | site | position 1 0 100 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

affiliations4469931101840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 affiliation_key VARCHAR VARCHAR(100) 1 0 100 0 tier VARCHAR VARCHAR(100) division | conference | caliber | organization | sport 0 0 100 0 parent_id INTEGER INTEGER 0 0 0 0 0 0 start_season_id INTEGER INTEGER(255) 0 0 255 0 0 0 start_date_time VARCHAR VARCHAR(100) 0 0 100 0 end_season_id INTEGER INTEGER(255) 0 0 255 0 0 0 end_date_time VARCHAR VARCHAR(100) 0 0 100 0

baseball_defensive_players19617252001020,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_defensive_group_id INTEGER INTEGER 0 0 0 0 0 0 player_id INTEGER INTEGER 0 0 0 0 0 0 position_id INTEGER INTEGER 0 0 0 0 0 0

baseball_defensive_group2170756189420,0,0255,255,255128,128,128255,255,2551128,128,1280000,0,0255,255,255128,128,128 id @primary_id 1 1

baseball_action_pitches19113921862120,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 baseball_event_state_id INTEGER INTEGER 0 0 0 0 0 0 baseball_defensive_group_id INTEGER INTEGER 0 0 0 0 0 0 umpire_call VARCHAR VARCHAR(100) 0 0 100 0 pitch_location VARCHAR VARCHAR(100) 0 0 100 0 pitch_type VARCHAR VARCHAR(100) 0 0 100 0 pitch_velocity INTEGER INTEGER 0 0 0 0 0 0 comment TEXT TEXT 0 0 trajectory_coordinates VARCHAR VARCHAR(100) yaml array of coordinates? 0 0 100 0 trajectory_formula VARCHAR VARCHAR(100) formula describing this path 0 0 100 0

american_football_down_progress_stats130010812852310,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 first_downs_total VARCHAR VARCHAR(100) 0 0 100 0 first_downs_pass VARCHAR VARCHAR(100) 0 0 100 0 first_downs_run VARCHAR VARCHAR(100) 0 0 100 0 first_downs_penalty VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down_attempts VARCHAR VARCHAR(100) 0 0 100 0 conversions_third_down_percentage VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down_attempts VARCHAR VARCHAR(100) 0 0 100 0 conversions_fourth_down_percentage VARCHAR VARCHAR(100) 0 0 100 0

NOTE32 1358 879 147 22 American Football Stats 0 255,255,255 0,0,0 128,128,128 1 0 1 american_football_defensive_stats16028812492840,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 id @primary_id 1 1 tackles_total VARCHAR VARCHAR(100) 0 0 100 0 tackles_solo VARCHAR VARCHAR(100) 0 0 100 0 tackles_assists VARCHAR VARCHAR(100) 0 0 100 0 interceptions_total VARCHAR VARCHAR(100) 0 0 100 0 interceptions_yards VARCHAR VARCHAR(100) 0 0 100 0 interceptions_average VARCHAR VARCHAR(100) 0 0 100 0 interceptions_longest VARCHAR VARCHAR(100) 0 0 100 0 interceptions_touchdown VARCHAR VARCHAR(100) 0 0 100 0 quarterback_hurries VARCHAR VARCHAR(100) 0 0 100 0 sacks_total VARCHAR VARCHAR(100) 0 0 100 0 sacks_yards VARCHAR VARCHAR(100) 0 0 100 0 passes_defensed VARCHAR VARCHAR(100) 0 0 100 0

american_football_special_teams_stats163112192795660,0,0255,255,255128,128,128255,255,2551192,192,1920010,0,0255,255,255128,128,128 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