Table slot9.WORLD.TSTA.DS_ICR_SEGMENTS
DS ICR Table used for re-usable IBR segments storing key data , IBR_SEGMENT and data fields
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
HEADERID number 0
DS_ICR_HEADERS.HEADERID DSICRSEG_DSICRHD_FK R
FK to DS_ICR_HEADERS HEADERID
IBR_SEGMENT varchar2 100
DS_IBR_SEGMENTS.IBR_SEGMENT DSICRSEG_DSIBRSEG_FK R
FK to DS_IBR_SEGMENTS IBR_SEGMENT
INCIDENT_ID number 0  √  null
INCIDENTS.INCIDENT_ID Implied Constraint R
Incident ID linked to data
SUPP_SEQ number 0  √  null Supplement Sequence Linked to the data
KEY1 varchar2 100 Key Field 1 Used to Retrieve Data
KEY2 varchar2 100 Key Field 2 Used to Retrieve the data
DATA1 varchar2 2000  √  null Generic Data Element 1
DATA2 varchar2 2000  √  null Generic Data Element 2
DATA3 varchar2 2000  √  null Generic Data Element 3
DATA4 varchar2 2000  √  null Generic Data Element 4
DATA5 varchar2 2000  √  null Generic Data Element 5
CREATOR_ID varchar2 100  √  null User creating the record
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null User who Last updated the record
UPDATOR_DATE date 7  √  null Date of Record last update
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"HEADERID" IS NOT NULL DSICRSEG_HEADERID_NN
"IBR_SEGMENT" IS NOT NULL DSICRSEG_IBR_SEGMENT_NN
"KEY1" IS NOT NULL DSICRSEG_KEY1_NN
"KEY2" IS NOT NULL DSICRSEG_KEY2_NN

Indexes:
Column(s) Type Sort Constraint Name
HEADERID + IBR_SEGMENT + KEY1 + KEY2 Primary key Asc/Asc/Asc/Asc DSICRSEG_PK
IBR_SEGMENT Performance Asc DSICRSEG_DSIBRSEG_FK_I
HEADERID Performance Asc DSICRSEG_DSICRHD_FK_I

Close relationships  within of separation: