XML Team 2005, XML Team Solutions MySQL3 2003-11-21 2005-04-14 Verdana,9,,0,1 206,231,255 0 0 1 1 (FK) Events Group 512 15 915 379 255,255,225 0,0,0 0,0,0 0 0 GROUPBOX2 223 885 703 1404 255,255,225 0,0,0 0,0,0 0 0 events535145255,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_key VARCHAR 0 0 0 40 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 season_key INTEGER 1 0 0 0 0 0 season_type VARCHAR 0 0 0 40 duration VARCHAR 0 0 0 20 attendance VARCHAR 0 0 0 20 event_weather809162255,255,2550,0,00,0,0128,128,128192,192,1920 event_id VARCHAR 0 0 0 20 event_key INTEGER 1 0 1 0 0 0 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 players3017255,255,2550,0,00,0,0128,128,128192,192,1920 player_key VARCHAR 1 1 0 20 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 teams278469255,255,2550,0,00,0,0128,128,128192,192,1920 team_key VARCHAR 1 1 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_key INTEGER 1 0 0 0 0 0 events_teams761279255,255,2550,0,00,0,0128,128,128192,192,1920 event_id VARCHAR 1 0 0 20 event_key INTEGER 1 0 1 0 0 0 team_key VARCHAR 1 0 0 20 alignment VARCHAR 0 0 0 20 score VARCHAR 0 0 0 20 events_players51838255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 0 0 0 0 0 event_key INTEGER 1 0 1 0 0 0 player_key VARCHAR 1 0 0 20 score VARCHAR 0 0 0 20 subscores699124255,255,2550,0,00,0,0128,128,128192,192,1920 event_id VARCHAR 0 0 0 40 event_key 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_affiliations64526255,255,2550,0,00,0,0128,128,128192,192,1920 event_id INTEGER 1 1 0 0 0 0 event_key VARCHAR 0 0 0 40 affiliation_type VARCHAR 0 team | division | conference | etc. 0 0 40 affiliation_key INTEGER 1 0 0 0 0 0 stats28936255,255,2550,0,00,0,0128,128,128192,192,1920 stat_key INTEGER 1 1 0 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 seasons378653255,255,2550,0,00,0,0128,128,128192,192,1920 season_key INTEGER 1 1 0 0 0 0 league_key INTEGER 1 0 0 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 leagues196653255,255,2550,0,00,0,0128,128,128192,192,1920 league_key INTEGER 1 1 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 divisions128481255,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 sites614483255,255,2550,0,00,0,0128,128,128192,192,1920 site_key INTEGER 1 1 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 player_injury_history303127255,255,2550,0,00,0,0128,128,128192,192,1920 player_key VARCHAR 1 0 0 20 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_key INTEGER 1 0 0 0 0 0 season_type VARCHAR 0 0 0 20 player_career_history135234255,255,2550,0,00,0,0128,128,128192,192,1920 player_key VARCHAR 1 0 0 20 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_offensive257901255,255,2550,0,00,0,0128,128,128192,192,1920 stat_key INTEGER 1 0 0 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_defensive467914255,255,2550,0,00,0,0128,128,128192,192,1920 stat_key INTEGER 1 0 0 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_pitching4691058255,255,2550,0,00,0,0128,128,128192,192,1920 stat_key INTEGER 1 0 0 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 REL1 550 121 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 REL3 695 292 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 576 421 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 719 200 0 0 events event_weather 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 2 1 None None REL8 664 154 0 0 events subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 id event_id 0 1 None None REL12 632 115 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 REL6 657 115 0 0 events event_affiliations 255,255,255 0,0,0 128,128,128 0,0,0 1 event_key event_key 0 1 None None REL7 719 227 0 0 events event_weather 255,255,255 0,0,0 128,128,128 0,0,0 1 event_key event_key 0 1 None None REL9 664 175 0 0 events subscores 255,255,255 0,0,0 128,128,128 0,0,0 1 event_key event_key 0 1 None None REL2 312 68 0 0 players events_players 255,255,255 0,0,0 128,128,128 0,0,0 1 player_key player_key 0 1 None None REL10 574 121 0 0 events events_players 255,255,255 0,0,0 128,128,128 0,0,0 1 event_key event_key 0 1 None None REL13 695 272 0 0 events events_teams 255,255,255 0,0,0 128,128,128 0,0,0 1 event_key event_key 0 1 None None REL14 346 695 0 0 leagues seasons 255,255,255 0,0,0 128,128,128 0,0,0 1 league_key league_key 0 1 None None REL15 257 780 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 172 653 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 132 567 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 220 597 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 502 549 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 259 510 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 579 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 REL27 305 621 0 0 leagues teams 255,255,255 0,0,0 128,128,128 0,0,0 1 league_key league_key 0 1 None None REL22 529 471 0 0 seasons events 255,255,255 0,0,0 128,128,128 0,0,0 1 season_key season_key 0 1 None None REL11 171 719 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 202 753 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 REL24 397 450 0 0 seasons player_injury_history 255,255,255 0,0,0 128,128,128 0,0,0 1 season_key season_key 0 1 None None REL25 205 154 0 0 players player_injury_history 255,255,255 0,0,0 128,128,128 0,0,0 1 player_key player_key 0 1 None None REL26 130 203 0 0 players player_career_history 255,255,255 0,0,0 128,128,128 0,0,0 1 player_key player_key 0 1 None None REL28 263 429 0 0 teams player_career_history 255,255,255 0,0,0 128,128,128 0,0,0 1 team_key team_key 0 1 None None REL29 197 1047 0 0 stats stats_baseball_offensive 255,255,255 0,0,0 128,128,128 0,0,0 1 stat_key stat_key 3 1 None None REL30 302 969 0 0 stats stats_baseball_defensive 255,255,255 0,0,0 128,128,128 0,0,0 1 stat_key stat_key 3 1 None None REL31 643 386 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 REL32 303 1117 0 0 stats stats_baseball_pitching 255,255,255 0,0,0 128,128,128 0,0,0 1 stat_key stat_key 3 1 None None Legend 209 4 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 815 53 Event Tables 255,255,255 0,0,0 128,128,128 0 1 NOTE3 621 890 Baseball Stats 255,255,255 0,0,0 128,128,128 0 1