Page 1 of 1

Dbase design question for 2 tables

Posted: Thu Jul 27, 2006 1:54 pm
by tdnxxx444
Was wondering which is there better database design situation:

1.
user
------
user_id
user_name

item
------
item_id
user_id
item_name

2.
user
------
user_id
user_name

item
------
item_id
item_name

user_item
----------
user_id
item_id

Posted: Thu Jul 27, 2006 1:57 pm
by feyd
what's this intended for? Can you describe what you are trying to do?

Posted: Thu Jul 27, 2006 2:36 pm
by tdnxxx444
Each user is suppose to have various items in his inventory.

Posted: Thu Jul 27, 2006 2:41 pm
by feyd
so, any number of users can have any number of items, basically? The second one then.