Schema ReferenceHalf-Court MapStar Reference110 waypoints

Court Geometry

Schema Reference — Star

Complete schema docs for star tier

Browse Schema Reference Next best page Open docs map

Generated pageCommand-ownedSchema metadata

Generated schema contract

Use star reference as the exact warehouse contract

This is the scorebook for the public model. Use it to verify final columns, constraints, and foreign keys, then switch to curated schema pages when you need table selection, grain guidance, or join patterns.

Best for

Final contracts

verify the exact public schema that analysts, tests, and exports depend on

Best clue

Public grain

the table name and constraint block tell you how to query without inventing columns

Ownership

Command-owned

regenerate from schema metadata instead of hand-editing

How to work this page

Pick the public table family before reading columns

Dimensions, facts, bridges, derived tables, and analytics views all surface different grains and workloads.

Use constraints to keep joins honest

Foreign keys and nullability often answer the real question faster than the descriptions alone.

Switch to curated pages for judgment calls

This page proves what exists; curated schema pages help you choose the right surface for the analysis.

Quick scan

Choose the warehouse family before reading the contract

Dimensions, facts, bridges, rollups, and analytics views answer different questions. Start there, then read the exact schema block.

109 schema blocks5 Public familiesTOC-driven

Generated public surfaces grouped by table family.

__team_dashboard_fantasy_metrics_mixin __team_dashboard_fantasy_ranks_mixin __team_dashboard_field_goal_metrics_mixin __team_dashboard_field_goal_ranks_mixin __team_dashboard_group_set_mixin __team_dashboard_grouping_mixin

+7 more in the page TOC and section list.

Dimensions

Stable entity, calendar, venue, and lookup anchors.

dim_arena dim_coach dim_college dim_date dim_game dim_official

+7 more in the page TOC and section list.

Facts

Event and measurement tables at analyst-facing grain.

fact_box_score_four_factors fact_defense_hub_detail fact_defense_hub fact_draft fact_estimated_metrics fact_game_leaders

+56 more in the page TOC and section list.

Bridges

Connector tables for many-to-many joins and role replay.

bridge_game_official bridge_game_team bridge_lineup_player bridge_play_player bridge_player_team_season

Rollups

Derived aggregate surfaces for quicker trend reads.

agg_all_time_leaders agg_clutch_stats agg_league_leaders agg_lineup_efficiency agg_on_off_splits agg_player_bio

+10 more in the page TOC and section list.

Schema Reference — Star

This tier contains 109 schema(s).

`agg_all_time_leaders`

Class: AggAllTimeLeadersSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`player_name`	`String`	No	—
`pts`	`Int64`	Yes	—
`ast`	`Int64`	Yes	—
`reb`	`Int64`	Yes	—
`pts_rank`	`Int64`	No	—
`ast_rank`	`Int64`	No	—
`reb_rank`	`Int64`	No	—

`agg_clutch_stats`

Class: AggClutchStatsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	Yes	gt=0
`season_year`	`String`	Yes	—
`clutch_gp`	`Int64`	Yes	—
`clutch_min`	`Float64`	Yes	—
`clutch_pts`	`Float64`	Yes	—
`clutch_fg_pct`	`Float64`	Yes	—
`clutch_ft_pct`	`Float64`	Yes	—
`league_clutch_pts`	`Float64`	Yes	—
`league_clutch_fg_pct`	`Float64`	Yes	—

`agg_league_leaders`

Class: AggLeagueLeadersSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	Yes	—
`avg_pts`	`Float64`	Yes	—
`avg_reb`	`Float64`	Yes	—
`avg_ast`	`Float64`	Yes	—
`avg_stl`	`Float64`	Yes	—
`avg_blk`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`pts_rank`	`Int64`	No	—
`reb_rank`	`Int64`	No	—
`ast_rank`	`Int64`	No	—
`stl_rank`	`Int64`	No	—
`blk_rank`	`Int64`	No	—

`agg_lineup_efficiency`

Class: AggLineupEfficiencySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`group_id`	`String`	No	—
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`total_gp`	`Int64`	Yes	—
`total_min`	`Float64`	Yes	—
`pts_per48`	`Float64`	Yes	—
`avg_net_rating`	`Float64`	Yes	—
`total_plus_minus`	`Float64`	Yes	—

`agg_on_off_splits`

Class: AggOnOffSplitsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`entity_type`	`String`	No	in=['player', 'team', 'player_detail']
`entity_id`	`Int64`	Yes	gt=0
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`on_off`	`String`	No	—
`gp`	`Int64`	Yes	—
`min`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`off_rating`	`Float64`	Yes	—
`def_rating`	`Float64`	Yes	—
`net_rating`	`Float64`	Yes	—

`agg_player_bio`

Class: AggPlayerBioSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`player_name`	`String`	No	—
`team_id`	`Int64`	Yes	gt=0
`team_abbreviation`	`String`	Yes	—
`age`	`Float64`	Yes	—
`player_height`	`String`	Yes	—
`player_height_inches`	`Float64`	Yes	—
`player_weight`	`String`	Yes	—
`college`	`String`	Yes	—
`country`	`String`	Yes	—
`draft_year`	`String`	Yes	—
`draft_round`	`String`	Yes	—
`draft_number`	`String`	Yes	—
`gp`	`Int64`	Yes	—
`pts`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`net_rating`	`Float64`	Yes	—
`oreb_pct`	`Float64`	Yes	—
`dreb_pct`	`Float64`	Yes	—
`usg_pct`	`Float64`	Yes	—
`ts_pct`	`Float64`	Yes	—
`ast_pct`	`Float64`	Yes	—
`season_year`	`String`	No	—

`agg_player_career`

Class: AggPlayerCareerSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`career_gp`	`Int64`	Yes	—
`career_min`	`Float64`	Yes	—
`career_pts`	`Float64`	Yes	—
`career_ppg`	`Float64`	Yes	—
`career_rpg`	`Float64`	Yes	—
`career_apg`	`Float64`	Yes	—
`career_spg`	`Float64`	Yes	—
`career_bpg`	`Float64`	Yes	—
`career_fg_pct`	`Float64`	Yes	—
`career_fg3_pct`	`Float64`	Yes	—
`career_ft_pct`	`Float64`	Yes	—
`first_season`	`String`	Yes	—
`last_season`	`String`	Yes	—
`seasons_played`	`Int64`	Yes	—

`agg_player_rolling`

Class: AggPlayerRollingSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`game_id`	`String`	No	—
`player_id`	`Int64`	No	gt=0
`game_date`	`String`	No	—
`pts_roll5`	`Float64`	Yes	—
`reb_roll5`	`Float64`	Yes	—
`ast_roll5`	`Float64`	Yes	—
`pts_roll10`	`Float64`	Yes	—
`reb_roll10`	`Float64`	Yes	—
`ast_roll10`	`Float64`	Yes	—
`pts_roll20`	`Float64`	Yes	—
`reb_roll20`	`Float64`	Yes	—
`ast_roll20`	`Float64`	Yes	—

`agg_player_season_per36`

Class: AggPlayerSeasonPer36Schema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	No	—
`avg_min`	`Float64`	Yes	—
`pts_per36`	`Float64`	Yes	—
`reb_per36`	`Float64`	Yes	—
`ast_per36`	`Float64`	Yes	—
`stl_per36`	`Float64`	Yes	—
`blk_per36`	`Float64`	Yes	—
`tov_per36`	`Float64`	Yes	—

`agg_player_season_per48`

Class: AggPlayerSeasonPer48Schema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	No	—
`avg_min`	`Float64`	Yes	—
`pts_per48`	`Float64`	Yes	—
`reb_per48`	`Float64`	Yes	—
`ast_per48`	`Float64`	Yes	—
`stl_per48`	`Float64`	Yes	—
`blk_per48`	`Float64`	Yes	—
`tov_per48`	`Float64`	Yes	—

`agg_player_season`

Class: AggPlayerSeasonSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	No	—
`total_min`	`Float64`	Yes	—
`avg_min`	`Float64`	Yes	—
`total_pts`	`Float64`	Yes	—
`avg_pts`	`Float64`	Yes	—
`total_reb`	`Float64`	Yes	—
`avg_reb`	`Float64`	Yes	—
`total_ast`	`Float64`	Yes	—
`avg_ast`	`Float64`	Yes	—
`total_stl`	`Float64`	Yes	—
`avg_stl`	`Float64`	Yes	—
`total_blk`	`Float64`	Yes	—
`avg_blk`	`Float64`	Yes	—
`total_tov`	`Float64`	Yes	—
`avg_tov`	`Float64`	Yes	—
`total_fgm`	`Float64`	Yes	—
`total_fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`total_fg3m`	`Float64`	Yes	—
`total_fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`total_ftm`	`Float64`	Yes	—
`total_fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`avg_off_rating`	`Float64`	Yes	—
`avg_def_rating`	`Float64`	Yes	—
`avg_net_rating`	`Float64`	Yes	—
`avg_ts_pct`	`Float64`	Yes	—
`avg_usg_pct`	`Float64`	Yes	—
`avg_pie`	`Float64`	Yes	—

`agg_shot_location_season`

Class: AggShotLocationSeasonSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`fgm`	`Int64`	Yes	—
`season_fgm_rank`	`Int64`	No	—

`agg_shot_zones`

Class: AggShotZonesSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`player_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`zone_basic`	`String`	Yes	—
`zone_area`	`String`	Yes	—
`zone_range`	`String`	Yes	—
`attempts`	`Int64`	Yes	—
`makes`	`Int64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`avg_distance`	`Float64`	Yes	—

`agg_team_franchise`

Class: AggTeamFranchiseSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`team_city`	`String`	Yes	—
`team_name`	`String`	Yes	—
`start_year`	`Int64`	Yes	—
`end_year`	`Int64`	Yes	—
`years`	`Int64`	Yes	—
`games`	`Int64`	Yes	—
`wins`	`Int64`	Yes	—
`losses`	`Int64`	Yes	—
`win_pct`	`Float64`	Yes	—
`po_appearances`	`Int64`	Yes	—
`div_titles`	`Int64`	Yes	—
`conf_titles`	`Int64`	Yes	—
`league_titles`	`Int64`	Yes	—
`franchise_age_years`	`Int64`	Yes	—
`computed_win_pct`	`Float64`	Yes	—

`agg_team_pace_and_efficiency`

Class: AggTeamPaceAndEfficiencySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	No	—
`avg_pace`	`Float64`	Yes	—
`avg_ortg`	`Float64`	Yes	—
`avg_drtg`	`Float64`	Yes	—
`avg_net_rtg`	`Float64`	Yes	—

`agg_team_season`

Class: AggTeamSeasonSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`season_year`	`String`	No	—
`season_type`	`String`	No	—
`gp`	`Int64`	No	—
`avg_pts`	`Float64`	Yes	—
`avg_reb`	`Float64`	Yes	—
`avg_ast`	`Float64`	Yes	—
`avg_stl`	`Float64`	Yes	—
`avg_blk`	`Float64`	Yes	—
`avg_tov`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—

`bridge_game_official`

Class: BridgeGameOfficialSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`official_id`	`Int64`	No	gt=0, FK→dim_official.official_id	Official identifier
`jersey_num`	`String`	Yes	—	Official jersey number

`bridge_game_team`

Class: BridgeGameTeamSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`side`	`String`	No	in=['home', 'away']	Home or away designation
`wl`	`String`	Yes	in=['W', 'L']	Win or loss result
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`bridge_lineup_player`

Class: BridgeLineupPlayerSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`group_id`	`String`	No	FK→fact_lineup_stats.group_id	Lineup group identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player in lineup
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`position_in_lineup`	`Int64`	Yes	—	Position index in lineup (1-5)
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`bridge_play_player`

Class: BridgePlayPlayerSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`event_num`	`Int64`	No	—	Event sequence number
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player involved in play
`team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Player team identifier
`player_role`	`String`	No	in=['primary', 'secondary', 'tertiary']	Role in play event

`bridge_player_team_season`

Class: BridgePlayerTeamSeasonSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`jersey_number`	`String`	Yes	—	Jersey number for season
`position`	`String`	Yes	—	Position played for season

`dim_arena`

Class: DimArenaSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`arena_id`	`Int64`	No	gt=0	Surrogate arena identifier
`arena_name`	`String`	No	—	Arena name
`city`	`String`	Yes	—	Arena city
`state`	`String`	Yes	—	Arena state
`country`	`String`	Yes	—	Arena country

`dim_coach`

Class: DimCoachSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`coach_id`	`Int64`	No	gt=0	Unique coach identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`season_year`	`String`	No	FK→dim_season.season_year	Season year (e.g. 2024-25)
`first_name`	`String`	Yes	—	Coach first name
`last_name`	`String`	Yes	—	Coach last name
`coach_type`	`String`	Yes	—	Coach type (Head Coach, etc.)
`is_assistant`	`Boolean`	Yes	—	Whether coach is assistant

`dim_college`

Class: DimCollegeSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`college_id`	`Int64`	No	gt=0	Surrogate college identifier
`college_name`	`String`	No	—	College name

`dim_date`

Class: DimDateSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`date_key`	`Int64`	No	gt=0	Integer date key YYYYMMDD
`full_date`	`String`	No	—	Calendar date string
`year`	`Int64`	No	—	Calendar year
`month`	`Int64`	No	—	Calendar month (1-12)
`day`	`Int64`	No	—	Day of month (1-31)
`day_of_week`	`Int64`	No	—	Day of week (1=Monday, 7=Sunday)
`day_name`	`String`	No	—	Day name (Monday-Sunday)
`month_name`	`String`	No	—	Month name (January-December)
`is_weekend`	`Boolean`	No	—	Whether date is Saturday/Sunday
`nba_season`	`String`	Yes	—	NBA season (e.g. 2024-25)
`nba_phase`	`String`	Yes	—	NBA season phase name

`dim_game`

Class: DimGameSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	—	Primary key — NBA game identifier
`game_date`	`String`	No	—	Date the game was played
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`season_type`	`String`	Yes	—	Season type (Regular Season, Playoffs, etc.)
`home_team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Home team identifier
`visitor_team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Visitor team identifier
`matchup`	`String`	Yes	—	Matchup string (e.g. LAL vs. BOS)
`arena_name`	`String`	Yes	—	Arena name
`arena_city`	`String`	Yes	—	Arena city

`dim_official`

Class: DimOfficialSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`official_id`	`Int64`	No	gt=0	Unique official identifier
`first_name`	`String`	Yes	—	Official first name
`last_name`	`String`	Yes	—	Official last name
`jersey_num`	`String`	Yes	—	Official jersey number

`dim_play_event_type`

Class: DimPlayEventTypeSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`event_type_id`	`Int64`	No	gt=0	Play event type identifier
`event_type_name`	`String`	No	—	Event type name (e.g. made_shot)
`event_category`	`String`	Yes	—	Event category grouping

`dim_player`

Class: DimPlayerSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_sk`	`Int64`	No	gt=0	Surrogate key for SCD2 player
`player_id`	`Int64`	No	gt=0	Natural key — NBA player identifier
`full_name`	`String`	No	—	Player full name
`first_name`	`String`	Yes	—	Player first name
`last_name`	`String`	Yes	—	Player last name
`is_active`	`Boolean`	Yes	—	Whether player is active
`team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Current team identifier
`position`	`String`	Yes	—	Player position
`jersey_number`	`String`	Yes	—	Jersey number
`height`	`String`	Yes	—	Player height
`weight`	`Int64`	Yes	—	Player weight in lbs
`birth_date`	`String`	Yes	—	Date of birth
`country`	`String`	Yes	—	Country of origin
`college_id`	`Int64`	Yes	gt=0, FK→dim_college.college_id	College identifier
`draft_year`	`Int64`	Yes	—	Draft year
`draft_round`	`Int64`	Yes	—	Draft round
`draft_number`	`Int64`	Yes	—	Draft pick number
`from_year`	`Int64`	Yes	—	First year in the league
`to_year`	`Int64`	Yes	—	Last year in the league
`valid_from`	`String`	No	—	SCD2 valid-from season
`valid_to`	`String`	Yes	—	SCD2 valid-to season
`is_current`	`Boolean`	No	—	Whether this is the current record

`dim_season_phase`

Class: DimSeasonPhaseSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`phase_id`	`Int64`	No	gt=0	Season phase identifier
`phase_name`	`String`	No	—	Phase name (e.g. Regular, Playoffs)
`phase_order`	`Int64`	No	gt=0	Sort order of phase in season

`dim_season`

Class: DimSeasonSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`start_date`	`String`	Yes	—	First game date of season
`end_date`	`String`	Yes	—	Last game date of season
`all_star_date`	`String`	Yes	—	All-Star game date
`playoff_start_date`	`String`	Yes	—	Playoff start date

`dim_shot_zone`

Class: DimShotZoneSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`zone_id`	`Int64`	No	gt=0	Surrogate shot zone identifier
`zone_basic`	`String`	No	—	Basic zone name
`zone_area`	`String`	No	—	Zone area (e.g. Left Side)
`zone_range`	`String`	No	—	Zone range (e.g. 16-24 ft.)

`dim_team_history`

Class: DimTeamHistorySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`team_history_sk`	`Int64`	No	gt=0	Surrogate key for SCD2 versioning
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`city`	`String`	Yes	—	Team city for this version
`nickname`	`String`	Yes	—	Team nickname for this version
`abbreviation`	`String`	Yes	—	Team abbreviation for this version
`franchise_name`	`String`	Yes	—	Franchise name
`league_id`	`String`	Yes	—	League identifier
`valid_from`	`String`	No	—	Season when this version became active
`valid_to`	`String`	Yes	—	Season of next change; NULL = current
`is_current`	`Boolean`	No	—	TRUE if this is the current version

`dim_team`

Class: DimTeamSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`team_id`	`Int64`	No	gt=0	NBA team identifier
`abbreviation`	`String`	No	—	Team abbreviation (e.g. LAL)
`full_name`	`String`	No	—	Full team name
`city`	`String`	Yes	—	Team city
`state`	`String`	Yes	—	Team state
`arena`	`String`	Yes	—	Home arena name
`year_founded`	`Int64`	Yes	gt=1900	Year team was founded
`conference`	`String`	Yes	—	Conference (East/West)
`division`	`String`	Yes	—	Division name

`fact_box_score_four_factors`

Class: FactBoxScoreFourFactorsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	FK→dim_team.team_id	Team identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Unique player identifier
`effective_field_goal_percentage`	`Float64`	Yes	—	Effective field goal percentage
`free_throw_attempt_rate`	`Float64`	Yes	—	Free throw attempt rate
`team_turnover_percentage`	`Float64`	Yes	—	Team turnover percentage
`offensive_rebound_percentage`	`Float64`	Yes	—	Offensive rebound percentage
`opp_effective_field_goal_percentage`	`Float64`	Yes	—	Opponent effective field goal percentage
`opp_free_throw_attempt_rate`	`Float64`	Yes	—	Opponent free throw attempt rate
`opp_team_turnover_percentage`	`Float64`	Yes	—	Opponent team turnover percentage
`opp_offensive_rebound_percentage`	`Float64`	Yes	—	Opponent offensive rebound percentage

`fact_defense_hub_detail`

Class: FactDefenseHubDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`defense_metric`	`String`	No	—	Normalized defense-hub metric discriminator
`rank`	`Int64`	Yes	gt=0	Rank within the defense hub metric lane
`team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Team identifier when present
`team_abbreviation`	`String`	Yes	—	Team abbreviation when present
`team_name`	`String`	Yes	—	Team display name when present
`season_type`	`String`	Yes	—	Season type used for the defense hub request
`stat_value`	`Float64`	Yes	—	Metric value for the selected defense hub lane

`fact_defense_hub`

Class: FactDefenseHubSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`rank`	`Int64`	Yes	gt=0	Rank within the base defense-hub packet
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	No	—	Team abbreviation
`team_name`	`String`	No	—	Team display name
`dreb`	`Float64`	Yes	—	Defensive rebounds value from the base defense-hub packet
`season_type`	`String`	Yes	—	Season type used for the defense-hub request

`fact_draft`

Class: FactDraftSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`person_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Drafted player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Drafting team identifier
`season`	`String`	No	—	Draft season year
`round_number`	`Int64`	Yes	—	Draft round (1 or 2)
`round_pick`	`Int64`	Yes	—	Pick number within round
`overall_pick`	`Int64`	Yes	—	Overall pick number
`player_name`	`String`	Yes	—	Player full name
`organization`	`String`	Yes	—	College or organization
`organization_type`	`String`	Yes	—	Type (College, HS, Intl, etc.)
`player_profile_flag`	`Int64`	Yes	in=[0, 1]	Has player profile (1=yes)

`fact_estimated_metrics`

Class: FactEstimatedMetricsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`gp`	`Int64`	Yes	—	Games played
`w`	`Int64`	Yes	—	Wins
`l`	`Int64`	Yes	—	Losses
`min`	`Float64`	Yes	—	Minutes played
`e_off_rating`	`Float64`	Yes	—	Estimated offensive rating
`e_def_rating`	`Float64`	Yes	—	Estimated defensive rating
`e_net_rating`	`Float64`	Yes	—	Estimated net rating
`e_pace`	`Float64`	Yes	—	Estimated pace
`e_ast_ratio`	`Float64`	Yes	—	Estimated assist ratio
`e_oreb_pct`	`Float64`	Yes	—	Estimated offensive rebound pct
`e_dreb_pct`	`Float64`	Yes	—	Estimated defensive rebound pct
`e_reb_pct`	`Float64`	Yes	—	Estimated total rebound pct
`e_tov_pct`	`Float64`	Yes	—	Estimated turnover percentage
`e_usg_pct`	`Float64`	Yes	—	Estimated usage percentage
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_game_leaders`

Class: FactGameLeadersSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`leader_type`	`String`	No	—	Leader category (home or away)
`person_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Unique player identifier
`name`	`String`	No	—	Player display name
`player_slug`	`String`	Yes	—	Player URL slug
`jersey_num`	`String`	Yes	—	Player jersey number
`position`	`String`	Yes	—	Player position
`team_tricode`	`String`	Yes	—	Three-letter team code
`points`	`Float64`	Yes	—	Points scored
`rebounds`	`Float64`	Yes	—	Total rebounds
`assists`	`Float64`	Yes	—	Total assists

`fact_game_result`

Class: FactGameResultSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`game_date`	`String`	No	—	Game date
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`season_type`	`String`	Yes	—	Season type (Regular, Playoff)
`home_team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Home team identifier
`visitor_team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Visiting team identifier
`wl_home`	`String`	Yes	—	Home team win/loss (W or L)
`pts_home`	`Int64`	Yes	—	Home team points
`pts_away`	`Int64`	Yes	—	Away team points
`plus_minus_home`	`Float64`	Yes	—	Home team plus-minus
`plus_minus_away`	`Float64`	Yes	—	Away team plus-minus
`pts_qtr1_home`	`Int64`	Yes	—	Home team Q1 points
`pts_qtr2_home`	`Int64`	Yes	—	Home team Q2 points
`pts_qtr3_home`	`Int64`	Yes	—	Home team Q3 points
`pts_qtr4_home`	`Int64`	Yes	—	Home team Q4 points
`pts_ot1_home`	`Int64`	Yes	—	Home team OT1 points
`pts_ot2_home`	`Int64`	Yes	—	Home team OT2 points
`pts_qtr1_away`	`Int64`	Yes	—	Away team Q1 points
`pts_qtr2_away`	`Int64`	Yes	—	Away team Q2 points
`pts_qtr3_away`	`Int64`	Yes	—	Away team Q3 points
`pts_qtr4_away`	`Int64`	Yes	—	Away team Q4 points
`pts_ot1_away`	`Int64`	Yes	—	Away team OT1 points
`pts_ot2_away`	`Int64`	Yes	—	Away team OT2 points

`fact_game_scoring`

Class: FactGameScoringSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`side`	`String`	No	in=['home', 'away']	Home or away designation
`period`	`Int64`	No	gt=0	Period number (1-4 qtrs, 5+ OT)
`pts`	`Int64`	Yes	—	Points scored in period
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_homepage_detail`

Class: FactHomepageDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`homepage_metric`	`String`	No	in=['pts', 'reb', 'ast', 'stl', 'fg_pct', 'ft_pct', 'fg3_pct', 'blk']	Homepage leaderboard metric discriminator
`rank`	`Int64`	Yes	gt=0	Rank within the homepage leaderboard lane
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	No	—	Team abbreviation
`team_name`	`String`	No	—	Team display name
`season_type`	`String`	Yes	—	Season type used for the leaderboard request
`stat_value`	`Float64`	Yes	—	Metric value for the selected homepage leaderboard lane

`fact_homepage_leaders_detail`

Class: FactHomepageLeadersDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`leader_variant`	`String`	No	in=['main', 'league_avg', 'league_max']	Homepage leaders result-set variant
`rank`	`Int64`	Yes	gt=0	Rank within the primary homepage leaders packet
`team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Team identifier when the variant is team-scoped
`team_abbreviation`	`String`	Yes	—	Team abbreviation when present
`team_name`	`String`	Yes	—	Team name when present
`season_type`	`String`	Yes	—	Season type used for the leaders request
`pts`	`Float64`	Yes	—	Points value for the variant
`fg_pct`	`Float64`	Yes	—	Field goal percentage for the variant
`fg3_pct`	`Float64`	Yes	—	Three-point percentage for the variant
`ft_pct`	`Float64`	Yes	—	Free throw percentage for the variant
`efg_pct`	`Float64`	Yes	—	Effective field goal percentage for the variant
`ts_pct`	`Float64`	Yes	—	True shooting percentage for the variant
`pts_per48`	`Float64`	Yes	—	Points per 48 minutes for the variant

`fact_homepage_leaders`

Class: FactHomepageLeadersSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`leader_source`	`String`	No	in=['home_page', 'homepage']	Alias source of the homepage leaders packet
`rank`	`Int64`	Yes	gt=0	Rank within the homepage leaders packet
`team_id`	`Int64`	Yes	gt=0, FK→dim_team.team_id	Team identifier
`team_name`	`String`	Yes	—	Team display name
`team_abbreviation`	`String`	Yes	—	Team abbreviation
`pts`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`efg_pct`	`Float64`	Yes	—
`ts_pct`	`Float64`	Yes	—
`pts_per48`	`Float64`	Yes	—
`season_type`	`String`	Yes	—	Season type used for the leaders request

`fact_homepage`

Class: FactHomepageSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`homepage_source`	`String`	No	in=['home_page', 'homepage']	Alias source of the homepage packet
`rank`	`Int64`	Yes	gt=0	Rank within the homepage points packet
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	No	—	Team abbreviation
`team_name`	`String`	No	—	Team display name
`pts`	`Float64`	Yes	—	Points value from the base homepage packet
`season_type`	`String`	Yes	—	Season type used for the homepage request

`fact_leaders_tiles_detail`

Class: FactLeadersTilesDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`tile_variant`	`String`	No	in=['all_time_high', 'last_season_high', 'main', 'low_season_high']	Leaders tiles result-set variant
`rank`	`Int64`	Yes	gt=0	Rank when the tile variant is ranked
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	No	—	Team abbreviation
`team_name`	`String`	No	—	Team display name
`season_year`	`String`	Yes	—	Season year attached to historical tile variants
`season_type`	`String`	Yes	—	Season type used for the leaders tiles request
`pts`	`Float64`	Yes	—	Points value surfaced by the tile variant

`fact_leaders_tiles`

Class: FactLeadersTilesSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	No	—	Team abbreviation
`team_name`	`String`	No	—	Team display name
`season_year`	`String`	Yes	—	Season year attached to the base leaders-tiles packet
`pts`	`Float64`	Yes	—	Points value from the base leaders-tiles packet
`season_type`	`String`	Yes	—	Season type used for the leaders-tiles request

`fact_league_lineup_viz`

Class: FactLeagueLineupVizSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`group_id`	`String`	No	—	Lineup group identifier
`group_name`	`String`	Yes	—	Lineup player names
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`team_abbreviation`	`String`	Yes	—	Team abbreviation code
`min`	`Float64`	Yes	—	Minutes played
`off_rating`	`Float64`	Yes	—	Offensive rating
`def_rating`	`Float64`	Yes	—	Defensive rating
`net_rating`	`Float64`	Yes	—	Net rating
`pace`	`Float64`	Yes	—	Pace factor
`ts_pct`	`Float64`	Yes	—	True shooting percentage
`fta_rate`	`Float64`	Yes	—	Free throw attempt rate
`tm_ast_pct`	`Float64`	Yes	—	Team assist percentage
`pct_fga_2pt`	`Float64`	Yes	—	Percentage of field goal attempts from two-point range
`pct_fga_3pt`	`Float64`	Yes	—	Percentage of field goal attempts from three-point range
`pct_pts_2pt_mr`	`Float64`	Yes	—	Percentage of points from mid-range two-pointers
`pct_pts_fb`	`Float64`	Yes	—	Percentage of points from fast breaks
`pct_pts_ft`	`Float64`	Yes	—	Percentage of points from free throws
`pct_pts_paint`	`Float64`	Yes	—	Percentage of points in the paint
`pct_ast_fgm`	`Float64`	Yes	—	Percentage of assisted field goals
`pct_uast_fgm`	`Float64`	Yes	—	Percentage of unassisted field goals
`opp_fg3_pct`	`Float64`	Yes	—	Opponent three-point percentage
`opp_efg_pct`	`Float64`	Yes	—	Opponent effective field goal percentage
`opp_fta_rate`	`Float64`	Yes	—	Opponent free throw attempt rate
`opp_tov_pct`	`Float64`	Yes	—	Opponent turnover percentage

`fact_lineup_stats`

Class: FactLineupStatsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`group_set`	`String`	No	—	Lineup group set label
`group_id`	`String`	No	—	Lineup group identifier
`group_name`	`String`	Yes	—	Lineup player names
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`gp`	`Int64`	Yes	—	Games played
`w`	`Int64`	Yes	—	Wins
`l`	`Int64`	Yes	—	Losses
`min`	`Float64`	Yes	—	Minutes played
`fgm`	`Int64`	Yes	—	Field goals made
`fga`	`Int64`	Yes	—	Field goals attempted
`fg_pct`	`Float64`	Yes	—	Field goal percentage
`fg3m`	`Int64`	Yes	—	Three-pointers made
`fg3a`	`Int64`	Yes	—	Three-pointers attempted
`fg3_pct`	`Float64`	Yes	—	Three-point percentage
`ftm`	`Int64`	Yes	—	Free throws made
`fta`	`Int64`	Yes	—	Free throws attempted
`ft_pct`	`Float64`	Yes	—	Free throw percentage
`oreb`	`Int64`	Yes	—	Offensive rebounds
`dreb`	`Int64`	Yes	—	Defensive rebounds
`reb`	`Int64`	Yes	—	Total rebounds
`ast`	`Int64`	Yes	—	Assists
`tov`	`Int64`	Yes	—	Turnovers
`stl`	`Int64`	Yes	—	Steals
`blk`	`Int64`	Yes	—	Blocks
`pts`	`Int64`	Yes	—	Points scored
`plus_minus`	`Float64`	Yes	—	Plus-minus
`net_rating`	`Float64`	Yes	—	Net rating
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_matchup`

Class: FactMatchupSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Offensive player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Offensive team identifier
`def_player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Defensive player identifier
`def_team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Defensive team identifier
`matchup_min`	`Float64`	Yes	—	Matchup minutes
`poss`	`Int64`	Yes	—	Possessions
`player_pts`	`Int64`	Yes	—	Points scored by offensive player
`team_pts`	`Int64`	Yes	—	Team points during matchup
`matchup_ast`	`Int64`	Yes	—	Assists during matchup
`matchup_tov`	`Int64`	Yes	—	Turnovers during matchup
`matchup_blk`	`Int64`	Yes	—	Blocks during matchup
`matchup_fgm`	`Int64`	Yes	—	Field goals made during matchup
`matchup_fga`	`Int64`	Yes	—	Field goals attempted in matchup
`matchup_fg_pct`	`Float64`	Yes	—	FG percentage during matchup
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_play_by_play`

Class: FactPlayByPlaySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`event_num`	`Int64`	No	—	Event sequence number
`event_msg_type`	`Int64`	No	—	Event message type code
`event_msg_action_type`	`Int64`	Yes	—	Event action type code
`period`	`Int64`	No	gt=0	Game period (1-4 qtrs, 5+ OT)
`wc_time_string`	`String`	Yes	—	Wall clock time
`pc_time_string`	`String`	Yes	—	Period clock time string
`home_description`	`String`	Yes	—	Home team event description
`neutral_description`	`String`	Yes	—	Neutral event description
`visitor_description`	`String`	Yes	—	Visitor team event description
`score`	`String`	Yes	—	Score at event (e.g. 102 - 98)
`score_margin`	`String`	Yes	—	Score margin at event
`player1_id`	`Int64`	Yes	FK→dim_player.player_id	Primary player identifier
`player1_team_id`	`Int64`	Yes	FK→dim_team.team_id	Primary player team ID
`player2_id`	`Int64`	Yes	FK→dim_player.player_id	Secondary player identifier
`player2_team_id`	`Int64`	Yes	FK→dim_team.team_id	Secondary player team ID
`player3_id`	`Int64`	Yes	FK→dim_player.player_id	Tertiary player identifier
`player3_team_id`	`Int64`	Yes	FK→dim_team.team_id	Tertiary player team ID
`event_type_name`	`String`	Yes	—	Derived event type label
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_awards`

Class: FactPlayerAwardsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`description`	`String`	No	—	Award description
`all_nba_team_number`	`Int64`	Yes	—	All-NBA team number
`season`	`String`	Yes	—	Award season
`month`	`String`	Yes	—	Award month (if applicable)
`week`	`String`	Yes	—	Award week (if applicable)
`conference`	`String`	Yes	—	Conference for award
`award_type`	`String`	Yes	—	Award type classification
`subtype1`	`String`	Yes	—	Award subtype 1
`subtype2`	`String`	Yes	—	Award subtype 2
`subtype3`	`String`	Yes	—	Award subtype 3

`fact_player_dashboard_clutch_overall`

Class: FactPlayerDashboardClutchOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_game_splits_overall`

Class: FactPlayerDashboardGameSplitsOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_general_splits_overall`

Class: FactPlayerDashboardGeneralSplitsOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_last_n_overall`

Class: FactPlayerDashboardLastNOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_shooting_overall`

Class: FactPlayerDashboardShootingOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`efg_pct_rank`	`Int64`	Yes	—	Effective field goal percentage rank.
`pct_ast_2pm_rank`	`Int64`	Yes	—	Assisted two-point make percentage rank.
`pct_uast_2pm_rank`	`Int64`	Yes	—	Unassisted two-point make percentage rank.
`pct_ast_3pm_rank`	`Int64`	Yes	—	Assisted three-point make percentage rank.
`pct_uast_3pm_rank`	`Int64`	Yes	—	Unassisted three-point make percentage rank.
`pct_ast_fgm_rank`	`Int64`	Yes	—	Assisted field goal make percentage rank.
`pct_uast_fgm_rank`	`Int64`	Yes	—	Unassisted field goal make percentage rank.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`efg_pct`	`Float64`	Yes	—	Effective field goal percentage.
`pct_ast_2pm`	`Float64`	Yes	—	Share of made twos that were assisted.
`pct_uast_2pm`	`Float64`	Yes	—	Share of made twos that were unassisted.
`pct_ast_3pm`	`Float64`	Yes	—	Share of made threes that were assisted.
`pct_uast_3pm`	`Float64`	Yes	—	Share of made threes that were unassisted.
`pct_ast_fgm`	`Float64`	Yes	—	Share of made field goals that were assisted.
`pct_uast_fgm`	`Float64`	Yes	—	Share of made field goals that were unassisted.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_team_perf_overall`

Class: FactPlayerDashboardTeamPerfOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_dashboard_yoy_overall`

Class: FactPlayerDashboardYoyOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`team_id`	`Int64`	Yes	gt=0	Team identifier for the season row.
`team_abbreviation`	`String`	Yes	—	Team abbreviation.
`max_game_date`	`String`	Yes	—	Most recent game date in the split.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_player_estimated_metrics`

Class: FactPlayerEstimatedMetricsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`gp`	`Int64`	Yes	—	Games played
`w`	`Int64`	Yes	—	Wins
`l`	`Int64`	Yes	—	Losses
`min`	`Float64`	Yes	—	Minutes played
`e_off_rating`	`Float64`	Yes	—	Estimated offensive rating
`e_def_rating`	`Float64`	Yes	—	Estimated defensive rating
`e_net_rating`	`Float64`	Yes	—	Estimated net rating
`e_pace`	`Float64`	Yes	—	Estimated pace
`e_ast_ratio`	`Float64`	Yes	—	Estimated assist ratio
`e_oreb_pct`	`Float64`	Yes	—	Estimated offensive rebound pct
`e_dreb_pct`	`Float64`	Yes	—	Estimated defensive rebound pct
`e_reb_pct`	`Float64`	Yes	—	Estimated total rebound pct
`e_tov_pct`	`Float64`	Yes	—	Estimated turnover percentage
`e_usg_pct`	`Float64`	Yes	—	Estimated usage percentage
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_game_advanced`

Class: FactPlayerGameAdvancedSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`off_rating`	`Float64`	Yes	—	Offensive rating
`def_rating`	`Float64`	Yes	—	Defensive rating
`net_rating`	`Float64`	Yes	—	Net rating
`ast_pct`	`Float64`	Yes	—	Assist percentage
`ast_to`	`Float64`	Yes	—	Assist-to-turnover ratio
`ast_ratio`	`Float64`	Yes	—	Assist ratio
`oreb_pct`	`Float64`	Yes	—	Offensive rebound percentage
`dreb_pct`	`Float64`	Yes	—	Defensive rebound percentage
`reb_pct`	`Float64`	Yes	—	Total rebound percentage
`efg_pct`	`Float64`	Yes	—	Effective field goal percentage
`ts_pct`	`Float64`	Yes	—	True shooting percentage
`usg_pct`	`Float64`	Yes	—	Usage percentage
`pace`	`Float64`	Yes	—	Pace factor
`pie`	`Float64`	Yes	—	Player impact estimate
`poss`	`Int64`	Yes	—	Possessions
`fta_rate`	`Float64`	Yes	—	Free throw attempt rate
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_game_hustle`

Class: FactPlayerGameHustleSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`contested_shots`	`Int64`	Yes	—	Total contested shots
`contested_shots_2pt`	`Int64`	Yes	—	Contested two-point shots
`contested_shots_3pt`	`Int64`	Yes	—	Contested three-point shots
`deflections`	`Int64`	Yes	—	Deflections
`charges_drawn`	`Int64`	Yes	—	Charges drawn
`screen_assists`	`Int64`	Yes	—	Screen assists
`screen_ast_pts`	`Int64`	Yes	—	Points from screen assists
`loose_balls_recovered`	`Int64`	Yes	—	Loose balls recovered
`box_outs`	`Int64`	Yes	—	Box outs
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_game_misc`

Class: FactPlayerGameMiscSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`pts_off_tov`	`Int64`	Yes	—	Points off turnovers
`second_chance_pts`	`Int64`	Yes	—	Second chance points
`fbps`	`Int64`	Yes	—	Fast break points
`pitp`	`Int64`	Yes	—	Points in the paint
`opp_pts_off_tov`	`Int64`	Yes	—	Opponent points off turnovers
`opp_second_chance_pts`	`Int64`	Yes	—	Opponent second chance points
`opp_fbps`	`Int64`	Yes	—	Opponent fast break points
`opp_pitp`	`Int64`	Yes	—	Opponent points in the paint
`pct_fga_2pt`	`Float64`	Yes	—	Percentage of FGA that are 2pt
`pct_fga_3pt`	`Float64`	Yes	—	Percentage of FGA that are 3pt
`pct_pts_2pt`	`Float64`	Yes	—	Percentage of points from 2pt
`pct_pts_2pt_mr`	`Float64`	Yes	—	Pct of pts from 2pt mid-range
`pct_pts_3pt`	`Float64`	Yes	—	Percentage of points from 3pt
`pct_pts_fb`	`Float64`	Yes	—	Pct of points from fast breaks
`pct_pts_ft`	`Float64`	Yes	—	Pct of points from free throws
`pct_pts_off_tov`	`Float64`	Yes	—	Pct of pts off turnovers
`pct_pts_pitp`	`Float64`	Yes	—	Pct of pts in the paint
`pct_ast_2pm`	`Float64`	Yes	—	Pct of 2pt made that are assisted
`pct_uast_2pm`	`Float64`	Yes	—	Pct of 2pt made unassisted
`pct_ast_3pm`	`Float64`	Yes	—	Pct of 3pt made that are assisted
`pct_uast_3pm`	`Float64`	Yes	—	Pct of 3pt made unassisted
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_game_tracking`

Class: FactPlayerGameTrackingSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`spd`	`Float64`	Yes	—	Average speed (mph)
`dist`	`Float64`	Yes	—	Distance traveled (miles)
`orbc`	`Int64`	Yes	—	Offensive rebound chances
`drbc`	`Int64`	Yes	—	Defensive rebound chances
`rbc`	`Int64`	Yes	—	Total rebound chances
`tchs`	`Int64`	Yes	—	Touches
`front_ct_tchs`	`Int64`	Yes	—	Front court touches
`time_of_poss`	`Float64`	Yes	—	Time of possession (min)
`passes`	`Int64`	Yes	—	Passes made
`ast`	`Int64`	Yes	—	Assists
`ft_ast`	`Int64`	Yes	—	Free throw assists
`cfgm`	`Int64`	Yes	—	Contested field goals made
`cfga`	`Int64`	Yes	—	Contested field goals attempted
`cfg_pct`	`Float64`	Yes	—	Contested FG percentage
`ufgm`	`Int64`	Yes	—	Uncontested FG made
`ufga`	`Int64`	Yes	—	Uncontested FG attempted
`ufg_pct`	`Float64`	Yes	—	Uncontested FG percentage
`dfgm`	`Int64`	Yes	—	Defended field goals made
`dfga`	`Int64`	Yes	—	Defended field goals attempted
`dfg_pct`	`Float64`	Yes	—	Defended FG percentage
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_player_game_traditional`

Class: FactPlayerGameTraditionalSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`min`	`Float64`	Yes	—	Minutes played
`pts`	`Int64`	Yes	—	Points scored
`reb`	`Int64`	Yes	—	Total rebounds
`ast`	`Int64`	Yes	—	Assists
`stl`	`Int64`	Yes	—	Steals
`blk`	`Int64`	Yes	—	Blocks
`tov`	`Int64`	Yes	—	Turnovers
`pf`	`Int64`	Yes	—	Personal fouls
`fgm`	`Int64`	Yes	—	Field goals made
`fga`	`Int64`	Yes	—	Field goals attempted
`fg_pct`	`Float64`	Yes	—	Field goal percentage
`fg3m`	`Int64`	Yes	—	Three-point field goals made
`fg3a`	`Int64`	Yes	—	Three-pointers attempted
`fg3_pct`	`Float64`	Yes	—	Three-point percentage
`ftm`	`Int64`	Yes	—	Free throws made
`fta`	`Int64`	Yes	—	Free throws attempted
`ft_pct`	`Float64`	Yes	—	Free throw percentage
`oreb`	`Int64`	Yes	—	Offensive rebounds
`dreb`	`Int64`	Yes	—	Defensive rebounds
`plus_minus`	`Float64`	Yes	—	Plus-minus
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`start_position`	`String`	Yes	—	Starting position (F, C, G)

`fact_player_matchups_detail`

Class: FactPlayerMatchupsDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`detail_source`	`String`	No	in=['player_compare', 'player_vs_player']	Comparison endpoint family that produced the row
`detail_variant`	`String`	No	in=['individual', 'overall_compare', 'on_off_court', 'overall']	Result-set variant within the comparison family
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`description`	`String`	Yes	—
`player_id`	`Int64`	Yes	gt=0
`player_name`	`String`	Yes	—
`vs_player_id`	`Int64`	Yes	gt=0
`vs_player_name`	`String`	Yes	—
`court_status`	`String`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`nba_fantasy_pts`	`Float64`	Yes	—
`cfid`	`String`	Yes	—
`cfparams`	`String`	Yes	—

`fact_player_matchups_shot_detail`

Class: FactPlayerMatchupsShotDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`split_family`	`String`	No	in=['shot_area', 'shot_distance']	Shot split family for the matchup row
`split_scope`	`String`	No	in=['off_court', 'on_court', 'overall']	On/off/overall scope of the shot split
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`player_id`	`Int64`	Yes	gt=0
`player_name`	`String`	Yes	—
`vs_player_id`	`Int64`	Yes	gt=0
`vs_player_name`	`String`	Yes	—
`court_status`	`String`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`cfid`	`String`	Yes	—
`cfparams`	`String`	Yes	—

`fact_player_splits`

Class: FactPlayerSplitsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`split_type`	`String`	No	—	Dashboard family represented by the union row.
`cfid`	`Int64`	Yes	—	Context filter identifier returned by nba_api.
`cfparams`	`String`	Yes	—	Serialized context filter parameters returned by nba_api.
`efg_pct_rank`	`Int64`	Yes	—	Effective field goal percentage rank.
`pct_ast_2pm_rank`	`Int64`	Yes	—	Assisted two-point make percentage rank.
`pct_uast_2pm_rank`	`Int64`	Yes	—	Unassisted two-point make percentage rank.
`pct_ast_3pm_rank`	`Int64`	Yes	—	Assisted three-point make percentage rank.
`pct_uast_3pm_rank`	`Int64`	Yes	—	Unassisted three-point make percentage rank.
`pct_ast_fgm_rank`	`Int64`	Yes	—	Assisted field goal make percentage rank.
`pct_uast_fgm_rank`	`Int64`	Yes	—	Unassisted field goal make percentage rank.
`efg_pct`	`Float64`	Yes	—	Effective field goal percentage.
`pct_ast_2pm`	`Float64`	Yes	—	Share of made twos that were assisted.
`pct_uast_2pm`	`Float64`	Yes	—	Share of made twos that were unassisted.
`pct_ast_3pm`	`Float64`	Yes	—	Share of made threes that were assisted.
`pct_uast_3pm`	`Float64`	Yes	—	Share of made threes that were unassisted.
`pct_ast_fgm`	`Float64`	Yes	—	Share of made field goals that were assisted.
`pct_uast_fgm`	`Float64`	Yes	—	Share of made field goals that were unassisted.
`fgm_rank`	`Int64`	Yes	—	Field goals made rank.
`fga_rank`	`Int64`	Yes	—	Field goals attempted rank.
`fg_pct_rank`	`Int64`	Yes	—	Field goal percentage rank.
`fg3m_rank`	`Int64`	Yes	—	Three-pointers made rank.
`fg3a_rank`	`Int64`	Yes	—	Three-pointers attempted rank.
`fg3_pct_rank`	`Int64`	Yes	—	Three-point percentage rank.
`blka_rank`	`Int64`	Yes	—	Blocked attempts rank.
`gp_rank`	`Int64`	Yes	—	Games played rank.
`w_rank`	`Int64`	Yes	—	Wins rank.
`l_rank`	`Int64`	Yes	—	Losses rank.
`w_pct_rank`	`Int64`	Yes	—	Win percentage rank.
`min_rank`	`Int64`	Yes	—	Minutes played rank.
`ftm_rank`	`Int64`	Yes	—	Free throws made rank.
`fta_rank`	`Int64`	Yes	—	Free throws attempted rank.
`ft_pct_rank`	`Int64`	Yes	—	Free throw percentage rank.
`oreb_rank`	`Int64`	Yes	—	Offensive rebounds rank.
`dreb_rank`	`Int64`	Yes	—	Defensive rebounds rank.
`reb_rank`	`Int64`	Yes	—	Rebounds rank.
`ast_rank`	`Int64`	Yes	—	Assists rank.
`tov_rank`	`Int64`	Yes	—	Turnovers rank.
`stl_rank`	`Int64`	Yes	—	Steals rank.
`blk_rank`	`Int64`	Yes	—	Blocks rank.
`pf_rank`	`Int64`	Yes	—	Personal fouls rank.
`pfd_rank`	`Int64`	Yes	—	Personal fouls drawn rank.
`pts_rank`	`Int64`	Yes	—	Points rank.
`plus_minus_rank`	`Int64`	Yes	—	Plus-minus rank.
`nba_fantasy_pts_rank`	`Int64`	Yes	—	NBA fantasy points rank.
`dd2_rank`	`Int64`	Yes	—	Double-doubles rank.
`td3_rank`	`Int64`	Yes	—	Triple-doubles rank.
`fgm`	`Float64`	Yes	—	Field goals made.
`fga`	`Float64`	Yes	—	Field goals attempted.
`fg_pct`	`Float64`	Yes	—	Field goal percentage.
`fg3m`	`Float64`	Yes	—	Three-pointers made.
`fg3a`	`Float64`	Yes	—	Three-pointers attempted.
`fg3_pct`	`Float64`	Yes	—	Three-point percentage.
`blka`	`Float64`	Yes	—	Blocked attempts.
`gp`	`Int64`	Yes	—	Games played.
`w`	`Int64`	Yes	—	Wins.
`l`	`Int64`	Yes	—	Losses.
`w_pct`	`Float64`	Yes	—	Win percentage.
`min`	`Float64`	Yes	—	Minutes played.
`ftm`	`Float64`	Yes	—	Free throws made.
`fta`	`Float64`	Yes	—	Free throws attempted.
`ft_pct`	`Float64`	Yes	—	Free throw percentage.
`oreb`	`Float64`	Yes	—	Offensive rebounds.
`dreb`	`Float64`	Yes	—	Defensive rebounds.
`reb`	`Float64`	Yes	—	Total rebounds.
`ast`	`Float64`	Yes	—	Assists.
`tov`	`Float64`	Yes	—	Turnovers.
`stl`	`Float64`	Yes	—	Steals.
`blk`	`Float64`	Yes	—	Blocks.
`pf`	`Float64`	Yes	—	Personal fouls.
`pfd`	`Float64`	Yes	—	Personal fouls drawn.
`pts`	`Float64`	Yes	—	Points scored.
`plus_minus`	`Float64`	Yes	—	Plus-minus differential.
`nba_fantasy_pts`	`Float64`	Yes	—	NBA fantasy points.
`dd2`	`Float64`	Yes	—	Double-doubles.
`td3`	`Float64`	Yes	—	Triple-doubles.
`team_id`	`Int64`	Yes	gt=0	Team identifier for the season row.
`team_abbreviation`	`String`	Yes	—	Team abbreviation.
`max_game_date`	`String`	Yes	—	Most recent game date in the split.
`group_set`	`String`	Yes	—	Grouping set returned by the player dashboard endpoint.
`group_value`	`String`	Yes	—	Grouping value returned by the player dashboard endpoint.
`player_id`	`Int64`	No	gt=0	Queried player identifier.
`season_year`	`String`	No	—	Queried season year.
`season_type`	`String`	No	—	Queried season type.

`fact_rotation`

Class: FactRotationSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`in_time_real`	`Float64`	Yes	—	Check-in time (tenths of sec)
`out_time_real`	`Float64`	Yes	—	Check-out time (tenths of sec)
`pts`	`Int64`	Yes	—	Points during stint
`pts_diff`	`Int64`	Yes	—	Point differential during stint
`usg_pct`	`Float64`	Yes	—	Usage percentage during stint
`side`	`String`	No	in=['home', 'away']	Home or away designation

`fact_shot_chart_league_averages`

Class: FactShotChartLeagueAveragesSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`average_source`	`String`	No	in=['shot_chart_detail', 'shot_chart_lineup_detail']	Shot-chart request family that produced the league-average row
`grid_type`	`String`	Yes	—
`zone_basic`	`String`	Yes	—
`zone_area`	`String`	Yes	—
`zone_range`	`String`	Yes	—
`fga`	`Float64`	Yes	—
`fgm`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—

`fact_shot_chart`

Class: FactShotChartSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`period`	`Int64`	No	gt=0	Game period (1-4 qtrs, 5+ OT)
`minutes_remaining`	`Int64`	Yes	—	Minutes remaining in period
`seconds_remaining`	`Int64`	Yes	—	Seconds remaining in period
`action_type`	`String`	Yes	—	Shot action type description
`shot_type`	`String`	Yes	—	Shot type (2PT or 3PT)
`zone_basic`	`String`	Yes	—	Shot zone basic area
`zone_area`	`String`	Yes	—	Shot zone directional area
`zone_range`	`String`	Yes	—	Shot zone distance range
`shot_distance`	`Int64`	Yes	—	Shot distance in feet
`loc_x`	`Int64`	Yes	—	Shot X-coordinate on court
`loc_y`	`Int64`	Yes	—	Shot Y-coordinate on court
`shot_made_flag`	`Int64`	Yes	in=[0, 1]	Shot made (1) or missed (0)
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_standings`

