Table slot9.WORLD.TSTA.TABLE_ADMIN_AUDIT
This table audits all actions taken via the table administration module including inserts, updates, and deletes
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
AUDIT_ID number 0 Unique ID for each audit row. Serves as part of primary key
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID TAA_IUP_FK R
Identifies who performed the admin action
DATETIME date 7  √  null Timestamp identifies when action was performed
DB_TABLE varchar2 30  √  null Identifies which database table the action was performed upon
ACTION varchar2 30  √  null Identifies action taken (INSERT, UPDATE, or DELETE)
SQL_STATEMENT varchar2 500  √  null Specific SQL statement executed

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AUDIT_ID" IS NOT NULL TAA_AUDIT_ID_NN
"LOGIN_ID" IS NOT NULL TAA_LOGIN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
AUDIT_ID Primary key Asc TAA_PK
LOGIN_ID Performance Asc TAA_IUP_FK_I

Close relationships  within of separation: