One of the things I’ve come across in most systems is the requirement for auditing.
As i see it there are 3 approaches to auditing
When - Keeping track of when something changed. e.g Product A was changed by Bob on 1st April 2009.
What - Keeping track of what changed - e.g Product A's price was changed from £15 to £20 by bob on 1st April 2009
Why - Keeping track of why something changed - e.g Product A's price changed from £15 to £20 by bob on 1st...