How to create a table for orders?

S

Stepan19982021-12-10 00:32:22

Database design

Stepan1998, 2021-12-10 00:32:22

If I understand correctly, then two tables need to be made under the order table.

The first one will contain users and order number, and the second one will have n number of lines with products for each order number?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

S

Slava Rozhnev, 2021-12-10
@Stepan1998

At least 4 tables:
Clients (Clients)
Products (Products)
Orders (Orders)
Products in the order (Order_Products)