K
K
Konstantin2018-10-14 06:19:15
SQL
Konstantin, 2018-10-14 06:19:15

What is the relationship between tables behind such logic?

A product may have several prices depending on the country. There can also be many countries.
Does this directly mean the relation of the Products -> ProductsPrices tables as one to many?

Answer the question

In order to leave comments, you need to log in

3 answer(s)
S
Sly04, 2018-10-14
@Junart1

A product may have several prices depending on the country.

Well, you yourself wrote, one product -> several prices. Communication: one to many.

A
ApeCoder, 2018-10-14
@ApeCoder

Yes

A
Andrey, 2018-10-14
@VladimirAndreev

If the database natively supports json fields, then the second table is not required.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question