Friday, May 27, 2011

Small Design Pattern: Status History

Where a table has a field for status lifecycle (e.g., New, In-Process, Pending, Complete, Void). You have a couple of options. One is to keep updating the Status field each time it changes. But if you want an audit trail of that  history, you can have a child table that captures each snapshot of history. It would be nice to have it one-click automated.

No comments:

Post a Comment