Hello. Faced the problem of creating an average complexity of the product catalog. The problem is mainly that the products are very different in characteristics. Example of product characteristics: Cornices, platbands (Name, article, price without primer, price with primer, price with painting) Insulators for pipes (Name, article, price, radius of the external pipe, insulation thickness, pipe thickness.) Formwork (Name, article , price, height, thickness, width) Characteristics described by the customer.
The question is how best to make the structure. 1) Create one table with common fields (Name, article) and a second table with characteristics, characteristics differ greatly, prices are completely different. How convenient is this method? 2) Push everything into one table and, when adding or issuing, issue only the necessary fields? I understand that it is crooked, but I would like to have only one table with goods, related keys with categories (To the house (Cornices and platbands), to the dacha (Pipes and formwork)) 3) Spray each type of product into a separate table.
Please tell me where to look for an example or who has a similar experience. How to competently make it relatively easy to scale, I will feel more goods and the number of characteristics will also increase ...
