Table slot9.WORLD.TSTA.DS_IBR_SEGMENT_DETAILS
This table defines the Segment Details, Attributes used in the Record Layout of each Segment. Segment Level, Legment Length, etc
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
SEGMENT_DETAIL_ID number 0
DS_IBR_EXTSYS_FIELDS_VW.SEGMENT_DETAIL_ID Implied Constraint R
EXTSYS_CODE varchar2 10
EXTERNAL_SYSTEM_CODES.CODE DSIBRSEGDET_EXSYS_FK R
IBR_SEGMENT varchar2 100
DS_IBR_SEGMENTS.IBR_SEGMENT DSIBRSEGDET_DSIBRSEG_FK R
SEGMENT_LEVEL varchar2 10  √  null
SEGMENT_LENGTH number 0  √  null
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
NAV_ORDER number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"EXTSYS_CODE" IS NOT NULL DSIBRSEGDET_EXTSYS_CODE_NN
"IBR_SEGMENT" IS NOT NULL DSIBRSEGDET_IBR_SEG_NN
"SEGMENT_DETAIL_ID" IS NOT NULL DSIBRSEGDET_SEG_DTL_NN

Indexes:
Column(s) Type Sort Constraint Name
SEGMENT_DETAIL_ID Primary key Asc DSIBRSEGDET_PK
IBR_SEGMENT Performance Asc DSIBRSEGDET_DSIBRSEG_FK_I
EXTSYS_CODE Performance Asc DSIBRSEGDET_EXSYS_FK_I
EXTSYS_CODE + IBR_SEGMENT Must be unique Asc/Asc DSIBRSEGDET_UK

Close relationships  within of separation: