Table slot9.WORLD.TSTA.VEHICLES
This table stores the vehicle information added 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
VEHICLE_ID number 38
ARRESTS.VEH_VEHICLE_ID ARR_VEH_FK R
BI_CITATIONS_VW.VEHICLE_ID Implied Constraint R
BOLO_VEHICLES.VEHICLE_ID BOLO_VEH_FK C
BUS_PER_VEHICLE_VW.VEHICLE_ID Implied Constraint R
BUSINESS_VEHICLES.VEHICLE_ID BV_VEH_FK R
BUSINESS_VEHICLES_VW.VEHICLE_ID Implied Constraint R
CASE_ACTIVITY_VEHICLES.VEHICLE_ID CACTVEH_VEH_FK R
CITATION_VEHICLE_VW.VEHICLE_ID Implied Constraint R
CITATION_VEHICLES.VEHICLE_ID CITVEH_VEH_FK R
DISPATCH_EVENT_VEHICLES.VEH_VEHICLE_ID DEV_VEH_FK R
FIELD_INT_SEARCH_VEHICLE_VW.VEHICLE_ID Implied Constraint R
FLDINT_VEH_VW.VEHICLE_ID Implied Constraint R
FLDINT_VEHICLES.VEHICLE_ID FLDIV_VEH_FK C
FLEET_MAINTENANCE_LOG.VEH_VEHICLE_ID FM_VEH_FK R
FLEET_MILEAGE_LOG.VEH_VEHICLE_ID FML_VEH_FK R
IMP_VEH_BUSINESSES_VW.VEHICLE_ID Implied Constraint R
IMP_VEH_OFFICERS_VW.VEHICLE_ID Implied Constraint R
IMPOUND.VEHICLE_ID IMPD_VEH_FK R
IMPOUND_DELETE_LOG.VEHICLE_ID IMPDEL_VEH_FK R
IMPOUND_VEHICLE_VW.VEHICLE_ID Implied Constraint R
INCIDENT_RECOVERY_VW.VEHICLE_ID Implied Constraint R
INCIDENT_VEHICLE_VW.VEHICLE_ID Implied Constraint R
INCIDENT_VEHICLES.VEHICLE_ID INCVEH_VEH_FK R
JS_OFFICER_DAILY_VEHICLE_VW.VEHICLE_ID Implied Constraint R
JS_OFFICER_DAILY_VW.VEHICLE_ID Implied Constraint R
JS_PERMIT_VEHICLE_VW.VEHICLE_ID Implied Constraint R
JS_VEHICLE_TOW_IMPOUND_VW.VEHICLE_ID Implied Constraint R
LIENHOLDERS.VEH_VEHICLE_ID LIENHLDR_VEH_FK C
PEOPLE_COMBO_VW.VEHICLE_ID Implied Constraint R
PEOPLE_VEHICLE_VW.VEHICLE_ID Implied Constraint R
PEOPLE_VEHICLES.VEHICLE_ID PERV_VEH_FK R
PERMIT_VEHICLES.VEHICLE_ID PERMV_VEH_FK R
PERMIT_VEHICLES_VW.VEHICLE_ID Implied Constraint R
TOWS.VEH_VEHICLE_ID TOW_VEH_FK C
USER_FIELD_VEH_VALUES.VEHICLE_ID USRSCRN_UFVV_VEH_FK R
USI_VEHICLES.VEHICLE_ID USI_VEH_VEH_FK R
USRSCRN_FLEET_VEHICLE_VW.VEHICLE_ID Implied Constraint R
USRSCRN_VEHICLE_VW.VEHICLE_ID Implied Constraint R
VEHICLE_ASSOC_CNT_VW.VEHICLE_ID Implied Constraint R
VEHICLE_ATTACHMENTS.VEHICLE_ID VEHATT_VEH_FK C
VEHICLE_DESC_NAME_VW.VEHICLE_ID Implied Constraint R
VEHICLE_DESC_VW.VEHICLE_ID Implied Constraint R
VEHICLE_DESCRIPTIONS.VEHICLE_ID VEHDSC_VEH_FK R
VEHICLE_DUP_SEARCH_VW.VEHICLE_ID Implied Constraint R
VEHICLE_IMAGES.VEHICLE_ID VIMG_VEH_FK R
VEHICLE_IMPOUND_VW.VEHICLE_ID Implied Constraint R
VEHICLE_INCIDENT_SUMMARY_VW.VEHICLE_ID Implied Constraint R
VEHICLE_INCIDENT_VW.VEHICLE_ID Implied Constraint R
VEHICLE_INSURANCE.VEHICLE_ID VEHINS_VEH_FK C
VEHICLE_INV_ROLE_CNT_VW.VEHICLE_ID Implied Constraint R
VEHICLE_PERSON_VW.VEHICLE_ID Implied Constraint R
VEHICLE_SUMMARY_VW.VEHICLE_ID Implied Constraint R
VEHICLES_NOT_DUPLICATES.NOT_DUP_VEHICLE_ID VEHNODUP_NOT_VEH_FK R
VEHICLES_NOT_DUPLICATES.VEHICLE_ID VEHNODUP_VEH_FK R
Vehicle ID number
VIN varchar2 20  √  null Vehicle Identification Number
YEAR number 38  √  null
VMA_VEHICLE_MAKE_CODE varchar2 30  √  null
VEHICLE_MAKES.VEHICLE_MAKE_CODE VEH_VMA_FK R
VEHICLE_MODELS.VMA_VEHICLE_MAKE_CODE VEH_VMO_FK R
Code of Manufacturer
VMO_VEHICLE_MODEL_CODE varchar2 30  √  null
VEHICLE_MODELS.VEHICLE_MODEL_CODE VEH_VMO_FK R
Code for vehicle model
VST_VEHICLE_STYLE_CODE varchar2 30  √  null
VEHICLE_STYLES.VEHICLE_STYLE_CODE VEH_VST_FK R
Code for vehicle style
CREATOR_ID varchar2 100  √  null Person creating the record
CREATOR_DATE date 7  √  null Date record created
UPDATOR_ID varchar2 100  √  null Person who last updated the record
UPDATOR_DATE date 7  √  null Date of last update
VTC_TYPE_CODE varchar2 2  √  null
VEHICLE_STYLES.VTC_TYPE_CODE VEH_VST_FK R
VEHICLE_TYPE_CODES.TYPE_CODE VEH_VTC_FK R
MCCS varchar2 20  √  null
INDX_SEC_LEVEL_CODE number 0  √  1
MASTER_INDEX_SECURITY_CODES.INDX_SEC_LEVEL_CODE VEHICLES_MIS_CD_CD_FK R
INDX_SEC_LEVEL_ID varchar2 100  √  null
INDX_SEC_LEVEL_AGENCY varchar2 30  √  null
ACTIVE_SUBSCRIPTION varchar2 1  √  null
INDX_TYPE_CODE varchar2 30  √  'KNOWN'
REC_ID number 0  √  null
LOADED_BY varchar2 100  √  null Interface that loaded this index record.
LAST_LOAD_DATE date 7  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"VEHICLE_ID" IS NOT NULL VEH_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
VEHICLE_ID Primary key Asc VEH_PK
Performance VEH_UPPER_VIN_FB_I
VIN Performance Asc VEH_VIN_I
VMA_VEHICLE_MAKE_CODE Performance Asc VEH_VMA_FK_I
VMO_VEHICLE_MODEL_CODE + VMA_VEHICLE_MAKE_CODE Performance Asc/Asc VEH_VMO_FK_I
VST_VEHICLE_STYLE_CODE + VTC_TYPE_CODE Performance Asc/Asc VEH_VST_FK_I
VTC_TYPE_CODE Performance Asc VEH_VTC_FK_I
INDX_SEC_LEVEL_CODE Performance Asc VEHICLES_INDX_SEC_LEVEL_CD_I

Close relationships  within of separation: