forked from Jman4190/nba-sql
-
Notifications
You must be signed in to change notification settings - Fork 24
Schema Explained
Matthew Pope edited this page Mar 7, 2021
·
4 revisions
The schema is straight forward and an Entity Relationship diagram can be found here, however the column names are a bit cryptic. Here is an example:
| Column | Description |
|---|---|
| season_year | The specific season key. Ex: 1998-99 |
| player_id | Foreign key to the player table |
| team_id | Foreign key to the team table |
| game_id | Id of the game |
| game_date | Date of the game |
| matchup | Opposing team |
| wl | Win/Loss |
| min | Minutes played |
| fgm | Field goals made |
| fga | Field goals attempted |
| fg_pct | Field goals percentage |
| fg3m | Field goal 3pts made |
| fg3a | Field goal 3pts attempted |
| fg3_pct | Field goal 3pts percentage |
| ftm | Free throws made |
| fta | Free throws attempted |
| ft_pct | Free throws percentage |
| oreb | Offensive rebounds |
| dreb | Defensive rebounds |
| reb | Total rebounds |
| ast | Assists |
| tov | Turn overs |
| stl | Steals |
| blk | Blocks |
| blka | Block attempts |
| pf | Personal fouls |
| pfd | Personal fouls defense |
| pts | Points |
| plus_minus | Box plus minus |
| nba_fantasy_points | Fantasy point total |
| dd2 | Double-doubles |
| td3 | Triple-doubles |