Table slot9.WORLD.TSTA.ROUTE_ACT_INST_USR_ROLES
This table stores an instance of the notification routing information 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
ACTION_INST_USER_ID number 38
ROUTE_ACTION_INST_USERS.ACTION_INST_USER_ID RTEATRO_RTEACTINUS_FK R
ROLE_NAME varchar2 30
ROLE_SECURITIES.ROLE_NAME RTEATRO_RS_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
"ACTION_INST_USER_ID" IS NOT NULL RTEATRO_ACT_INST_ID_NN
"ROLE_NAME" IS NOT NULL RTEATRO_ROLE_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
ACTION_INST_USER_ID + ROLE_NAME Primary key Asc/Asc RTEATRO_PK
ROLE_NAME Performance Asc RTEATRO_RS_FK_I
ACTION_INST_USER_ID Performance Asc RTEATRO_RTEACTINUS_FK_I

Close relationships  within of separation: