Database design
Posted: Sat Jun 05, 2004 11:13 am
I'm working on a project withs ome friends, and i have one idea, but i dont think it will work or be the best. And i can't think of any other way, so i came to ask for opinions!
Ok i've got a table of items, all withtheir own id and all. Ok, now i have another table for the users items. The way i have that set up is something like:
UserID | i1 | i2 | ..... i29 | i30
the i1 - i30 are for the items in their inventory, and i was goignt o store the itemID in those places. Only now that i think about it this doesn't seem like the best of ideas. So i was wondering if anyone had any suggestions of what i should do...
Ok i've got a table of items, all withtheir own id and all. Ok, now i have another table for the users items. The way i have that set up is something like:
UserID | i1 | i2 | ..... i29 | i30
the i1 - i30 are for the items in their inventory, and i was goignt o store the itemID in those places. Only now that i think about it this doesn't seem like the best of ideas. So i was wondering if anyone had any suggestions of what i should do...