Table slot9.WORLD.TSTA.ACCESS_MODULES
Define list of modules (and associated request parameter) to monitor access
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
MODULE_CODE varchar2 100
ACCESS_LOGS.MODULE_CODE ACLOGS_MODULE_CD_FK R
ACCESS_URLS.MODULE_CODE ACURLS_ACMOD_FK R
Name of application module
REQ_PARAM varchar2 100  √  null Name of request parameter used within the application to identify the unique id for the module
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
"MODULE_CODE" IS NOT NULL ACMOD_MODULE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
MODULE_CODE Primary key Asc ACMOD_PK
REQ_PARAM Performance Asc ACMOD_REQ_PARAM_I

Close relationships  within of separation: