How to implement properties for different products in an online store?

Question

Yii

There is an online clothing store, each product has its own properties, dresses have their own, shirts have their own, bags have their own as in the picture for example:

How to implement it correctly when adding? Simply adding these fields to a table with products is not an option, how can you display the necessary parameters when choosing a category and at the same time all this was stored separately from the products themselves?

Answer 1

either use a document-oriented database or EAV

Answer 2

Look towards EAV. This is an approach when you have only the most basic characteristics in the product table, such as availability, price, and specific ones are stored in a separate table, where each row is one property. Well, another table for the names of characteristics. Approximately like this:

goods{id, name, price}
attribute{id, name}
attribute_value{id, id_attr, id_good, value}

There are some options related to the data type of the attribute. Those. there can be one table with attribute values ​​and it has fields for both string value and numeric and date for example. And you can have one table per type.

Answer 3

Products
id name table
1 iPhone
3 black Options id name
table 1 white 3 round 4 black Options_to_products table id_product id_option 1 4 1 3 3 1 Something like this, if I understood the question correctly