Table slot9.WORLD.TSTA.INC_COMMENT_GROUP_COMMENTS
Table to hold disapproval comments for a section of a report
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 0
COURT_CASE_DELETE.ID Implied Constraint R
GROUP_ID number 0
INC_COMMENT_GROUPS.ID INCCOMGRPCOM_INCCOMGRP_FK C
SECTION_CODE varchar2 30
EJS_CODES.CODE INCCOMGRPCOM_EJSCD_SEC_FK R
SECTION_CODE_TYPE varchar2 30 'INC_COM_SECTION_CODES'
EJS_CODES.CODE_TYPE INCCOMGRPCOM_EJSCD_SEC_FK R
SUB_SECTION_CODE varchar2 30  √  null
EJS_CODES.CODE INCCOMGRPCOM_EJSCD_SUB_FK R
SUB_SECTION_CODE_TYPE varchar2 30  √  'INC_COM_SUB_SECTION_CODES'
EJS_CODES.CODE_TYPE INCCOMGRPCOM_EJSCD_SUB_FK R
KEY_VAL_1 varchar2 30  √  null
KEY_VAL_2 varchar2 30  √  null
SUPERVISOR_COMMENT varchar2 2000  √  null
RESPONSE_COMMENT varchar2 2000  √  null
ACKNOWLEDGE_FLAG varchar2 1  √  'N'
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
"GROUP_ID" IS NOT NULL INCCOMGRPCOM_GR_PID_NN
"ID" IS NOT NULL INCCOMGRPCOM_ID_NN
"SECTION_CODE" IS NOT NULL INCCOMGRPCOM_SEC_CD_NN
"SECTION_CODE_TYPE" IS NOT NULL INCCOMGRPCOM_SEC_CD_TYP_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc INCCOMGRPCOM_PK
SECTION_CODE_TYPE + SECTION_CODE Performance Asc/Asc INCCOMGRPCOM_EJSCD_SEC_FK_I
SUB_SECTION_CODE_TYPE + SUB_SECTION_CODE Performance Asc/Asc INCCOMGRPCOM_EJSCD_SUB_FK_I
GROUP_ID Performance Asc INCCOMGRPCOM_INCCOMGRP_FK_I

Close relationships  within of separation: