How to implement dynamic product attributes in Laravel?

Question

SQL

Tell me the logic for implementing dynamic product attributes.
The bottom line is:
There is an online store of roofing materials, which has various manufacturers. Accordingly, they will have different attributes. So we have to change the filter depending on the category. Proceeding from this, as I understand it, we make dynamic product attributes.
What is the difficulty:
If I make a table with attribute names, a table with attribute binding to a category, and a table with product_id, attribute_id, value
Then how can I get and display this whole thing?

Answer 1

Creation of EAV - problems in the future.
Use JSON
https://coussej.github.io/2016/01/14/Replacing-EAV...