Posted by MadDiver on 06/05/07 04:56

Guys,

I need to create an application that handles several product types/
categories. Each product type can have totally different fields to
describe it. For instance a car would have Year, Make, Model, and
Miles, whereas a house would have Year, Address, SQ Feet, Amenities,
etc.
These are just examples but you get my drift.

the application needs a form to input, show and search the data for
each of the product types.

I cannot hard-code each product type and its associated fields in the
database, since one of the requirements is that an administrative user
can create any product type he/she needs. The application then has to
generate the forms for data input, show, and search on the main site.

What are your suggestions as how to best address these requirements?
What would be the best DB schema?

THANKS!!!

[Back to original message]