Table slot9.WORLD.TSTA.NOTIFY_ROLES
This table defines the roles in which a notification will be sent when created
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
NOTIFY_TYPE_CD number 8
NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD NR_NDM_FK R
ROLE_NAME varchar2 30
ROLE_SECURITIES.ROLE_NAME NR_RS_FK R
Database Role
CUSTODY_ONLY varchar2 1  √  null A flag to issue the notification only if the person is in custody.
EMAIL_ENABLED varchar2 1 'N' A Flag indicating if the role is to recieve an email notification along with the standard notification.
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
EMAIL_ENABLED IN ('Y', 'N') CK_NR_EMAIL_ENABLED
"EMAIL_ENABLED" IS NOT NULL NR_EMAIL_ENABLED_NN
"NOTIFY_TYPE_CD" IS NOT NULL NR_NOTIFY_TYPE_CD_NN
"ROLE_NAME" IS NOT NULL NR_ROLE_NAME_NN

Indexes:
Column(s) Type Sort Constraint Name
NOTIFY_TYPE_CD + ROLE_NAME Primary key Asc/Asc NR_PK
NOTIFY_TYPE_CD Performance Asc NR_NDM_FK_I
ROLE_NAME Performance Asc NR_RS_FK_I

Close relationships  within of separation: