How to create a database for a filter?

Question

Database design

How do you usually create a database with tables if the site has filters?
A long dependency, where does the table indicate the name of the other 10 tables in which there will be another separate search and selection?
Is there a good article on this topic?

Answer 1

Well, different types of goods are classics.
The table can be made one, the characteristics unique for each product can be stored in the jason field, and searched with special engines such as sphinx or elastic

Answer 2

In each case, the developer decides.
The simplest example for trading components: