Table slot9.WORLD.TSTA.INCIDENT_WARNING_NOTIFY_LOG
Log for notifications sent from the Incident Warnings Module
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 38
DS_ICR_CAT_QUERIES.ID Implied Constraint R
SENT_TO_LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID INCWARNOTLG_IUP_FK R
WARNING_ID number 38
DATA_SET_ID number 38  √  null
DS_ICR_DATA_SETS.DATASETID INCWARNOTLG_DSICR_FK R
INCIDENT_ID number 38
INCIDENTS.INCIDENT_ID INCWARNOTLG_INC_FK R
COMMENTS varchar2 4000  √  null
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 INCWARNOTLG_ID_NN
"INCIDENT_ID" IS NOT NULL INCWARNOTLG_INC_ID_NN
"SENT_TO_LOGIN_ID" IS NOT NULL INCWARNOTLG_LOG_ID_NN
"WARNING_ID" IS NOT NULL INCWARNOTLG_WARN_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc INCWARNOTLG_PK
DATA_SET_ID Performance Asc INCWARNOTLG_DSICR_FK_I
INCIDENT_ID Performance Asc INCWARNOTLG_INC_FK_I
SENT_TO_LOGIN_ID Performance Asc INCWARNOTLG_IUP_FK_I

Close relationships  within of separation: