Welcome to WebmasterWorld Guest from 54.163.61.66

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

1 table or 2?

     
4:29 am on Jan 3, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:Mar 4, 2004
posts:553
votes: 0


I will be creating a database for a new game I plan on making, now, the table will be laid out like so.

ID
Name
Password
Address
City
State
Country
Zip
Character Name
Character Type
etc
etc

Now should I have the user info in one table and the character info in another or should they both be in the same table?

6:31 am on Jan 3, 2005 (gmt 0)

Full Member

10+ Year Member

joined:Apr 27, 2003
posts:243
votes: 0


Depends, if one user can have more than one character then DEFINITELY yes to having two tables. If a user can only have one character, I don't see why you couldn't have them in one table.
8:49 am on Jan 3, 2005 (gmt 0)

Preferred Member

10+ Year Member

joined:Mar 4, 2004
posts:553
votes: 0


for each user account there will be one character.
7:46 pm on Jan 3, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator jatar_k is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 24, 2001
posts:15756
votes: 0


I would think 2

the way I look at it there will be things attributed to users that has nothing to do with characters and things for characters that are not connected to users.

8:01 pm on Jan 3, 2005 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member 10+ Year Member

joined:Aug 1, 2003
posts:815
votes: 0


I agree that two tables are better. Otherwise, you can bet you'll eventually use "Name" when you mena "Character Name."

Keep an eye towards flexibility when you design your data. A user is a user and a character is a character. In a "future version," maybe you'll want multiple characters per player, characters with no player, etc. Right now you want to ensure a one-to-one correspondence between player and character. That's all possible with 2 tables.

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members