mpope9 / nba-sql

:basketball: An application to build an NBA database backed by MySQL, Postgres, or SQLite
Apache License 2.0
171 stars 20 forks source link

Adding season table, dynamically generating season list. #70

Closed mpope9 closed 2 years ago

mpope9 commented 2 years ago

This is to address https://github.com/mpope9/nba-sql/issues/65

Adds a new 'season' table, that is just the int representation of each season. Not used as a pk / fk right now, but it'll be a solid place to track what seasons are loaded, and like what the current season loaded is.

Also, instead of having a fixed season list, now the season list is auto-generated. So no need to push a change when a new season happens, it should automagically show up!