MySQL Forums :: Newbie :: Design of tables


Advanced Search

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

hi,

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


Subject Written By Posted
Design of tables Andy Deans 01/18/2010 03:22PM
Re: Design of tables Chad Bourque 01/19/2010 02:22PM
Re: Design of tables Andy Deans 01/19/2010 05:11PM
Re: Design of tables Rick James 01/19/2010 09:08PM
Re: Design of tables Andy Deans 01/20/2010 06:25AM
Re: Design of tables Andy Deans 01/20/2010 09:05AM
Re: Design of tables Rick James 01/20/2010 10:57PM
Re: Design of tables Andy Deans 03/20/2010 03:41AM
Re: Design of tables Rick James 03/20/2010 01:07PM
Re: Design of tables Andy Deans 03/20/2010 04:23PM
Re: Design of tables Rick James 03/21/2010 09:28AM
Re: Design of tables Andy Deans 03/21/2010 12:59PM
Re: Design of tables Rick James 03/21/2010 03:09PM
Re: Design of tables Andy Deans 03/23/2010 04:41AM
Re: Design of tables Rick James 03/23/2010 07:52PM
Re: Design of tables Andy Deans 03/24/2010 05:05AM
Re: Design of tables Guelphdad Lake 03/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.