Answer the question
In order to leave comments, you need to log in
Is the order table structure of an online store correct?
Hello! Looking at the source codes of the CMS of online stores, all are built on the principle that the data from the user's basket table is duplicated in the corresponding order when placing it. In my understanding, it’s more correct to simply add a foreign key to the cart in the order. Or is it bad practice, what do you think?
Answer the question
In order to leave comments, you need to log in
This practice is aimed at avoiding mistakes.
If you paid attention, then the price at the time of sale and the discounts applied to the product and bonus data are fixed there, and in many cases you cannot even edit it from the interface.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question