XML Team 2005, XML Team Solutions, Inc. MySQL3 2003-11-21 2005-05-21 Verdana,9,,0,1 192,192,192 0 0 1 1 (FK) Events Group 666 340 1035 1191 255,255,225 0,0,0 255,128,192 0 0 GROUPBOX2 176 1578 608 2108 255,255,225 0,0,0 0,0,0 0 0 Events Group1 16 338 389 884 255,255,225 0,0,0 0,0,0 0 0 Events Group11 21 895 364 1190 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX21 26 70 980 287 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX211 399 591 651 706 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX2111 394 743 650 996 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX22 66 1279 958 1540 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX23 173 2125 885 2850 255,255,225 0,0,0 0,0,0 0 0 events914927255,255,2550,0,00,0,0128,128,128255,128,1920 id INTEGER 1 1 1 0 0 0 event_key VARCHAR 0 0 0 20 publisher_id INTEGER 1 0 0 0 0 0 site_key INTEGER 1 0 0 0 0 0 start_date_time VARCHAR 0 Normalized to UTC 0 0 20 site_alignment VARCHAR 0 0 0 20 event_status VARCHAR 0 0 0 20 duration VARCHAR 0 0 0 20 attendance VARCHAR 0 0 0 20 weather_conditions914614255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 event_id VARCHAR 0 0 0 20 temperature VARCHAR 0 0 0 20 humidity VARCHAR 0 0 0 20 clouds VARCHAR 0 0 0 20 wind_direction VARCHAR 0 0 0 20 wind_velocity VARCHAR 0 0 0 20 players200382255,255,2550,0,00,0,0128,128,1280,128,2550 id INTEGER 1 Unique per player_key + publisher_id 1 1 0 0 0 player_key VARCHAR 1 0 0 20 publisher_id INTEGER 1 0 0 0 0 0 given_name VARCHAR 0 0 0 20 middle_name VARCHAR 0 0 0 20 family_name VARCHAR 0 0 0 20 nickname VARCHAR 0 0 0 20 full_name VARCHAR 0 0 0 20 birth_date VARCHAR 0 0 0 20 gender VARCHAR 0 0 0 20 birth_city VARCHAR 0 0 0 20 birth_state VARCHAR 0 0 0 20 birth_country VARCHAR 0 0 0 20 death_date VARCHAR 0 0 0 20 current_injury_phase_id INTEGER 0 0 0 0 0 0 current_team_phase_id INTEGER 0 0 0 0 0 0 current_league_phase_id INTEGER 0 0 0 0 0 0 teams41954255,255,2550,0,00,0,0128,128,128255,128,1280 id INTEGER 1 1 1 0 0 0 team_key VARCHAR 1 0 0 20 publisher_id INTEGER 1 0 0 0 0 0 first_name VARCHAR 0 0 0 20 last_name VARCHAR 0 0 0 20 alias VARCHAR 0 0 0 40 abbreviation VARCHAR 0 0 0 20 short_name VARCHAR 0 0 0 20 home_site_id INTEGER 1 0 0 0 0 0 league_id INTEGER 1 0 0 0 0 0 events_players_subscores700418255,255,2550,0,00,0,0128,128,128192,192,1920 id VARCHAR 1 1 1 40 event_id VARCHAR 0 0 0 40 player_id INTEGER 1 0 0 0 0 0 period VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 players_stats141773255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 0 0 0 0 stat_type VARCHAR 1 0 0 40 player_id INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR 0 event | sub_season | league_phase | lifetime 0 0 40 stat_coverage_id INTEGER 0 0 0 0 0 0 seasons424605255,255,2550,0,00,0,00,0,0255,128,00 id INTEGER 1 Unique per season_key + publisher_id 1 1 0 0 0 season_key INTEGER 1 0 0 0 0 0 publisher_id INTEGER 1 0 0 0 0 0 league_id INTEGER 1 0 0 0 0 0 start_date_time VARCHAR 0 0 0 40 end_date_time VARCHAR 0 0 0 40 sites4171026255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 site_key INTEGER 1 0 0 0 0 0 publisher_id INTEGER 1 0 0 0 0 0 name VARCHAR 0 0 0 40 country INTEGER 1 0 0 0 0 0 state_province INTEGER 1 0 0 0 0 0 city VARCHAR 0 0 0 40 postal_code VARCHAR 0 0 0 40 postal_code_extension VARCHAR 0 0 0 40 timezone VARCHAR 0 0 0 40 address_1 VARCHAR 0 0 0 40 address_2 VARCHAR 0 0 0 40 alias VARCHAR 0 0 0 40 injury_phases41403255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 player_id INTEGER 1 0 0 0 0 0 injury_status VARCHAR 0 0 0 20 injury_type VARCHAR 0 0 0 20 injury_comment VARCHAR 0 0 0 20 disabled_list VARCHAR 0 0 0 20 start_date_time VARCHAR 0 0 0 20 end_date_time VARCHAR 0 0 0 20 season_id INTEGER 1 0 0 0 0 0 team_phases35597255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 player_id INTEGER 1 0 0 0 0 0 team_id INTEGER 1 0 0 0 0 0 uniform_number VARCHAR 0 0 0 20 regular_position VARCHAR 0 0 0 20 start_date_time VARCHAR 0 0 0 20 start_season_id INTEGER 1 0 0 0 0 0 end_date_time VARCHAR 0 0 0 20 end_season_id INTEGER 1 0 0 0 0 0 height VARCHAR 0 0 0 40 weight VARCHAR 0 0 0 40 baseball_offensive_stats4031650255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 average VARCHAR 0 0 0 40 runs_scored VARCHAR 0 0 0 40 at_bats VARCHAR 0 0 0 40 hits VARCHAR 0 0 0 40 rbi VARCHAR 0 0 0 40 total_bases VARCHAR 0 0 0 40 slugging_percentage VARCHAR 0 0 0 40 bases_on_balls VARCHAR 0 0 0 40 strikeouts VARCHAR 0 0 0 40 left_on_base VARCHAR 0 0 0 40 left_in_scoring_position VARCHAR 0 0 0 40 singles VARCHAR 0 0 0 40 doubles VARCHAR 0 0 0 40 triples VARCHAR 0 0 0 40 home_runs VARCHAR 0 0 0 40 grand_slams VARCHAR 0 0 0 40 at_bats_per_rbi VARCHAR 0 0 0 40 plate_appearances_per_rbi VARCHAR 0 0 0 40 at_bats_per_home_run VARCHAR 0 0 0 40 plate_appearances_per_home_run VARCHAR 0 0 0 40 sac_flies VARCHAR 0 0 0 40 sac_bunts VARCHAR 0 0 0 40 grounded_into_double_play VARCHAR 0 0 0 40 moved_up VARCHAR 0 0 0 40 on_base_percentage VARCHAR 0 0 0 40 stolen_bases VARCHAR 0 0 0 40 stolen_bases_caught VARCHAR 0 0 0 40 stolen_bases_average VARCHAR 0 0 0 40 hit_by_pitch VARCHAR 0 0 0 40 defensive_interferance_reaches VARCHAR 0 0 0 40 on_base_plus_slugging VARCHAR 0 0 0 40 plate_appearances VARCHAR 0 0 0 40 hits_extra_base VARCHAR 0 0 0 40 baseball_defensive_stats2111603255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 double_plays VARCHAR 0 0 0 40 triple_plays VARCHAR 0 0 0 40 putouts VARCHAR 0 0 0 40 assists VARCHAR 0 0 0 40 errors VARCHAR 0 0 0 40 fielding_percentage VARCHAR 0 0 0 40 defensive_average VARCHAR 0 0 0 40 errors_passed_ball VARCHAR 0 0 0 40 errors_catchers_interference VARCHAR 0 0 0 40 baseball_pitching_stats2101758255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 runs_allowed VARCHAR 0 0 0 40 home_runs_allowed VARCHAR 0 0 0 40 innings_pitched VARCHAR 0 0 0 40 hits VARCHAR 0 0 0 40 earned_runs VARCHAR 0 0 0 40 unearned_runs VARCHAR 0 0 0 40 bases_on_balls VARCHAR 0 0 0 40 bases_on_balls_intentional VARCHAR 0 0 0 40 strikeouts VARCHAR 0 0 0 40 strikeout_to_bb_ratio VARCHAR 0 0 0 40 number_of_pitches VARCHAR 0 0 0 40 era VARCHAR 0 0 0 40 inherited_runners_scored VARCHAR 0 0 0 40 pick_offs VARCHAR 0 0 0 40 errors_hit_with_pitch VARCHAR 0 0 0 40 errors_wild_pitch VARCHAR 0 0 0 40 balks VARCHAR 0 0 0 40 wins VARCHAR 0 0 0 40 losses VARCHAR 0 0 0 40 saves VARCHAR 0 0 0 40 shutouts VARCHAR 0 0 0 40 games_complete VARCHAR 0 0 0 40 games_finished VARCHAR 0 0 0 40 winning_percentage VARCHAR 0 0 0 40 event_credit VARCHAR 0 0 0 40 save_credit VARCHAR 0 0 0 40 player_league_phases177729255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 player_id INTEGER 1 0 0 0 0 0 league_id INTEGER 1 0 0 0 0 0 start_date_time VARCHAR 0 0 0 20 start_season_id INTEGER 1 0 0 0 0 0 end_date_time VARCHAR 0 0 0 20 end_season_id INTEGER 1 0 0 0 0 0 publishers5651139255,255,2550,0,00,0,0128,128,128128,255,1280 id INTEGER 1 1 0 0 0 0 publisher_key VARCHAR 1 0 0 40 publisher_name VARCHAR 0 0 0 40 events_players914501255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 player_id INTEGER 1 1 0 0 0 0 score VARCHAR 0 0 0 40 events_teams_subscores696956255,255,2550,0,00,0,0128,128,128192,192,1920 id VARCHAR 1 1 1 40 event_id INTEGER 1 0 0 0 0 0 team_id INTEGER 1 0 0 0 0 0 period VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 events_sub_seasons788620255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 sub_season_id INTEGER 1 1 0 0 0 0 team_affiliation_phases1981018255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 team_id INTEGER 1 0 0 0 0 0 start_season_id INTEGER 1 0 0 0 0 0 end_season_id INTEGER 1 0 0 0 0 0 affiliation_id INTEGER 1 0 0 0 0 0 affiliations467837255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 affiliation_key VARCHAR 1 0 0 40 name VARCHAR 0 0 0 40 alias VARCHAR 0 0 0 40 abbreviation VARCHAR 0 0 0 40 type VARCHAR 0 division | conference | caliber | organization | sport 0 0 40 parent_id INTEGER 0 0 0 0 0 0 affiliations_teams1221127255,255,2550,0,00,0,0128,128,128192,192,1920 affiliation_id INTEGER 1 1 0 0 0 0 team_id INTEGER 1 1 0 0 0 0 affiliations_events686800255,255,2550,0,00,0,0128,128,128192,192,1920 affiliation_id INTEGER 1 1 0 0 0 0 event_id INTEGER 1 1 0 0 0 0 sub_seasons545612255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per season_id + type 1 1 0 0 0 season_id INTEGER 1 0 0 0 0 0 type VARCHAR 1 pre | regular | post | exhibition | all-start 0 0 20 start_date_time VARCHAR 0 0 0 20 end_date_time VARCHAR 0 0 0 20 events_teams803832255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 team_id INTEGER 1 1 0 0 0 0 alignment VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 documents368122255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 doc_id VARCHAR 1 0 0 80 publisher_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 0 0 40 title VARCHAR 0 player | team | league | etc. 0 0 40 language VARCHAR 0 0 0 40 priority VARCHAR 0 event | sub_season | league_phase | lifetime 0 0 40 revision_id VARCHAR 0 0 0 40 stats_coverage VARCHAR 0 0 0 40 fixture_id INTEGER 1 0 0 0 0 0 sportsml_path VARCHAR 0 0 0 40 abstract VARCHAR 0 0 0 40 fixtures717158255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per fixture_key + publisher_id 1 1 0 0 0 fixture_key VARCHAR 0 0 0 40 publisher_id INTEGER 1 0 0 0 0 0 name VARCHAR 0 player | team | league | etc. 0 0 40 doc_class_id INTEGER 1 0 0 0 0 0 doc_classes871176255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 name VARCHAR 0 player | team | league | etc. 0 0 40 latest_revisions62137255,255,2550,0,00,0,0128,128,128192,192,1920 revision_id INTEGER 1 0 0 0 0 0 latest_document_id INTEGER 1 0 0 0 0 0 documents_teams206227255,255,2550,0,00,0,0128,128,128192,192,1920 document_id INTEGER 1 1 0 0 0 0 team_id INTEGER 1 1 0 0 0 0 affiliations_documents555217255,255,2550,0,00,0,0128,128,128192,192,1920 affiliation_id INTEGER 1 1 0 0 0 0 document_id INTEGER 1 1 0 0 0 0 events_fixtures8491117255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 fixture_id INTEGER 1 1 0 0 0 0 latest_document_id INTEGER 1 0 0 0 0 0 wagering_moneylines1531336255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 bookmaker_key VARCHAR 0 0 0 40 event_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 0 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 0 0 0 0 rotation_number VARCHAR 0 0 0 40 comment VARCHAR 0 0 0 40 vigorish VARCHAR 0 0 0 40 line VARCHAR 0 0 0 40 line_opening VARCHAR 0 0 0 40 prediction VARCHAR 0 0 0 40 wagering_odds_lines6051348255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 bookmaker_key VARCHAR 0 0 0 40 event_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 0 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 0 0 0 0 rotation_number VARCHAR 0 0 0 40 comment VARCHAR 0 0 0 40 numerator VARCHAR 0 0 0 40 denominator VARCHAR 0 0 0 40 prediction VARCHAR 0 0 0 40 payout_calculation VARCHAR 0 0 0 40 payout_amount VARCHAR 0 0 0 40 wagering_straight_spread_lines7511331255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 bookmaker_key VARCHAR 0 0 0 40 event_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 0 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 0 0 0 0 rotation_number VARCHAR 0 0 0 40 comment VARCHAR 0 0 0 40 vigorish VARCHAR 0 0 0 40 value VARCHAR 0 0 0 40 value_opening VARCHAR 0 0 0 40 prediction VARCHAR 0 0 0 40 wagering_runlines4671297255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 bookmaker_key VARCHAR 0 0 0 40 event_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 0 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 0 0 0 0 rotation_number VARCHAR 0 0 0 40 comment VARCHAR 0 0 0 40 vigorish VARCHAR 0 0 0 40 line VARCHAR 0 0 0 40 line_opening VARCHAR 0 0 0 40 value VARCHAR 0 0 0 40 prediction VARCHAR 0 0 0 40 wagering_total_score_lines2911326255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 Unique per bookmaker_key + event_id + date_time + (team_id | player_id) 1 1 0 0 0 bookmaker_key VARCHAR 0 0 0 40 event_id INTEGER 1 0 0 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 0 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 0 0 0 0 rotation_number VARCHAR 0 0 0 40 comment VARCHAR 0 0 0 40 vigorish VARCHAR 0 0 0 40 line_over VARCHAR 0 0 0 40 line_under VARCHAR 0 0 0 40 total VARCHAR 0 0 0 40 total_opening VARCHAR 0 0 0 40 prediction VARCHAR 0 0 0 40 american_football_defensive_stats1982143255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 tackles_total VARCHAR 0 0 0 40 tackles_solo VARCHAR 0 0 0 40 tackles_assists VARCHAR 0 0 0 40 interceptions_total VARCHAR 0 0 0 40 interceptions_yards VARCHAR 0 0 0 40 interceptions_average VARCHAR 0 0 0 40 interceptions_longest VARCHAR 0 0 0 40 interceptions_touchdown VARCHAR 0 0 0 40 quarterback_hurries VARCHAR 0 0 0 40 sacks_total VARCHAR 0 0 0 40 sacks_yards VARCHAR 0 0 0 40 passes_defensed VARCHAR 0 0 0 40 american_football_down_progress_stats2012331255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 first_downs_total VARCHAR 0 0 0 40 first_downs_pass VARCHAR 0 0 0 40 first_downs_run VARCHAR 0 0 0 40 first_downs_penalty VARCHAR 0 0 0 40 conversions_third_down VARCHAR 0 0 0 40 conversions_third_down_attempts VARCHAR 0 0 0 40 conversions_third_down_percentage VARCHAR 0 0 0 40 conversions_fourth_down VARCHAR 0 0 0 40 conversions_fourth_down_attempts VARCHAR 0 0 0 40 conversions_fourth_down_percentage VARCHAR 0 0 0 40 american_football_fumbles_stats4402150255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 fumbles_committed VARCHAR 0 0 0 40 fumbles_forced VARCHAR 0 0 0 40 fumbles_recovered VARCHAR 0 0 0 40 fumbles_lost VARCHAR 0 0 0 40 fumbles_yards_gained VARCHAR 0 0 0 40 fumbles_own_committed VARCHAR 0 0 0 40 fumbles_own_recovered VARCHAR 0 0 0 40 fumbles_own_lost VARCHAR 0 0 0 40 fumbles_own_yards_gained VARCHAR 0 0 0 40 fumbles_opposing_committed VARCHAR 0 0 0 40 fumbles_opposing_recovered VARCHAR 0 0 0 40 fumbles_opposing_lost VARCHAR 0 0 0 40 fumbles_opposing_yards_gained VARCHAR 0 0 0 40 american_football_offensive_stats4402502255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 offensive_plays_yards VARCHAR 0 0 0 40 offensive_plays_number VARCHAR 0 0 0 40 offensive_plays_average_yards_per VARCHAR 0 0 0 40 possession_duration VARCHAR 0 0 0 40 turnovers_giveaway VARCHAR 0 0 0 40 american_football_rushing_stats4422365255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 rushes_attempts VARCHAR 0 0 0 40 rushes_yards VARCHAR 0 0 0 40 rushes_touchdowns VARCHAR 0 0 0 40 rushing_average_yards_per VARCHAR 0 0 0 40 rushes_first_down VARCHAR 0 0 0 40 rushes_longest VARCHAR 0 0 0 40 american_football_penalties_stats6682365255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 penalties_total VARCHAR 0 0 0 40 penalty_yards VARCHAR 0 0 0 40 penalty_first_downs VARCHAR 0 0 0 40 american_football_passing_stats2062583255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 passes_attempts VARCHAR 0 0 0 40 passes_completions VARCHAR 0 0 0 40 passes_percentage VARCHAR 0 0 0 40 passes_yards_gross VARCHAR 0 0 0 40 passes_yards_net VARCHAR 0 0 0 40 passes_yards_lost VARCHAR 0 0 0 40 passes_touchdowns VARCHAR 0 0 0 40 passes_touchdowns_percentage VARCHAR 0 0 0 40 passes_interceptions VARCHAR 0 0 0 40 passes_interceptions_percentage VARCHAR 0 0 0 40 passes_longest VARCHAR 0 0 0 40 passes_average_yards_per VARCHAR 0 0 0 40 passer_rating VARCHAR 0 0 0 40 receptions_total VARCHAR 0 0 0 40 receptions_yards VARCHAR 0 0 0 40 receptions_touchdowns VARCHAR 0 0 0 40 receptions_first_down VARCHAR 0 0 0 40 receptions_longest VARCHAR 0 0 0 40 receptions_average_yards_per VARCHAR 0 0 0 40 american_football_sacks_against_stats2022511255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 sacks_against_yards VARCHAR 0 0 0 40 sacks_against_total VARCHAR 0 0 0 40 american_football_scoring_stats4452607255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 touchdowns_total VARCHAR 0 0 0 40 touchdowns_passing VARCHAR 0 0 0 40 touchdowns_rushing VARCHAR 0 0 0 40 touchdowns_special_teams VARCHAR 0 0 0 40 touchdowns_defensive VARCHAR 0 0 0 40 extra_points_attempts VARCHAR 0 0 0 40 extra_points_made VARCHAR 0 0 0 40 extra_points_missed VARCHAR 0 0 0 40 extra_points_blocked VARCHAR 0 0 0 40 field_goal_attempts VARCHAR 0 0 0 40 field_goals_made VARCHAR 0 0 0 40 field_goals_missed VARCHAR 0 0 0 40 field_goals_blocked VARCHAR 0 0 0 40 safeties_against VARCHAR 0 0 0 40 two_point_conversions_attempts VARCHAR 0 0 0 40 two_point_conversions_made VARCHAR 0 0 0 40 touchbacks_total VARCHAR 0 0 0 40 american_football_special_teams_stats6532463255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 returns_punt_total VARCHAR 0 0 0 40 returns_punt_yards VARCHAR 0 0 0 40 returns_punt_average VARCHAR 0 0 0 40 returns_punt_longest VARCHAR 0 0 0 40 returns_punt_touchdown VARCHAR 0 0 0 40 returns_kickoff_total VARCHAR 0 0 0 40 returns_kickoff_yards VARCHAR 0 0 0 40 returns_kickoff_average VARCHAR 0 0 0 40 returns_kickoff_longest VARCHAR 0 0 0 40 returns_kickoff_touchdown VARCHAR 0 0 0 40 returns_total VARCHAR 0 0 0 40 returns_yards VARCHAR 0 0 0 40 punts_total VARCHAR 0 0 0 40 punts_yards_gross VARCHAR 0 0 0 40 punts_yards_net VARCHAR 0 0 0 40 punts_longest VARCHAR 0 0 0 40 punts_inside_20 VARCHAR 0 0 0 40 punts_inside_20_percentage VARCHAR 0 0 0 40 punts_average VARCHAR 0 0 0 40 punts_blocked VARCHAR 0 0 0 40 touchbacks_total VARCHAR 0 0 0 40 touchbacks_total_percentage VARCHAR 0 0 0 40 touchbacks_kickoffs VARCHAR 0 0 0 40 touchbacks_kickoffs_percentage VARCHAR 0 0 0 40 touchbacks_punts VARCHAR 0 0 0 40 touchbacks_punts_percentage VARCHAR 0 0 0 40 touchbacks_interceptions VARCHAR 0 0 0 40 touchbacks_interceptions_percentage VARCHAR 0 0 0 40 fair_catches VARCHAR 0 0 0 40 core_stats101646255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 score VARCHAR 0 0 0 40 score_opposing VARCHAR 0 0 0 40 score_attempts VARCHAR 0 0 0 40 score_attempts_opposing VARCHAR 0 0 0 40 score_percentage VARCHAR 0 0 0 40 score_percentage_opposing VARCHAR 0 0 0 40 team_american_football_stats6872214255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 yards_per_attempt VARCHAR 0 0 0 40 average_starting_position VARCHAR 0 0 0 40 timeouts VARCHAR 0 0 0 40 time_of_possession VARCHAR 0 0 0 40 turnover_ratio VARCHAR 0 0 0 40 stats_teams411872255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 0 0 0 0 stat_type VARCHAR 1 0 0 40 team_id INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR 0 event | sub_season | league_phase | lifetime 0 0 40 stat_coverage_id INTEGER 0 0 0 0 0 0 affiliations_stats561966255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 0 0 0 0 stat_type VARCHAR 1 0 0 40 affiliation_id INTEGER 1 0 0 0 0 0 stat_coverage_type VARCHAR 0 event | sub_season | league_phase | lifetime 0 0 40 stat_coverage_id INTEGER 0 0 0 0 0 0 documents_players62193255,255,2550,0,00,0,0128,128,128192,192,1920 document_id INTEGER 1 1 0 0 0 0 player_id INTEGER 1 1 0 0 0 0 REL5 978 818 0 0 events weather_conditions 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 2 1 None None REL8 849 708 0 0 events events_players_subscores 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL31 728 1026 0 0 sites events 255,255,255 0,0,0 128,128,128 0,0,0 1 site_key site_key 0 1 None None REL25 165 428 0 0 injury_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_injury_phase_id 3 0 None None REL36 446 868 0 0 publishers players 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL35 784 1074 0 0 publishers events 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL37 175 568 0 0 players team_phases 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL26 231 663 0 0 players player_league_phases 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL34 165 466 0 0 players injury_phases 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL38 175 605 0 0 team_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_team_phase_id 3 0 None None REL39 258 663 0 0 player_league_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_league_phase_id 3 0 None None REL2 965 738 0 0 events events_players 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL7 637 526 0 0 players events_players 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL1 530 453 0 0 players events_players_subscores 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL6 871 973 0 0 events events_teams_subscores 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL9 419 991 0 0 teams events_teams_subscores 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL10 554 1155 0 0 publishers sites 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL40 277 556 0 0 seasons injury_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id season_id 0 1 None None REL22 902 791 0 0 events events_sub_seasons 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL24 170 1029 0 0 teams team_affiliation_phases 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL43 394 974 0 0 affiliations team_affiliation_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL44 279 1064 0 0 sites teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id home_site_id 0 1 None None REL19 353 1092 0 0 publishers teams 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL45 558 914 0 0 publishers seasons 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL46 125 1106 0 0 teams affiliations_teams 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL47 342 1030 0 0 affiliations affiliations_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL11 848 879 0 0 events affiliations_events 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL15 616 852 0 0 affiliations affiliations_events 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL12 340 853 0 0 seasons team_affiliation_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id start_season_id 0 1 None None REL16 370 853 0 0 seasons team_affiliation_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id end_season_id 0 1 None None REL17 358 705 0 0 seasons player_league_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id start_season_id 0 1 None None REL18 358 725 0 0 seasons player_league_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id end_season_id 0 1 None None REL20 287 656 0 0 seasons team_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id start_season_id 0 1 None None REL21 287 678 0 0 seasons team_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id end_season_id 0 1 None None REL23 83 847 0 0 teams team_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL28 532 647 0 0 seasons sub_seasons 255,255,255 0,0,0 128,128,128 0,0,0 1 id season_id 0 1 None None REL48 711 643 0 0 sub_seasons events_sub_seasons 255,255,255 0,0,0 128,128,128 0,0,0 1 id sub_season_id 0 1 None None REL42 893 909 0 0 events events_teams 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL49 472 914 0 0 teams events_teams 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL50 692 684 0 0 publishers fixtures 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL51 499 708 0 0 publishers documents 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL52 590 184 0 0 fixtures documents 255,255,255 0,0,0 128,128,128 0,0,0 1 id fixture_id 0 1 None None REL58 336 242 0 0 documents documents_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id document_id 0 1 None None REL59 182 608 0 0 teams documents_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL60 509 230 0 0 documents affiliations_documents 255,255,255 0,0,0 128,128,128 0,0,0 1 id document_id 0 1 None None REL61 567 545 0 0 affiliations affiliations_documents 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL62 967 1082 0 0 events events_fixtures 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL63 849 673 0 0 fixtures events_fixtures 255,255,255 0,0,0 128,128,128 0,0,0 1 id fixture_id 0 1 None None REL64 656 697 0 0 documents events_fixtures 255,255,255 0,0,0 128,128,128 0,0,0 1 id latest_document_id 0 1 None None REL65 844 194 0 0 doc_classes fixtures 255,255,255 0,0,0 128,128,128 0,0,0 1 id doc_class_id 0 1 None None REL53 589 1214 0 0 events wagering_moneylines 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL66 145 1211 0 0 teams wagering_moneylines 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL67 229 967 0 0 players wagering_moneylines 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL68 910 1189 0 0 events wagering_straight_spread_lines 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL69 446 1232 0 0 teams wagering_straight_spread_lines 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL70 573 964 0 0 players wagering_straight_spread_lines 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL71 807 1197 0 0 events wagering_odds_lines 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL72 373 1250 0 0 teams wagering_odds_lines 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL73 483 973 0 0 players wagering_odds_lines 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL74 673 1223 0 0 events wagering_total_score_lines 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL75 230 1206 0 0 teams wagering_total_score_lines 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL76 331 962 0 0 players wagering_total_score_lines 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL77 737 1190 0 0 events wagering_runlines 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL78 304 1212 0 0 teams wagering_runlines 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL79 404 947 0 0 players wagering_runlines 255,255,255 0,128,255 128,128,128 0,0,0 1 id player_id 0 1 None None REL54 281 158 0 0 documents latest_revisions 255,255,255 0,0,0 128,128,128 0,0,0 1 id latest_document_id 3 1 None None REL3 304 926 0 0 affiliations teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL4 486 763 0 0 affiliations seasons 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL27 380 829 0 0 affiliations player_league_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL13 142 1185 0 0 players players_stats 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL29 78 1479 0 0 teams stats_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL30 309 1449 0 0 affiliations affiliations_stats 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL32 266 205 0 0 documents documents_players 255,255,255 0,0,0 128,128,128 0,0,0 1 id document_id 0 1 None None REL33 197 305 0 0 players documents_players 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None Legend 291 14 XTOSS — XML Team Open Sports Schema Released under GPL at http://www.xtoss.org -- © 2005 XML Team Solutions, Inc. 255,255,255 0,0,0 128,128,128 2 1 NOTE1 944 365 Event Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE3 505 1603 Baseball Stats 255,255,255 0,0,0 128,128,128 0 1 NOTE11 34 355 Player Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE111 29 906 Team Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE31 31 88 Document Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE1111 74 1291 Wagering Line Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE32 741 2152 American Football Stats 255,255,255 0,0,0 128,128,128 0 1