Hello Mark, What exactly is your question?
How to design the tables for the different types of clothing? Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com > Hi All, > > I have the job of creating a DB for an online clothing company. I have > some experience with relational design and sql and php. I'm stumped as > they have products that contain numerous attributes, and are wishing to > get away, if possible, with entering separate records for each and every > product that has different ones. I will list below some example products > and their attributes. > > Shirts: > neck > body_length > shoulder_length > chest > waist > sleeve > cuff > color > > Pants: > waist > under_crotch_length > upper_crotch_length > upper_crotch_back_length > upper_leg_length > lower_leg_length > > Jacket: > body_length > shoulder_length > chest > waist > sleeve > > Belts: > body_length > body_width > waist_length > buckle_length > buckle_length > holes > sleeve_length > > below is a link to what they have on Ebay at the moment, > > http://cgi.ebay.com/DOLCE-GABBANA-PEACE-Jeans-48_W0QQitemZ7757125046QQcategoryZ11483QQtcZphotoQQcmdZViewItem > > keep in mind, I have only listed attributes above, not the actual table > designs. They deal with a lot of variety within brands etc. Anyone got > any solutions for this? I haven't started on a basic design yet, but am > looking to do that soon. I f i can minimize their record input, that'd > be great Cheers. > > Mark. > > ---------------------------------------------------------------------------- ---- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
