Welcome to WebmasterWorld Guest from

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
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.

Character Name
Character Type

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
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
votes: 0

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


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

joined:July 24, 2001
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
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