How to organize a database with dynamic characteristics?

Question

Database design

Greetings!
There are goods with different characteristics in the online store, for example: if these are mobile phones, then the characteristics are as follows (standard: GSM, camera: 20mpx, infrared port: yes, well, etc.), and if it is a refrigerator, the characteristics will be as follows (Type of refrigerator: Two-chamber, Number of compressors: 1, Type of control: Electronic, etc.)
So the question is, how to organize a database using Mysql and Laravel? Does each product type require its own table?
Or use JSON fields? What is safer and faster? Thanks in advance!

Answer 1

From the experience of implementing a similar project: A
separate table is created for all products with the fields:
- [Property ID]
- [Product ID]
- [Property short name] - For example, "Memory capacity"
- [Property value] - For example, "30"
- [Unit dimensions] - For example "GB"
- [Property type] - for grouping properties according to some internal features.
Accordingly, each product can have an infinite number of properties.