M
M
Michael2018-01-02 16:16:39
ASP.NET
Michael, 2018-01-02 16:16:39

What is the best way to store order status in the database?

Good afternoon, there is such a moment.
There is an order
table of orders
- a table of products that are included in the order (quantity, etc.)
- comments on the order
There was a need to store the status of the order for each update, so that roughly speaking for the 5th update of the order I can see what has changed in the order.
What is the best way to store such states, maybe there are convenient mechanisms for this?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Filippenko, 2018-01-02
@mix_gorbachev

If only for viewing, then one additional table with all the data of the previous state wrapped in JSON is enough.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question