Players Table

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
karljames@xxxxxxxxxxxxxxx
www.theufl.com
 

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


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux