Table slot9.WORLD.TSTA.EJS_TABLE_AUDITING
Legacy table. This table is not currently used
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
OLD_VALUE varchar2 255  √  null The old value of an updated record.
AUDIT_DATE date 7  √  null The date and time the audit record was created.
TABLE_NAME varchar2 255 The table name of an audited record.
COLUMN_VALUE varchar2 255  √  null The new value of a record.
ACTION varchar2 30  √  null
EJS_CODES.CODE EA_EJS_CODE_FK R
The action taken. (Insert, Update or Delete.)
TRANSACTION_ID number 38 The transaction id for an audited record.
COLUMN_NAME varchar2 255 The column of an audited record.
CREATOR_ID varchar2 100  √  null The user that created the audit record.
REC_ID number 0  √  null
TABLE_REC_ID number 0  √  null
ACTION_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE EA_EJS_CODE_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"COLUMN_NAME" IS NOT NULL EA_COLUMN_NAME_NN
"TABLE_NAME" IS NOT NULL EA_TABLE_NAME_NN
"TRANSACTION_ID" IS NOT NULL EA_TRANSACTION_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
TRANSACTION_ID + TABLE_NAME + COLUMN_NAME Primary key Asc/Asc/Asc EA_PK
ACTION_TYPE + ACTION Performance Asc/Asc EA_EJS_CODE_FK_I

Close relationships  within of separation: