Whether the order status of the order table needs to be represented by different fields of transaction status, payment status, logistics status.

does the order status of the order table need to be represented by different fields for the transaction status, payment status, logistics status?
at present, I use a field to represent all the status of the order. I don"t know what"s wrong with this?
Please give me some advice

Apr.05,2021

you can have a field for these statuses. This is not a big problem, but the status of "deleted" should not be put in this field, because it should be a logically deleted identity and should be stored separately, such as is_delete. The default value of the field is not deleted, and it becomes deleted only after deletion.


the disadvantage is that if the order is deleted in the foreground and in the background, please tell me what is the status of the order seen by the Recycle Bin?


how to do the refund
in order to expand in the future, I think it's better to separate
transaction status, payment status, logistics status

.
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b3aa18-e77b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b3aa18-e77b.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?