Hello,
I posted this message yesterday but it’s not here anymore. Maybe somethinbg happened when kirupa was optimizing the forum last night.
Anyway, my question was:
in a Table called users i have 4 fields:
USERS
id | name | age | list
there could be thousands of users and as many items in one list, and each list item is UNIQUE(per user) but user can have the same items.
I suggested making a new table called list:
USERS
id | name | age
LIST
id | item
Some one replied to this and said that i was all wrong.
According to him I should make one list table per user:
USERS
id | name | age
LIST_$id(id from USERS.id)
| item |
it seems weird to me to create so many tables, since there might be multiple thousand users.
However, I trust the answer and will implement it.
But can someone explain the reasonning behind it? Thx a lot
and thx to the guy who had replied to this post before it was lost in space.
