Table slot9.WORLD.TSTA.NOTIFICATION_DETAILS
This table stores the actual notifications sent to users and is accessible from the home page
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_DTL_NUMBER number 8
NEW_NOTIFICATIONS_VW.NOTIFY_DTL_NUMBER Implied Constraint R
NOTIFICATION_DETAILS_DATA.NOTIFY_DTL_NUMBER NDTL_DATA_NDTL_FK C
NOTIFICATION_DTL_ROLES.NOTIFY_DTL_NUMBER NTDTLRL_NDTL_FK C
NOTIFY_DETAIL_DISABLE_ALERTS.NOTIFY_DTL_NUMBER NDDA_DTL_NUM_FK C
NDM_NOTIFY_TYPE_CD number 8
NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD NDTL_NDM_FK R
NOTIFY_DTL_PRIORITY_NUM number 1
NOTIFY_DTL_INFO varchar2 80  √  null
NOTIFY_DTL_TYPE varchar2 80  √  null
NOTIFY_DTL_ROLE varchar2 30  √  null
NOTIFY_DTL_USER_ID varchar2 100  √  null
NOTIFY_DTL_DATE_TIME date 7  √  null
ACTIVE_KEY_1 varchar2 39  √  null
ACTIVE_KEY_2 varchar2 39  √  null
ACTIVE_KEY_3 varchar2 39  √  null
ACTIVE_KEY_4 varchar2 39  √  null
ACTIVE_KEY_5 varchar2 39  √  null
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE Implied Constraint R
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
BUSY_FLAG varchar2 1  √  null
NOTES varchar2 4000  √  null
UNIT_CODE varchar2 5  √  null
EMP_SERVICE_ASSIGN_CODES.CODE NDTL_EMPSRVASC_FK R
REC_ID number 0  √  null
SUB_CATEGORY varchar2 255  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"NDM_NOTIFY_TYPE_CD" IS NOT NULL NDTL_NDM_NOTIFY_TYPE_CD_NN
"NOTIFY_DTL_NUMBER" IS NOT NULL NDTL_NOTIFY_DTL_NUMBER_NN
"NOTIFY_DTL_PRIORITY_NUM" IS NOT NULL NDTL_NOTIFY_DTL_PRIORITY_NU_NN

Indexes:
Column(s) Type Sort Constraint Name
NOTIFY_DTL_NUMBER Primary key Asc NDTL_PK
UNIT_CODE Performance Asc NDTL_EMPSRVASC_FK_I
NDM_NOTIFY_TYPE_CD Performance Asc NDTL_NDM_FK_I
NOTIFY_DTL_ROLE Performance Asc NTDL_ROLE_I
NOTIFY_DTL_USER_ID Performance Asc NTDL_USERID_I

Close relationships  within of separation: