© 2009-2021 COLOSSUS INCORPORATED. ** For Official Use Only / Sensitive **
Table slot9.WORLD.TSTA.ACCESS_LOGS
Define list of URLs to monitor for access to log
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
LOG_ID number 38
ASSIGNMENT_LOGS.LOG_ID Implied Constraint R
CITATION_DELETE.LOG_ID Implied Constraint R
EVIDENCE_DELETE.LOG_ID Implied Constraint R
FLDINT_DELETE.LOG_ID Implied Constraint R
INCIDENT_DELETE.LOG_ID Implied Constraint R
JS_OFFICER_DAILY_VW.LOG_ID Implied Constraint R
WARRANT_DELETE.LOG_ID Implied Constraint R
WARRANT_SERVING_OFFICERS.LOG_ID Implied Constraint R
Unique identifier for log entry
MODULE_CODE varchar2 100  √  null
ACCESS_MODULES.MODULE_CODE ACLOGS_MODULE_CD_FK R
Name of application module
USER_NAME varchar2 100  √  null User ID who accessed the record being logged
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE ACLOGS_AGNCY_CD_FK R
Agency ID of user who accessed the record being logged
ACCESS_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE ACLOGS_ACCESS_TYPE_FK R
Defines what type of access to log
ACCESS_TYPE_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE ACLOGS_ACCESS_TYPE_FK R
EJS code type for the access type
RECORD_ID number 38  √  null Unique ID for the module record being accessed (case id, warrant id, etc.)
ACCESS_TIMESTAMP date 7  √  null Timestamp the record was accessed (truncated to the hour to prevent too many access entries)
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"LOG_ID" IS NOT NULL ACLOGS_LOG_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
LOG_ID Primary key Asc ACLOGS_PK  
ACCESS_TYPE_CODE_TYPE + ACCESS_TYPE_CODE Performance Asc/Asc ACLOGS_ACCESS_TYPE_FK_I  
AGENCY_CODE Performance Asc ACLOGS_AGNCY_CD_FK_I  
MODULE_CODE Performance Asc ACLOGS_MODULE_CD_FK_I  
RECORD_ID Performance Asc ACLOGS_RECORD_ID_I  
MODULE_CODE + USER_NAME + AGENCY_CODE + ACCESS_TYPE_CODE + ACCESS_TYPE_CODE_TYPE + RECORD_ID + ACCESS_TIMESTAMP Must be unique Asc/Asc/Asc/Asc/Asc/Asc/Asc ACLOGS_UK These unique columns are also nullable

Close relationships  within of separation: