Table slot9.WORLD.TSTA.EJS_NOTES_ANNOTATED
Table to hold a annotated note record
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
EJS_NOTES_ANNOTATIONS.ANNO_NOTE_ID ENAS_ENA_FK C
COURT_CASE_DELETE.ID Implied Constraint R
SOURCE_NOTE_ID number 0
EJS_NOTES.NOTE_ID ENA_EJSN_SRC_FK C
ANNOTATED_NOTE_ID number 0
EJS_NOTES.NOTE_ID ENA_EJSN_ANNO_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
"ANNOTATED_NOTE_ID" IS NOT NULL ENA_ANNO_NOT_ID_NN
"ID" IS NOT NULL ENA_ID_NN
"SOURCE_NOTE_ID" IS NOT NULL ENA_SRC_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc ENA_PK
ANNOTATED_NOTE_ID Performance Asc ENA_EJSN_ANNO_FK_I
SOURCE_NOTE_ID Performance Asc ENA_EJSN_SRC_FK_I

Close relationships  within of separation: