Re: [PHP] Players Table

[Christoph]

Players

NFL_Team ( varchar32 )
Fantasy_team ( varchar32 )


I player can definitely be part of only 1 NFL Team.  But how are you 
handling your league?  Is this just for a single small group of people?  Or 
is this database to be set up for lots of leagues?  If the latter, you 
should move Fantasy_team out to another table.


Also, do you want to be able to track a player historically?  If so, you 
might want to move NFL_Team to another table as well since a player can get 
traded.



Salary cap (int )6


Why do you need this?  For the fantasy league?  If so, is the cap different 
for each league?  If so, you might want to break this out.



Another thought.
I am not sure on what to do with the players stats.
Should that be in the same table as his profile info?
Like Passing Yards, touchdowns, etc.


If you want to track this as part of historical data, put it into another 
table.  Otherwise it should do fine in the player table.


thnx,
Chris 


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Players Table

[Karl james]

Team,

I am trying to start this up.
Just not sure if I am doing this correctly or not.
Can you please advise?
I am sure you all have seen my post from before.

Have, I created the players table right?

Players

Id_Number ( int )
First_Name ( varchar32 )
Last_Name ( varchar32 )
NFL_Team ( varchar32 )
Fantasy_team ( varchar32 )
Position ( varchar32 )
College ( varchar32 )
Height (tinyint)3 
Weigh (tinyint) 3
Years of experience ( tinyint )3
Salary cap (int )6

I have the ID number marked as the primary key.

Is that right?

Another thought.
I am not sure on what to do with the players stats.
Should that be in the same table as his profile info?
Like Passing Yards, touchdowns, etc.

Your advice, is greatly appreciated and respected!!!


Karl James
[EMAIL PROTECTED]
www.theufl.com
 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php