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