I am putting my Madden 2007 franchise online, and I want to keep track of all the players’ stats on my team. Im not quite sure how I should setup the database structure for this though. Here is one idea I had:
Table: Season
Table2: WeekOne, Table3: WeekTwo, etc till week 17
Table: Quarterback, Running Back, Wide Reciever, etc… In each of these tables would be the different categories like touchdowns, yards, etc.
So for Season i just created an id column in case I wanted a season 2, 3, or 4, etc.
WeekOne, WeekTwo, only have the column ID, just like Season.
Then I have a table for each position, with an id and columns for their stats like touchdowns, yards, etc.
this is the structure I was thinking about, does anyone think this looks right?