MySQL Forums
Forum List  »  Newbie

Design of tables
Posted by: Andy Deans
Date: January 18, 2010 03:22PM


i know this might be a simple answer from someone out there but just need to understand something:

i have a php site which mysql database sits behind. basically it will sell various products.

a user can have multiple clients and a client can be sold multiple products.

the products are different criteria. by that what i mean is, when the user goes in and allocates a product to the client the form is different that he will fill out. so one might be for car insurance and the other might be for home insurance.

what i am not sure is, do you create just one products table and just change the fields in the app to reflect this or do you create multiple tables, 1 for car insurance and 1 for home insurance?

many thanks

Options: ReplyQuote

Written By
Design of tables
January 18, 2010 03:22PM
January 19, 2010 02:22PM
January 19, 2010 05:11PM
January 19, 2010 09:08PM
January 20, 2010 06:25AM
January 20, 2010 09:05AM
January 20, 2010 10:57PM
March 20, 2010 03:41AM
March 20, 2010 01:07PM
March 20, 2010 04:23PM
March 21, 2010 09:28AM
March 21, 2010 12:59PM
March 21, 2010 03:09PM
March 23, 2010 04:41AM
March 23, 2010 07:52PM
March 24, 2010 05:05AM
March 23, 2010 11:20AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.