Class: FactStandingsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`conference`	`String`	Yes	—	Conference (East or West)
`division`	`String`	Yes	—	Division name
`conf_rank`	`Int64`	Yes	—	Conference rank
`div_rank`	`Int64`	Yes	—	Division rank
`wins`	`Int64`	Yes	—	Total wins
`losses`	`Int64`	Yes	—	Total losses
`win_pct`	`Float64`	Yes	—	Win percentage
`home_record`	`String`	Yes	—	Home record (e.g. 30-11)
`road_record`	`String`	Yes	—	Road record (e.g. 25-16)
`last_ten`	`String`	Yes	—	Last 10 games record
`current_streak`	`String`	Yes	—	Current streak (e.g. W3, L2)
`games_back`	`Float64`	Yes	—	Games behind conference leader
`clinch_indicator`	`String`	Yes	—	Clinch indicator (e.g. p, x, z)
`pts_pg`	`Float64`	Yes	—	Average points per game
`opp_pts_pg`	`Float64`	Yes	—	Opponent points per game
`diff_pts_pg`	`Float64`	Yes	—	Point differential per game
`season_year`	`String`	No	—	Season year (e.g. 2024-25)
`season_type`	`String`	Yes	—	Season type (Regular, Playoff)

`fact_synergy`

Class: FactSynergySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	Yes	gt=0, FK→dim_player.player_id	Player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`play_type`	`String`	No	—	Play type (Isolation, PnR, etc.)
`type_grouping`	`String`	No	in=['offensive', 'defensive']	Offensive or defensive grouping
`gp`	`Int64`	Yes	—	Games played
`poss_pct`	`Float64`	Yes	—	Possession percentage
`poss`	`Int64`	Yes	—	Possessions
`pts`	`Int64`	Yes	—	Points scored
`fgm`	`Int64`	Yes	—	Field goals made
`fga`	`Int64`	Yes	—	Field goals attempted
`fg_pct`	`Float64`	Yes	—	Field goal percentage
`efg_pct`	`Float64`	Yes	—	Effective FG percentage
`ppp`	`Float64`	Yes	—	Points per possession
`score_pct`	`Float64`	Yes	—	Scoring frequency percentage
`tov_pct`	`Float64`	Yes	—	Turnover percentage
`ft_poss_pct`	`Float64`	Yes	—	Free throw possession pct
`percentile`	`Float64`	Yes	—	League percentile ranking
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_team_awards_conf`

Class: FactTeamAwardsConfSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`yearawarded`	`String`	Yes	—
`oppositeteam`	`String`	Yes	—

`fact_team_awards_div`

Class: FactTeamAwardsDivSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`yearawarded`	`String`	Yes	—
`oppositeteam`	`String`	Yes	—

`fact_team_background`

Class: FactTeamBackgroundSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`abbreviation`	`String`	No	—
`nickname`	`String`	No	—
`yearfounded`	`Int64`	Yes	gt=1900
`city`	`String`	Yes	—
`arena`	`String`	Yes	—
`arenacapacity`	`Int64`	Yes	gt=0
`owner`	`String`	Yes	—
`generalmanager`	`String`	Yes	—
`headcoach`	`String`	Yes	—
`dleagueaffiliation`	`String`	Yes	—

`fact_team_dashboard_general_overall`

Class: FactTeamDashboardGeneralOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`cfid`	`Int64`	Yes	—
`cfparams`	`String`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`season_type`	`String`	No	—
`season_year`	`String`	No	—

`fact_team_dashboard_shooting_overall`

Class: FactTeamDashboardShootingOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`cfid`	`Int64`	Yes	—
`cfparams`	`String`	Yes	—
`efg_pct_rank`	`Int64`	Yes	—
`pct_ast_2pm_rank`	`Int64`	Yes	—
`pct_uast_2pm_rank`	`Int64`	Yes	—
`pct_ast_3pm_rank`	`Int64`	Yes	—
`pct_uast_3pm_rank`	`Int64`	Yes	—
`pct_ast_fgm_rank`	`Int64`	Yes	—
`pct_uast_fgm_rank`	`Int64`	Yes	—
`efg_pct`	`Float64`	Yes	—
`pct_ast_2pm`	`Float64`	Yes	—
`pct_uast_2pm`	`Float64`	Yes	—
`pct_ast_3pm`	`Float64`	Yes	—
`pct_uast_3pm`	`Float64`	Yes	—
`pct_ast_fgm`	`Float64`	Yes	—
`pct_uast_fgm`	`Float64`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`season_type`	`String`	No	—

`fact_team_estimated_metrics`

Class: FactTeamEstimatedMetricsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`gp`	`Int64`	Yes	—	Games played
`w`	`Int64`	Yes	—	Wins
`l`	`Int64`	Yes	—	Losses
`min`	`Float64`	Yes	—	Minutes played
`e_off_rating`	`Float64`	Yes	—	Estimated offensive rating
`e_def_rating`	`Float64`	Yes	—	Estimated defensive rating
`e_net_rating`	`Float64`	Yes	—	Estimated net rating
`e_pace`	`Float64`	Yes	—	Estimated pace
`e_ast_ratio`	`Float64`	Yes	—	Estimated assist ratio
`e_oreb_pct`	`Float64`	Yes	—	Estimated offensive rebound pct
`e_dreb_pct`	`Float64`	Yes	—	Estimated defensive rebound pct
`e_reb_pct`	`Float64`	Yes	—	Estimated total rebound pct
`e_tov_pct`	`Float64`	Yes	—	Estimated turnover percentage
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_team_game_log`

Class: FactTeamGameLogSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`season_id`	`String`	Yes	—
`team_id`	`Int64`	No	gt=0
`team_abbreviation`	`String`	Yes	—
`team_name`	`String`	Yes	—
`game_id`	`String`	No	—
`game_date`	`String`	Yes	—
`matchup`	`String`	Yes	—
`wl`	`String`	Yes	in=['W', 'L']
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`video_available`	`Int64`	Yes	—

`fact_team_game`

Class: FactTeamGameSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`fgm`	`Int64`	Yes	—	Team field goals made
`fga`	`Int64`	Yes	—	Team field goals attempted
`fg_pct`	`Float64`	Yes	—	Team field goal percentage
`fg3m`	`Int64`	Yes	—	Team three-pointers made
`fg3a`	`Int64`	Yes	—	Team three-pointers attempted
`fg3_pct`	`Float64`	Yes	—	Team three-point percentage
`ftm`	`Int64`	Yes	—	Team free throws made
`fta`	`Int64`	Yes	—	Team free throws attempted
`ft_pct`	`Float64`	Yes	—	Team free throw percentage
`oreb`	`Int64`	Yes	—	Team offensive rebounds
`dreb`	`Int64`	Yes	—	Team defensive rebounds
`reb`	`Int64`	Yes	—	Team total rebounds
`ast`	`Int64`	Yes	—	Team assists
`stl`	`Int64`	Yes	—	Team steals
`blk`	`Int64`	Yes	—	Team blocks
`tov`	`Int64`	Yes	—	Team turnovers
`pf`	`Int64`	Yes	—	Team personal fouls
`pts`	`Int64`	Yes	—	Team total points
`pts_qtr1`	`Int64`	Yes	—	Team first quarter points
`pts_qtr2`	`Int64`	Yes	—	Team second quarter points
`pts_qtr3`	`Int64`	Yes	—	Team third quarter points
`pts_qtr4`	`Int64`	Yes	—	Team fourth quarter points
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_team_hof`

Class: FactTeamHofSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`playerid`	`Int64`	Yes	gt=0
`player`	`String`	Yes	—
`position`	`String`	Yes	—
`jersey`	`String`	Yes	—
`seasonswithteam`	`String`	Yes	—
`year`	`String`	Yes	—

`fact_team_lineups_overall`

Class: FactTeamLineupsOverallSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`group_set`	`String`	No	—
`group_id`	`String`	No	—
`group_name`	`String`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`fgm`	`Int64`	Yes	—
`fga`	`Int64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Int64`	Yes	—
`fg3a`	`Int64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ftm`	`Int64`	Yes	—
`fta`	`Int64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Int64`	Yes	—
`dreb`	`Int64`	Yes	—
`reb`	`Int64`	Yes	—
`ast`	`Int64`	Yes	—
`tov`	`Int64`	Yes	—
`stl`	`Int64`	Yes	—
`blk`	`Int64`	Yes	—
`blka`	`Int64`	Yes	—
`pf`	`Int64`	Yes	—
`pfd`	`Int64`	Yes	—
`pts`	`Int64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—
`season_type`	`String`	No	—

`fact_team_matchups_detail`

Class: FactTeamMatchupsDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`detail_source`	`String`	No	in=['team_vs_player', 'team_and_players_vs']	Comparison endpoint family that produced the row
`detail_variant`	`String`	No	in=['on_off_court', 'overall', 'vs_player_overall', 'players_vs_players', 'team_players_vs_players_off', 'team_players_vs_players_on', 'team_vs_players', 'team_vs_players_off']	Result-set variant within the team comparison family
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`title_description`	`String`	Yes	—
`description`	`String`	Yes	—
`team_id`	`Int64`	Yes	gt=0
`team_abbreviation`	`String`	Yes	—
`team_name`	`String`	Yes	—
`player_id`	`Int64`	Yes	gt=0
`player_name`	`String`	Yes	—
`vs_player_id`	`Int64`	Yes	gt=0
`vs_player_name`	`String`	Yes	—
`court_status`	`String`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`nba_fantasy_pts`	`Float64`	Yes	—
`dd2`	`Float64`	Yes	—
`td3`	`Float64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—
`nba_fantasy_pts_rank`	`Int64`	Yes	—
`dd2_rank`	`Int64`	Yes	—
`td3_rank`	`Int64`	Yes	—
`cfid`	`String`	Yes	—
`cfparams`	`String`	Yes	—

`fact_team_matchups_shot_detail`

Class: FactTeamMatchupsShotDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`split_family`	`String`	No	in=['shot_area', 'shot_distance']	Shot split family for the team matchup row
`split_scope`	`String`	No	in=['off_court', 'on_court', 'overall']	On/off/overall scope of the shot split
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`team_id`	`Int64`	Yes	gt=0
`team_abbreviation`	`String`	Yes	—
`team_name`	`String`	Yes	—
`vs_player_id`	`Int64`	Yes	gt=0
`vs_player_name`	`String`	Yes	—
`court_status`	`String`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`cfid`	`String`	Yes	—
`cfparams`	`String`	Yes	—

`fact_team_player_dashboard`

Class: FactTeamPlayerDashboardSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`nba_fantasy_pts_rank`	`Int64`	Yes	—
`dd2_rank`	`Int64`	Yes	—
`td3_rank`	`Int64`	Yes	—
`nba_fantasy_pts`	`Float64`	Yes	—
`dd2`	`Float64`	Yes	—
`td3`	`Float64`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`player_id`	`Int64`	No	gt=0
`player_name`	`String`	Yes	—
`group_set`	`String`	No	—
`season_type`	`String`	No	—

`fact_team_pt_reb_detail`

Class: FactTeamPtRebDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`team_name`	`String`	Yes	—
`sort_order`	`Int64`	Yes	—
`g`	`Int64`	Yes	—
`reb_num_contesting_range`	`String`	Yes	—
`reb_frequency`	`Float64`	Yes	—
`oreb`	`Int64`	Yes	—
`dreb`	`Int64`	Yes	—
`reb`	`Int64`	Yes	—
`c_oreb`	`Int64`	Yes	—
`c_dreb`	`Int64`	Yes	—
`c_reb`	`Int64`	Yes	—
`c_reb_pct`	`Float64`	Yes	—
`uc_oreb`	`Int64`	Yes	—
`uc_dreb`	`Int64`	Yes	—
`uc_reb`	`Int64`	Yes	—
`uc_reb_pct`	`Float64`	Yes	—
`season_type`	`String`	No	—

`fact_team_pt_shots_detail`

Class: FactTeamPtShotsDetailSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`team_id`	`Int64`	No	gt=0
`team_name`	`String`	Yes	—
`sort_order`	`Int64`	Yes	—
`g`	`Int64`	Yes	—
`close_def_dist_range`	`String`	Yes	—
`fga_frequency`	`Float64`	Yes	—
`fgm`	`Int64`	Yes	—
`fga`	`Int64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`efg_pct`	`Float64`	Yes	—
`fg2a_frequency`	`Float64`	Yes	—
`fg2m`	`Int64`	Yes	—
`fg2a`	`Int64`	Yes	—
`fg2_pct`	`Float64`	Yes	—
`fg3a_frequency`	`Float64`	Yes	—
`fg3m`	`Int64`	Yes	—
`fg3a`	`Int64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`season_type`	`String`	No	—

`fact_team_pt_tracking`

Class: FactTeamPtTrackingSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`tracking_type`	`String`	No	in=['pass', 'pass_received', 'rebound', 'shots']
`team_id`	`Int64`	No	gt=0
`team_name`	`String`	Yes	—
`pass_type`	`String`	Yes	—
`g`	`Int64`	Yes	—
`pass_from`	`String`	Yes	—
`pass_to`	`String`	Yes	—
`pass_teammate_player_id`	`Int64`	Yes	gt=0
`frequency`	`Float64`	Yes	—
`pass`	`Int64`	Yes	—
`ast`	`Int64`	Yes	—
`fgm`	`Int64`	Yes	—
`fga`	`Int64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg2m`	`Int64`	Yes	—
`fg2a`	`Int64`	Yes	—
`fg2_pct`	`Float64`	Yes	—
`fg3m`	`Int64`	Yes	—
`fg3a`	`Int64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`sort_order`	`Int64`	Yes	—
`reb_num_contesting_range`	`String`	Yes	—
`reb_frequency`	`Float64`	Yes	—
`oreb`	`Int64`	Yes	—
`dreb`	`Int64`	Yes	—
`reb`	`Int64`	Yes	—
`c_oreb`	`Int64`	Yes	—
`c_dreb`	`Int64`	Yes	—
`c_reb`	`Int64`	Yes	—
`c_reb_pct`	`Float64`	Yes	—
`uc_oreb`	`Int64`	Yes	—
`uc_dreb`	`Int64`	Yes	—
`uc_reb`	`Int64`	Yes	—
`uc_reb_pct`	`Float64`	Yes	—
`close_def_dist_range`	`String`	Yes	—
`fga_frequency`	`Float64`	Yes	—
`efg_pct`	`Float64`	Yes	—
`fg2a_frequency`	`Float64`	Yes	—
`fg3a_frequency`	`Float64`	Yes	—
`season_type`	`String`	No	—

`fact_team_retired`

Class: FactTeamRetiredSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`playerid`	`Int64`	Yes	gt=0
`player`	`String`	Yes	—
`position`	`String`	Yes	—
`jersey`	`String`	Yes	—
`seasonswithteam`	`String`	Yes	—
`year`	`String`	Yes	—

`fact_team_season_ranks`

Class: FactTeamSeasonRanksSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`league_id`	`String`	Yes	—
`season_id`	`String`	Yes	—
`team_id`	`Int64`	No	gt=0
`pts_rank`	`Int64`	Yes	gt=0
`pts_pg`	`Float64`	Yes	—
`reb_rank`	`Int64`	Yes	gt=0
`reb_pg`	`Float64`	Yes	—
`ast_rank`	`Int64`	Yes	gt=0
`ast_pg`	`Float64`	Yes	—
`opp_pts_rank`	`Int64`	Yes	gt=0
`opp_pts_pg`	`Float64`	Yes	—
`season_type`	`String`	Yes	—

`fact_team_social_sites`

Class: FactTeamSocialSitesSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`accounttype`	`String`	Yes	—
`website_link`	`String`	Yes	—

`fact_team_splits`

Class: FactTeamSplitsSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`cfid`	`Int64`	Yes	—
`cfparams`	`String`	Yes	—
`efg_pct_rank`	`Int64`	Yes	—
`pct_ast_2pm_rank`	`Int64`	Yes	—
`pct_uast_2pm_rank`	`Int64`	Yes	—
`pct_ast_3pm_rank`	`Int64`	Yes	—
`pct_uast_3pm_rank`	`Int64`	Yes	—
`pct_ast_fgm_rank`	`Int64`	Yes	—
`pct_uast_fgm_rank`	`Int64`	Yes	—
`efg_pct`	`Float64`	Yes	—
`pct_ast_2pm`	`Float64`	Yes	—
`pct_uast_2pm`	`Float64`	Yes	—
`pct_ast_3pm`	`Float64`	Yes	—
`pct_uast_3pm`	`Float64`	Yes	—
`pct_ast_fgm`	`Float64`	Yes	—
`pct_uast_fgm`	`Float64`	Yes	—
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—
`season_type`	`String`	No	—
`season_year`	`String`	Yes	—
`split_type`	`String`	No	in=['general', 'shooting']

`fact_tracking_defense`

Class: FactTrackingDefenseSchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0, FK→dim_player.player_id	Defender player identifier
`team_id`	`Int64`	No	gt=0, FK→dim_team.team_id	Team identifier
`defense_category`	`String`	No	—	Defense category (Overall, 3pt, etc.)
`gp`	`Int64`	Yes	—	Games played
`g`	`Int64`	Yes	—	Games
`freq`	`Float64`	Yes	—	Frequency of defense
`d_fgm`	`Int64`	Yes	—	Defended field goals made
`d_fga`	`Int64`	Yes	—	Defended field goals attempted
`d_fg_pct`	`Float64`	Yes	—	Defended FG percentage
`normal_fg_pct`	`Float64`	Yes	—	Normal (undefended) FG pct
`pct_plusminus`	`Float64`	Yes	—	FG pct differential (defended vs normal)
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`fact_win_probability`

Class: FactWinProbabilitySchema Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`game_id`	`String`	No	FK→dim_game.game_id	Unique game identifier
`event_num`	`Int64`	No	—	Event sequence number
`period`	`Int64`	No	gt=0	Game period (1-4 qtrs, 5+ OT)
`pc_time_string`	`String`	Yes	—	Period clock time string
`home_pct`	`Float64`	Yes	—	Home team win probability
`visitor_pct`	`Float64`	Yes	—	Visitor team win probability
`home_pts`	`Int64`	Yes	—	Home team points at event
`visitor_pts`	`Int64`	Yes	—	Visitor team points at event
`home_score_margin`	`Int64`	Yes	—	Home team score margin
`season_year`	`String`	No	—	Season year (e.g. 2024-25)

`__team_dashboard_fantasy_metrics_mixin`

Class: _TeamDashboardFantasyMetricsMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`nba_fantasy_pts`	`Float64`	Yes	—
`dd2`	`Float64`	Yes	—
`td3`	`Float64`	Yes	—

`__team_dashboard_fantasy_ranks_mixin`

Class: _TeamDashboardFantasyRanksMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`nba_fantasy_pts_rank`	`Int64`	Yes	—
`dd2_rank`	`Int64`	Yes	—
`td3_rank`	`Int64`	Yes	—

`__team_dashboard_field_goal_metrics_mixin`

Class: _TeamDashboardFieldGoalMetricsMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—

`__team_dashboard_field_goal_ranks_mixin`

Class: _TeamDashboardFieldGoalRanksMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—

`__team_dashboard_group_set_mixin`

Class: _TeamDashboardGroupSetMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`group_set`	`String`	No	—

`__team_dashboard_grouping_mixin`

Class: _TeamDashboardGroupingMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`group_set`	`String`	No	—
`group_value`	`String`	Yes	—

`__team_dashboard_player_identity_mixin`

Class: _TeamDashboardPlayerIdentityMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`player_id`	`Int64`	No	gt=0
`player_name`	`String`	Yes	—

`__team_dashboard_reference_mixin`

Class: _TeamDashboardReferenceMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`cfid`	`Int64`	Yes	—
`cfparams`	`String`	Yes	—

`__team_dashboard_season_type_mixin`

Class: _TeamDashboardSeasonTypeMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints	Description
`season_type`	`String`	No	—

`__team_dashboard_shooting_extension_ranks_mixin`

Class: _TeamDashboardShootingExtensionRanksMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`efg_pct_rank`	`Int64`	Yes	—
`pct_ast_2pm_rank`	`Int64`	Yes	—
`pct_uast_2pm_rank`	`Int64`	Yes	—
`pct_ast_3pm_rank`	`Int64`	Yes	—
`pct_uast_3pm_rank`	`Int64`	Yes	—
`pct_ast_fgm_rank`	`Int64`	Yes	—
`pct_uast_fgm_rank`	`Int64`	Yes	—

`__team_dashboard_shooting_extensions_mixin`

Class: _TeamDashboardShootingExtensionsMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`efg_pct`	`Float64`	Yes	—
`pct_ast_2pm`	`Float64`	Yes	—
`pct_uast_2pm`	`Float64`	Yes	—
`pct_ast_3pm`	`Float64`	Yes	—
`pct_uast_3pm`	`Float64`	Yes	—
`pct_ast_fgm`	`Float64`	Yes	—
`pct_uast_fgm`	`Float64`	Yes	—

`__team_dashboard_standard_metrics_mixin`

Class: _TeamDashboardStandardMetricsMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`fgm`	`Float64`	Yes	—
`fga`	`Float64`	Yes	—
`fg_pct`	`Float64`	Yes	—
`fg3m`	`Float64`	Yes	—
`fg3a`	`Float64`	Yes	—
`fg3_pct`	`Float64`	Yes	—
`blka`	`Float64`	Yes	—
`gp`	`Int64`	Yes	—
`w`	`Int64`	Yes	—
`l`	`Int64`	Yes	—
`w_pct`	`Float64`	Yes	—
`min`	`Float64`	Yes	—
`ftm`	`Float64`	Yes	—
`fta`	`Float64`	Yes	—
`ft_pct`	`Float64`	Yes	—
`oreb`	`Float64`	Yes	—
`dreb`	`Float64`	Yes	—
`reb`	`Float64`	Yes	—
`ast`	`Float64`	Yes	—
`tov`	`Float64`	Yes	—
`stl`	`Float64`	Yes	—
`blk`	`Float64`	Yes	—
`pf`	`Float64`	Yes	—
`pfd`	`Float64`	Yes	—
`pts`	`Float64`	Yes	—
`plus_minus`	`Float64`	Yes	—

`__team_dashboard_standard_ranks_mixin`

Class: _TeamDashboardStandardRanksMixin Coerce: True | Strict: False

Column	Type	Nullable	Constraints
`fgm_rank`	`Int64`	Yes	—
`fga_rank`	`Int64`	Yes	—
`fg_pct_rank`	`Int64`	Yes	—
`fg3m_rank`	`Int64`	Yes	—
`fg3a_rank`	`Int64`	Yes	—
`fg3_pct_rank`	`Int64`	Yes	—
`blka_rank`	`Int64`	Yes	—
`gp_rank`	`Int64`	Yes	—
`w_rank`	`Int64`	Yes	—
`l_rank`	`Int64`	Yes	—
`w_pct_rank`	`Int64`	Yes	—
`min_rank`	`Int64`	Yes	—
`ftm_rank`	`Int64`	Yes	—
`fta_rank`	`Int64`	Yes	—
`ft_pct_rank`	`Int64`	Yes	—
`oreb_rank`	`Int64`	Yes	—
`dreb_rank`	`Int64`	Yes	—
`reb_rank`	`Int64`	Yes	—
`ast_rank`	`Int64`	Yes	—
`tov_rank`	`Int64`	Yes	—
`stl_rank`	`Int64`	Yes	—
`blk_rank`	`Int64`	Yes	—
`pf_rank`	`Int64`	Yes	—
`pfd_rank`	`Int64`	Yes	—
`pts_rank`	`Int64`	Yes	—
`plus_minus_rank`	`Int64`	Yes	—

Companion cuts

Turn exact public contracts into practical table choices

Once the star contract is confirmed, use curated pages to decide which table family or analyst shortcut fits the question.

Curated table family

Turn exact star contracts into working analysis

The generated star reference is the scorebook. These curated pages help you decide which public tables to start with, how they join, and where analyst-friendly shortcuts already exist.

Section hub

Schema Reference

Complete schema docs for staging tier

Data Dictionary

Scorer's-table lexicon for column meanings, naming patterns, and generated field inventories

Schema Reference — Star

Use star reference as the exact warehouse contract

Pick the public table family before reading columns

Use constraints to keep joins honest

Switch to curated pages for judgment calls

Choose the warehouse family before reading the contract

Turn exact public contracts into practical table choices

Use dimensions for stable entity context

Pick the right fact or bridge grain

Check whether an analytics view already solves it

Turn exact star contracts into working analysis

Dimensions

Facts & Bridges

Analytics Views

On this page