Table slot9.WORLD.TSTA.NOTIFY_PRIORITY_CODES
This table defines the different types of priorities available to assign a notification when creating a new notification template
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
PRIORITY_CODE number 1
IJIS_USER_PROFILES.EMAIL_NOTIFICATIONS_PRIORITY IUP_NPC2_FK R
NOTIFICATION_DEF_MASTERS.NOTIFY_PRIORITY NDM_NPC2_FK R
Notify/Alert priority code
PRIORITY_DESC varchar2 255  √  null Code Description
VISUAL_ALERT_YN varchar2 1 'Y' Does the code visually alert the user?
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
AUDIO_ALERT_YN varchar2 1 'N'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
AUDIO_ALERT_YN IN ('Y', 'N') CK_NPC2_AUDIO_ALERT_YN
"AUDIO_ALERT_YN" IS NOT NULL NPC2_AUDIO_ALERT_YN_NN
"PRIORITY_CODE" IS NOT NULL NPC2_PRIORITY_CODE_NN
"VISUAL_ALERT_YN" IS NOT NULL NPC2_VISUAL_ALERT_YN_NN

Indexes:
Column(s) Type Sort Constraint Name
PRIORITY_CODE Primary key Asc NPC2_PK

Close relationships  within of separation: