Table slot9.WORLD.TSTA.ROUTE_INSTANCE_ROLES
Stores Agencies selected by the user when Sending a forms out for review

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
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R
PK Unique identifier for record
ROLE_NAME varchar2 30
ROLE_SECURITIES.ROLE_NAME RTINSTRL_RS_FK R
FK to AGENCY_CODES
ROUTE_INSTANCE_ID number 0
ROUTE_INSTANCES.ROUTE_INSTANCE_ID RTINSTRL_RTEINST_FK R
FK to ROUTE_INSTANCES
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
"ID" IS NOT NULL RTINSTRL_ID_NN
"ROLE_NAME" IS NOT NULL RTINSTRL_ROLE_NAME_NN
"ROUTE_INSTANCE_ID" IS NOT NULL RTINSTRL_RT_INST_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc RTINSTRL_PK
ROLE_NAME Performance Asc RTINSTRL_RS_FK_I
ROUTE_INSTANCE_ID Performance Asc RTINSTRL_RTEINST_FKK_I

Close relationships  within of separation: