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)

Similar questions

C

Cheizer2020-01-04 18:31:08

How to cut a string in a loop in PHP? 2Reply

K

kkoshakk2019-11-03 14:54:57

What is the best way to make a fast database structure of settlements? 2Reply

V

Vic Shostak2017-06-11 16:15:23

What is the best way to organize a database for a Django / Flask web service in order to prepare for heavy loads? 1Reply

S

Sergey Ilichev2021-05-12 16:17:21

When should you allocate data to a separate table? 2Reply

S

Sergey Khlopov2019-11-26 11:20:04

What is the best way to make relationships between tables and the tables themselves? 0Reply

Didn't find what you were looking for?

Ask your question