AuditPlus tables

Audit plus imports some tables that they are used for its functionalities.

AuditTransactionMetadata

It stores the name and the description of all the audited transactions. They are identified by the internal GUID of the object. 

GeneXus generates a GUID for each object and attribute in the KB. This GUID is unique and it isn't modified any time. You can see the GUID of an object exporting that object or attribute as XML and opening that file.

AuditTableMetadata

It stores the name, description, parent table of all the audited tables (A transaction can have multiple tables). They are identified by the internal GUID of the object.

It stores if the audit of that table can be turned off at runtime.

AuditAttributeMetadata

It stores the Name and description of all the attributes of the audited transactions. They are identified by the internal GUID of the object.

AuditTableAttribute

It associates to each table all the attributes of that table. One attribute can be in multiple tables, because it can be key of one table and foreign key of another table. For each record, it stores if it is FK, PK or description attribute of that table.

AuditRecord

It stores all the information of a modification of a record. The date, user, transaction and table.

AuditRecordAttribute

In this table are stored all the attributes inserted or modified of a record, storing the previous value and the new value.

AuditRecordAttributesBlob

In this table are stored all the blob attributes modified of a record.