Change capture
The trigger copies the new row for inserts and updates. For deletes it stores only the primary key. Extra columns hold a change sequence ID, an action code (I, U or D), a timestamp and the user. The two tables had no triggers or foreign keys of their own, so adding a trigger caused no cascading effects.