Results 1 to 1 of 1
Jan 8, 2006, 09:50 #1
- Join Date
- Nov 2002
- Madison, WI USA
- 0 Post(s)
- 0 Thread(s)
setting up table for product searches
I am creating a database for fashion designers. Each fashion desiger is an a table named "authorize" and have an id of "member_id".
The question comes in setting up the table(s) to enter their styles of work.
A quick example would be there is a master category of shoes, under which there are sub-categories: (pumps, clogs, boots, athletic shoes, etc...)
*there will be other categories like clothes, dresses, etc.. which will of course of other subcategories.
The subcategories have styles (Toe Type, Color, Heel Type, etc...)
Each of the categories could be either men or women.
How would I set this up? Whould this be several tables, with several more lookup tables? Or could it just be one table with an id that ties each together? I know that somehow there would be a lookup table for the product to user.