| Title | XTOSS |
| Author | XML Team |
| Copyright | 2006, XML Team Solutions, Inc. |
| Version | 8 |
| DBMS | Created | Modified |
| MySQL3 | 2006-03-22 | 2006-03-22 |
| Comments |
| Domains | |||
| Name | Datatype | Default | Comment |
| primary_id | INTEGER | ||
| addresses | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| location_id | INTEGER | NO | YES | ||
| language | VARCHAR(40) | NO | NO | ||
| suite | VARCHAR(40) | NO | NO | ||
| floor | VARCHAR(40) | NO | NO | ||
| building | VARCHAR(40) | NO | NO | ||
| street_number | VARCHAR(40) | NO | NO | ||
| street_prefix | VARCHAR(40) | NO | NO | ||
| street | VARCHAR(40) | NO | NO | ||
| street_suffix | VARCHAR(40) | NO | NO | ||
| neighborhood | VARCHAR(40) | NO | NO | ||
| district | VARCHAR(40) | NO | NO | ||
| locality | VARCHAR(40) | NO | NO | ||
| county | VARCHAR(40) | NO | NO | ||
| region | VARCHAR(40) | NO | NO | ||
| postal_code | VARCHAR(40) | NO | NO | ||
| country | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| affiliations | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| affiliation_key | VARCHAR(40) | NO | YES | ||
| name | VARCHAR(40) | NO | NO | ||
| alias | VARCHAR(40) | NO | NO | ||
| abbreviation | VARCHAR(40) | NO | NO | ||
| tier | VARCHAR(40) | NO | NO | division | conference | caliber | organization | sport | |
| parent_id | INTEGER | NO | NO | ||
| start_season_id | VARCHAR(40) | NO | NO | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| end_season_id | VARCHAR(40) | NO | NO | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| affiliations_documents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| affiliation_id | INTEGER | YES | YES | ||
| document_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| affiliations_events | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| affiliation_id | INTEGER | YES | YES | ||
| event_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| affiliations_media | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| affiliation_id | INTEGER | NO | YES | ||
| media_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| affiliations_teams | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| affiliation_id | INTEGER | YES | YES | ||
| team_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_action_play_participants | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| play_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| role | VARCHAR(40) | NO | YES | ||
| score_type | VARCHAR(40) | NO | NO | ||
| field_line | INTEGER | NO | NO | ||
| yardage | INTEGER | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_action_plays | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| american_football_event_state_id | INTEGER | NO | YES | ||
| sequence_number | INTEGER | NO | NO | ||
| play_type | VARCHAR(40) | NO | NO | ||
| score_attempt_type | VARCHAR(40) | NO | NO | ||
| drive_result | VARCHAR(40) | NO | NO | ||
| points | INTEGER | NO | NO | ||
| comment | VARCHAR(255) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_defensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| tackles_total | VARCHAR(40) | NO | NO | ||
| tackles_solo | VARCHAR(40) | NO | NO | ||
| tackles_assists | VARCHAR(40) | NO | NO | ||
| interceptions_total | VARCHAR(40) | NO | NO | ||
| interceptions_yards | VARCHAR(40) | NO | NO | ||
| interceptions_average | VARCHAR(40) | NO | NO | ||
| interceptions_longest | VARCHAR(40) | NO | NO | ||
| interceptions_touchdown | VARCHAR(40) | NO | NO | ||
| quarterback_hurries | VARCHAR(40) | NO | NO | ||
| sacks_total | VARCHAR(40) | NO | NO | ||
| sacks_yards | VARCHAR(40) | NO | NO | ||
| passes_defensed | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_down_progress_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| first_downs_total | VARCHAR(40) | NO | NO | ||
| first_downs_pass | VARCHAR(40) | NO | NO | ||
| first_downs_run | VARCHAR(40) | NO | NO | ||
| first_downs_penalty | VARCHAR(40) | NO | NO | ||
| conversions_third_down | VARCHAR(40) | NO | NO | ||
| conversions_third_down_attempts | VARCHAR(40) | NO | NO | ||
| conversions_third_down_percentage | VARCHAR(40) | NO | NO | ||
| conversions_fourth_down | VARCHAR(40) | NO | NO | ||
| conversions_fourth_down_attempts | VARCHAR(40) | NO | NO | ||
| conversions_fourth_down_percentage | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_event_states | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| chronology | VARCHAR(40) | NO | YES | current | historic | |
| event_id | INTEGER | NO | YES | ||
| publisher_key | VARCHAR(40) | NO | YES | ||
| period_value | INTEGER | NO | NO | ||
| period_time_elapsed | VARCHAR(40) | NO | NO | ||
| period_time_remaining | VARCHAR(40) | NO | NO | ||
| clock_state | VARCHAR(40) | NO | NO | ||
| down | INTEGER | NO | NO | ||
| team_in_possession_id | INTEGER | NO | NO | ||
| distance_for_1st_down | INTEGER | NO | NO | ||
| field_side | VARCHAR(40) | NO | NO | home | away | |
| field_line | INTEGER | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_fumbles_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| fumbles_committed | VARCHAR(40) | NO | NO | ||
| fumbles_forced | VARCHAR(40) | NO | NO | ||
| fumbles_recovered | VARCHAR(40) | NO | NO | ||
| fumbles_lost | VARCHAR(40) | NO | NO | ||
| fumbles_yards_gained | VARCHAR(40) | NO | NO | ||
| fumbles_own_committed | VARCHAR(40) | NO | NO | ||
| fumbles_own_recovered | VARCHAR(40) | NO | NO | ||
| fumbles_own_lost | VARCHAR(40) | NO | NO | ||
| fumbles_own_yards_gained | VARCHAR(40) | NO | NO | ||
| fumbles_opposing_committed | VARCHAR(40) | NO | NO | ||
| fumbles_opposing_recovered | VARCHAR(40) | NO | NO | ||
| fumbles_opposing_lost | VARCHAR(40) | NO | NO | ||
| fumbles_opposing_yards_gained | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_offensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| offensive_plays_yards | VARCHAR(40) | NO | NO | ||
| offensive_plays_number | VARCHAR(40) | NO | NO | ||
| offensive_plays_average_yards_per | VARCHAR(40) | NO | NO | ||
| possession_duration | VARCHAR(40) | NO | NO | ||
| turnovers_giveaway | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_passing_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| passes_attempts | VARCHAR(40) | NO | NO | ||
| passes_completions | VARCHAR(40) | NO | NO | ||
| passes_percentage | VARCHAR(40) | NO | NO | ||
| passes_yards_gross | VARCHAR(40) | NO | NO | ||
| passes_yards_net | VARCHAR(40) | NO | NO | ||
| passes_yards_lost | VARCHAR(40) | NO | NO | ||
| passes_touchdowns | VARCHAR(40) | NO | NO | ||
| passes_touchdowns_percentage | VARCHAR(40) | NO | NO | ||
| passes_interceptions | VARCHAR(40) | NO | NO | ||
| passes_interceptions_percentage | VARCHAR(40) | NO | NO | ||
| passes_longest | VARCHAR(40) | NO | NO | ||
| passes_average_yards_per | VARCHAR(40) | NO | NO | ||
| passer_rating | VARCHAR(40) | NO | NO | ||
| receptions_total | VARCHAR(40) | NO | NO | ||
| receptions_yards | VARCHAR(40) | NO | NO | ||
| receptions_touchdowns | VARCHAR(40) | NO | NO | ||
| receptions_first_down | VARCHAR(40) | NO | NO | ||
| receptions_longest | VARCHAR(40) | NO | NO | ||
| receptions_average_yards_per | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_penalties_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| penalties_total | VARCHAR(40) | NO | NO | ||
| penalty_yards | VARCHAR(40) | NO | NO | ||
| penalty_first_downs | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_rushing_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| rushes_attempts | VARCHAR(40) | NO | NO | ||
| rushes_yards | VARCHAR(40) | NO | NO | ||
| rushes_touchdowns | VARCHAR(40) | NO | NO | ||
| rushing_average_yards_per | VARCHAR(40) | NO | NO | ||
| rushes_first_down | VARCHAR(40) | NO | NO | ||
| rushes_longest | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_sacks_against_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| sacks_against_yards | VARCHAR(40) | NO | NO | ||
| sacks_against_total | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_scoring_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| touchdowns_total | VARCHAR(40) | NO | NO | ||
| touchdowns_passing | VARCHAR(40) | NO | NO | ||
| touchdowns_rushing | VARCHAR(40) | NO | NO | ||
| touchdowns_special_teams | VARCHAR(40) | NO | NO | ||
| touchdowns_defensive | VARCHAR(40) | NO | NO | ||
| extra_points_attempts | VARCHAR(40) | NO | NO | ||
| extra_points_made | VARCHAR(40) | NO | NO | ||
| extra_points_missed | VARCHAR(40) | NO | NO | ||
| extra_points_blocked | VARCHAR(40) | NO | NO | ||
| field_goal_attempts | VARCHAR(40) | NO | NO | ||
| field_goals_made | VARCHAR(40) | NO | NO | ||
| field_goals_missed | VARCHAR(40) | NO | NO | ||
| field_goals_blocked | VARCHAR(40) | NO | NO | ||
| safeties_against | VARCHAR(40) | NO | NO | ||
| two_point_conversions_attempts | VARCHAR(40) | NO | NO | ||
| two_point_conversions_made | VARCHAR(40) | NO | NO | ||
| touchbacks_total | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| american_football_special_teams_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| returns_punt_total | VARCHAR(40) | NO | NO | ||
| returns_punt_yards | VARCHAR(40) | NO | NO | ||
| returns_punt_average | VARCHAR(40) | NO | NO | ||
| returns_punt_longest | VARCHAR(40) | NO | NO | ||
| returns_punt_touchdown | VARCHAR(40) | NO | NO | ||
| returns_kickoff_total | VARCHAR(40) | NO | NO | ||
| returns_kickoff_yards | VARCHAR(40) | NO | NO | ||
| returns_kickoff_average | VARCHAR(40) | NO | NO | ||
| returns_kickoff_longest | VARCHAR(40) | NO | NO | ||
| returns_kickoff_touchdown | VARCHAR(40) | NO | NO | ||
| returns_total | VARCHAR(40) | NO | NO | ||
| returns_yards | VARCHAR(40) | NO | NO | ||
| punts_total | VARCHAR(40) | NO | NO | ||
| punts_yards_gross | VARCHAR(40) | NO | NO | ||
| punts_yards_net | VARCHAR(40) | NO | NO | ||
| punts_longest | VARCHAR(40) | NO | NO | ||
| punts_inside_20 | VARCHAR(40) | NO | NO | ||
| punts_inside_20_percentage | VARCHAR(40) | NO | NO | ||
| punts_average | VARCHAR(40) | NO | NO | ||
| punts_blocked | VARCHAR(40) | NO | NO | ||
| touchbacks_total | VARCHAR(40) | NO | NO | ||
| touchbacks_total_percentage | VARCHAR(40) | NO | NO | ||
| touchbacks_kickoffs | VARCHAR(40) | NO | NO | ||
| touchbacks_kickoffs_percentage | VARCHAR(40) | NO | NO | ||
| touchbacks_punts | VARCHAR(40) | NO | NO | ||
| touchbacks_punts_percentage | VARCHAR(40) | NO | NO | ||
| touchbacks_interceptions | VARCHAR(40) | NO | NO | ||
| touchbacks_interceptions_percentage | VARCHAR(40) | NO | NO | ||
| fair_catches | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| baseball_action_contact_details | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| baseball_action_pitch_id | INTEGER | NO | YES | ||
| location | VARCHAR(40) | NO | NO | ||
| strength | VARCHAR(40) | NO | NO | hard | soft | grounder | etc. | |
| velocity | INTEGER | NO | NO | ||
| comment | TEXT | NO | NO | ||
| trajectory_coordinates | VARCHAR(40) | NO | NO | yaml array of coordinates? | |
| trajectory_formula | VARCHAR(40) | NO | NO | formula describing this path | |
| Index name | Type | Sorting | Primary | Attributes |
| baseball_action_pitches | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| sequence_number | INTEGER | NO | NO | ||
| baseball_action_play_id | INTEGER | NO | NO | ||
| umpire_call | VARCHAR(40) | NO | NO | ||
| pitch_location | VARCHAR(40) | NO | NO | ||
| pitch_type | VARCHAR(40) | NO | NO | ||
| pitch_velocity | INTEGER | NO | NO | ||
| comment | TEXT | NO | NO | ||
| trajectory_coordinates | VARCHAR(40) | NO | NO | yaml array of coordinates? | |
| trajectory_formula | VARCHAR(40) | NO | NO | formula describing this path | |
| Index name | Type | Sorting | Primary | Attributes |
| baseball_action_plays | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| baseball_event_state_id | INTEGER | NO | NO | ||
| sequence_number | INTEGER | NO | NO | ||
| play_type | VARCHAR(40) | NO | NO | ||
| notation | VARCHAR(40) | NO | NO | ||
| notation_yaml | TEXT | NO | NO | ||
| comment | VARCHAR(255) | NO | NO | ||
| runner_on_first_advance | INTEGER | NO | NO | ||
| runner_on_second_advance | INTEGER | NO | NO | ||
| runner_on_third_advance | INTEGER | NO | NO | ||
| outs_recorded | INTEGER | NO | NO | ||
| rbi | INTEGER | NO | NO | ||
| runs_scored | INTEGER | NO | NO | ||
| earned_runs_scored | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| baseball_action_substitutions | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| baseball_event_state_id | INTEGER | NO | NO | ||
| sequence_number | INTEGER | NO | NO | ||
| person_type | VARCHAR(40) | NO | NO | person | associate | official | |
| person_original_id | INTEGER | NO | NO | ||
| person_original_position_id | INTEGER | NO | NO | ||
| person_original_lineup_slot | INTEGER | NO | NO | ||
| person_replacing_id | INTEGER | NO | NO | ||
| person_replacing_position_id | INTEGER | NO | NO | ||
| person_replacing_lineup_slot | INTEGER | NO | NO | ||
| substitution_reason | VARCHAR(255) | NO | NO | ||
| comment | VARCHAR(255) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| baseball_defensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| double_plays | VARCHAR(40) | NO | NO | ||
| triple_plays | VARCHAR(40) | NO | NO | ||
| putouts | VARCHAR(40) | NO | NO | ||
| assists | VARCHAR(40) | NO | NO | ||
| errors | VARCHAR(40) | NO | NO | ||
| fielding_percentage | VARCHAR(40) | NO | NO | ||
| defensive_average | VARCHAR(40) | NO | NO | ||
| errors_passed_ball | VARCHAR(40) | NO | NO | ||
| errors_catchers_interference | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| baseball_event_states | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| chronology | VARCHAR(40) | NO | YES | current | historic | |
| event_id | INTEGER | NO | YES | ||
| publisher_id | VARCHAR(40) | NO | YES | change to FK for publishers table | |
| inning_value | INTEGER | NO | NO | ||
| inning_half | VARCHAR(40) | NO | NO | top | bottom | |
| outs | INTEGER | NO | NO | ||
| balls | INTEGER | NO | NO | ||
| strikes | INTEGER | NO | NO | ||
| runner_on_first_id | INTEGER | NO | NO | ||
| runner_on_second_id | INTEGER | NO | NO | ||
| runner_on_third_id | INTEGER | NO | NO | ||
| runs_this_inning_half | INTEGER | NO | NO | ||
| pitcher_id | INTEGER | NO | NO | ||
| batter_id | INTEGER | NO | NO | ||
| batter_side | VARCHAR(40) | NO | NO | left | right | |
| Index name | Type | Sorting | Primary | Attributes |
| baseball_offensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| average | VARCHAR(40) | NO | NO | ||
| runs_scored | VARCHAR(40) | NO | NO | ||
| at_bats | VARCHAR(40) | NO | NO | ||
| hits | VARCHAR(40) | NO | NO | ||
| rbi | VARCHAR(40) | NO | NO | ||
| total_bases | VARCHAR(40) | NO | NO | ||
| slugging_percentage | VARCHAR(40) | NO | NO | ||
| bases_on_balls | VARCHAR(40) | NO | NO | ||
| strikeouts | VARCHAR(40) | NO | NO | ||
| left_on_base | VARCHAR(40) | NO | NO | ||
| left_in_scoring_position | VARCHAR(40) | NO | NO | ||
| singles | VARCHAR(40) | NO | NO | ||
| doubles | VARCHAR(40) | NO | NO | ||
| triples | VARCHAR(40) | NO | NO | ||
| home_runs | VARCHAR(40) | NO | NO | ||
| grand_slams | VARCHAR(40) | NO | NO | ||
| at_bats_per_rbi | VARCHAR(40) | NO | NO | ||
| plate_appearances_per_rbi | VARCHAR(40) | NO | NO | ||
| at_bats_per_home_run | VARCHAR(40) | NO | NO | ||
| plate_appearances_per_home_run | VARCHAR(40) | NO | NO | ||
| sac_flies | VARCHAR(40) | NO | NO | ||
| sac_bunts | VARCHAR(40) | NO | NO | ||
| grounded_into_double_play | VARCHAR(40) | NO | NO | ||
| moved_up | VARCHAR(40) | NO | NO | ||
| on_base_percentage | VARCHAR(40) | NO | NO | ||
| stolen_bases | VARCHAR(40) | NO | NO | ||
| stolen_bases_caught | VARCHAR(40) | NO | NO | ||
| stolen_bases_average | VARCHAR(40) | NO | NO | ||
| hit_by_pitch | VARCHAR(40) | NO | NO | ||
| defensive_interferance_reaches | VARCHAR(40) | NO | NO | ||
| on_base_plus_slugging | VARCHAR(40) | NO | NO | ||
| plate_appearances | VARCHAR(40) | NO | NO | ||
| hits_extra_base | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| baseball_pitching_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| runs_allowed | VARCHAR(40) | NO | NO | ||
| home_runs_allowed | VARCHAR(40) | NO | NO | ||
| innings_pitched | VARCHAR(40) | NO | NO | ||
| hits | VARCHAR(40) | NO | NO | ||
| earned_runs | VARCHAR(40) | NO | NO | ||
| unearned_runs | VARCHAR(40) | NO | NO | ||
| bases_on_balls | VARCHAR(40) | NO | NO | ||
| bases_on_balls_intentional | VARCHAR(40) | NO | NO | ||
| strikeouts | VARCHAR(40) | NO | NO | ||
| strikeout_to_bb_ratio | VARCHAR(40) | NO | NO | ||
| number_of_pitches | VARCHAR(40) | NO | NO | ||
| era | VARCHAR(40) | NO | NO | ||
| inherited_runners_scored | VARCHAR(40) | NO | NO | ||
| pick_offs | VARCHAR(40) | NO | NO | ||
| errors_hit_with_pitch | VARCHAR(40) | NO | NO | ||
| errors_wild_pitch | VARCHAR(40) | NO | NO | ||
| balks | VARCHAR(40) | NO | NO | ||
| wins | VARCHAR(40) | NO | NO | ||
| losses | VARCHAR(40) | NO | NO | ||
| saves | VARCHAR(40) | NO | NO | ||
| shutouts | VARCHAR(40) | NO | NO | ||
| games_complete | VARCHAR(40) | NO | NO | ||
| games_finished | VARCHAR(40) | NO | NO | ||
| winning_percentage | VARCHAR(40) | NO | NO | ||
| event_credit | VARCHAR(40) | NO | NO | ||
| save_credit | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| basketball_defensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| steals_total | CHAR(20) | NO | NO | ||
| steals_per_game | CHAR(20) | NO | NO | ||
| blocks_total | CHAR(20) | NO | NO | ||
| blocks_per_game | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| basketball_event_states | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(100) | YES | YES | ||
| chronology | CHAR(20) | NO | NO | ||
| event_id | CHAR(100) | NO | NO | ||
| publisher_key | CHAR(40) | NO | NO | ||
| period_value | CHAR(20) | NO | NO | ||
| period_time_elapsed | CHAR(20) | NO | NO | ||
| period_time_remaining | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| basketball_offensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| field_goals_made | INTEGER | NO | NO | ||
| field_goals_attempted | INTEGER | NO | NO | ||
| field_goals_percentage | VARCHAR(40) | NO | NO | ||
| field_goals_per_game | VARCHAR(40) | NO | NO | ||
| field_goals_attempted_per_game | VARCHAR(40) | NO | NO | ||
| field_goals_percentage_adjusted | VARCHAR(40) | NO | NO | ||
| three_pointers_made | INTEGER | NO | NO | ||
| three_pointers_attempted | INTEGER | NO | NO | ||
| three_pointers_percentage | VARCHAR(40) | NO | NO | ||
| three_pointers_per_game | CHAR(20) | NO | NO | ||
| three_pointers_attempted_per_game | CHAR(20) | NO | NO | ||
| free_throws_made | CHAR(20) | NO | NO | ||
| free_throws_attempted | CHAR(20) | NO | NO | ||
| free_throws_percentage | CHAR(20) | NO | NO | ||
| free_throws_per_game | CHAR(20) | NO | NO | ||
| free_throws_attempted_per_game | CHAR(20) | NO | NO | ||
| points_scored_total | CHAR(20) | NO | NO | ||
| points_scored_per_game | CHAR(20) | NO | NO | ||
| assists_total | CHAR(20) | NO | NO | ||
| assists_per_game | CHAR(20) | NO | NO | ||
| turnovers_total | CHAR(20) | NO | NO | ||
| turnovers_per_game | CHAR(20) | NO | NO | ||
| points_scored_off_turnovers | CHAR(20) | NO | NO | ||
| points_scored_in_paint | CHAR(20) | NO | NO | ||
| points_scored_on_second_chance | CHAR(20) | NO | NO | ||
| points_scored_on_fast_break | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| basketball_rebounding_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| rebounds_total | CHAR(20) | NO | NO | ||
| rebounds_per_game | CHAR(20) | NO | NO | ||
| rebounds_defensive | CHAR(20) | NO | NO | ||
| rebounds_offensive | CHAR(20) | NO | NO | ||
| team_rebounds_total | CHAR(20) | NO | NO | ||
| team_rebounds_per_game | CHAR(20) | NO | NO | ||
| team_rebounds_defensive | CHAR(20) | NO | NO | ||
| team_rebounds_offensive | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| core_person_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| time_played | INTEGER | NO | NO | in seconds | |
| events_played | INTEGER | NO | NO | ||
| events_started | INTEGER | NO | NO | ||
| position_id | INTEGER | NO | NO | optional id, which allows one to record how long the person was at this position | |
| Index name | Type | Sorting | Primary | Attributes |
| core_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| score | VARCHAR(40) | NO | NO | ||
| score_opposing | VARCHAR(40) | NO | NO | ||
| score_attempts | VARCHAR(40) | NO | NO | ||
| score_attempts_opposing | VARCHAR(40) | NO | NO | ||
| score_percentage | VARCHAR(40) | NO | NO | ||
| score_percentage_opposing | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| document_classes | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| name | VARCHAR(40) | NO | NO | person | team | league | etc. | |
| Index name | Type | Sorting | Primary | Attributes |
| document_contents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| document_id | VARCHAR(40) | NO | YES | ||
| sportsml | MEDIUMTEXT | NO | NO | ||
| abstract | TEXT | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| document_fixtures | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per fixture_key + publisher_id | |
| fixture_key | VARCHAR(40) | NO | NO | ||
| publisher_id | INTEGER | NO | YES | ||
| name | VARCHAR(40) | NO | NO | person | team | league | etc. | |
| document_class_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| document_fixtures_events | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| document_fixture_id | INTEGER | NO | YES | ||
| event_id | INTEGER | NO | YES | ||
| latest_document_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| document_package_entry | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| document_package_id | VARCHAR(40) | NO | NO | ||
| rank | VARCHAR(40) | NO | NO | ||
| document_id | VARCHAR(40) | NO | NO | ||
| headline | VARCHAR(40) | NO | NO | ||
| short_headline | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| document_packages | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| package_key | VARCHAR(40) | NO | NO | eg, top-news-nba | |
| package_name | VARCHAR(40) | NO | NO | eg, "Top NBA News" | |
| date_time | DATETIME | NO | NO | time this package was originally published | |
| Index name | Type | Sorting | Primary | Attributes |
| documents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| doc_id | VARCHAR(40) | NO | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| date_time | DATETIME | NO | NO | Timestamp for when this document was originally published. | |
| title | VARCHAR(40) | NO | NO | person | team | league | etc. | |
| language | VARCHAR(40) | NO | NO | ||
| priority | VARCHAR(40) | NO | NO | event | sub_season | league_phase | lifetime | |
| revision_id | VARCHAR(40) | NO | NO | ||
| stats_coverage | VARCHAR(40) | NO | NO | ||
| document_fixture_id | INTEGER | NO | YES | ||
| source_id | INTEGER | NO | NO | An alternative publisher_id for "republishers" of information. | |
| db_loading_date_time | VARCHAR(40) | NO | NO | Timestamp for when this document was loaded into the DB. | |
| Index name | Type | Sorting | Primary | Attributes |
| documents_media | |||||
| identifies the relationship between a document and its zero-or-more Media Objects | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| document_id | VARCHAR(40) | NO | NO | ||
| media_id | VARCHAR(40) | NO | NO | ||
| media_caption_id | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| events | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| event_key | VARCHAR(40) | NO | NO | ||
| name | VARCHAR(80) | NO | NO | ||
| publisher_id | INTEGER | NO | YES | ||
| start_date_time | DATETIME | NO | NO | Normalized to UTC | |
| site_id | INTEGER | NO | YES | ||
| site_alignment | VARCHAR(40) | NO | NO | ||
| event_status | VARCHAR(40) | NO | NO | ||
| duration | VARCHAR(40) | NO | NO | ||
| attendance | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| events_documents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| event_id | INTEGER | NO | YES | ||
| document_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| events_media | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| event_id | INTEGER | NO | YES | ||
| media_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| events_sub_seasons | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| event_id | INTEGER | YES | YES | ||
| sub_season_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| ice_hockey_defensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(255) | NO | YES | ||
| shots_power_play_allowed | CHAR(20) | NO | NO | ||
| shots_penalty_shot_allowed | CHAR(20) | NO | NO | ||
| goals_power_play_allowed | CHAR(20) | NO | NO | ||
| goals_penalty_shot_allowed | CHAR(20) | NO | NO | ||
| goals_against_average | CHAR(20) | NO | NO | ||
| saves | CHAR(20) | NO | NO | ||
| save_percentage | CHAR(20) | NO | NO | ||
| penalty_killing_amount | CHAR(20) | NO | NO | ||
| penalty_killing_percentage | CHAR(20) | NO | NO | ||
| shots_blocked | CHAR(20) | NO | NO | ||
| takeaways | CHAR(20) | NO | NO | ||
| shutouts | CHAR(20) | NO | NO | ||
| minutes_penalty_killing | CHAR(20) | NO | NO | ||
| hits | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| ice_hockey_event_states | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(100) | YES | YES | ||
| chronology | CHAR(20) | NO | NO | ||
| event_id | CHAR(100) | NO | NO | ||
| publisher_key | CHAR(40) | NO | NO | ||
| period_value | CHAR(20) | NO | NO | ||
| period_time_elapsed | CHAR(20) | NO | NO | ||
| period_time_remaining | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| ice_hockey_offensive_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(255) | NO | YES | ||
| goals_game_winning | CHAR(20) | NO | NO | ||
| goals_game_tying | CHAR(20) | NO | NO | ||
| goals_power_play | CHAR(20) | NO | NO | ||
| goals_short_handed | CHAR(20) | NO | NO | ||
| goals_even_strength | CHAR(20) | NO | NO | ||
| goals_empty_net | CHAR(20) | NO | NO | ||
| goals_overtime | CHAR(20) | NO | NO | ||
| goals_shootout | CHAR(20) | NO | NO | ||
| goals_penalty_shot | CHAR(20) | NO | NO | ||
| assists | CHAR(20) | NO | NO | ||
| points | CHAR(20) | NO | NO | ||
| power_play_amount | CHAR(20) | NO | NO | ||
| power_play_percentage | CHAR(20) | NO | NO | ||
| shots_penalty_shot_taken | CHAR(20) | NO | NO | ||
| shots_penalty_shot_missed | CHAR(20) | NO | NO | ||
| shots_penalty_shot_percentage | CHAR(20) | NO | NO | ||
| giveaways | CHAR(20) | NO | NO | ||
| minutes_power_play | CHAR(20) | NO | NO | ||
| faceoff_wins | CHAR(20) | NO | NO | ||
| faceoff_losses | CHAR(20) | NO | NO | ||
| faceoff_win_percentage | CHAR(20) | NO | NO | ||
| scoring_chances | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| injury_phases | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| person_id | INTEGER | NO | YES | ||
| injury_status | VARCHAR(40) | NO | NO | ||
| injury_type | VARCHAR(40) | NO | NO | ||
| injury_comment | VARCHAR(40) | NO | NO | ||
| disabled_list | VARCHAR(40) | NO | NO | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| season_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| key_aliases | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| key_type | VARCHAR(40) | NO | NO | person | team | league | etc. | |
| key_value | VARCHAR(40) | NO | NO | A person_key, team_key, etc. | |
| id_value | INTEGER | NO | NO | A person_id, team_id, etc. | |
| common_key | VARCHAR(40) | NO | NO | Locally generated key that is the same for all rows that are aliases for the same thing. | |
| Index name | Type | Sorting | Primary | Attributes |
| latest_revisions | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| revision_id | INTEGER | NO | YES | ||
| latest_document_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| locations | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| timezone | VARCHAR(40) | NO | NO | In tz format, see: http://www.twinsun.com/tz/tz-link.htm | |
| latitude | VARCHAR(40) | NO | NO | ||
| longitude | VARCHAR(40) | NO | NO | ||
| country_code | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| media | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| object_id | VARCHAR(40) | NO | NO | parallel to the doc_id... the original unique ID provided by the publisher | |
| source_id | VARCHAR(40) | NO | NO | an ID that was used upstream from the current publisher's object_id | |
| revision_id | VARCHAR(40) | NO | NO | ||
| type | VARCHAR(40) | NO | NO | photo | audio | video | |
| publisher_id | VARCHAR(40) | NO | NO | ||
| date_time | VARCHAR(40) | NO | NO | ||
| credit_id | VARCHAR(40) | NO | NO | ||
| db_loading_date_time | VARCHAR(40) | NO | NO | ||
| creation_location_id | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| media_captions | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| media_id | VARCHAR(40) | NO | NO | ||
| caption_type | VARCHAR(40) | NO | NO | main | headline | name, to give three common examples, from longest to shortest length | |
| caption | VARCHAR(40) | NO | NO | ||
| caption_author_id | VARCHAR(40) | NO | NO | ||
| language | VARCHAR(40) | NO | NO | ||
| size | VARCHAR(40) | NO | NO | size of caption, in characters | |
| Index name | Type | Sorting | Primary | Attributes |
| media_contents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| media_id | VARCHAR(40) | NO | NO | ||
| object | VARCHAR(40) | NO | NO | ||
| format | VARCHAR(40) | NO | NO | ||
| mime_type | VARCHAR(40) | NO | NO | ||
| height | VARCHAR(40) | NO | NO | ||
| width | VARCHAR(40) | NO | NO | ||
| duration | VARCHAR(40) | NO | NO | ||
| size | VARCHAR(40) | NO | NO | ||
| resolution | VARCHAR(40) | NO | NO | main | thumbnail | low-bandwidth | high-bandwidth | |
| Index name | Type | Sorting | Primary | Attributes |
| media_keywords | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| keyword | VARCHAR(40) | NO | NO | ||
| media_id | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| outcome_totals | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| standing_subgroup_id | VARCHAR(40) | NO | NO | ||
| outcome_holder_type | VARCHAR(40) | NO | NO | team | player | etc | |
| outcome_holder_id | VARCHAR(40) | NO | NO | the team_id or player_id or etc | |
| rank | VARCHAR(40) | NO | NO | ||
| wins | VARCHAR(40) | NO | NO | ||
| losses | VARCHAR(40) | NO | NO | ||
| ties | VARCHAR(40) | NO | NO | ||
| undecideds | VARCHAR(40) | NO | NO | ||
| winning_percentage | VARCHAR(40) | NO | NO | ||
| points_scored_for | VARCHAR(40) | NO | NO | ||
| points_scored_against | VARCHAR(40) | NO | NO | ||
| points_difference | VARCHAR(40) | NO | NO | games back, for baseball | |
| standing_points | VARCHAR(40) | NO | NO | ||
| streak_type | VARCHAR(40) | NO | NO | win | loss | tie | score | assist | point | |
| streak_duration | VARCHAR(40) | NO | NO | number of days | |
| streak_total | VARCHAR(40) | NO | NO | number of games | |
| streak_start | DATE | NO | NO | ||
| streak_end | DATE | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| participants_events | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| participant_id | VARCHAR(40) | NO | NO | ||
| participant_type | VARCHAR(40) | NO | NO | ||
| event_id | VARCHAR(40) | NO | NO | ||
| alignment | VARCHAR(40) | NO | NO | ||
| score | VARCHAR(40) | NO | NO | ||
| event_outcome | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| periods | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| participant_event_id | VARCHAR(40) | NO | NO | ||
| value | VARCHAR(40) | NO | NO | ||
| score | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| person_event_metadata | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| status | VARCHAR(40) | NO | NO | benched | started | played | scratched | |
| weight | VARCHAR(40) | NO | NO | ||
| role_id | INTEGER | NO | YES | ||
| position_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| person_league_phases | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| person_id | INTEGER | NO | YES | ||
| league_id | INTEGER | NO | YES | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| start_season_id | INTEGER | NO | YES | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| end_season_id | INTEGER | NO | YES | ||
| role | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| person_names | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per person_key + publisher_id | |
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| language | VARCHAR(40) | NO | NO | en-us for example | |
| given_name | VARCHAR(40) | NO | NO | ||
| middle_name | VARCHAR(40) | NO | NO | ||
| family_name | VARCHAR(40) | NO | NO | ||
| nickname | VARCHAR(40) | NO | NO | ||
| full_name | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| persons | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per person_key + publisher_id | |
| person_key | VARCHAR(40) | NO | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| gender | VARCHAR(40) | NO | NO | ||
| default_person_name_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| current_injury_phase_id | INTEGER | NO | NO | ||
| current_team_phase_id | INTEGER | NO | NO | ||
| current_league_phase_id | INTEGER | NO | NO | ||
| birth_date | VARCHAR(40) | NO | NO | ||
| death_date | VARCHAR(40) | NO | NO | ||
| birth_location_id | INTEGER | NO | NO | ||
| hometown_location_id | INTEGER | NO | NO | ||
| residence_location_id | INTEGER | NO | NO | ||
| death_location_id | INTEGER | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| persons_documents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| person_id | INTEGER | YES | YES | ||
| document_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| persons_media | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| media_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| positions | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| affiliation_id | INTEGER | NO | YES | ||
| abbreviation | VARCHAR(20) | NO | YES | ||
| name | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| publishers | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| publisher_key | VARCHAR(40) | NO | YES | ||
| publisher_name | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| roles | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| role_key | VARCHAR(40) | NO | YES | player | coach | manager | owner| umpire | etc. | |
| role_name | VARCHAR(40) | NO | NO | Display name for the key | |
| comment | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| seasons | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per season_key + publisher_id | |
| season_key | INTEGER | NO | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| league_id | INTEGER | NO | YES | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| sites | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| site_key | INTEGER | NO | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| name | VARCHAR(40) | NO | NO | ||
| alias | VARCHAR(40) | NO | NO | ||
| location_id | INTEGER | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| standing_subgroups | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| standing_id | VARCHAR(40) | NO | NO | ||
| affiliation_id | VARCHAR(40) | NO | NO | id for, say, American League East division | |
| Index name | Type | Sorting | Primary | Attributes |
| standings | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | INTEGER | YES | YES | ||
| affiliation_id | VARCHAR(40) | NO | NO | eg, ID for league-key | |
| type | VARCHAR(40) | NO | NO | division | conference | playoffs | wild-card | etc. | |
| sub_season_id | VARCHAR(40) | NO | NO | ||
| last_updated | VARCHAR(40) | NO | NO | date timestamp that these standings were last updated | |
| duration_scope | VARCHAR(40) | NO | NO | regulation | overtime | etc. Indicates class of events included statistics apply to. | |
| competition_scope | VARCHAR(40) | NO | NO | 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 | |
| competition_scope_id | VARCHAR(40) | NO | NO | a team_id, a position_id, a division_id, etc. The ID for kind of competition standing is limited to | |
| alignment_scope | VARCHAR(40) | NO | NO | all | home | away | etc. Indicates that the included statistics apply only to events played either at home or away | |
| site_scope | VARCHAR(40) | NO | NO | all | indoors | outdoors | carpet | clay | etc. | |
| scoping_label | VARCHAR(40) | NO | NO | A textual description for the scope (when all else fails...) | |
| publisher_id | INTEGER | NO | YES | ||
| source | VARCHAR(40) | NO | NO | pre-published | real-time | |
| Index name | Type | Sorting | Primary | Attributes |
| stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| stat_repository_type | VARCHAR(40) | NO | NO | name of the table that has this stat_id as its id | |
| stat_repository_id | INTEGER | NO | YES | ||
| stat_holder_type | VARCHAR(40) | NO | NO | person | team | conference | league | etc. | |
| stat_holder_id | INTEGER | NO | NO | id of that person, team, etc. | |
| stat_coverage_type | VARCHAR(40) | NO | NO | event | sub_season | league_phase | lifetime | |
| stat_coverage_id | INTEGER | NO | NO | id of that event, sub_season, etc. | |
| stat_stage | VARCHAR(40) | NO | YES | intermediate | final ??? | |
| Index name | Type | Sorting | Primary | Attributes |
| sub_periods | |||||
| Especially for Tennis. sub_period is for game, period is for set, score is for total number of sets won. | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | VARCHAR(40) | YES | YES | ||
| period_id | VARCHAR(40) | NO | NO | ||
| value | VARCHAR(40) | NO | NO | ||
| score | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| sub_seasons | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per season_id + type | |
| sub_season_key | VARCHAR(40) | NO | NO | ||
| season_id | INTEGER | NO | YES | ||
| type | VARCHAR(40) | NO | YES | pre | regular | post | exhibition | all-start | |
| start_date_time | VARCHAR(40) | NO | NO | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| IDX_sub_seasons_1 | Default | Default | NO | sub_season_key |
| team_affiliation_phases | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| team_id | INTEGER | NO | YES | ||
| start_season_id | INTEGER | NO | YES | ||
| end_season_id | INTEGER | NO | YES | ||
| affiliation_id | INTEGER | NO | YES | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| team_american_football_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| yards_per_attempt | VARCHAR(40) | NO | NO | ||
| average_starting_position | VARCHAR(40) | NO | NO | ||
| timeouts | VARCHAR(40) | NO | NO | ||
| time_of_possession | VARCHAR(40) | NO | NO | ||
| turnover_ratio | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| team_phases | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| person_id | INTEGER | NO | YES | ||
| role_id | INTEGER | NO | YES | ||
| team_id | INTEGER | NO | YES | ||
| uniform_number | VARCHAR(40) | NO | NO | ||
| regular_position_id | INTEGER | NO | NO | ||
| start_date_time | VARCHAR(40) | NO | NO | ||
| start_season_id | INTEGER | NO | YES | ||
| end_date_time | VARCHAR(40) | NO | NO | ||
| end_season_id | INTEGER | NO | YES | ||
| height | VARCHAR(40) | NO | NO | ||
| weight | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| teams | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| team_key | VARCHAR(40) | NO | YES | ||
| publisher_id | INTEGER | NO | YES | ||
| first_name | VARCHAR(40) | NO | NO | ||
| last_name | VARCHAR(40) | NO | NO | ||
| full_name | VARCHAR(40) | NO | NO | ||
| alias | VARCHAR(40) | NO | NO | ||
| abbreviation | VARCHAR(40) | NO | NO | ||
| short_name | VARCHAR(40) | NO | NO | ||
| home_site_id | INTEGER | NO | NO | ||
| league_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| teams_documents | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| team_id | INTEGER | YES | YES | ||
| document_id | INTEGER | YES | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| teams_media | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| team_id | INTEGER | NO | YES | ||
| media_id | INTEGER | NO | YES | ||
| Index name | Type | Sorting | Primary | Attributes |
| tennis_action_points | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(100) | YES | YES | ||
| sub_period_id | CHAR(20) | NO | NO | ||
| sequence_number | CHAR(100) | NO | NO | ||
| win_type | CHAR(40) | NO | NO | forced | unforced | |
| Index name | Type | Sorting | Primary | Attributes |
| tennis_action_volleys | |||||
| One row per time the ball makes contact with a racquet. Including the first serve and the second serve. | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(100) | YES | YES | ||
| sequence_number | CHAR(100) | NO | NO | 1 == first_service | 2 == second_service | 3 == return | 4 == the_next_volley | etc. | |
| tennis_action_points_id | CHAR(40) | NO | NO | ||
| landing_location | VARCHAR(40) | NO | NO | for things like hawkeye coordinates | |
| swing_type | VARCHAR(40) | NO | NO | forward | backhand | |
| result | VARCHAR(40) | NO | NO | winner | out | returned | let | |
| spin_type | VARCHAR(40) | NO | NO | ||
| trajectory_details | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| tennis_event_states | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(100) | YES | YES | ||
| set | CHAR(20) | NO | NO | ||
| game | CHAR(100) | NO | NO | ||
| server_person_id | CHAR(40) | NO | NO | ||
| server_score | CHAR(20) | NO | NO | ||
| receiver_person_id | CHAR(20) | NO | NO | ||
| receiver_score | CHAR(20) | NO | NO | ||
| service-number | CHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| tennis_return_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(255) | NO | YES | ||
| returns_played | CHAR(20) | NO | NO | ||
| matches_played | CHAR(20) | NO | NO | ||
| first_service_return_points_won | CHAR(20) | NO | NO | ||
| first_service_return_points_won_pct | CHAR(20) | NO | NO | ||
| second_service_return_points_won | CHAR(20) | NO | NO | ||
| second_service_return_points_won_pct | CHAR(20) | NO | NO | ||
| return_games_played | CHAR(20) | NO | NO | ||
| return_games_won | CHAR(20) | NO | NO | ||
| return_games_won_pct | CHAR(20) | NO | NO | ||
| break_points_played | CHAR(20) | NO | NO | ||
| break_points_converted | CHAR(20) | NO | NO | ||
| break_points_converted_pct | CHAR(20) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| tennis_service_stats | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | CHAR(255) | NO | YES | ||
| services_played | CHAR(20) | NO | NO | ||
| matches_played | CHAR(20) | NO | NO | ||
| aces | CHAR(20) | NO | NO | ||
| first_services_good | CHAR(20) | NO | NO | ||
| first_services_good_pct | CHAR(20) | NO | NO | ||
| first_service_points_won | CHAR(20) | NO | NO | ||
| first_service_points_won_pct | CHAR(20) | NO | NO | ||
| second_service_points_won | CHAR(20) | NO | NO | ||
| second_service_points_won_pct | CHAR(20) | NO | NO | ||
| service_games_played | CHAR(20) | NO | NO | ||
| service_games_won | CHAR(20) | NO | NO | ||
| service_games_won_pct | CHAR(20) | NO | NO | ||
| break_points_played | CHAR(20) | NO | NO | ||
| break_points_saved | CHAR(20) | NO | NO | ||
| break_points_saved_pct | CHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| wagering_moneylines | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per bookmaker_key + event_id + date_time + (team_id | person_id) | |
| bookmaker_key | VARCHAR(40) | NO | NO | ||
| event_id | INTEGER | NO | YES | ||
| date_time | VARCHAR(40) | NO | NO | Time that line was set | |
| team_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| rotation_number | VARCHAR(40) | NO | NO | ||
| comment | VARCHAR(40) | NO | NO | ||
| vigorish | VARCHAR(40) | NO | NO | ||
| line | VARCHAR(40) | NO | NO | ||
| line_opening | VARCHAR(40) | NO | NO | ||
| prediction | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| wagering_odds_lines | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per bookmaker_key + event_id + date_time + (team_id | person_id) | |
| bookmaker_key | VARCHAR(40) | NO | NO | ||
| event_id | INTEGER | NO | YES | ||
| date_time | VARCHAR(40) | NO | NO | Time that line was set | |
| team_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| rotation_number | VARCHAR(40) | NO | NO | ||
| comment | VARCHAR(40) | NO | NO | ||
| numerator | VARCHAR(40) | NO | NO | ||
| denominator | VARCHAR(40) | NO | NO | ||
| prediction | VARCHAR(40) | NO | NO | ||
| payout_calculation | VARCHAR(40) | NO | NO | ||
| payout_amount | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| wagering_runlines | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per bookmaker_key + event_id + date_time + (team_id | person_id) | |
| bookmaker_key | VARCHAR(40) | NO | NO | ||
| event_id | INTEGER | NO | YES | ||
| date_time | VARCHAR(40) | NO | NO | Time that line was set | |
| team_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| rotation_number | VARCHAR(40) | NO | NO | ||
| comment | VARCHAR(40) | NO | NO | ||
| vigorish | VARCHAR(40) | NO | NO | ||
| line | VARCHAR(40) | NO | NO | ||
| line_opening | VARCHAR(40) | NO | NO | ||
| value | VARCHAR(40) | NO | NO | ||
| prediction | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| wagering_straight_spread_lines | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per bookmaker_key + event_id + date_time + (team_id | person_id) | |
| bookmaker_key | VARCHAR(40) | NO | NO | ||
| event_id | INTEGER | NO | YES | ||
| date_time | VARCHAR(40) | NO | NO | Time that line was set | |
| team_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| rotation_number | VARCHAR(40) | NO | NO | ||
| comment | VARCHAR(40) | NO | NO | ||
| vigorish | VARCHAR(40) | NO | NO | ||
| value | VARCHAR(40) | NO | NO | ||
| value_opening | VARCHAR(40) | NO | NO | ||
| prediction | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| wagering_total_score_lines | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | Unique per bookmaker_key + event_id + date_time + (team_id | person_id) | |
| bookmaker_key | VARCHAR(40) | NO | NO | ||
| event_id | INTEGER | NO | YES | ||
| date_time | VARCHAR(40) | NO | NO | Time that line was set | |
| team_id | INTEGER | NO | YES | ||
| person_id | INTEGER | NO | YES | Unique per person_key + publisher_id | |
| rotation_number | VARCHAR(40) | NO | NO | ||
| comment | VARCHAR(40) | NO | NO | ||
| vigorish | VARCHAR(40) | NO | NO | ||
| line_over | VARCHAR(40) | NO | NO | ||
| line_under | VARCHAR(40) | NO | NO | ||
| total | VARCHAR(40) | NO | NO | ||
| total_opening | VARCHAR(40) | NO | NO | ||
| prediction | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| weather_conditions | |||||
| Attribute | Datatype | Primary | Not Null | Default | Comment |
| id | @primary_id | YES | YES | ||
| event_id | VARCHAR(40) | NO | NO | ||
| temperature | VARCHAR(40) | NO | NO | ||
| humidity | VARCHAR(40) | NO | NO | ||
| clouds | VARCHAR(40) | NO | NO | ||
| wind_direction | VARCHAR(40) | NO | NO | ||
| wind_velocity | VARCHAR(40) | NO | NO | ||
| Index name | Type | Sorting | Primary | Attributes |
| Foreign Keys | ||||
| Name | Constraint | Parent | Child | Comment |
| Rel | baseball_event_states | baseball_action_substitutions | ||
| REL10 | publishers | sites | ||
| REL11 | events | affiliations_events | ||
| REL12 | seasons | team_affiliation_phases | ||
| Rel14 | baseball_event_states | baseball_action_plays | ||
| REL15 | affiliations | affiliations_events | ||
| REL16 | seasons | team_affiliation_phases | ||
| REL17 | seasons | person_league_phases | ||
| REL18 | seasons | person_league_phases | ||
| REL19 | publishers | teams | ||
| REL20 | seasons | team_phases | ||
| REL21 | seasons | team_phases | ||
| REL22 | events | events_sub_seasons | ||
| REL23 | teams | team_phases | ||
| REL24 | teams | team_affiliation_phases | ||
| REL25 | injury_phases | persons | ||
| REL26 | persons | person_league_phases | ||
| REL27 | affiliations | person_league_phases | ||
| REL28 | seasons | sub_seasons | ||
| REL3 | affiliations | teams | ||
| REL32 | documents | persons_documents | ||
| REL33 | persons | persons_documents | ||
| REL34 | persons | injury_phases | ||
| REL35 | publishers | events | ||
| REL36 | publishers | persons | ||
| REL37 | persons | team_phases | ||
| REL38 | team_phases | persons | ||
| REL39 | person_league_phases | persons | ||
| REL4 | affiliations | seasons | ||
| REL40 | seasons | injury_phases | ||
| Rel41 | positions | baseball_action_substitutions | ||
| REL43 | affiliations | team_affiliation_phases | ||
| REL44 | sites | teams | ||
| REL45 | publishers | seasons | ||
| REL46 | teams | affiliations_teams | ||
| REL47 | affiliations | affiliations_teams | ||
| REL48 | sub_seasons | events_sub_seasons | ||
| REL5 | events | weather_conditions | ||
| REL50 | publishers | document_fixtures | ||
| REL51 | publishers | documents | ||
| REL52 | document_fixtures | documents | ||
| REL53 | events | wagering_moneylines | ||
| REL54 | documents | latest_revisions | ||
| Rel55 | positions | baseball_action_substitutions | ||
| Rel56 | sites | events | ||
| Rel57 | baseball_action_plays | baseball_action_pitches | ||
| REL58 | documents | teams_documents | ||
| REL59 | teams | teams_documents | ||
| REL60 | documents | affiliations_documents | ||
| REL61 | affiliations | affiliations_documents | ||
| REL62 | events | document_fixtures_events | ||
| REL63 | document_fixtures | document_fixtures_events | ||
| REL64 | documents | document_fixtures_events | ||
| REL65 | document_classes | document_fixtures | ||
| REL66 | teams | wagering_moneylines | ||
| REL67 | persons | wagering_moneylines | ||
| REL68 | events | wagering_straight_spread_lines | ||
| REL69 | teams | wagering_straight_spread_lines | ||
| REL70 | persons | wagering_straight_spread_lines | ||
| REL71 | events | wagering_odds_lines | ||
| REL72 | teams | wagering_odds_lines | ||
| REL73 | persons | wagering_odds_lines | ||
| REL74 | events | wagering_total_score_lines | ||
| REL75 | teams | wagering_total_score_lines | ||
| REL76 | persons | wagering_total_score_lines | ||
| REL77 | events | wagering_runlines | ||
| REL78 | teams | wagering_runlines | ||
| REL79 | persons | wagering_runlines | ||
| Rel80 | positions | team_phases | ||
| Rel81 | teams | american_football_event_states | ||
| Rel82 | american_football_event_states | american_football_action_plays | ||
| Rel83 | american_football_action_plays | american_football_action_play_participants | ||
| Rel84 | persons | american_football_action_play_participants | ||
| Rel85 | roles | team_phases | ||
| Rel86 | persons | person_names | ||
| Rel87 | person_names | persons | ||
| Rel88 | roles | person_event_metadata | ||
| Rel89 | positions | person_event_metadata | ||
| Rel90 | publishers | key_aliases | ||
| Rel91 | baseball_action_pitches | baseball_action_contact_details | ||
| Rel93 | positions | core_person_stats | ||
| Rel94 | publishers | documents | ||
| Rel95 | events | events_documents | ||
| Rel96 | documents | events_documents | ||
| Relation1 | documents | document_contents | ||
| Relation10 | persons | media | ||
| Relation11 | locations | media | ||
| Relation12 | media | media_contents | ||
| Relation13 | media | documents_media | ||
| Relation14 | media_captions | documents_media | ||
| Relation15 | documents | documents_media | ||
| Relation16 | media | media_captions | ||
| Relation17 | persons | media_captions | ||
| Relation18 | media | media_keywords | ||
| Relation19 | affiliations | affiliations_media | ||
| Relation2 | affiliations | standings | ||
| Relation20 | media | affiliations_media | ||
| Relation21 | persons | persons_media | ||
| Relation22 | media | persons_media | ||
| Relation23 | teams | teams_media | ||
| Relation24 | media | teams_media | ||
| Relation25 | events | events_media | ||
| Relation26 | media | events_media | ||
| Relation27 | publishers | standings | ||
| Relation3 | sub_seasons | standings | ||
| Relation4 | standings | standing_subgroups | ||
| Relation5 | affiliations | standing_subgroups | ||
| Relation6 | standing_subgroups | outcome_totals | ||
| Relation7 | document_packages | document_package_entry | ||
| Relation8 | documents | document_package_entry | ||
| Relation9 | publishers | media | ||