MySQL Schema suggestions

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).