Table slot9.WORLD.TSTA.DS_IBR_SEGMENTS
This parent table defines all Segments used in Record Layout for Attachment File that is sent to the FBI, State

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_SEGMENT varchar2 100
DS_IBR_EXTSYS_FIELDS_VW.IBR_SEGMENT Implied Constraint R
DS_IBR_FIELD_SYSTEMS.IBR_SEGMENT DSIBRFLDSY_DSIBRSEG_FK R
DS_IBR_FIELD_VALUES_FAST_VW.IBR_SEGMENT Implied Constraint R
DS_IBR_FIELD_VALUES_VW.IBR_SEGMENT Implied Constraint R
DS_IBR_MODIFY_VALUES_VW.IBR_SEGMENT Implied Constraint R
DS_IBR_SEGMENT_DETAILS.IBR_SEGMENT DSIBRSEGDET_DSIBRSEG_FK R
DS_ICR_SEGMENTS.IBR_SEGMENT DSICRSEG_DSIBRSEG_FK R
DS_NIBRS_ARRESTS_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_GROUPB_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_HEADERS_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_OFFENDERS_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_OFFENSES_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_PROPERTY_VW.IBR_SEGMENT Implied Constraint R
DS_NIBRS_VICTIMS_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_ARRESTS_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_GROUPB_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_HEADERS_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_OFFENDERS_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_OFFENSES_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_PROPERTY_VW.IBR_SEGMENT Implied Constraint R
JS_DS_NIBRS_VICTIMS_VW.IBR_SEGMENT Implied Constraint R
UCR_ARRESTEES_GTT.IBR_SEGMENT Implied Constraint R
UCR_HEADERS_GTT.IBR_SEGMENT Implied Constraint R
UCR_OFFENSES_GTT.IBR_SEGMENT Implied Constraint R
UCR_VICTIMS_GTT.IBR_SEGMENT Implied Constraint R
SEGMENT_COMMENT varchar2 200  √  null
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
"IBR_SEGMENT" IS NOT NULL DSIBRSEG_IBR_SEGMENT_NN

Indexes:
Column(s) Type Sort Constraint Name
IBR_SEGMENT Primary key Asc DSIBRSEG_PK

Close relationships  within of separation: