What is the best way to organize the database schema?

Question

MySQL

Hello!
The situation is this:
There are goods, there are shops. Different stores may have the same product, but the price will be different.
What is the best way to organize the base in this case?
It comes to my mind to make a separate table where the product - store relationship and the column with prices for each specific relationship will be stored, but is this correct?
Application in php, laravel 5.1, MySQL database
Sorry if the question is stupid, but I want to hear advice and do everything right.

Answer 1

I organized it through many-to-many relationships. You will need table pivots. How to optimize a select query in Laravel5 (many-to-many) ? I asked a question. There is little description. I saw somewhere more about pivot tables, but I can't find it.

Answer 2

I didn’t understand the question halfway, your terminology is hard.
My suggestion:
- table Shop(id, ...);
- table Goods(id, ...);
- table ProductPrice(shop_id, product_id, price);

Answer 3

Add the price
product_id / shop_id / price to the link table

Answer 4

How else can it actually be done? Everything is correct in the question. You can only add a scope for convenience, which adds a column with prices to the request, so that all this looks more transparent.