Footprints Data Model

Table
Name audit_txn
Comment
A record of the Principal and create time of the start of the commit time of a
logical transaction.  In many cases multiple Audit Log entries will use the same
transaction.

Column
Name Datatype Comment Is PK Is FK
audit_txn_id bigint The automatically generated primary key of the audit_txn table. Yes No
txn_start_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
app_user_id bigint
A Foreign Key to the Application User table.  The audit trail transaction may
or may not be associated with a customer or agent user.  If this column is null,
then a system component should be identified.
No Yes
sys_component_id int
This is a foreign key to the system component table. The audit trail
transaction may or may not be associated with a customer or agent user.   The
system component will be set if there is no application user identified.  It
identifies the source of the transaction.  Values include SYSTEM, WEB_SERVICES,
ASSET_MANAGEMENT, CALENDAR,
IMPORTING, etc.  All identifiers are negative, so that they can be
distinguished from userids in case they are both stored in the same dynamic
table CreatedBy, and UpdatedBy fields.  We are going to try first normal form
normalization here and see if it works.

No Yes