Jump to content

cetaces

New Members
  • Posts

    1
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

cetaces's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I have a design question that perhaps someone could guide me on.  If I am to build a database consisting of users and a list of items attached to each user what would be the best design layout.  There can be only one of each particular item per user but there may be any number of different items assigned to a user.  Would it be better to? Have one table for users and another table for items and each time a user adds an item to their list, add that users name and item to the items table? User1 item1 User2 item1 User3 item4 User1 item2 User1 item4 User2 item2 Etc… Or Set it up so that each time a user registers, a separate table is created just for them and then each time an item is added to that user’s list it is added to their own personal table. Or Have one master table that has the users in it and then a field for items that is a list built with some type of delimiter and has to be destructed and constructed each time a user deletes or adds an item to their list. Or is there a better way that I am simply to inexperienced to see yet? I’d love to hear some of the different ideas from experienced users with respect to performance positives and negatives for the different design options. Thanks in advance for any feedback!
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.