michalekb11 / NHL-expected-goals

0 stars 0 forks source link

Plan a more optimal database structure #57

Closed michalekb11 closed 10 months ago

michalekb11 commented 1 year ago

We need a better database structure with clear relationships between tables. It should be easy to join tables to combine information.

Some thought must be put into the data collection here as well. Take game_id for example. I get this from hockeyreference, but I need it to be part of the odds as well as the daily player data. How can we get data collection to work as a unified system instead of messy individual components?