Table slot9.WORLD.TSTA.VEHICLE_TYPE_CODES
This table defines the valid type codes that can be added to a vehicle 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
TYPE_CODE varchar2 30
COURT_APPEARANCE_SEARCH_VW.TYPE_CODE Implied Constraint R
DISPATCH_EVENT_VEHICLES_VW.TYPE_CODE Implied Constraint R
JS_CITATION_VW.TYPE_CODE Implied Constraint R
RV_CUSTOM_OBJECTS.TYPE_CODE Implied Constraint R
VEHICLE_MAKES.VTC_TYPE_CODE VMA_VTC_FK R
VEHICLE_MODELS.VTC_TYPE_CODE VMO_VTC_FK R
VEHICLE_STYLES.VTC_TYPE_CODE VST_VTC_FK R
VEHICLES.VTC_TYPE_CODE VEH_VTC_FK R
WARRANT_ADDR_SEARCH_VW.TYPE_CODE Implied Constraint R
WARRANT_OFFICER_SEARCH_VW.TYPE_CODE Implied Constraint R
WARRANT_SEARCH_VW.TYPE_CODE Implied Constraint R
WARRANT_SRVOFF_SEARCH_VW.TYPE_CODE Implied Constraint R
Vehicle type code
TYPE_DESC varchar2 255  √  null Vehicle type description
ACCIDENT_CODE varchar2 30  √  null
REC_ID number 0  √  null
NPTC_PROPERTY_TYPE_CODE varchar2 30
EJS_CODES.CODE VTC_NPTC_PROPE_EJS_CODE_FK R
NPTC_PROPERTY_TYPE_TYPE varchar2 30 'NIBRS_PROPERTY_TYPE_CODES'
EJS_CODES.CODE_TYPE VTC_NPTC_PROPE_EJS_CODE_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_VTC_ACTIVE
"NPTC_PROPERTY_TYPE_TYPE" IS NOT NULL VTC_NPTC_PROP_TYPETYPE_NN
"NPTC_PROPERTY_TYPE_CODE" IS NOT NULL VTC_NPTC_PROPERTY_TYPECODE_NN
"TYPE_CODE" IS NOT NULL VTC_TYPE_CODE_NN

Indexes:
Column(s) Type Sort Constraint Name
TYPE_CODE Primary key Asc VTC_PK
NPTC_PROPERTY_TYPE_TYPE + NPTC_PROPERTY_TYPE_CODE Performance Asc/Asc VTC_NPTC_PROPE_EJS_CODE_FK_I

Close relationships  within of separation: