Table slot9.WORLD.TSTA.PROPERTY_TYPE_CODES
This table defines the valid type codes assigned to a MASTER PROPERTY in the application
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
PROPERTY_TYPE varchar2 30
PROPERTIES.PROPERTY_TYPE_CODE PRO_PROP_CD_FK R
PROPERTY_TYPE_DRUGS_VW.PROPERTY_TYPE Implied Constraint R
PROPERTY_TYPE_GUNS_VW.PROPERTY_TYPE Implied Constraint R
PROPERTY_TYPE_NOT_DRUG_GUN_VW.PROPERTY_TYPE Implied Constraint R
Type of property
NPTC_PROPERTY_TYPE varchar2 30
EJS_CODES.CODE PROP_CD_NPTC_PROPE_EJS_CODE_FK R
The property type code used for NIBRS reporting.
PROPERTY_TYPE_DESC varchar2 80  √  null Description of the property type
PROPERTY_CATEGORY varchar2 30  √  null
EJS_CODES.CODE PROP_CD_PROPCAT_EJS_CODES_FK R
NPTC_PROPERTY_TYPE_TYPE varchar2 30  √  'NIBRS_PROPERTY_TYPE_CODES'
EJS_CODES.CODE_TYPE PROP_CD_NPTC_PROPE_EJS_CODE_FK R
REC_ID number 0  √  null
PROPERTY_CATEGORY_TYPE varchar2 30  √  null
EJS_CODES.CODE_TYPE PROP_CD_PROPCAT_EJS_CODES_FK R
ACTIVE varchar2 1  √  'Y'

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
ACTIVE IN ('N', 'Y') CK_PROP_CD_ACTIVE
UPPER(TRIM(PROPERTY_TYPE)) = PROPERTY_TYPE CK_PROPCD_PROP_CD
"NPTC_PROPERTY_TYPE" IS NOT NULL PROP_CD_NPTC_PROPERTY_TYPE_NN
"PROPERTY_TYPE" IS NOT NULL PROP_CD_PROPERTY_TYPE_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
PROPERTY_TYPE Primary key Asc PROP_CD_PK  
NPTC_PROPERTY_TYPE Performance Asc PROP_CD_NPTC_FK_I  
NPTC_PROPERTY_TYPE_TYPE + NPTC_PROPERTY_TYPE Performance Asc/Asc PROP_CD_NPTC_PROPE_EJS_CODE_I  
PROPERTY_CATEGORY_TYPE + PROPERTY_CATEGORY Performance Asc/Asc PROP_CD_PROPCAT_EJS_CODES_FK_I  
Must be unique PROP_CD_UK_I These unique columns are also nullable

Close relationships  within of separation: