Table slot9.WORLD.TSTA.NOTIFY_DETAIL_DISABLE_ALERTS
This table defines the notification alerts that are to be disabled. This is available by selecting the flashing notifications when new ones arrive and select disable
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 10
NOTIFICATION_DETAILS.NOTIFY_DTL_NUMBER NDDA_DTL_NUM_FK C
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID NDDA_LGIN_ID_FK R
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

Analyzed at Mon Sep 20 21:05 MDT 2021

Indexes:
Column(s) Type Sort Constraint Name
NOTIFY_DTL_NUMBER + LOGIN_ID Primary key Asc/Asc NTFY_DTL_DSBL_ALRTS_PK
NOTIFY_DTL_NUMBER Performance Asc NDDA_DTL_NUM_FK_I
LOGIN_ID Performance Asc NDDA_LGIN_ID_FK_I

Close relationships  within of separation: