Table slot9.WORLD.TSTA.NIBRS_PROP_MAPPINGS
This table defines valid property types based on the given NIBRS offense and attempted or completed values or property status codes
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
NIBRS_PROP_ID number 0
ZZ_NIBRS_PROP_MAPPINGS.NIBRS_PROP_ID Implied Constraint R
ZZC1_NIBRS_PROP_MAPPINGS.NIBRS_PROP_ID Implied Constraint R
ZZV1_NIBRS_PROP_MAPPINGS.NIBRS_PROP_ID Implied Constraint R
NIBRS_PROP_ID_SEQ Sequence/Unique Key for this table
PROPERTY_CODE_TYPE varchar2 30 'NIBRS_PROPERTY_TYPE_CODES'
EJS_CODES.CODE_TYPE NIBRSPROP_MAP_PROP_EJS_CD_FK R
EJS Codes Code Type- referencing nibrs_property_type_codes in ejs_codes
PROPERTY_CODE varchar2 30
EJS_CODES.CODE NIBRSPROP_MAP_PROP_EJS_CD_FK R
EJS Codes Code - referencing nibrs_property_type_codes code value
NIBRS_CODE varchar2 30
NIBRS_CODES.NIBRS_CODE NIBRSPROP_MAP_NIBRS_CD_FK R
NIBRS Code - code value
CODE_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE NIBRSPROP_MAP_EJS_CD_FK R
EJS Codes Code Type- referencing: ac_codes, property_loss_codes
CODE varchar2 30  √  null
EJS_CODES.CODE NIBRSPROP_MAP_EJS_CD_FK R
EJS Codes Code - code value
CREATOR_DATE date 7  √  null Date of record creation
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
CREATOR_ID varchar2 100  √  null Person creating the record
REC_ID number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"NIBRS_CODE" IS NOT NULL NIBRSPROP_MAP_NIBRS_CD_NN
"NIBRS_PROP_ID" IS NOT NULL NIBRSPROP_MAP_NIBRS_PROP_ID_NN
"PROPERTY_CODE" IS NOT NULL NIBRSPROP_MAP_PROPCD_NN
"PROPERTY_CODE_TYPE" IS NOT NULL NIBRSPROP_MAP_PROPCD_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name
NIBRS_PROP_ID Primary key Asc NIBRSPROP_MAP_PK
CODE_TYPE + CODE Performance Asc/Asc NIBRSPROP_MAP_EJS_CD_FK_I
NIBRS_CODE Performance Asc NIBRSPROP_MAP_NIBRS_CD_FK_I
PROPERTY_CODE_TYPE + PROPERTY_CODE Performance Asc/Asc NIBRSPROP_MAP_PROP_EJS_CD_FK_I

Close relationships  within of separation: