auditTrail

(Dev Manual)

One record = one edit of a single field in a database

General Info

This table records edits to various fields in the database. All edits to many fields in the database are logged to this table. I don't know if it will get too large to deal with at some point, we might have to dump it from time to time.

Relationships

The auditTrail table is only related to the auditTrail Shadow table for syncing. The individual records are found via a script with variables and not a relationship.

Edit Data

The auditTrail table is populated solely through the script triggers on various layouts in the database. See Audit Trail in the Dev Manual.

<- Change Log Bibliography->