The way I have my hockey stats database set up, I can record all the stats for a player over a season and over multiple seasons. I just realized that this is not exactly what I want, so I need to redo the database.
What I want is to be able to record a list of players that played in a particular game, individual stats for each player during the game, and also keep track of what order the goals/assists happened.
Keeping stats on a game-by-game basis gives me an ability to do more with the data, and I can still keep track of season data as well.
I've been having a brain fart and I can't think of how to do this. Do I need multiple tables?
What I want is to be able to record a list of players that played in a particular game, individual stats for each player during the game, and also keep track of what order the goals/assists happened.
Keeping stats on a game-by-game basis gives me an ability to do more with the data, and I can still keep track of season data as well.
I've been having a brain fart and I can't think of how to do this. Do I need multiple tables?