Shared column schema: espn mbb team schedule schema

Columns shared verbatim across: espn_mbb_team_schedule, espn_nba_team_schedule.

Details

col_name	types	description
event_id	character	Unique event / game identifier (ESPN).
season	integer	Season identifier (4-digit year or 'YYYY-YY' string).
season_type	integer	Season type (1=pre-season, 2=regular season, 3=postseason, 4=off-season for ESPN; or string label for WNBA Stats).
week	integer	Week number within the season.
date	character	Date in YYYY-MM-DD format.
name	character	Display name.
short_name	character	Short display name.
opponent_id	character	Unique identifier for opponent.
opponent_abbrev	character	Abbreviation for opponent.
home_away	character	Game venue label ('home' or 'away').
neutral_site	logical	Neutral site.
conference_competition	logical	Conference competition.
venue_id	character	Unique venue identifier.
venue_name	character	Venue name.
venue_city	character	Venue city.
venue_state	character	Venue state / region.
broadcast	character	Broadcast information string.
result	character	Result.
team_score	character	Team's score / final score.
opponent_score	character	Opponent score.
winner	logical	Winner.