Table slot9.WORLD.TSTA.EVIDENCE_LABEL_CELLS
a cell/field in an evidence label
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
CELL_ID number 38
ROW_ID number 38
EVIDENCE_LABEL_ROWS.ROW_ID EVIDLBLCL_EVIDLBL_FK C
DISPLAY_INDEX number 38
FIELD_CODE varchar2 30
EJS_CODES.CODE EVIDLBLCL_EJSCD_FLDCD_FK R
FIELD_CODE_TYPE varchar2 30
EJS_CODES.CODE_TYPE EVIDLBLCL_EJSCD_FLDCD_FK R
WIDTH number 38
ALLOW_OVERFLOW_FLAG varchar2 1  √  'N'
LABEL varchar2 100  √  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
"CELL_ID" IS NOT NULL EVIDLBLCL_CELL_ID_NN
"FIELD_CODE" IS NOT NULL EVIDLBLCL_FC_NN
"FIELD_CODE_TYPE" IS NOT NULL EVIDLBLCL_FC_TYP_NN
"DISPLAY_INDEX" IS NOT NULL EVIDLBLCL_IND_NN
"ROW_ID" IS NOT NULL EVIDLBLCL_ROW_ID_NN
"WIDTH" IS NOT NULL EVIDLBLCL_WDT_NN

Indexes:
Column(s) Type Sort Constraint Name
CELL_ID Primary key Asc EVIDLBLCL_PK
FIELD_CODE_TYPE + FIELD_CODE Performance Asc/Asc EVIDLBLCL_EJSCD_FLDCD_FK_I
ROW_ID Performance Asc EVIDLBLCL_EVIDLBL_FK_I

Close relationships  within of separation: