Table slot9.WORLD.TSTA.DS_IBR_FIELDS
This parent table defines the fields used in a Record Layout for each Segment. The Fields can be reused between EXTERNAL_SYSTEM_CODES.CODE
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
IBR_FIELD_ID number 0
DS_IBR_EXTSYS_FIELDS_VW.IBR_FIELD_ID Implied Constraint R
DS_IBR_FIELD_SYSTEMS.IBR_FIELD_ID DSIBRFLDSY_DSIBRFLD_FK R
DS_IBR_FIELD_VALUES_FAST_VW.IBR_FIELD_ID Implied Constraint R
DS_IBR_FIELD_VALUES_VW.IBR_FIELD_ID Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.IBR_FIELD_ID Implied Constraint R
FIELD_NAME varchar2 30
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
FIELD_DESCRIPTION varchar2 255  √  null
METHOD_NAME varchar2 50  √  null
CODE_TYPE varchar2 50  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"FIELD_NAME" IS NOT NULL DSIBRFLD_FIELD_NAME_NN
"IBR_FIELD_ID" IS NOT NULL DSIBRFLD_IBR_FIELD_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
IBR_FIELD_ID Primary key Asc DSIBRFLD_PK
FIELD_NAME Must be unique Asc DSIBRFLD_UK

Close relationships  within of separation: