Footprints Data Model

Table
Name audit_log
Comment 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.

Column
Name Datatype Comment Is PK Is FK
audit_log_id bigint The automatically generated primary key of the audit_log table. Yes No
audit_event_type_id BIGINT 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. No Yes
audit_txn_id bigint A Foreign Key to the Audit Transaction table. No Yes
create_date datetime 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. No No
insert_update_delete_cd varchar(255) Indicates I-Insert, U-Update, D-Delete database action. No No
string_parm_1 varchar(4000) A substitution parameter for the referenced formatted string. No No
string_parm_2 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_3 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_4 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_5 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_6 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_7 varchar(255) A substitution parameter for the referenced formatted string. No No
string_parm_8 varchar(255) A substitution parameter for the referenced formatted string. No No
raw_msg varchar(max) The value of a Audit Log, stored as a long text object. No No
audit_prop_dim_id bigint A Foreign Key to the Audit Property Dimension table. No Yes
domain_obj_id bigint The numeric Primary Key of the Object that is autologged. No No
audit_msg_tmpl_id bigint A Foreign Key to the Audit Message Template table. No Yes
string_parm_7_int varchar(4000) 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. No No