Table slot9.WORLD.TSTA.ARREST_LOG
This table stores the log entries for changes to property, disposition, etc. on an ARREST as done within the application
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
ARREST_LOG_ID number 0
ARREST_ID number 0
ARRESTS.ARREST_ID ARL_ARR_FK R
LOG varchar2 4000  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
LOG_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ARL_EJSCD_LOGTYPE_FK R
FK to ejs codes (code) defines user log entry type
LOG_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ARL_EJSCD_LOGTYPE_FK R
FK to ejs codes (code type) defines user log entry type

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ARREST_ID" IS NOT NULL ARL_ARREST_ID_NN
"ARREST_LOG_ID" IS NOT NULL ARL_LOG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ARREST_LOG_ID Primary key Asc ARL_PK
ARREST_ID Performance Asc ARL_ARR_FK_I
LOG_TYPE_CODE_TYPE + LOG_TYPE_CODE Performance Asc/Asc ARL_EJSCD_LOGTYPE_FK_I

Close relationships  within of separation: