Footprints Data Model

Table
Table Name Audit Log
Table Definition The main Audit Log table which uses a serial key to establish the order of Audit Trail entries as committed to the system. It has subordinate notes and data values which are considered unordered within the Audit Log. It is possible and desirable that multiple Audit Log entries would have the same transaction id.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Audit Log Id The automatically generated primary key of the audit_log table. LONG Yes
Audit Event Type Id The unique identifier for an instance of Audit Event Type. This identifier must be kept in sync with programming code that uses an enumeration or fixed constant to identify particular values. LONG Yes
Audit Transaction Id A Foreign Key to the Audit Transaction table. LONG Yes
Create Date The transaction date of the Audit Log entry. This date may not be in strict order with the Audit Log id in the event that features are used to continue a previous Audit Log transaction. DATE Yes
Insert Update Delete Code Indicates I-Insert, U-Update, D-Delete database action. VARCHAR(255) No
String Parameter 1 A substitution parameter for the referenced formatted string. VARCHAR(4000) No
String Parameter 2 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 3 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 4 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 5 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 6 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 7 A substitution parameter for the referenced formatted string. VARCHAR(255) No
String Parameter 7 Int This is a computed column. The integer version of parameter 7. It is only indexed when parameter 8 is '_USER_SESSION_'. It greatly increases the User browse screens ability to compute the last_login. VARCHAR(4000) No
String Parameter 8 A substitution parameter for the referenced formatted string. VARCHAR(255) No
Raw Message The value of a Audit Log, stored as a long text object. TEXT No
Audit Property Dimension Id A Foreign Key to the Audit Property Dimension table. LONG No
Domain Object Id The numeric Primary Key of the Object that is autologged. LONG No
Audit Message Template Id A Foreign Key to the Audit Message Template table. LONG No