Table slot9.WORLD.TSTA.USER_SCREEN_MISC_NOTES
This table stores additional notes added on a custom form in the application
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
MISC_NOTE_ID number 38
SCREEN_INSTANCE_ID number 38
USER_SCREEN_COMMENTS.SCREEN_INSTANCE_ID USR_SCRNMN_USRSCRN_COM_FK R
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID USR_SCRNMN_IUP_FK R
AGENCY_CODE varchar2 100
AGENCY_CODES.AGENCY_CODE USR_SCRNMN_AGNCY_CD_FK R
NOTIFY_TYPE_CD number 0
NOTIFICATION_DEF_MASTERS.NOTIFY_TYPE_CD USR_SCRNMN_NDM_FK R
COMMENT_ID number 0  √  null
USER_SCREEN_COMMENTS.COMMENT_ID USR_SCRNMN_USRSCRN_COM_FK R
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
"AGENCY_CODE" IS NOT NULL USR_SCRNMN_AGNCY_CD_NN
"LOGIN_ID" IS NOT NULL USR_SCRNMN_LOGIN_ID_NN
"MISC_NOTE_ID" IS NOT NULL USR_SCRNMN_MSC_NOTE_ID_NN
"NOTIFY_TYPE_CD" IS NOT NULL USR_SCRNMN_NOT_TYP_NN
"SCREEN_INSTANCE_ID" IS NOT NULL USR_SCRNMN_SCRN_INST_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
MISC_NOTE_ID Primary key Asc USR_SCRNMN_PK
AGENCY_CODE Performance Asc USR_SCRNMN_AGNCY_CD_FK_I
LOGIN_ID Performance Asc USR_SCRNMN_IUP_FK_I
NOTIFY_TYPE_CD Performance Asc USR_SCRNMN_NDM_FK_I
COMMENT_ID + SCREEN_INSTANCE_ID Performance Asc/Asc USR_SCRNMN_USRSCRN_COM_FK_I

Close relationships  within of separation: