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
Subject
Written By
Posted
Design of tables
January 18, 2010 03:22PM
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.