Table slot9.WORLD.TSTA.ROUTE_ACTIONS
This table defines routing actions for routing custom form notifications
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_ACTION_ID number 38
ROUTE_ACTION_AGENCIES.ROUTE_ACTION_ID RTEAA_RTEACT_FK R
ROUTE_ACTION_INSTANCES.ROUTE_ACTION_ID RTEACTIN_RTEACT_FK R
ROUTE_ACTION_ROLES.ROUTE_ACTION_ID RTEAR_RTEACT_FK R
ROUTE_ACTION_USERS.ROUTE_ACTION_ID RTEAU_RTEACT_FK R
ROUTE_ACTIONS.PARENT_ROUTE_ACTION_ID RTEACT_RTEACT_FK R
TEMPLATE_ID number 38
ROUTE_TEMPLATES.TEMPLATE_ID RTEACT_ROUTEM_FK R
PARENT_ROUTE_ACTION_ID number 38  √  null
ROUTE_ACTIONS.ROUTE_ACTION_ID RTEACT_RTEACT_FK R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REQUIRE_COMMENT_FLAG varchar2 1  √  'N' Set to Y if you want to require a comment on this route submission
TEXT varchar2 500  √  null
USER_CANCEL_FLAG varchar2 1  √  'N'
DISABLE_ADD_USERS_FLAG varchar2 1  √  'N'
DISABLE_REMOVE_USERS_FLAG varchar2 1  √  'N'
DISABLE_ADD_ROLES_FLAG varchar2 1  √  'N'
DISABLE_REMOVE_ROLES_FLAG varchar2 1  √  'N'
REQUIRE_ONE_USER_FLAG varchar2 1  √  'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ROUTE_ACTION_ID" IS NOT NULL RTEACT_ACTION_ID_NN
"TEMPLATE_ID" IS NOT NULL RTEACT_TEMP_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ROUTE_ACTION_ID Primary key Asc RTEACT_PK
TEMPLATE_ID Performance Asc RTEACT_ROUTEM_FK_I
PARENT_ROUTE_ACTION_ID Performance Asc RTEACT_RTEACT_FK_I

Close relationships  within of separation: