TitleXTOSS 
AuthorXML Team 
Copyright2007, XML Team Solutions, Inc. 
Version8 

DBMS Created Modified
MySQL3  2007-03-12  2007-03-12 
Comments


Domains
Name Datatype Default Comment
primary_id  INTEGER     
boolean_domain  INTEGER     


addresses
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
location_id  INTEGER  NO  YES     
language  VARCHAR(100)  NO  NO     
suite  VARCHAR(100)  NO  NO     
floor  VARCHAR(100)  NO  NO     
building  VARCHAR(100)  NO  NO     
street_number  VARCHAR(100)  NO  NO     
street_prefix  VARCHAR(100)  NO  NO     
street  VARCHAR(100)  NO  NO     
street_suffix  VARCHAR(100)  NO  NO     
neighborhood  VARCHAR(100)  NO  NO     
district  VARCHAR(100)  NO  NO     
locality  VARCHAR(100)  NO  NO    city or town 
county  VARCHAR(100)  NO  NO     
region  VARCHAR(100)  NO  NO    state or province 
postal_code  VARCHAR(100)  NO  NO     
country  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_addresses_1  Default  Default  NO  locality 
IDX_addresses_2  Default  Default  NO  region 
IDX_addresses_3  Default  Default  NO  postal_code 
IDX_FK_add_loc_id__loc_id  Default  Default  NO  location_id 



affiliations
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
affiliation_key  VARCHAR(100)  NO  YES     
publisher_id  INTEGER  NO  YES     
tier  VARCHAR(100)  NO  NO    division | conference | caliber | organization | sport 
parent_id  INTEGER  NO  NO     
start_season_id  INTEGER  NO  NO     
start_date_time  DATE  NO  NO     
end_season_id  INTEGER  NO  NO     
end_date_time  DATE  NO  NO     

Index name Type Sorting Primary Attributes
IDX_affiliations_1  Default  Default  NO  affiliation_key 
IDX_affiliations_2  Default  Default  NO  tier 
IDX_FK_aff_pub_id__pub_id  Default  Default  NO  publisher_id 



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



american_football_action_participants
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
american_football_action_play_id  INTEGER  NO  YES     
person_id  INTEGER  NO  YES    Unique per person_key + publisher_id 
participant_role  VARCHAR(100)  NO  YES     
score_type  VARCHAR(100)  NO  NO     
field_line  INTEGER  NO  NO     
yardage  INTEGER  NO  NO     

Index name Type Sorting Primary Attributes
IDX_american_football_action_participants_1  Default  Default  NO  participant_role 
IDX_american_football_action_participants_2  Default  Default  NO  score_type 
IDX_FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id  Default  Default  NO  american_football_action_play_id 
IDX_FK_ame_foo_act_par_per_id__per_id  Default  Default  NO  person_id 



american_football_action_plays
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
american_football_event_state_id  INTEGER  NO  YES     
play_type  VARCHAR(100)  NO  NO     
score_attempt_type  VARCHAR(100)  NO  NO     
drive_result  VARCHAR(100)  NO  NO     
points  INTEGER  NO  NO     
comment  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_american_football_action_plays_1  Default  Default  NO  play_type 
IDX_american_football_action_plays_2  Default  Default  NO  score_attempt_type 
IDX_american_football_action_plays_3  Default  Default  NO  drive_result 
IDX_FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id  Default  Default  NO  american_football_event_state_id 



american_football_defensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
tackles_total  VARCHAR(100)  NO  NO     
tackles_solo  VARCHAR(100)  NO  NO     
tackles_assists  VARCHAR(100)  NO  NO     
interceptions_total  VARCHAR(100)  NO  NO     
interceptions_yards  VARCHAR(100)  NO  NO     
interceptions_average  VARCHAR(100)  NO  NO     
interceptions_longest  VARCHAR(100)  NO  NO     
interceptions_touchdown  VARCHAR(100)  NO  NO     
quarterback_hurries  VARCHAR(100)  NO  NO     
sacks_total  VARCHAR(100)  NO  NO     
sacks_yards  VARCHAR(100)  NO  NO     
passes_defensed  VARCHAR(100)  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(100)  NO  NO     
first_downs_pass  VARCHAR(100)  NO  NO     
first_downs_run  VARCHAR(100)  NO  NO     
first_downs_penalty  VARCHAR(100)  NO  NO     
conversions_third_down  VARCHAR(100)  NO  NO     
conversions_third_down_attempts  VARCHAR(100)  NO  NO     
conversions_third_down_percentage  VARCHAR(100)  NO  NO     
conversions_fourth_down  VARCHAR(100)  NO  NO     
conversions_fourth_down_attempts  VARCHAR(100)  NO  NO     
conversions_fourth_down_percentage  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



american_football_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_id  INTEGER  NO  YES     
current_state  SMALLINT  NO  NO     
sequence_number  INTEGER  NO  NO     
period_value  INTEGER  NO  NO     
period_time_elapsed  VARCHAR(100)  NO  NO     
period_time_remaining  VARCHAR(100)  NO  NO     
clock_state  VARCHAR(100)  NO  NO     
down  INTEGER  NO  NO     
team_in_possession_id  INTEGER  NO  NO     
distance_for_1st_down  INTEGER  NO  NO     
field_side  VARCHAR(100)  NO  NO    home | away 
field_line  INTEGER  NO  NO     

Index name Type Sorting Primary Attributes
IDX_american_football_event_states_1  Default  Default  NO  current_state 
IDX_FK_ame_foo_eve_sta_eve_id__eve_id  Default  Default  NO  event_id 



american_football_fumbles_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
fumbles_committed  VARCHAR(100)  NO  NO     
fumbles_forced  VARCHAR(100)  NO  NO     
fumbles_recovered  VARCHAR(100)  NO  NO     
fumbles_lost  VARCHAR(100)  NO  NO     
fumbles_yards_gained  VARCHAR(100)  NO  NO     
fumbles_own_committed  VARCHAR(100)  NO  NO     
fumbles_own_recovered  VARCHAR(100)  NO  NO     
fumbles_own_lost  VARCHAR(100)  NO  NO     
fumbles_own_yards_gained  VARCHAR(100)  NO  NO     
fumbles_opposing_committed  VARCHAR(100)  NO  NO     
fumbles_opposing_recovered  VARCHAR(100)  NO  NO     
fumbles_opposing_lost  VARCHAR(100)  NO  NO     
fumbles_opposing_yards_gained  VARCHAR(100)  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(100)  NO  NO     
offensive_plays_number  VARCHAR(100)  NO  NO     
offensive_plays_average_yards_per  VARCHAR(100)  NO  NO     
possession_duration  VARCHAR(100)  NO  NO     
turnovers_giveaway  VARCHAR(100)  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(100)  NO  NO     
passes_completions  VARCHAR(100)  NO  NO     
passes_percentage  VARCHAR(100)  NO  NO     
passes_yards_gross  VARCHAR(100)  NO  NO     
passes_yards_net  VARCHAR(100)  NO  NO     
passes_yards_lost  VARCHAR(100)  NO  NO     
passes_touchdowns  VARCHAR(100)  NO  NO     
passes_touchdowns_percentage  VARCHAR(100)  NO  NO     
passes_interceptions  VARCHAR(100)  NO  NO     
passes_interceptions_percentage  VARCHAR(100)  NO  NO     
passes_longest  VARCHAR(100)  NO  NO     
passes_average_yards_per  VARCHAR(100)  NO  NO     
passer_rating  VARCHAR(100)  NO  NO     
receptions_total  VARCHAR(100)  NO  NO     
receptions_yards  VARCHAR(100)  NO  NO     
receptions_touchdowns  VARCHAR(100)  NO  NO     
receptions_first_down  VARCHAR(100)  NO  NO     
receptions_longest  VARCHAR(100)  NO  NO     
receptions_average_yards_per  VARCHAR(100)  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(100)  NO  NO     
penalty_yards  VARCHAR(100)  NO  NO     
penalty_first_downs  VARCHAR(100)  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(100)  NO  NO     
rushes_yards  VARCHAR(100)  NO  NO     
rushes_touchdowns  VARCHAR(100)  NO  NO     
rushing_average_yards_per  VARCHAR(100)  NO  NO     
rushes_first_down  VARCHAR(100)  NO  NO     
rushes_longest  VARCHAR(100)  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(100)  NO  NO     
sacks_against_total  VARCHAR(100)  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(100)  NO  NO     
touchdowns_passing  VARCHAR(100)  NO  NO     
touchdowns_rushing  VARCHAR(100)  NO  NO     
touchdowns_special_teams  VARCHAR(100)  NO  NO     
touchdowns_defensive  VARCHAR(100)  NO  NO     
extra_points_attempts  VARCHAR(100)  NO  NO     
extra_points_made  VARCHAR(100)  NO  NO     
extra_points_missed  VARCHAR(100)  NO  NO     
extra_points_blocked  VARCHAR(100)  NO  NO     
field_goal_attempts  VARCHAR(100)  NO  NO     
field_goals_made  VARCHAR(100)  NO  NO     
field_goals_missed  VARCHAR(100)  NO  NO     
field_goals_blocked  VARCHAR(100)  NO  NO     
safeties_against  VARCHAR(100)  NO  NO     
two_point_conversions_attempts  VARCHAR(100)  NO  NO     
two_point_conversions_made  VARCHAR(100)  NO  NO     
touchbacks_total  VARCHAR(100)  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(100)  NO  NO     
returns_punt_yards  VARCHAR(100)  NO  NO     
returns_punt_average  VARCHAR(100)  NO  NO     
returns_punt_longest  VARCHAR(100)  NO  NO     
returns_punt_touchdown  VARCHAR(100)  NO  NO     
returns_kickoff_total  VARCHAR(100)  NO  NO     
returns_kickoff_yards  VARCHAR(100)  NO  NO     
returns_kickoff_average  VARCHAR(100)  NO  NO     
returns_kickoff_longest  VARCHAR(100)  NO  NO     
returns_kickoff_touchdown  VARCHAR(100)  NO  NO     
returns_total  VARCHAR(100)  NO  NO     
returns_yards  VARCHAR(100)  NO  NO     
punts_total  VARCHAR(100)  NO  NO     
punts_yards_gross  VARCHAR(100)  NO  NO     
punts_yards_net  VARCHAR(100)  NO  NO     
punts_longest  VARCHAR(100)  NO  NO     
punts_inside_20  VARCHAR(100)  NO  NO     
punts_inside_20_percentage  VARCHAR(100)  NO  NO     
punts_average  VARCHAR(100)  NO  NO     
punts_blocked  VARCHAR(100)  NO  NO     
touchbacks_total  VARCHAR(100)  NO  NO     
touchbacks_total_percentage  VARCHAR(100)  NO  NO     
touchbacks_kickoffs  VARCHAR(100)  NO  NO     
touchbacks_kickoffs_percentage  VARCHAR(100)  NO  NO     
touchbacks_punts  VARCHAR(100)  NO  NO     
touchbacks_punts_percentage  VARCHAR(100)  NO  NO     
touchbacks_interceptions  VARCHAR(100)  NO  NO     
touchbacks_interceptions_percentage  VARCHAR(100)  NO  NO     
fair_catches  VARCHAR(100)  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(100)  NO  NO     
strength  VARCHAR(100)  NO  NO    hard | soft | grounder | etc. 
velocity  INTEGER  NO  NO     
comment  TEXT  NO  NO     
trajectory_coordinates  VARCHAR(100)  NO  NO    yaml array of coordinates? 
trajectory_formula  VARCHAR(100)  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     
baseball_event_state_id  INTEGER  NO  YES     
baseball_defensive_group_id  INTEGER  NO  NO     
umpire_call  VARCHAR(100)  NO  NO     
pitch_location  VARCHAR(100)  NO  NO     
pitch_type  VARCHAR(100)  NO  NO     
pitch_velocity  INTEGER  NO  NO     
comment  TEXT  NO  NO     
trajectory_coordinates  VARCHAR(100)  NO  NO    yaml array of coordinates? 
trajectory_formula  VARCHAR(100)  NO  NO    formula describing this path 

