Schema suggestions
| Important: The following is a text only archive! For full features; Go to Schema suggestions |
posted by Zalight
I am currently making a web app for my football pool, and was wondering if
someone would suggest the best way to handle table designs for the
scoring.
For example, I already have tables set up for nfl_player, and nfl_team. How
should I store the stats from the games each Sunday?
I dont have much experience in the matter, so would a table such as
stats (game_id, player_id, pass_yds, Pass_tds, rush_yds, ... etc) get too
unwieldy too quickly, or not?
Could someone suggest the best way to do this? (I know I have been kind of
vague on any restrictions etc, but I would just like to hear what the good
designs would be and then strive to see if I could meet them).