# Database structure?

**URL:** <https://forum.kirupa.com/t/database-structure/211169>\
**Category:** Uncategorized\
**Created:** [December 28, 2006, 5:07am UTC](https://forum.kirupa.com/t/database-structure/211169 "2006-12-28T05:07:23Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![AlexGM16](https://avatars.discourse-cdn.com/v4/letter/a/e8c25b/32.png) [@AlexGM16](https://forum.kirupa.com/u/AlexGM16)\
**Post date:** [December 28, 2006, 5:07am UTC](https://forum.kirupa.com/t/database-structure/211169/1 "2006-12-28T05:07:23Z")

</div>

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?

![](http://img150.imageshack.us/img150/5346/structuremr8.jpg)