Index name Type Sorting Primary Attributes
IDX_baseball_action_pitches_1  Default  Default  NO  umpire_call 
IDX_baseball_action_pitches_2  Default  Default  NO  pitch_type 
IDX_FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id  Default  Default  NO  baseball_defensive_group_id 
IDX_FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id  Default  Default  NO  baseball_event_state_id 



baseball_action_plays
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
baseball_event_state_id  INTEGER  NO  YES     
play_type  VARCHAR(100)  NO  NO     
notation  VARCHAR(100)  NO  NO     
notation_yaml  TEXT  NO  NO     
baseball_defensive_group_id  INTEGER  NO  NO     
comment  VARCHAR(100)  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(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_baseball_action_plays_1  Default  Default  NO  play_type 
IDX_FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id  Default  Default  NO  baseball_event_state_id 



baseball_action_substitutions
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
baseball_event_state_id  INTEGER  NO  YES     
sequence_number  INTEGER  NO  NO     
person_type  VARCHAR(100)  NO  NO    player | associate | official - NOT NEEDED? 
person_original_id  INTEGER  NO  YES     
person_original_position_id  INTEGER  NO  YES     
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(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



baseball_defensive_group
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     

Index name Type Sorting Primary Attributes



baseball_defensive_players
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
baseball_defensive_group_id  INTEGER  NO  YES     
player_id  INTEGER  NO  YES     
position_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes



baseball_defensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
double_plays  VARCHAR(100)  NO  NO     
triple_plays  VARCHAR(100)  NO  NO     
putouts  VARCHAR(100)  NO  NO     
assists  VARCHAR(100)  NO  NO     
errors  VARCHAR(100)  NO  NO     
fielding_percentage  VARCHAR(100)  NO  NO     
defensive_average  VARCHAR(100)  NO  NO     
errors_passed_ball  VARCHAR(100)  NO  NO     
errors_catchers_interference  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



baseball_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_id  INTEGER  NO  YES     
current_state  SMALLINT  NO  NO    true if this is the current state of the event 
sequence_number  INTEGER  NO  NO    the unique serial number for this state 
at_bat_number  INTEGER  NO  NO    the unique serial number for this at bat 
inning_value  INTEGER  NO  NO     
inning_half  VARCHAR(100)  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     
runner_on_first  SMALLINT  NO  NO     
runner_on_second  SMALLINT  NO  NO     
runner_on_third  SMALLINT  NO  NO     
runs_this_inning_half  INTEGER  NO  NO     
pitcher_id  INTEGER  NO  NO     
batter_id  INTEGER  NO  NO     
batter_side  VARCHAR(100)  NO  NO    left | right 

Index name Type Sorting Primary Attributes
IDX_baseball_event_states_1  Default  Default  NO  current_state 
IDX_FK_bas_eve_sta_eve_id__eve_id  Default  Default  NO  event_id 



baseball_offensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
average  VARCHAR(100)  NO  NO     
runs_scored  VARCHAR(100)  NO  NO     
at_bats  VARCHAR(100)  NO  NO     
hits  VARCHAR(100)  NO  NO     
rbi  VARCHAR(100)  NO  NO     
total_bases  VARCHAR(100)  NO  NO     
slugging_percentage  VARCHAR(100)  NO  NO     
bases_on_balls  VARCHAR(100)  NO  NO     
strikeouts  VARCHAR(100)  NO  NO     
left_on_base  VARCHAR(100)  NO  NO     
left_in_scoring_position  VARCHAR(100)  NO  NO     
singles  VARCHAR(100)  NO  NO     
doubles  VARCHAR(100)  NO  NO     
triples  VARCHAR(100)  NO  NO     
home_runs  VARCHAR(100)  NO  NO     
grand_slams  VARCHAR(100)  NO  NO     
at_bats_per_rbi  VARCHAR(100)  NO  NO     
plate_appearances_per_rbi  VARCHAR(100)  NO  NO     
at_bats_per_home_run  VARCHAR(100)  NO  NO     
plate_appearances_per_home_run  VARCHAR(100)  NO  NO     
sac_flies  VARCHAR(100)  NO  NO     
sac_bunts  VARCHAR(100)  NO  NO     
grounded_into_double_play  VARCHAR(100)  NO  NO     
moved_up  VARCHAR(100)  NO  NO     
on_base_percentage  VARCHAR(100)  NO  NO     
stolen_bases  VARCHAR(100)  NO  NO     
stolen_bases_caught  VARCHAR(100)  NO  NO     
stolen_bases_average  VARCHAR(100)  NO  NO     
hit_by_pitch  VARCHAR(100)  NO  NO     
defensive_interferance_reaches  VARCHAR(100)  NO  NO     
on_base_plus_slugging  VARCHAR(100)  NO  NO     
plate_appearances  VARCHAR(100)  NO  NO     
hits_extra_base  VARCHAR(100)  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(100)  NO  NO     
home_runs_allowed  VARCHAR(100)  NO  NO     
innings_pitched  VARCHAR(100)  NO  NO     
hits  VARCHAR(100)  NO  NO     
earned_runs  VARCHAR(100)  NO  NO     
unearned_runs  VARCHAR(100)  NO  NO     
bases_on_balls  VARCHAR(100)  NO  NO     
bases_on_balls_intentional  VARCHAR(100)  NO  NO     
strikeouts  VARCHAR(100)  NO  NO     
strikeout_to_bb_ratio  VARCHAR(100)  NO  NO     
number_of_pitches  VARCHAR(100)  NO  NO     
era  VARCHAR(100)  NO  NO     
inherited_runners_scored  VARCHAR(100)  NO  NO     
pick_offs  VARCHAR(100)  NO  NO     
errors_hit_with_pitch  VARCHAR(100)  NO  NO     
errors_wild_pitch  VARCHAR(100)  NO  NO     
balks  VARCHAR(100)  NO  NO     
wins  VARCHAR(100)  NO  NO     
losses  VARCHAR(100)  NO  NO     
saves  VARCHAR(100)  NO  NO     
shutouts  VARCHAR(100)  NO  NO     
games_complete  VARCHAR(100)  NO  NO     
games_finished  VARCHAR(100)  NO  NO     
winning_percentage  VARCHAR(100)  NO  NO     
event_credit  VARCHAR(100)  NO  NO     
save_credit  VARCHAR(100)  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  VARCHAR(100)  NO  NO     
steals_per_game  VARCHAR(100)  NO  NO     
blocks_total  VARCHAR(100)  NO  NO     
blocks_per_game  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



basketball_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
chronology  VARCHAR(100)  NO  NO     
event_id  INTEGER  NO  NO     
publisher_key  VARCHAR(100)  NO  NO     
period_value  VARCHAR(100)  NO  NO     
period_time_elapsed  VARCHAR(100)  NO  NO     
period_time_remaining  VARCHAR(100)  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(100)  NO  NO     
field_goals_per_game  VARCHAR(100)  NO  NO     
field_goals_attempted_per_game  VARCHAR(100)  NO  NO     
field_goals_percentage_adjusted  VARCHAR(100)  NO  NO     
three_pointers_made  INTEGER  NO  NO     
three_pointers_attempted  INTEGER  NO  NO     
three_pointers_percentage  VARCHAR(100)  NO  NO     
three_pointers_per_game  VARCHAR(100)  NO  NO     
three_pointers_attempted_per_game  VARCHAR(100)  NO  NO     
free_throws_made  VARCHAR(100)  NO  NO     
free_throws_attempted  VARCHAR(100)  NO  NO     
free_throws_percentage  VARCHAR(100)  NO  NO     
free_throws_per_game  VARCHAR(100)  NO  NO     
free_throws_attempted_per_game  VARCHAR(100)  NO  NO     
points_scored_total  VARCHAR(100)  NO  NO     
points_scored_per_game  VARCHAR(100)  NO  NO     
assists_total  VARCHAR(100)  NO  NO     
assists_per_game  VARCHAR(100)  NO  NO     
turnovers_total  VARCHAR(100)  NO  NO     
turnovers_per_game  VARCHAR(100)  NO  NO     
points_scored_off_turnovers  VARCHAR(100)  NO  NO     
points_scored_in_paint  VARCHAR(100)  NO  NO     
points_scored_on_second_chance  VARCHAR(100)  NO  NO     
points_scored_on_fast_break  VARCHAR(100)  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  VARCHAR(100)  NO  NO     
rebounds_per_game  VARCHAR(100)  NO  NO     
rebounds_defensive  VARCHAR(100)  NO  NO     
rebounds_offensive  VARCHAR(100)  NO  NO     
team_rebounds_total  VARCHAR(100)  NO  NO     
team_rebounds_per_game  VARCHAR(100)  NO  NO     
team_rebounds_defensive  VARCHAR(100)  NO  NO     
team_rebounds_offensive  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



bookmakers
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(100)  NO  NO     
publisher_id  INTEGER  NO  YES     
location_id  INTEGER  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  YES    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(100)  NO  NO     
score_opposing  VARCHAR(100)  NO  NO     
score_attempts  VARCHAR(100)  NO  NO     
score_attempts_opposing  VARCHAR(100)  NO  NO     
score_percentage  VARCHAR(100)  NO  NO     
score_percentage_opposing  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



display_names
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
language  VARCHAR(100)  NO  YES     
entity_type  VARCHAR(100)  NO  YES    person | team | affiliation tier | site | position 
entity_id  INTEGER  NO  YES     
full_name  VARCHAR(100)  NO  NO     
first_name  VARCHAR(100)  NO  NO     
middle_name  VARCHAR(100)  NO  NO     
last_name  VARCHAR(100)  NO  NO     
alias  VARCHAR(100)  NO  NO     
abbreviation  VARCHAR(100)  NO  NO     
short_name  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



document_classes
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
name  VARCHAR(100)  NO  NO    event-summary, news, statistics, etc. Should be called document_class_key, really. 

Index name Type Sorting Primary Attributes
IDX_document_classes_1  Default  Default  NO  name 



document_contents
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
document_id  INTEGER  NO  YES     
sportsml  VARCHAR(40)  NO  NO     
abstract  TEXT  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_doc_con_doc_id__doc_id  Default  Default  NO  document_id 



document_fixtures
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES    Unique per fixture_key + publisher_id 
fixture_key  VARCHAR(100)  NO  NO     
publisher_id  INTEGER  NO  YES     
name  VARCHAR(100)  NO  NO    OUTMODED.... should use display_names instead 
document_class_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes
IDX_document_fixtures_1  Default  Default  NO  fixture_key 
IDX_FK_doc_fix_doc_cla_id__doc_cla_id  Default  Default  NO  document_class_id 
IDX_FK_doc_fix_pub_id__pub_id  Default  Default  NO  publisher_id 



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     
last_update  DATE  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_doc_fix_eve_doc_fix_id__doc_fix_id  Default  Default  NO  document_fixture_id 
IDX_FK_doc_fix_eve_eve_id__eve_id  Default  Default  NO  event_id 
IDX_FK_doc_fix_eve_lat_doc_id__doc_id  Default  Default  NO  latest_document_id 



document_package_entry
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
document_package_id  INTEGER  NO  YES     
rank  VARCHAR(100)  NO  NO     
document_id  INTEGER  NO  YES     
headline  VARCHAR(100)  NO  NO     
short_headline  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



document_packages
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
package_key  VARCHAR(100)  NO  NO    eg, top-news-nba 
package_name  VARCHAR(100)  NO  NO    eg, "Top NBA News" 
date_time  DATE  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(75)  NO  YES     
publisher_id  INTEGER  NO  YES     
date_time  DATE  NO  NO    Timestamp for when this document was originally published. 
title  VARCHAR(255)  NO  NO    person | team | league | etc. 
language  VARCHAR(100)  NO  NO     
priority  VARCHAR(100)  NO  NO    event | sub_season | league_phase | lifetime 
revision_id  VARCHAR(75)  NO  NO     
stats_coverage  VARCHAR(100)  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(100)  NO  NO    Timestamp for when this document was loaded into the DB. 

Index name Type Sorting Primary Attributes
IDX_documents_1  Default  Default  NO  doc_id 
IDX_documents_3  Default  Default  NO  date_time 
IDX_documents_4  Default  Default  NO  priority 
IDX_documents_5  Default  Default  NO  revision_id 
IDX_FK_doc_doc_fix_id__doc_fix_id  Default  Default  NO  document_fixture_id 
IDX_FK_doc_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_FK_doc_sou_id__pub_id  Default  Default  NO  source_id 



documents_media
identifies the relationship between a document and its zero-or-more Media Objects
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
document_id  INTEGER  NO  YES     
media_id  INTEGER  NO  YES     
media_caption_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes



events
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_key  VARCHAR(100)  NO  YES     
publisher_id  INTEGER  NO  YES     
start_date_time  DATE  NO  NO    Normalized to UTC 
site_id  INTEGER  NO  NO     
site_alignment  VARCHAR(100)  NO  NO     
event_status  VARCHAR(100)  NO  NO     
duration  VARCHAR(100)  NO  NO     
attendance  VARCHAR(100)  NO  NO     
last_update  DATE  NO  NO     

Index name Type Sorting Primary Attributes
IDX_events_1  Default  Default  NO  event_key 
IDX_FK_eve_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_FK_eve_sit_id__sit_id  Default  Default  NO  site_id 



events_documents
Attribute Datatype Primary Not Null Default Comment
event_id  INTEGER  YES  YES     
document_id  INTEGER  YES  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  @primary_id  YES  YES     
shots_power_play_allowed  VARCHAR(100)  NO  NO     
shots_penalty_shot_allowed  VARCHAR(100)  NO  NO     
goals_power_play_allowed  VARCHAR(100)  NO  NO     
goals_penalty_shot_allowed  VARCHAR(100)  NO  NO     
goals_against_average  VARCHAR(100)  NO  NO     
saves  VARCHAR(100)  NO  NO     
save_percentage  VARCHAR(100)  NO  NO     
penalty_killing_amount  VARCHAR(100)  NO  NO     
penalty_killing_percentage  VARCHAR(100)  NO  NO     
shots_blocked  VARCHAR(100)  NO  NO     
takeaways  VARCHAR(100)  NO  NO     
shutouts  VARCHAR(100)  NO  NO     
minutes_penalty_killing  VARCHAR(100)  NO  NO     
hits  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



ice_hockey_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
chronology  VARCHAR(100)  NO  NO     
event_id  INTEGER  NO  NO     
publisher_key  VARCHAR(100)  NO  NO     
period_value  VARCHAR(100)  NO  NO     
period_time_elapsed  VARCHAR(100)  NO  NO     
period_time_remaining  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



ice_hockey_offensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
goals_game_winning  VARCHAR(100)  NO  NO     
goals_game_tying  VARCHAR(100)  NO  NO     
goals_power_play  VARCHAR(100)  NO  NO     
goals_short_handed  VARCHAR(100)  NO  NO     
goals_even_strength  VARCHAR(100)  NO  NO     
goals_empty_net  VARCHAR(100)  NO  NO     
goals_overtime  VARCHAR(100)  NO  NO     
goals_shootout  VARCHAR(100)  NO  NO     
goals_penalty_shot  VARCHAR(100)  NO  NO     
assists  VARCHAR(100)  NO  NO     
points  VARCHAR(100)  NO  NO     
power_play_amount  VARCHAR(100)  NO  NO     
power_play_percentage  VARCHAR(100)  NO  NO     
shots_penalty_shot_taken  VARCHAR(100)  NO  NO     
shots_penalty_shot_missed  VARCHAR(100)  NO  NO     
shots_penalty_shot_percentage  VARCHAR(100)  NO  NO     
giveaways  VARCHAR(100)  NO  NO     
minutes_power_play  VARCHAR(100)  NO  NO     
faceoff_wins  VARCHAR(100)  NO  NO     
faceoff_losses  VARCHAR(100)  NO  NO     
faceoff_win_percentage  VARCHAR(100)  NO  NO     
scoring_chances  VARCHAR(100)  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(100)  NO  NO     
injury_type  VARCHAR(100)  NO  NO     
injury_comment  VARCHAR(100)  NO  NO     
disabled_list  VARCHAR(100)  NO  NO     
start_date_time  VARCHAR(100)  NO  NO     
end_date_time  VARCHAR(100)  NO  NO     
season_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes
IDX_FK_inj_pha_per_id__per_id  Default  Default  NO  person_id 
IDX_FK_inj_pha_sea_id__sea_id  Default  Default  NO  season_id 
IDX_injury_phases_2  Default  Default  NO  injury_status 
IDX_injury_phases_3  Default  Default  NO  start_date_time 
IDX_injury_phases_4  Default  Default  NO  end_date_time 



key_aliases
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
publisher_id  INTEGER  NO  YES     
alias_type  VARCHAR(100)  NO  NO    persons | teams | affiliations | events | etc. 
alias_id  INTEGER  NO  NO    A person_id, team_id, etc. 
alias_key  VARCHAR(100)  NO  NO    A person_key, team_key, etc. 
common_key  VARCHAR(100)  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
IDX_FK_key_ali_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_key_aliases_1  Default  Default  NO  alias_type 
IDX_key_aliases_2  Default  Default  NO  alias_id 
IDX_key_aliases_3  Default  Default  NO  alias_key 
IDX_key_aliases_4  Default  Default  NO  common_key 



latest_revisions
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
revision_id  VARCHAR(75)  NO  YES    a string from the SportsML 
latest_document_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes
IDX_FK_lat_rev_lat_doc_id__doc_id  Default  Default  NO  latest_document_id 
IDX_latest_revisions_1  Default  Default  NO  revision_id 



locations
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
timezone  VARCHAR(100)  NO  NO    In tz format, see: http://www.twinsun.com/tz/tz-link.htm 
latitude  VARCHAR(100)  NO  NO     
longitude  VARCHAR(100)  NO  NO     
country_code  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_locations_1  Default  Default  NO  country_code 



media
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
object_id  INTEGER  NO  NO    parallel to the doc_id... the original unique ID provided by the publisher 
source_id  INTEGER  NO  NO    an ID that was used upstream from the current publisher's object_id 
revision_id  INTEGER  NO  NO     
media_type  VARCHAR(100)  NO  NO    photo | audio | video 
publisher_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO     
credit_id  INTEGER  NO  YES     
db_loading_date_time  VARCHAR(100)  NO  NO     
creation_location_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes



media_captions
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
media_id  INTEGER  NO  YES     
caption_type  VARCHAR(100)  NO  NO    main | headline | name, to give three common examples, from longest to shortest length 
caption  VARCHAR(100)  NO  NO     
caption_author_id  INTEGER  NO  YES     
language  VARCHAR(100)  NO  NO     
caption_size  VARCHAR(100)  NO  NO    size of caption, in characters 

Index name Type Sorting Primary Attributes



media_contents
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
media_id  INTEGER  NO  YES     
object  VARCHAR(100)  NO  NO     
format  VARCHAR(100)  NO  NO     
mime_type  VARCHAR(100)  NO  NO     
height  VARCHAR(100)  NO  NO     
width  VARCHAR(100)  NO  NO     
duration  VARCHAR(100)  NO  NO     
file_size  VARCHAR(100)  NO  NO     
resolution  VARCHAR(100)  NO  NO    main | thumbnail | low-bandwidth | high-bandwidth 

Index name Type Sorting Primary Attributes



media_keywords
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
keyword  VARCHAR(100)  NO  NO     
media_id  INTEGER  NO  YES     

Index name Type Sorting Primary Attributes



motor_racing_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_id  VARCHAR(100)  NO  NO     
lap  VARCHAR(100)  NO  NO     
laps_remaining  VARCHAR(100)  NO  NO     
time_elapsed  VARCHAR(100)  NO  NO     
flag_state  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



motor_racing_qualifying_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
grid  VARCHAR(100)  NO  NO     
pole_position  VARCHAR(100)  NO  NO     
pole_wins  VARCHAR(100)  NO  NO     
qualifying_speed  VARCHAR(100)  NO  NO     
qualifying_speed_units  VARCHAR(100)  NO  NO     
qualifying_time  VARCHAR(100)  NO  NO     
qualifying_position  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



motor_racing_race_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
time_behind_leader  VARCHAR(100)  NO  NO     
laps_behind_leader  VARCHAR(100)  NO  NO     
time_ahead_follower  VARCHAR(100)  NO  NO     
laps_ahead_follower  VARCHAR(100)  NO  NO     
time  VARCHAR(100)  NO  NO     
points  VARCHAR(100)  NO  NO     
points_rookie  VARCHAR(100)  NO  NO     
bonus  VARCHAR(100)  NO  NO     
laps_completed  VARCHAR(100)  NO  NO     
laps_leading_total  VARCHAR(100)  NO  NO     
distance_leading  VARCHAR(100)  NO  NO     
distance_completed  VARCHAR(100)  NO  NO     
distance_units  VARCHAR(40)  NO  NO     
speed_average  VARCHAR(40)  NO  NO     
speed_units  VARCHAR(40)  NO  NO     
status  VARCHAR(40)  NO  NO     
finishes_top_5  VARCHAR(40)  NO  NO     
finishes_top_10  VARCHAR(40)  NO  NO     
starts  VARCHAR(40)  NO  NO     
finishes  VARCHAR(40)  NO  NO     
non_finishes  VARCHAR(40)  NO  NO     
wins  VARCHAR(40)  NO  NO     
races_leading  VARCHAR(40)  NO  NO     
money  VARCHAR(40)  NO  NO     
money_units  VARCHAR(40)  NO  NO     
leads_total  VARCHAR(40)  NO  NO     

Index name Type Sorting Primary Attributes



outcome_totals
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
standing_subgroup_id  INTEGER  NO  YES     
outcome_holder_type  VARCHAR(100)  NO  NO    team | player | etc 
outcome_holder_id  INTEGER  NO  NO    the team_id or player_id or etc 
rank  VARCHAR(100)  NO  NO     
wins  VARCHAR(100)  NO  NO     
losses  VARCHAR(100)  NO  NO     
ties  VARCHAR(100)  NO  NO     
undecideds  VARCHAR(100)  NO  NO     
winning_percentage  VARCHAR(100)  NO  NO     
points_scored_for  VARCHAR(100)  NO  NO     
points_scored_against  VARCHAR(100)  NO  NO     
points_difference  VARCHAR(100)  NO  NO    games back, for baseball 
standing_points  VARCHAR(100)  NO  NO     
streak_type  VARCHAR(100)  NO  NO    win | loss | tie | score | assist | point 
streak_duration  VARCHAR(100)  NO  NO    number of days 
streak_total  VARCHAR(100)  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  @primary_id  YES  YES     
participant_type  VARCHAR(100)  NO  YES     
participant_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
alignment  VARCHAR(100)  NO  NO     
score  VARCHAR(100)  NO  NO     
event_outcome  VARCHAR(100)  NO  NO     
rank  INTEGER  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_par_eve_eve_id__eve_id  Default  Default  NO  event_id 
IDX_participants_events_1  Default  Default  NO  participant_type 
IDX_participants_events_2  Default  Default  NO  participant_id 
IDX_participants_events_3  Default  Default  NO  alignment 
IDX_participants_events_4  Default  Default  NO  event_outcome 



periods
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
participant_event_id  INTEGER  NO  YES     
period_value  VARCHAR(100)  NO  NO     
score  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_per_par_eve_id__par_eve_id  Default  Default  NO  participant_event_id 



person_event_metadata
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
person_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
status  VARCHAR(100)  NO  NO    benched | started | played | scratched 
weight  VARCHAR(100)  NO  NO     
role_id  INTEGER  NO  NO     
position_id  INTEGER  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_per_eve_met_eve_id__eve_id  Default  Default  NO  event_id 
IDX_FK_per_eve_met_per_id__per_id  Default  Default  NO  person_id 
IDX_FK_per_eve_met_pos_id__pos_id  Default  Default  NO  position_id 
IDX_FK_per_eve_met_rol_id__rol_id  Default  Default  NO  role_id 
IDX_person_event_metadata_1  Default  Default  NO  status 



person_phases
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
person_id  INTEGER  NO  YES     
membership_type  VARCHAR(40)  NO  NO    teams | affiliations 
membership_id  INTEGER  NO  YES    the team_id or affiliation_id 
role_id  INTEGER  NO  YES     
role_status  VARCHAR(40)  NO  NO    further metadata on the role (free-agent, signed, retired | drafted | playing) 
phase_status  VARCHAR(40)  NO  NO    active | inactive 
uniform_number  VARCHAR(20)  NO  NO     
regular_position_id  INTEGER  NO  YES     
start_date_time  DATE  NO  NO     
start_season_id  INTEGER  NO  YES     
end_date_time  DATE  NO  NO     
end_season_id  INTEGER  NO  YES     
height  VARCHAR(100)  NO  NO     
weight  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_per_pha_per_id__per_id  Default  Default  NO  person_id 
IDX_FK_per_pha_reg_pos_id__pos_id  Default  Default  NO  regular_position_id 
IDX_person_phases_1  Default  Default  NO  membership_type 
IDX_person_phases_2  Default  Default  NO  membership_id 
IDX_person_phases_3  Default  Default  NO  phase_status 



persons
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES    Unique per person_key + publisher_id 
person_key  VARCHAR(100)  NO  YES     
publisher_id  INTEGER  NO  YES     
gender  VARCHAR(20)  NO  NO     
current_injury_phase_id  INTEGER  NO  NO     
current_team_phase_id  INTEGER  NO  NO     
current_league_phase_id  INTEGER  NO  NO     
birth_date  VARCHAR(30)  NO  NO     
death_date  VARCHAR(30)  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
IDX_FK_per_cur_inj_pha_id__inj_pha_id  Default  Default  NO  current_injury_phase_id 
IDX_FK_per_cur_lea_pha_id__per_pha_id  Default  Default  NO  current_league_phase_id 
IDX_FK_per_cur_tea_pha_id__per_pha_id  Default  Default  NO  current_team_phase_id 
IDX_FK_per_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_persons_1  Default  Default  NO  person_key 



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     

Index name Type Sorting Primary Attributes
IDX_FK_pos_aff_id__aff_id  Default  Default  NO  affiliation_id 
IDX_positions_1  Default  Default  NO  abbreviation 



publishers
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
publisher_key  VARCHAR(100)  NO  YES     
publisher_name  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_publishers_1  Default  Default  NO  publisher_key 



roles
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
role_key  VARCHAR(100)  NO  YES    player | coach | manager | owner| umpire | etc. 
role_name  VARCHAR(100)  NO  NO    Display name for the key 
comment  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_roles_1  Default  Default  NO  role_key 



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  DATE  NO  NO     
end_date_time  DATE  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_sea_lea_id__aff_id  Default  Default  NO  league_id 
IDX_FK_sea_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_seasons_1  Default  Default  NO  season_key 



sites
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
site_key  INTEGER  NO  YES     
publisher_id  INTEGER  NO  YES     
location_id  INTEGER  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_sit_loc_id__loc_id  Default  Default  NO  location_id 
IDX_FK_sit_pub_id__pub_id  Default  Default  NO  publisher_id 
IDX_sites_1  Default  Default  NO  site_key 



soccer_defensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
shots_penalty_shot_allowed  VARCHAR(100)  NO  NO     
goals_penalty_shot_allowed  VARCHAR(100)  NO  NO     
goals_against_average  VARCHAR(100)  NO  NO     
goals_against_total  VARCHAR(100)  NO  NO     
saves  VARCHAR(100)  NO  NO     
save_percentage  VARCHAR(100)  NO  NO     
catches_punches  VARCHAR(100)  NO  NO     
shots_on_goal_total  VARCHAR(100)  NO  NO     
shots_shootout_total  VARCHAR(100)  NO  NO     
shots_shootout_allowed  VARCHAR(100)  NO  NO     
shots_blocked  VARCHAR(100)  NO  NO     
shutouts  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



soccer_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_id  VARCHAR(100)  NO  NO     
period_value  VARCHAR(100)  NO  NO     
period_time_elapsed  VARCHAR(100)  NO  NO     
period_time_remaining  VARCHAR(100)  NO  NO     
minutes_elapsed  VARCHAR(100)  NO  NO     
period_minute_elapsed  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



soccer_foul_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
fouls_suffered  VARCHAR(100)  NO  NO     
fouls_commited  VARCHAR(100)  NO  NO     
cautions_total  VARCHAR(100)  NO  NO     
cautions_pending  VARCHAR(100)  NO  NO     
caution_points_total  VARCHAR(100)  NO  NO     
caution_points_pending  VARCHAR(100)  NO  NO     
ejections_total  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



soccer_offensive_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
goals_game_winning  VARCHAR(100)  NO  NO     
goals_game_tying  VARCHAR(100)  NO  NO     
goals_overtime  VARCHAR(100)  NO  NO     
goals_shootout  VARCHAR(100)  NO  NO     
goals_total  VARCHAR(100)  NO  NO     
assists_game_winning  VARCHAR(100)  NO  NO     
assists_game_tying  VARCHAR(100)  NO  NO     
assists_overtime  VARCHAR(100)  NO  NO     
assists_total  VARCHAR(100)  NO  NO     
points  VARCHAR(100)  NO  NO     
shots_total  VARCHAR(100)  NO  NO     
shots_on_goal_total  VARCHAR(100)  NO  NO     
shots_hit_frame  VARCHAR(100)  NO  NO     
shots_penalty_shot_taken  VARCHAR(100)  NO  NO     
shots_penalty_shot_scored  VARCHAR(100)  NO  NO     
shots_penalty_shot_missed  VARCHAR(40)  NO  NO     
shots_penalty_shot_percentage  VARCHAR(40)  NO  NO     
shots_shootout_taken  VARCHAR(40)  NO  NO     
shots_shootout_scored  VARCHAR(40)  NO  NO     
shots_shootout_missed  VARCHAR(40)  NO  NO     
shots_shootout_percentage  VARCHAR(40)  NO  NO     
giveaways  VARCHAR(40)  NO  NO     
offsides  VARCHAR(40)  NO  NO     
corner_kicks  VARCHAR(40)  NO  NO     
hat_tricks  VARCHAR(40)  NO  NO     

Index name Type Sorting Primary Attributes



standing_subgroups
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
standing_id  INTEGER  NO  YES     
affiliation_id  INTEGER  NO  YES    id for, say, American League East division 

Index name Type Sorting Primary Attributes



standings
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
affiliation_id  INTEGER  NO  YES    eg, ID for league-key 
standing_type  VARCHAR(100)  NO  NO    division | conference | playoffs | wild-card | etc. 
sub_season_id  INTEGER  NO  YES     
last_updated  VARCHAR(100)  NO  NO    date timestamp that these standings were last updated 
duration_scope  VARCHAR(100)  NO  NO    regulation | overtime | etc. Indicates class of events included statistics apply to. 
competition_scope  VARCHAR(100)  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(100)  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(100)  NO  NO    all | home | away | etc. Indicates that the included statistics apply only to events played either at home or away 
site_scope  VARCHAR(100)  NO  NO    all | indoors | outdoors | carpet | clay | etc. 
scoping_label  VARCHAR(100)  NO  NO    A textual description for the scope (when all else fails...) 
publisher_id  INTEGER  NO  YES     
source  VARCHAR(100)  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(100)  NO  NO    name of the table that has this stat_id as its id 
stat_repository_id  INTEGER  NO  YES    id in that table for this row 
stat_holder_type  VARCHAR(100)  NO  NO    persons | teams | affiliations | etc. 
stat_holder_id  INTEGER  NO  NO    id of that person, team, etc. 
stat_coverage_type  VARCHAR(100)  NO  NO    events | sub_seasons | affiliations | *_phases | etc. 
stat_coverage_id  INTEGER  NO  NO    id of that event, sub_season, etc. 
context  VARCHAR(40)  NO  YES    event if this is a confirmed stat, event-play if an unofficial mid-game update, etc. 

Index name Type Sorting Primary Attributes
IDX_stats_1  Default  Default  NO  stat_repository_type 
IDX_stats_2  Default  Default  NO  stat_repository_id 
IDX_stats_3  Default  Default  NO  stat_holder_type 
IDX_stats_4  Default  Default  NO  stat_holder_id 
IDX_stats_5  Default  Default  NO  stat_coverage_type 
IDX_stats_6  Default  Default  NO  stat_coverage_id 
IDX_stats_7  Default  Default  NO  context 



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  @primary_id  YES  YES     
period_id  INTEGER  NO  YES     
sub_period_value  VARCHAR(100)  NO  NO     
score  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_sub_per_per_id__per_id  Default  Default  NO  period_id 



sub_seasons
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES    Unique per season_id + type 
sub_season_key  VARCHAR(100)  NO  YES     
season_id  INTEGER  NO  YES     
sub_season_type  VARCHAR(100)  NO  YES    pre | regular | post | exhibition | all-star 
start_date_time  DATE  NO  NO     
end_date_time  DATE  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_sub_sea_sea_id__sea_id  Default  Default  NO  season_id 
IDX_sub_seasons_1  Default  Default  NO  sub_season_key 
IDX_sub_seasons_2  Default  Default  NO  sub_season_type 



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(100)  NO  NO     
end_date_time  VARCHAR(100)  NO  NO     
phase_status  VARCHAR(40)  NO  NO    active | inactive 
role_id  INTEGER  NO  NO    identifies the relationship between a minor league team and parent MLB ballclub 

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(100)  NO  NO     
average_starting_position  VARCHAR(100)  NO  NO     
timeouts  VARCHAR(100)  NO  NO     
time_of_possession  VARCHAR(100)  NO  NO     
turnover_ratio  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



teams
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
team_key  VARCHAR(100)  NO  YES     
publisher_id  INTEGER  NO  YES     
home_site_id  INTEGER  NO  NO     
league_id  INTEGER  NO  NO     

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  @primary_id  YES  YES     
sub_period_id  VARCHAR(100)  NO  NO     
sequence_number  VARCHAR(100)  NO  NO     
win_type  VARCHAR(100)  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  @primary_id  YES  YES     
sequence_number  VARCHAR(100)  NO  NO    1 == first_service | 2 == second_service | 3 == return | 4 == the_next_volley | etc. 
tennis_action_points_id  INTEGER  NO  NO     
landing_location  VARCHAR(100)  NO  NO    for things like hawkeye coordinates 
swing_type  VARCHAR(100)  NO  NO    forward | backhand 
result  VARCHAR(100)  NO  NO    winner | out | returned | let 
spin_type  VARCHAR(100)  NO  NO     
trajectory_details  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



tennis_event_states
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
tennis_set  VARCHAR(100)  NO  NO    set is a reserved word in SQL 
game  VARCHAR(100)  NO  NO     
server_person_id  INTEGER  NO  NO     
server_score  VARCHAR(100)  NO  NO     
receiver_person_id  INTEGER  NO  NO     
receiver_score  VARCHAR(100)  NO  NO     
service_number  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



tennis_return_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
returns_played  VARCHAR(100)  NO  NO     
matches_played  VARCHAR(100)  NO  NO     
first_service_return_points_won  VARCHAR(100)  NO  NO     
first_service_return_points_won_pct  VARCHAR(100)  NO  NO     
second_service_return_points_won  VARCHAR(100)  NO  NO     
second_service_return_points_won_pct  VARCHAR(100)  NO  NO     
return_games_played  VARCHAR(100)  NO  NO     
return_games_won  VARCHAR(100)  NO  NO     
return_games_won_pct  VARCHAR(100)  NO  NO     
break_points_played  VARCHAR(100)  NO  NO     
break_points_converted  VARCHAR(100)  NO  NO     
break_points_converted_pct  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



tennis_service_stats
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
services_played  VARCHAR(100)  NO  NO     
matches_played  VARCHAR(100)  NO  NO     
aces  VARCHAR(100)  NO  NO     
first_services_good  VARCHAR(100)  NO  NO     
first_services_good_pct  VARCHAR(100)  NO  NO     
first_service_points_won  VARCHAR(100)  NO  NO     
first_service_points_won_pct  VARCHAR(100)  NO  NO     
second_service_points_won  VARCHAR(100)  NO  NO     
second_service_points_won_pct  VARCHAR(100)  NO  NO     
service_games_played  VARCHAR(100)  NO  NO     
service_games_won  VARCHAR(100)  NO  NO     
service_games_won_pct  VARCHAR(100)  NO  NO     
break_points_played  VARCHAR(100)  NO  NO     
break_points_saved  VARCHAR(100)  NO  NO     
break_points_saved_pct  VARCHAR(100)  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_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO    Time that line was set 
team_id  INTEGER  NO  YES     
person_id  INTEGER  NO  NO     
rotation_key  VARCHAR(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     
vigorish  VARCHAR(100)  NO  NO     
line  VARCHAR(100)  NO  NO     
line_opening  VARCHAR(100)  NO  NO     
prediction  VARCHAR(100)  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_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO    Time that line was set 
team_id  INTEGER  NO  YES     
person_id  INTEGER  NO  NO     
rotation_key  VARCHAR(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     
numerator  VARCHAR(100)  NO  NO     
denominator  VARCHAR(100)  NO  NO     
prediction  VARCHAR(100)  NO  NO     
payout_calculation  VARCHAR(100)  NO  NO     
payout_amount  VARCHAR(100)  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_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO    Time that line was set 
team_id  INTEGER  NO  YES     
person_id  INTEGER  NO  NO     
rotation_key  VARCHAR(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     
vigorish  VARCHAR(100)  NO  NO     
line  VARCHAR(100)  NO  NO     
line_opening  VARCHAR(100)  NO  NO     
line_value  VARCHAR(100)  NO  NO     
prediction  VARCHAR(100)  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_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO    Time that line was set 
team_id  INTEGER  NO  YES     
person_id  INTEGER  NO  NO     
rotation_key  VARCHAR(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     
vigorish  VARCHAR(100)  NO  NO     
line_value  VARCHAR(100)  NO  NO     
line_value_opening  VARCHAR(100)  NO  NO     
prediction  VARCHAR(100)  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_id  INTEGER  NO  YES     
event_id  INTEGER  NO  YES     
date_time  VARCHAR(100)  NO  NO    Time that line was set 
team_id  INTEGER  NO  YES     
person_id  INTEGER  NO  NO     
rotation_key  VARCHAR(100)  NO  NO     
comment  VARCHAR(100)  NO  NO     
vigorish  VARCHAR(100)  NO  NO     
line_over  VARCHAR(100)  NO  NO     
line_under  VARCHAR(100)  NO  NO     
total  VARCHAR(100)  NO  NO     
total_opening  VARCHAR(100)  NO  NO     
prediction  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes



weather_conditions
Attribute Datatype Primary Not Null Default Comment
id  @primary_id  YES  YES     
event_id  INTEGER  NO  YES     
temperature  VARCHAR(100)  NO  NO     
humidity  VARCHAR(100)  NO  NO     
clouds  VARCHAR(100)  NO  NO     
wind_direction  VARCHAR(100)  NO  NO     
wind_velocity  VARCHAR(100)  NO  NO     

Index name Type Sorting Primary Attributes
IDX_FK_wea_con_eve_id__eve_id  Default  Default  NO  event_id 





Foreign Keys


FK_add_loc_id__loc_id
Constraint: FK_add_loc_id__loc_id
Source: locations -> id
Target: addresses -> location_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_doc_aff_id__aff_id
Constraint: FK_aff_doc_aff_id__aff_id
Source: affiliations -> id
Target: affiliations_documents -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_doc_doc_id__doc_id
Constraint: FK_aff_doc_doc_id__doc_id
Source: documents -> id
Target: affiliations_documents -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_eve_aff_id__aff_id
Constraint: FK_aff_eve_aff_id__aff_id
Source: affiliations -> id
Target: affiliations_events -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_eve_eve_id__eve_id
Constraint: FK_aff_eve_eve_id__eve_id
Source: events -> id
Target: affiliations_events -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_med_aff_id__aff_id
Constraint: FK_aff_med_aff_id__aff_id
Source: affiliations -> id
Target: affiliations_media -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_med_med_id__med_id
Constraint: FK_aff_med_med_id__med_id
Source: media -> id
Target: affiliations_media -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_aff_par_id__aff_id
Constraint: FK_aff_par_id__aff_id
Source: affiliations -> id
Target: affiliations -> parent_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_aff_pub_id__pub_id
Constraint: FK_aff_pub_id__pub_id
Source: publishers -> id
Target: affiliations -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id
Constraint: FK_ame_foo_act_par_ame_foo_act_pla_id__ame_foo_act_pla_id
Source: american_football_action_plays -> id
Target: american_football_action_participants -> american_football_action_play_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_ame_foo_act_par_per_id__per_id
Constraint: FK_ame_foo_act_par_per_id__per_id
Source: persons -> id
Target: american_football_action_participants -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id
Constraint: FK_ame_foo_act_pla_ame_foo_eve_sta_id__ame_foo_eve_sta_id
Source: american_football_event_states -> id
Target: american_football_action_plays -> american_football_event_state_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_ame_foo_eve_sta_eve_id__eve_id
Constraint: FK_ame_foo_eve_sta_eve_id__eve_id
Source: events -> id
Target: american_football_event_states -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_ame_foo_eve_sta_tea_in_pos_id__tea_id
Constraint: FK_ame_foo_eve_sta_tea_in_pos_id__tea_id
Source: teams -> id
Target: american_football_event_states -> team_in_possession_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_act_con_det_bas_act_pit_id__bas_act_pit_id
Constraint: FK_bas_act_con_det_bas_act_pit_id__bas_act_pit_id
Source: baseball_action_pitches -> id
Target: baseball_action_contact_details -> baseball_action_pitch_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id
Constraint: FK_bas_act_pit_bas_def_gro_id__bas_def_gro_id
Source: baseball_defensive_group -> id
Target: baseball_action_pitches -> baseball_defensive_group_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id
Constraint: FK_bas_act_pit_bas_eve_sta_id__bas_eve_sta_id
Source: baseball_event_states -> id
Target: baseball_action_pitches -> baseball_event_state_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id
Constraint: FK_bas_act_pla_bas_eve_sta_id__bas_eve_sta_id
Source: baseball_event_states -> id
Target: baseball_action_plays -> baseball_event_state_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_sub_bas_eve_sta_id__bas_eve_sta_id
Constraint: FK_bas_act_sub_bas_eve_sta_id__bas_eve_sta_id
Source: baseball_event_states -> id
Target: baseball_action_substitutions -> baseball_event_state_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_sub_per_ori_id__per_id
Constraint: FK_bas_act_sub_per_ori_id__per_id
Source: persons -> id
Target: baseball_action_substitutions -> person_original_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_sub_per_ori_pos_id__pos_id
Constraint: FK_bas_act_sub_per_ori_pos_id__pos_id
Source: positions -> id
Target: baseball_action_substitutions -> person_original_position_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_act_sub_per_rep_id__per_id
Constraint: FK_bas_act_sub_per_rep_id__per_id
Source: persons -> id
Target: baseball_action_substitutions -> person_replacing_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_act_sub_per_rep_pos_id__pos_id
Constraint: FK_bas_act_sub_per_rep_pos_id__pos_id
Source: positions -> id
Target: baseball_action_substitutions -> person_replacing_position_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_def_pla_bas_def_gro_id__bas_def_gro_id
Constraint: FK_bas_def_pla_bas_def_gro_id__bas_def_gro_id
Source: baseball_defensive_group -> id
Target: baseball_defensive_players -> baseball_defensive_group_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_def_pla_pla_id__per_id
Constraint: FK_bas_def_pla_pla_id__per_id
Source: persons -> id
Target: baseball_defensive_players -> player_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_def_pla_pos_id__pos_id
Constraint: FK_bas_def_pla_pos_id__pos_id
Source: positions -> id
Target: baseball_defensive_players -> position_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_eve_sta_bat_id__per_id
Constraint: FK_bas_eve_sta_bat_id__per_id
Source: persons -> id
Target: baseball_event_states -> batter_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_eve_sta_eve_id__eve_id
Constraint: FK_bas_eve_sta_eve_id__eve_id
Source: events -> id
Target: baseball_event_states -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_bas_eve_sta_pit_id__per_id
Constraint: FK_bas_eve_sta_pit_id__per_id
Source: persons -> id
Target: baseball_event_states -> pitcher_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_eve_sta_run_on_fir_id__per_id
Constraint: FK_bas_eve_sta_run_on_fir_id__per_id
Source: persons -> id
Target: baseball_event_states -> runner_on_first_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_eve_sta_run_on_sec_id__per_id
Constraint: FK_bas_eve_sta_run_on_sec_id__per_id
Source: persons -> id
Target: baseball_event_states -> runner_on_second_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_bas_eve_sta_run_on_thi_id__per_id
Constraint: FK_bas_eve_sta_run_on_thi_id__per_id
Source: persons -> id
Target: baseball_event_states -> runner_on_third_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_boo_loc_id__loc_id
Constraint: FK_boo_loc_id__loc_id
Source: locations -> id
Target: bookmakers -> location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_boo_pub_id__pub_id
Constraint: FK_boo_pub_id__pub_id
Source: publishers -> id
Target: bookmakers -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_cor_per_sta_pos_id__pos_id
Constraint: FK_cor_per_sta_pos_id__pos_id
Source: positions -> id
Target: core_person_stats -> position_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_con_doc_id__doc_id
Constraint: FK_doc_con_doc_id__doc_id
Source: documents -> id
Target: document_contents -> document_id
Cardinality: 1    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_doc_fix_id__doc_fix_id
Constraint: FK_doc_doc_fix_id__doc_fix_id
Source: document_fixtures -> id
Target: documents -> document_fixture_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_fix_doc_cla_id__doc_cla_id
Constraint: FK_doc_fix_doc_cla_id__doc_cla_id
Source: document_classes -> id
Target: document_fixtures -> document_class_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_fix_eve_doc_fix_id__doc_fix_id
Constraint: FK_doc_fix_eve_doc_fix_id__doc_fix_id
Source: document_fixtures -> id
Target: document_fixtures_events -> document_fixture_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_fix_eve_eve_id__eve_id
Constraint: FK_doc_fix_eve_eve_id__eve_id
Source: events -> id
Target: document_fixtures_events -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_fix_eve_lat_doc_id__doc_id
Constraint: FK_doc_fix_eve_lat_doc_id__doc_id
Source: documents -> id
Target: document_fixtures_events -> latest_document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_fix_pub_id__pub_id
Constraint: FK_doc_fix_pub_id__pub_id
Source: publishers -> id
Target: document_fixtures -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_med_doc_id__doc_id
Constraint: FK_doc_med_doc_id__doc_id
Source: documents -> id
Target: documents_media -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_med_med_cap_id__med_cap_id
Constraint: FK_doc_med_med_cap_id__med_cap_id
Source: media_captions -> id
Target: documents_media -> media_caption_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_med_med_id__med_id
Constraint: FK_doc_med_med_id__med_id
Source: media -> id
Target: documents_media -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_pac_ent_doc_id__doc_id
Constraint: FK_doc_pac_ent_doc_id__doc_id
Source: documents -> id
Target: document_package_entry -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_pac_ent_doc_pac_id__doc_pac_id
Constraint: FK_doc_pac_ent_doc_pac_id__doc_pac_id
Source: document_packages -> id
Target: document_package_entry -> document_package_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_pub_id__pub_id
Constraint: FK_doc_pub_id__pub_id
Source: publishers -> id
Target: documents -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_doc_sou_id__pub_id
Constraint: FK_doc_sou_id__pub_id
Source: publishers -> id
Target: documents -> source_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_eve_doc_doc_id__doc_id
Constraint: FK_eve_doc_doc_id__doc_id
Source: documents -> id
Target: events_documents -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_doc_eve_id__eve_id
Constraint: FK_eve_doc_eve_id__eve_id
Source: events -> id
Target: events_documents -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_med_eve_id__eve_id
Constraint: FK_eve_med_eve_id__eve_id
Source: events -> id
Target: events_media -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_med_med_id__med_id
Constraint: FK_eve_med_med_id__med_id
Source: media -> id
Target: events_media -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_pub_id__pub_id
Constraint: FK_eve_pub_id__pub_id
Source: publishers -> id
Target: events -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_sit_id__sit_id
Constraint: FK_eve_sit_id__sit_id
Source: sites -> id
Target: events -> site_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_eve_sub_sea_eve_id__eve_id
Constraint: FK_eve_sub_sea_eve_id__eve_id
Source: events -> id
Target: events_sub_seasons -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_eve_sub_sea_sub_sea_id__sub_sea_id
Constraint: FK_eve_sub_sea_sub_sea_id__sub_sea_id
Source: sub_seasons -> id
Target: events_sub_seasons -> sub_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_inj_pha_per_id__per_id
Constraint: FK_inj_pha_per_id__per_id
Source: persons -> id
Target: injury_phases -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_inj_pha_sea_id__sea_id
Constraint: FK_inj_pha_sea_id__sea_id
Source: seasons -> id
Target: injury_phases -> season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_key_ali_pub_id__pub_id
Constraint: FK_key_ali_pub_id__pub_id
Source: publishers -> id
Target: key_aliases -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_lat_rev_lat_doc_id__doc_id
Constraint: FK_lat_rev_lat_doc_id__doc_id
Source: documents -> id
Target: latest_revisions -> latest_document_id
Cardinality: 1    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_cap_cap_aut_id__per_id
Constraint: FK_med_cap_cap_aut_id__per_id
Source: persons -> id
Target: media_captions -> caption_author_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_cap_med_id__med_id
Constraint: FK_med_cap_med_id__med_id
Source: media -> id
Target: media_captions -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_con_med_id__med_id
Constraint: FK_med_con_med_id__med_id
Source: media -> id
Target: media_contents -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_cre_id__per_id
Constraint: FK_med_cre_id__per_id
Source: persons -> id
Target: media -> credit_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_cre_loc_id__loc_id
Constraint: FK_med_cre_loc_id__loc_id
Source: locations -> id
Target: media -> creation_location_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_key_med_id__med_id
Constraint: FK_med_key_med_id__med_id
Source: media -> id
Target: media_keywords -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_med_pub_id__pub_id
Constraint: FK_med_pub_id__pub_id
Source: publishers -> id
Target: media -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_out_tot_sta_sub_id__sta_sub_id
Constraint: FK_out_tot_sta_sub_id__sta_sub_id
Source: standing_subgroups -> id
Target: outcome_totals -> standing_subgroup_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_par_eve_eve_id__eve_id
Constraint: FK_par_eve_eve_id__eve_id
Source: events -> id
Target: participants_events -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_bir_loc_id__loc_id
Constraint: FK_per_bir_loc_id__loc_id
Source: locations -> id
Target: persons -> birth_location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_cur_inj_pha_id__inj_pha_id
Constraint: FK_per_cur_inj_pha_id__inj_pha_id
Source: injury_phases -> id
Target: persons -> current_injury_phase_id
Cardinality: 1    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_cur_lea_pha_id__per_pha_id
Constraint: FK_per_cur_lea_pha_id__per_pha_id
Source: person_phases -> id
Target: persons -> current_league_phase_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_cur_tea_pha_id__per_pha_id
Constraint: FK_per_cur_tea_pha_id__per_pha_id
Source: person_phases -> id
Target: persons -> current_team_phase_id
Cardinality: 1    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_dea_loc_id__loc_id
Constraint: FK_per_dea_loc_id__loc_id
Source: locations -> id
Target: persons -> death_location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_doc_doc_id__doc_id
Constraint: FK_per_doc_doc_id__doc_id
Source: documents -> id
Target: persons_documents -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_doc_per_id__per_id
Constraint: FK_per_doc_per_id__per_id
Source: persons -> id
Target: persons_documents -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_eve_met_eve_id__eve_id
Constraint: FK_per_eve_met_eve_id__eve_id
Source: events -> id
Target: person_event_metadata -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_eve_met_per_id__per_id
Constraint: FK_per_eve_met_per_id__per_id
Source: persons -> id
Target: person_event_metadata -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_eve_met_pos_id__pos_id
Constraint: FK_per_eve_met_pos_id__pos_id
Source: positions -> id
Target: person_event_metadata -> position_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_eve_met_rol_id__rol_id
Constraint: FK_per_eve_met_rol_id__rol_id
Source: roles -> id
Target: person_event_metadata -> role_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_hom_loc_id__loc_id
Constraint: FK_per_hom_loc_id__loc_id
Source: locations -> id
Target: persons -> hometown_location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_per_med_med_id__med_id
Constraint: FK_per_med_med_id__med_id
Source: media -> id
Target: persons_media -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_med_per_id__per_id
Constraint: FK_per_med_per_id__per_id
Source: persons -> id
Target: persons_media -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_par_eve_id__par_eve_id
Constraint: FK_per_par_eve_id__par_eve_id
Source: participants_events -> id
Target: periods -> participant_event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pha_end_sea_id__sea_id
Constraint: FK_per_pha_end_sea_id__sea_id
Source: seasons -> id
Target: person_phases -> end_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pha_per_id__per_id
Constraint: FK_per_pha_per_id__per_id
Source: persons -> id
Target: person_phases -> person_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pha_reg_pos_id__pos_id
Constraint: FK_per_pha_reg_pos_id__pos_id
Source: positions -> id
Target: person_phases -> regular_position_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pha_rol_id__rol_id
Constraint: FK_per_pha_rol_id__rol_id
Source: roles -> id
Target: person_phases -> role_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pha_sta_sea_id__sea_id
Constraint: FK_per_pha_sta_sea_id__sea_id
Source: seasons -> id
Target: person_phases -> start_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_pub_id__pub_id
Constraint: FK_per_pub_id__pub_id
Source: publishers -> id
Target: persons -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_per_res_loc_id__loc_id
Constraint: FK_per_res_loc_id__loc_id
Source: locations -> id
Target: persons -> residence_location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_pos_aff_id__aff_id
Constraint: FK_pos_aff_id__aff_id
Source: affiliations -> id
Target: positions -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sea_lea_id__aff_id
Constraint: FK_sea_lea_id__aff_id
Source: affiliations -> id
Target: seasons -> league_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sea_pub_id__pub_id
Constraint: FK_sea_pub_id__pub_id
Source: publishers -> id
Target: seasons -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sit_loc_id__loc_id
Constraint: FK_sit_loc_id__loc_id
Source: locations -> id
Target: sites -> location_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_sit_pub_id__pub_id
Constraint: FK_sit_pub_id__pub_id
Source: publishers -> id
Target: sites -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sta_aff_id__aff_id
Constraint: FK_sta_aff_id__aff_id
Source: affiliations -> id
Target: standings -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sta_pub_id__pub_id
Constraint: FK_sta_pub_id__pub_id
Source: publishers -> id
Target: standings -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sta_sub_aff_id__aff_id
Constraint: FK_sta_sub_aff_id__aff_id
Source: affiliations -> id
Target: standing_subgroups -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sta_sub_sea_id__sub_sea_id
Constraint: FK_sta_sub_sea_id__sub_sea_id
Source: sub_seasons -> id
Target: standings -> sub_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sta_sub_sta_id__sta_id
Constraint: FK_sta_sub_sta_id__sta_id
Source: standings -> id
Target: standing_subgroups -> standing_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sub_per_per_id__per_id
Constraint: FK_sub_per_per_id__per_id
Source: periods -> id
Target: sub_periods -> period_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_sub_sea_sea_id__sea_id
Constraint: FK_sub_sea_sea_id__sea_id
Source: seasons -> id
Target: sub_seasons -> season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_aff_pha_aff_id__aff_id
Constraint: FK_tea_aff_pha_aff_id__aff_id
Source: affiliations -> id
Target: team_affiliation_phases -> affiliation_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_aff_pha_end_sea_id__sea_id
Constraint: FK_tea_aff_pha_end_sea_id__sea_id
Source: seasons -> id
Target: team_affiliation_phases -> end_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_aff_pha_rol_id__rol_id
Constraint: FK_tea_aff_pha_rol_id__rol_id
Source: roles -> id
Target: team_affiliation_phases -> role_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_tea_aff_pha_sta_sea_id__sea_id
Constraint: FK_tea_aff_pha_sta_sea_id__sea_id
Source: seasons -> id
Target: team_affiliation_phases -> start_season_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_aff_pha_tea_id__tea_id
Constraint: FK_tea_aff_pha_tea_id__tea_id
Source: teams -> id
Target: team_affiliation_phases -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_doc_doc_id__doc_id
Constraint: FK_tea_doc_doc_id__doc_id
Source: documents -> id
Target: teams_documents -> document_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_doc_tea_id__tea_id
Constraint: FK_tea_doc_tea_id__tea_id
Source: teams -> id
Target: teams_documents -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_hom_sit_id__sit_id
Constraint: FK_tea_hom_sit_id__sit_id
Source: sites -> id
Target: teams -> home_site_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_tea_lea_id__aff_id
Constraint: FK_tea_lea_id__aff_id
Source: affiliations -> id
Target: teams -> league_id
Cardinality: 0..n    Parent Mandatory: NO
On Update: None
On Delete: None



FK_tea_med_med_id__med_id
Constraint: FK_tea_med_med_id__med_id
Source: media -> id
Target: teams_media -> media_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_med_tea_id__tea_id
Constraint: FK_tea_med_tea_id__tea_id
Source: teams -> id
Target: teams_media -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_tea_pub_id__pub_id
Constraint: FK_tea_pub_id__pub_id
Source: publishers -> id
Target: teams -> publisher_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_mon_boo_id__boo_id
Constraint: FK_wag_mon_boo_id__boo_id
Source: bookmakers -> id
Target: wagering_moneylines -> bookmaker_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_mon_eve_id__eve_id
Constraint: FK_wag_mon_eve_id__eve_id
Source: events -> id
Target: wagering_moneylines -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_mon_tea_id__tea_id
Constraint: FK_wag_mon_tea_id__tea_id
Source: teams -> id
Target: wagering_moneylines -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_odd_lin_boo_id__boo_id
Constraint: FK_wag_odd_lin_boo_id__boo_id
Source: bookmakers -> id
Target: wagering_odds_lines -> bookmaker_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_odd_lin_eve_id__eve_id
Constraint: FK_wag_odd_lin_eve_id__eve_id
Source: events -> id
Target: wagering_odds_lines -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_odd_lin_tea_id__tea_id
Constraint: FK_wag_odd_lin_tea_id__tea_id
Source: teams -> id
Target: wagering_odds_lines -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_run_boo_id__boo_id
Constraint: FK_wag_run_boo_id__boo_id
Source: bookmakers -> id
Target: wagering_runlines -> bookmaker_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_run_eve_id__eve_id
Constraint: FK_wag_run_eve_id__eve_id
Source: events -> id
Target: wagering_runlines -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_run_tea_id__tea_id
Constraint: FK_wag_run_tea_id__tea_id
Source: teams -> id
Target: wagering_runlines -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_str_spr_lin_boo_id__boo_id
Constraint: FK_wag_str_spr_lin_boo_id__boo_id
Source: bookmakers -> id
Target: wagering_straight_spread_lines -> bookmaker_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_str_spr_lin_eve_id__eve_id
Constraint: FK_wag_str_spr_lin_eve_id__eve_id
Source: events -> id
Target: wagering_straight_spread_lines -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_str_spr_lin_tea_id__tea_id
Constraint: FK_wag_str_spr_lin_tea_id__tea_id
Source: teams -> id
Target: wagering_straight_spread_lines -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_tot_sco_lin_boo_id__boo_id
Constraint: FK_wag_tot_sco_lin_boo_id__boo_id
Source: bookmakers -> id
Target: wagering_total_score_lines -> bookmaker_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_tot_sco_lin_eve_id__eve_id
Constraint: FK_wag_tot_sco_lin_eve_id__eve_id
Source: events -> id
Target: wagering_total_score_lines -> event_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wag_tot_sco_lin_tea_id__tea_id
Constraint: FK_wag_tot_sco_lin_tea_id__tea_id
Source: teams -> id
Target: wagering_total_score_lines -> team_id
Cardinality: 0..n    Parent Mandatory: YES
On Update: None
On Delete: None



FK_wea_con_eve_id__eve_id
Constraint: FK_wea_con_eve_id__eve_id
Source: events -> id
Target: weather_conditions -> event_id
Cardinality: 0..1    Parent Mandatory: YES
On Update: None
On Delete: None