How to make an order table with a floating number of items?

I

Igorek982021-06-01 11:24:18

Database design

Igorek98, 2021-06-01 11:24:18

Tell me how to make a table of orders with a floating number of products?
How to store all products and their quantities in a table, so that later we can open this order and get the values \u200b\u200bof these products and prices from other tables.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Slava Rozhnev, 2021-06-01
@rozhnev

This is called a many -to-many relationship :
Example-many-to-many relationship