Table slot9.WORLD.TSTA.USER_SCREEN_COMMENTS
This table stores the comment text added in a custom form comment-type field
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
COMMENT_ID number 38
USER_SCREEN_MISC_NOTES.COMMENT_ID USR_SCRNMN_USRSCRN_COM_FK R
SCREEN_INSTANCE_ID number 38
USER_SCREEN_MISC_NOTES.SCREEN_INSTANCE_ID USR_SCRNMN_USRSCRN_COM_FK R
USER_SCREEN_INSTANCES.INSTANCE_ID USRSCRN_COM_USRSCRN_INST_FK R
COMMENT_CODE varchar2 30  √  null
EJS_CODES.CODE USRSCRN_COM_EJS_CODE_FK R
COMMENT_CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE USRSCRN_COM_EJS_CODE_FK R
COMMENTS varchar2 4000  √  null
CREATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null Domain to store an Oracle USER ID
UPDATOR_DATE date 7  √  null
LOGIN_ID varchar2 100
IJIS_USER_PROFILES.LOGIN_ID USRSCRN_COM_IUP_FK R
AGENCY_CODE varchar2 30
AGENCY_CODES.AGENCY_CODE USRSCRN_COM_AGNCY_CD_FK R
ACTION_INST_USER_ID number 38  √  null
ROUTE_ACTION_INST_USERS.ACTION_INST_USER_ID USRSCRN_COM_RTEACTINUS_FK R
ORIG_RTE_INST_ID number 38  √  null
ROUTE_INSTANCES.ROUTE_INSTANCE_ID USRSCRN_COM_RTEINST_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"AGENCY_CODE" IS NOT NULL USRSCRN_COM_AGNCY_CD_NN
"COMMENT_ID" IS NOT NULL USRSCRN_COM_COMMENT_ID_NN
"LOGIN_ID" IS NOT NULL USRSCRN_COM_LOGIN_ID_NN
"SCREEN_INSTANCE_ID" IS NOT NULL USRSCRN_COM_SCRNINSTID_NN

Indexes:
Column(s) Type Sort Constraint Name
COMMENT_ID + SCREEN_INSTANCE_ID Primary key Asc/Asc USRSCRN_COM_PK
AGENCY_CODE Performance Asc USRSCRN_COM_AGNCY_CD_FK_I
COMMENT_CODE_TYPE + COMMENT_CODE Performance Asc/Asc USRSCRN_COM_EJS_CODE_FK_I
LOGIN_ID Performance Asc USRSCRN_COM_IUP_FK_I
ACTION_INST_USER_ID Performance Asc USRSCRN_COM_RTEACTINUS_FK_I
ORIG_RTE_INST_ID Performance Asc USRSCRN_COM_RTEINST_FK_I
SCREEN_INSTANCE_ID Performance Asc USRSCRN_COM_USRSCRN_INST_FK_I

Close relationships  within of separation: