Is there any need of log table

Issue

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.

Solution

From what you have described, I would assume a column is sufficient.

You might need another table if:

  • An order can have more than one status at the same time
  • You need to keep a history of when the order changed status

There might be other cases that would require another table, but you haven’t described that any such condition applies in your case, as far as I can tell.

Answered By – Bill Karwin

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published