XML Team 2005, XML Team Solutions MySQL3 2003-11-21 2005-04-18 Verdana,9,,0,1 206,231,255 0 0 1 1 (FK) Events Group 521 39 943 454 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX2 173 885 773 1407 255,255,225 0,0,0 0,0,0 0 0 Events Group1 9 4 392 433 255,255,225 0,0,0 0,0,0 0 0 events556201255,255,2550,0,00,0,0128,128,128192,192,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_conditions805191255,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 players1611255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 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 1 0 1 0 0 0 current_team_phase_id INTEGER 1 0 1 0 0 0 current_league_phase_id INTEGER 1 0 1 0 0 0 teams278469255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 team_key VARCHAR 1 0 0 20 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_key INTEGER 1 0 0 0 0 0 division_key INTEGER 1 0 0 0 0 0 conference_key INTEGER 1 0 0 0 0 0 league_id INTEGER 1 0 1 0 0 0 events_teams709383255,255,2550,0,00,0,0128,128,128192,192,1920 event_id VARCHAR 1 0 0 20 team_key VARCHAR 1 0 0 20 alignment VARCHAR 0 0 0 20 score VARCHAR 0 0 0 20 events_players_subscores61751255,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 organizations117769255,255,2550,0,00,0,0128,128,128192,192,1920 organization_key INTEGER 1 1 0 0 0 0 organization_name VARCHAR 0 0 0 40 event_affiliations701161255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 affiliation_type VARCHAR 0 team | division | conference | etc. 0 0 40 affiliation_key INTEGER 1 0 0 0 0 0 stats27936255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 name VARCHAR 0 0 0 40 stat_holder_type VARCHAR 0 player | team | league | etc. 0 0 40 stat_holder_key VARCHAR 0 0 0 40 stat_coverage_type VARCHAR 0 event | season | career | etc. 0 0 40 stat_coverage_key VARCHAR 0 0 0 40 stat_table_name VARCHAR 0 0 0 40 seasons365640255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 1 0 0 0 season_key INTEGER 1 0 0 0 0 0 league_id INTEGER 1 0 1 0 0 0 preseason_start_date_time VARCHAR 0 0 0 40 regular_season_start_date_time VARCHAR 0 0 0 40 postseason_start_date_time VARCHAR 0 0 0 40 postseason_end_date_time VARCHAR 0 0 0 40 leagues203642255,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 league_name VARCHAR 0 0 0 40 league_alias VARCHAR 0 0 0 40 caliber_key INTEGER 1 0 0 0 0 0 organization_key INTEGER 1 0 0 0 0 0 sport_key INTEGER 1 0 0 0 0 0 sports205823255,255,2550,0,00,0,0128,128,128192,192,1920 sport_key INTEGER 1 1 0 0 0 0 sport_name VARCHAR 0 0 0 40 sport_alias VARCHAR 0 0 0 40 conferences50593255,255,2550,0,00,0,0128,128,128192,192,1920 conference_key INTEGER 1 1 0 0 0 0 conference_name VARCHAR 0 0 0 40 league_key INTEGER 1 0 0 0 0 0 divisions124446255,255,2550,0,00,0,0128,128,128192,192,1920 division_key INTEGER 1 1 0 0 0 0 division_name VARCHAR 0 0 0 40 conference_key INTEGER 1 0 0 0 0 0 league_key INTEGER 1 0 0 0 0 0 sites725648255,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 site_name VARCHAR 0 0 0 40 site_country INTEGER 1 0 0 0 0 0 site_state_province INTEGER 1 0 0 0 0 0 site_city VARCHAR 0 0 0 40 site_postal_code VARCHAR 0 0 0 40 site_postal_code_extension VARCHAR 0 0 0 40 site_timezone VARCHAR 0 0 0 40 site_address_1 VARCHAR 0 0 0 40 site_address_2 VARCHAR 0 0 0 40 calibers70710255,255,2550,0,00,0,0128,128,128192,192,1920 caliber_key INTEGER 1 1 0 0 0 0 caliber_name VARCHAR 1 league_id? level_id? 0 0 40 injury_phases27886255,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 season_type VARCHAR 0 0 0 20 team_phases160254255,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_key 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 end_date_time VARCHAR 0 0 0 20 start_season_key INTEGER 1 0 0 0 0 0 start_season_type VARCHAR 0 0 0 20 end_season_key VARCHAR 0 0 0 40 end_season_type VARCHAR 0 0 0 40 height VARCHAR 0 0 0 40 weight VARCHAR 0 0 0 40 stats_baseball_offensive560908255,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_defensive382893255,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_pitching3841051255,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_phases26286255,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 end_date_time VARCHAR 0 0 0 20 start_season_key INTEGER 1 0 0 0 0 0 start_season_type VARCHAR 0 0 0 20 end_season_key VARCHAR 0 0 0 40 end_season_type VARCHAR 0 0 0 40 publishers410361255,255,2550,0,00,0,0128,128,128192,192,1920 id INTEGER 1 1 0 0 0 0 publisher_name VARCHAR 0 0 0 40 events_players530110255,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_subscores800310255,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_leagues573369255,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 season_id INTEGER 1 0 1 0 0 0 season_type VARCHAR 0 0 0 40 REL3 676 352 0 0 events events_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL4 550 474 0 0 teams events_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 team_key team_key 0 1 None None REL5 728 250 0 0 events weather_conditions 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 2 1 None None REL8 653 162 0 0 events events_players_subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL12 676 208 0 0 events event_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL15 250 786 0 0 sports leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 sport_key sport_key 0 1 None None REL16 175 647 0 0 leagues conferences 255,255,255 0,0,0 128,128,128 0,0,0 1 league_key league_key 0 1 None None REL17 130 549 0 0 conferences divisions 255,255,255 0,0,0 128,128,128 0,0,0 1 conference_key conference_key 0 1 None None REL18 225 574 0 0 leagues divisions 255,255,255 0,0,0 128,128,128 0,0,0 1 league_key league_key 0 1 None None REL19 558 648 0 0 sites teams 255,255,255 0,0,0 128,128,128 0,0,0 1 site_key home_site_key 0 1 None None REL20 257 494 0 0 divisions teams 255,255,255 0,0,0 128,128,128 0,0,0 1 division_key division_key 0 1 None None REL21 213 583 0 0 conferences teams 255,255,255 0,0,0 128,128,128 0,0,0 1 conference_key conference_key 0 1 None None REL11 175 712 0 0 calibers leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 caliber_key caliber_key 0 1 None None REL23 212 756 0 0 organizations leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 organization_key organization_key 0 1 None None REL28 273 445 0 0 teams team_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 team_key team_key 0 1 None None REL31 726 484 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 152 524 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 227 123 0 0 injury_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_injury_phase_id 0 1 None None REL36 293 284 0 0 publishers players 255,255,255 0,0,0 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL35 527 320 0 0 publishers events 255,255,255 0,0,0 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL37 152 240 0 0 players team_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL26 53 256 0 0 players league_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL34 227 163 0 0 players injury_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL38 186 240 0 0 team_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_team_phase_id 0 1 None None REL39 87 256 0 0 league_phases players 255,255,255 0,0,0 128,128,128 0,0,0 1 id current_league_phase_id 0 1 None None REL2 579 179 0 0 events events_players 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL7 353 107 0 0 players events_players 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL1 396 66 0 0 players events_players_subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 id player_id 0 1 None None REL6 725 312 0 0 events events_teams_subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL9 595 430 0 0 teams events_teams_subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 id team_id 0 1 None None REL10 622 522 0 0 publishers sites 255,255,255 0,0,0 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL13 259 959 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 260 1114 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 348 1051 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 303 621 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 343 701 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 368 519 0 0 publishers leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id publisher_id 0 1 None None REL40 373 429 0 0 seasons injury_phases 255,255,255 0,0,0 128,128,128 0,0,0 1 id season_id 0 1 None None REL22 596 345 0 0 events events_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL41 447 538 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 REL42 548 534 0 0 seasons events_leagues 255,255,255 0,0,0 128,128,128 0,0,0 1 id season_id 0 1 None None Legend 681 821 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 827 57 Event Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE3 239 918 Baseball Stats 255,255,255 0,0,0 128,128,128 0 1 NOTE11 303 18 Player Tables 255,255,255 0,0,0 128,128,128 0 1