XML Team 2005, XML Team Solutions, Inc. MySQL3 2003-11-21 2005-04-26 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 20 71 974 288 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 1 0 0 0 current_team_phase_id INTEGER 0 0 1 0 0 0 current_league_phase_id INTEGER 0 0 1 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 abbreviation VARCHAR 0 0 0 20 short_name VARCHAR 0 0 0 20 home_site_id INTEGER 1 0 1 0 0 0 league_id INTEGER 1 0 1 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 1 0 0 0 period VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 stats421850255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 stat_table_name VARCHAR 0 0 0 40 stat_holder_type VARCHAR 0 player | team | league | etc. 0 0 40 stat_holder_id VARCHAR 0 0 0 40 stat_coverage_type VARCHAR 0 event | sub_season | league_phase | lifetime 0 0 40 stat_coverage_id VARCHAR 0 0 0 40 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 1 0 0 0 start_date_time VARCHAR 0 0 0 40 end_date_time VARCHAR 0 0 0 40 leagues414801255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 league_key INTEGER 1 0 0 0 0 0 publisher_id INTEGER 1 0 0 0 0 0 name VARCHAR 0 0 0 40 alias VARCHAR 0 0 0 40 abbreviation 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 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 1 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 1 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 1 0 0 0 team_id INTEGER 1 0 1 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 1 0 0 0 end_date_time VARCHAR 0 0 0 20 end_season_id INTEGER 1 0 1 0 0 0 height VARCHAR 0 0 0 40 weight VARCHAR 0 0 0 40 stats_baseball_offensive4011650255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_baseball_defensive2111603255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_baseball_pitching2101758255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 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 1 0 0 0 league_key INTEGER 1 0 0 0 0 0 start_date_time VARCHAR 0 0 0 20 start_season_id INTEGER 1 0 1 0 0 0 end_date_time VARCHAR 0 0 0 20 end_season_id INTEGER 1 0 1 0 0 0 publishers5641086255,255,2550,0,00,0,0128,128,128128,255,1280 id INTEGER 1 1 0 0 0 0 publisher_name VARCHAR 0 0 0 40 events_players914501255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 1 0 0 0 player_id INTEGER 1 1 1 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 1 0 0 0 team_id INTEGER 1 0 1 0 0 0 period VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 events_leagues773633255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 1 0 0 0 league_id INTEGER 1 1 1 0 0 0 sub_season_id INTEGER 1 Unique per season_id + type 0 1 0 0 0 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 1 0 0 0 start_season_id INTEGER 1 0 1 0 0 0 end_season_id INTEGER 1 0 1 0 0 0 affiliation_id INTEGER 1 0 1 0 0 0 affiliations537880255,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 teams_affiliations1221127255,255,2550,0,00,0,0128,128,128192,192,1920 team_id INTEGER 1 1 1 0 0 0 affiliation_id INTEGER 1 1 1 0 0 0 events_affiliations686800255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 1 0 0 0 affiliation_id INTEGER 1 1 1 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 1 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 1 0 0 0 team_id INTEGER 1 1 1 0 0 0 alignment VARCHAR 0 0 0 40 score VARCHAR 0 0 0 40 leagues_affiliations536776255,255,2550,0,00,0,0128,128,128192,192,1920 league_id INTEGER 1 1 1 0 0 0 affiliation_id INTEGER 1 1 1 0 0 0 documents368122255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 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 1 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 1 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 revisions63156255,255,2550,0,00,0,0128,128,128192,192,1920 revision_id INTEGER 1 1 1 0 0 0 most_recent_document_id INTEGER 1 0 1 0 0 0 documents_leagues578139255,255,2550,0,00,0,0128,128,128192,192,1920 document_id INTEGER 1 1 1 0 0 0 league_id INTEGER 1 1 1 0 0 0 documents_teams73213255,255,2550,0,00,0,0128,128,128192,192,1920 document_id INTEGER 1 1 1 0 0 0 team_id INTEGER 1 1 1 0 0 0 documents_affiliations504213255,255,2550,0,00,0,0128,128,128192,192,1920 document_id INTEGER 1 1 1 0 0 0 affiliation_id INTEGER 1 1 1 0 0 0 events_fixtures8491117255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 1 0 0 0 fixture_id INTEGER 1 1 1 0 0 0 document_id INTEGER 1 0 1 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 1 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 1 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 1 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 1 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 1 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 1 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 1 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 1 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 1 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 1 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 1 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 1 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 1 0 0 0 date_time VARCHAR 0 Time that line was set 0 0 40 team_id INTEGER 1 0 1 0 0 0 player_id INTEGER 1 Unique per player_key + publisher_id 0 1 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 stats_american_football_defensive1982143255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_down_progress2012331255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_fumbles4402150255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_offensive4402502255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_rushing4422365255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_penalties6682365255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_passing2062583255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_sacks_against2022511255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 1 0 0 0 sacks_against_yards VARCHAR 0 0 0 40 sacks_against_total VARCHAR 0 0 0 40 stats_american_football_scoring4452607255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_american_football_special_teams6532463255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_team101646255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 stats_team_american_football6872214255,255,2550,0,00,0,0128,128,128192,192,1920 stat_id INTEGER 1 0 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 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 1024 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 REL33 353 815 0 0 leagues league_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 league_key league_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 442 842 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 783 1045 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 224 663 0 0 players 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 253 663 0 0 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 990 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 553 1120 0 0 publishers sites 255,255,255 128,255,128 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL13 202 1792 0 0 stats stats_baseball_defensive 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL29 181 1901 0 0 stats stats_baseball_pitching 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL30 276 1861 0 0 stats stats_baseball_offensive 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL32 278 910 0 0 leagues teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL14 462 745 0 0 leagues seasons 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL27 534 985 0 0 publishers leagues 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 886 804 0 0 events events_leagues 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL41 641 747 0 0 leagues events_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL24 170 1027 0 0 teams affiliation_phases 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL43 425 982 0 0 affiliations 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 1055 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 560 887 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 117 1100 0 0 teams teams_affiliations 255,255,255 255,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL47 377 1044 0 0 affiliations teams_affiliations 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 events_affiliations 255,255,255 255,128,192 128,128,128 0,0,0 1 id event_id 0 1 None None REL15 651 873 0 0 affiliations events_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL12 338 853 0 0 seasons affiliation_phases 255,255,255 255,128,0 128,128,128 0,0,0 1 id start_season_id 0 1 None None REL16 367 853 0 0 seasons 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 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 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 704 648 0 0 sub_seasons events_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id sub_season_id 0 1 None None REL42 901 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 919 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 REL3 522 826 0 0 leagues leagues_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL4 589 846 0 0 affiliations leagues_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL50 693 658 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 496 676 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 194 0 0 fixtures documents 255,255,255 0,0,0 128,128,128 0,0,0 1 id fixture_id 0 1 None None REL54 299 162 0 0 documents revisions 255,255,255 0,0,0 128,128,128 0,0,0 1 id most_recent_document_id 3 1 None None REL55 299 187 0 0 documents revisions 255,255,255 0,0,0 128,128,128 0,0,0 1 id revision_id 3 1 None None REL56 520 157 0 0 documents documents_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id document_id 0 1 None None REL57 554 488 0 0 leagues documents_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id league_id 0 1 None None REL58 269 231 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 115 601 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 483 231 0 0 documents documents_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id document_id 0 1 None None REL61 563 564 0 0 affiliations documents_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id affiliation_id 0 1 None None REL62 953 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 840 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 652 691 0 0 documents events_fixtures 255,255,255 0,0,0 128,128,128 0,0,0 1 id 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 140 1205 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 221 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 1228 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 1246 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 482 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 227 1200 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 327 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 1208 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 401 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 REL80 81 1796 0 0 stats stats_team 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL81 169 2038 0 0 stats stats_american_football_defensive 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL82 190 2132 0 0 stats stats_american_football_down_progress 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL83 196 2222 0 0 stats stats_american_football_sacks_against 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL84 296 2065 0 0 stats stats_american_football_fumbles 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL85 445 2198 0 0 stats stats_american_football_special_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL86 419 2080 0 0 stats stats_team_american_football 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL87 410 2156 0 0 stats stats_american_football_penalties 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL88 313 2149 0 0 stats stats_american_football_rushing 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL89 329 2218 0 0 stats stats_american_football_offensive 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL90 180 2258 0 0 stats stats_american_football_passing 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_id 0 1 None None REL91 322 2270 0 0 stats stats_american_football_scoring 255,255,255 0,0,0 128,128,128 0,0,0 1 id stat_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