Table slot9.WORLD.TSTA.DS_IBR_FIELD_VALUES
This table stores the Row Based representation of each Fields Values of the Record Layout for all Segments
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
DS_ICR_HEADERID number 0
DS_ICR_UNIQUE_KEY varchar2 255
DS_ICR_REC_NUM varchar2 255
ORIG_IBR_VALUE varchar2 2000  √  null
TRANSLATED_VALUE varchar2 2000  √  null
MODIFIED varchar2 1 'N'
CHANGE_COMMENT varchar2 200  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
MODIFIED_VALUE varchar2 2000  √  null
IBR_FIELD_VALUE_ID number 0
DS_IBR_FIELD_VALUES_FAST_VW.IBR_FIELD_VALUE_ID Implied Constraint R
DS_IBR_FIELD_VALUES_VW.IBR_FIELD_VALUE_ID Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.IBR_FIELD_VALUE_ID Implied Constraint R
IBR_FIELD_SYSTEM_ID number 0
DS_IBR_FIELD_SYSTEMS.IBR_FIELD_SYSTEM_ID DSIBRFLDV_DSIBRFLDSY_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
MODIFIED IN ('Y', 'N') CK_DSIBRFLDV_MODIFIED
"DS_ICR_REC_NUM" IS NOT NULL DSIBRFLDV_DSICRRECNUM_NN
"DS_ICR_UNIQUE_KEY" IS NOT NULL DSIBRFLDV_DSICRUNQKEY_NN
"DS_ICR_HEADERID" IS NOT NULL DSIBRFLDV_HEADERID_NN
"IBR_FIELD_SYSTEM_ID" IS NOT NULL DSIBRFLDV_IBR_FLDS_ID_NN
"MODIFIED" IS NOT NULL DSIBRFLDV_MODIFIED_NN

Indexes:
Column(s) Type Sort Constraint Name
IBR_FIELD_VALUE_ID Primary key Asc DSIBRFLDV_PK
IBR_FIELD_SYSTEM_ID Performance Asc DSIBRFLDV_DSIBRFLDSY_FK_I
DS_ICR_HEADERID Performance Asc DSIBRFLDV_I
MODIFIED Performance Asc DSIBRFLDV_MODFLG_FK_I
IBR_FIELD_SYSTEM_ID + DS_ICR_HEADERID + DS_ICR_UNIQUE_KEY + DS_ICR_REC_NUM Must be unique Asc/Asc/Asc/Asc DSIBRFLDV_UK

Close relationships  within of separation: