Which database schema to choose for a product catalog?

Question

SQL

There is a catalog of goods: mattresses, beds, pillows, bed linen. Foolishly, I made everything in separate tables, since the sets of characteristics are different.
Like tables like this:

МоделиМатрасов (фото, базовые характеристики: высота, состав, производитель – FK, ...)
ВнешнийВидМатрасов (вариации с пружинными блоками (FK) и чехлами (FK) и FK на Модель)
ВариантыМатрасов (Вид, Размер – FK, цена)

About the same with the beds, but there are other characteristics and photos for each. Appearance is separate.
How can I generalize all these goods, use json / jsonb? Will it be convenient to search by filters in the catalog? And how to work with this in the Doctrine (or abandon it in this case?)

Answer 1

You need this schema for the database.

Answer 2

You need specs separately. make goods separately ...
Here's just a one-on-one example to make it convenient to work with the filter and that the plates were with a small number of columns:
Do 1 large table or split it into parts?
If it is not very clear - write questions, I will help to understand