I have a database table
real_estate where the basic information is held (
id, status, sku, address, building_type, sales_status) and now I want to attach features to that
The data collected by the agency always uses the same form; a 7 page form structured in different categories.
For example, you have categories like
KITCHEN APPLIANCES etc., and within those categories you have several options for example
renovation_year. Sometimes that option is a single field but other times it's a multiple checkbox or a dropdown or something else. The form is always the same for every piece of Real Estate.
How would I go about saving that information in the database as normalized as possible?
Should I have a table with
real_estate_feature_categories and a table
real_estate_feature that has a many-to-one relationship?
How would I link a specific real estate property to a field with a value?