php mysql控制帖子表单字段

Question

I am trying to create a database for storing cars information.

Cars can be categorized as new, used, or for rent. Each type of car category has different attributes, because new cars have different features that are not needed for used, and same case for used and rent category. Attributes can be added, deleted in future using Application Admin side form manager for these 3 categories.

currently i am storing these in 1 product table with all the attributes required by these 3 categories.

PRODUCT(id,title,description,model,kilometer,enginsize,conditions,.....,.,...)

As form for each category is proposed to be managed from admin control, i am looking for a new scalable database.

current development:

all common attributes in Products

PRODUCT(pid,title,description,...)

CATEGORY(cid,cname) new,used,rent

form_field(formfield_id,name,type)  to store all attributes that are not common

form_field_category(formfield_id,cid) to store category associated attributes

form_post_data(post_id,pid,formfield_id,value) to store submitted data

Any suggestions.

Answer 1

What you need is called an Entity-Attribute-Value model.

If most of the values in table form_post_data are text, simply make it a varchar field. However if you're storing numeric values, choices and other types (things you might want to filter on), have a look at this article An alternative way of EAV modelling.

For you have properties that can have multiple values, have a look at this follow up article EAV multi-value fields.