I am developing an application that has database of mysql having orders and orderdetails table. order table having column orderStatus. My question is whether it is necessary to create another order log table if order status is 'closed' (that means completed orders) or just orderstatus column is enough.
-
what is your criteria for "necessary"? Obviously both can work. The full range of queries needs to be examined to look at the complexity of all of them. If you are unsure of these, just pick a method, the simplest one. As you develop you application you'll start to see if it was a bad choice or not, at which you can change, or call it software debt.– danblackAug 30, 2022 at 2:04
-
@danblack thank you– Sudip977Aug 30, 2022 at 5:35
Add a comment
|