M
M
Maxim Volkov2019-11-21 12:05:00
Database design
Maxim Volkov, 2019-11-21 12:05:00

How to organize database tables with product characteristics when creating a catalog in Laravel?

The task is to display product groups in the product catalog, where each product has the same characteristics with different values, for example: width, height, length, weight, power, etc.
What is the most rational way to organize tables with links in order to display its characteristics with values ​​in the catalog element card.
I can't figure out how to design tables and relationships: product -> characteristic -> value, so that by product id you can get a list of characteristics with their values.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Aksentiev, 2019-11-21
@voland700

EAV

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question