
April 14th, 2003, 12:20 AM
|
|
|
|
Join Date: Apr 2007
Posts: 14
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
advise on structure of database
I am creating a mysql database with game stats.
What I would like would be some suggestions on the best way to organise the database. ie, more than 1 table?
There will be:
* 15 rounds
* 10 players
* 8 types of stats (goals, missed goals, intercept, thrown an intercept, stepping, contact, who they played, result)
Once the game is over, stats for that round would not be updated.
The output page would display things like the following:
* team stats for each round plus overall team stats
* player stats for each game plus for overall stats
I was thinking the best way to setup the input page would be to have a drop down menu for the rounds, a drop down menu for the players and then possibly a check box list for options like goals, penalities, etc. Being the stats will always only add 1, I was thinking maybe instead of the check box's to have another drop down with the stat options, like in the drop down menu it would have goal, penality, intercept, etc.
|