You may want to audit or ‘journal’ changes to your data.
As you update a record, add a record, or delete a record – log that change in a different table.
When doing your designs in the Data Modeler, you can ask at the time of DDL generation to have the journaling table and trigger created for one or more of your relational design tables.
Step One: Hit the DDL button.
For each table, you’ll get the journal table and the trigger to populate said table.