Karl James wrote:
Team,
I want to know if my table is setup correctly.
I am creating a site where team owners control fantasy football teams.
Imaginary teams. They can trade players, add and drop them as long as
they are under the salary cap at all times. if not they are given a warning
to make a different move or something along those lines.
I have created a table for league_members.
Can you tell me if I have this set up correctly.
This will be for the register.php form
Field Type Attributes Null Default Extra Action
fantasyteamname varchar(30) No
firstname varchar(20) No
lastname varchar(30) No
username varchar(10) No
emailaddress varchar(50) No 0
address varchar(50) No
city varchar(30) No
state varchar(30) No
zipcode tinyint(5) No 0
homephonenumber tinyint(4) No 0
mobilephonenumber tinyint(4) No 0
favoriteprofootballteam varchar(50) No 0
favoritecollegeteam varchar(50) No 0
I'd make fantasyteamname, favoriteprofootballteam, and
favoritecollegeteam int's instead and have them as separate database tables.
I'm sure many people are going to share the same favourite pro team and
college teams so you could make a dropdown box with those options
instead of making your users type them in ;)
Fantasyteamname should go with the fantasy team details - not be with
the user info so keep the team name with the other details, and just an
id to link between them.
--
Postgresql & php tutorials
http://www.designmagick.com/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
