Audit Trail Database Table Design. These audit tables can be either clones of the respective tables-to-be-audited ie. Option 3 is almost always the best one at least for traditional structured databases.
With the Audit Trail module the following tables are added to the database. An audit table for each table to be audited. Option 3 is almost always the best one at least for traditional structured databases.
Sourced from database transaction logs it describes all the changes to the records of an.
Regenerate the audit triggers and procedures for the table so that they now audit the additional column. I have also stumbled upon this interesting article on Maintaining a Log of Database Changes that tries to list the pro and cons of each approach. Represents the table where the AuditDataItemPersistent objects are stored. Sourced from database transaction logs it describes all the changes to the records of an.
