| Author |
 Topic  |
|
|
e3stone
Average Member
USA
885 Posts |
 Posted - 16 May 2001 : 16:14:55
|
I'm making a version of fantasy football for my forum. I'm not sure how to address the following problem which I'll give in a scenario:
before the first football game each member selects their roster. At 12:00 a.m. Sunday (gameday) their roster is "locked" for the games that are on Sunday, Sunday night, and monday night. However, anytime after the roster is "locked" they can change their roster for the following week, but the locked roster will be used to tally the point for the current week's games.
Would I have a table called "roster" and then have a field within that table called "Week_Number"? There are 16 or 17 weeks in the regular football season. This isn't too efficient, but would work for football, however, if I had a fantasy baseball app, then there are 162 games...that table would be huge.
Any opinions on how I could design the tables?
<-- Eric -->
http://insidewaco.com/forum/home.asp |
|
|
e3stone
Average Member
USA
885 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 May 2001 : 20:01:50
|
I can't exactly visualize what you need. If I understand, I'd have a few tables.
Members, for membership information
AvailablePlayers, to populate the rosters,
WeeklyRoster, for holding the selected rosters.
The weekly roster would have columns for weekID, PlayerID, MemmberID, etc.
======
Doug G
====== |
 |
|
| |
Topic |
|
|
|
Topic Locked
