Table slot9.WORLD.TSTA.EJS_NIBRS_DATA_ELEMENTS
Application table driven lists of values.
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
ID number 0
COURT_CASE_DELETE.ID Implied Constraint R
NIBRS_DE_NUMBER varchar2 10
NIBRS_DE_NAME varchar2 255
STATE_MAPPING varchar2 255  √  null
IS_CLERK_UPDATE varchar2 1  √  'N'
DE_CODE_TABLE varchar2 100  √  null
DE_CODE_TYPE varchar2 30  √  null
DE_CHILD_TABLE varchar2 30  √  null
DE_DEST_TABLE varchar2 100  √  null
DE_DEST_TAB_COL varchar2 100  √  null
DE_DEST_TAB_COL_CODE_TYPE varchar2 100  √  null
SECTION_NAME varchar2 100  √  null
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ID" IS NOT NULL ENIBR_DE_ID_NN
"NIBRS_DE_NAME" IS NOT NULL ENIBR_DE_NIBRS_DE_NAME_NN
"NIBRS_DE_NUMBER" IS NOT NULL ENIBR_DE_NIBRS_DE_NUMBER_NN

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc ENIBR_DE_PK

Close relationships: