SunQuest
           Database Management
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesDatabase Management

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now!
  #1  
Old December 9th, 2002, 04:18 PM
Bradleyscott Bradleyscott is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Dec 2002
Posts: 1 Bradleyscott User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Design ?

I am currently designing a Stats page for a league football League I am in.

I have come up with this particular table design, but am having problems with the way the scheduling works.

The league is a playstation online league, we are going to keep many stats for the team and individual characters on a persons team. I have broken it into these main tables

Team (keeps the Name of the user, the team he uses and his password and e-mail, etc.)

TeamStats (this keeps track of the overall team stats the score of each game, the yardage, etc is stored here)

TeamPlayer (This keeps each of the characters on that teams stats)

Schedule (this is the schedule that each team follows)

The schedule is what I am worried about the most. I can only think of two ways to do this,

1.) Have the key be the Game# (an incrimental number that I setup for each team's game each week. So week 1 would be #'s 1-32. Week 2 would be 33-64, etc)

2.) Have three keys week#, home, and away. As we have some teams that play each other twice.

I think I may be thinking too much or making it more difficult than I need it to be.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesDatabase Management > Design ?


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway