Good thought for a redesign when this gets moved to a new backend - some sort of generalized audit table for all the key tables. If you did this, did you have one audit table per table to be tracked or did you have an overall audit table that had a field to indicate the table being tracked?

>Or it could be a byproduct of an audit table...