Say i have an order that's placed, the credit card has been authed. but..in fulfillment the order changes (defective item, customer changes order, etc)..
I want my database designed in such a way as to allow an easy query of changes to that order (or any/all other data)?
One idea is to 'mirror' each table (Customers ==>CustomerChanges, Orders ==> Orders==>OrderChanges, OrderItems ==> OrderItemsChanges) .. where each 'change' table has a timestamp and the username of the person who made the change.
Pulling stuff from logs will not do because this has to happen on the fly.
Hmmmmmmmmmmmmm.
I want my database designed in such a way as to allow an easy query of changes to that order (or any/all other data)?
One idea is to 'mirror' each table (Customers ==>CustomerChanges, Orders ==> Orders==>OrderChanges, OrderItems ==> OrderItemsChanges) .. where each 'change' table has a timestamp and the username of the person who made the change.
Pulling stuff from logs will not do because this has to happen on the fly.
Hmmmmmmmmmmmmm.