Table slot9.WORLD.TSTA.ROUTE_INSTANCES
This table stores the instances of notification routes for a custom form
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
ROUTE_INSTANCE_ID number 38
ROUTE_ACTION_INSTANCES.ROUTE_INSTANCE_ID RTEACTIN_RTEINST_FK R
ROUTE_INSTANCE_AGENCIES.ROUTE_INSTANCE_ID RTINSTAG_RTINST_FK R
ROUTE_INSTANCE_ROLES.ROUTE_INSTANCE_ID RTINSTRL_RTEINST_FK R
USER_SCREEN_COMMENTS.ORIG_RTE_INST_ID USRSCRN_COM_RTEINST_FK R
USER_SCREEN_INST_ROUTES.ROUTE_INSTANCE_ID USRSCRTI_RTEINST_FK R
TEMPLATE_ID number 38  √  null
ROUTE_TEMPLATES.TEMPLATE_ID RTEINST_ROUTEM_FK R
STATUS_CODE varchar2 30
EJS_CODES.CODE RTEINST_STATUS_CD_FK R
STATUS_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE RTEINST_STATUS_CD_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ROUTE_INSTANCE_ID" IS NOT NULL RTEINST_INST_ID_NN
"STATUS_CODE" IS NOT NULL RTEINST_ST_CD_NN
"STATUS_CODE_TYPE" IS NOT NULL RTEINST_ST_CD_TP_NN

Indexes:
Column(s) Type Sort Constraint Name
ROUTE_INSTANCE_ID Primary key Asc RTEINST_PK
TEMPLATE_ID Performance Asc RTEINST_ROUTEM_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc RTEINST_STATUS_CD_FK_I

Close relationships  within of separation: