Table slot9.WORLD.TSTA.DEPARTMENT_VEHICLES
This table defines vehicles used in the OFFICER DAILY LOG 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 0
ARREST_ADDRESS_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_CFS_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_DISPOSITION_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_NARRATIVE_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_ORG_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_PERSON_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_PROPERTY_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_SEARCH_VW.VEHICLE_ID Implied Constraint R
ARREST_VEHICLE_SEARCH_VW.VEHICLE_ID Implied Constraint R
ASSIGNMENT_VEHICLES.VEHICLE_ID AV_DV_FK R
DISPATCH_EVENT_VEHICLES_VW.VEHICLE_ID Implied Constraint R
DV_ASSIGNMENTS.VEHICLE_ID DVAS_DV_FK R
DV_ATTACHMENTS.VEHICLE_ID DVATT_DV_FK R
DV_CRASH_DELETE_LOG.VEHICLE_ID Implied Constraint R
DV_CRASH_INSURANCE_VW.VEHICLE_ID Implied Constraint R
DV_CRASH_REFERENCES_VW.VEHICLE_ID Implied Constraint R
DV_CRASH_SERVICE_RECORDS_VW.VEHICLE_ID Implied Constraint R
DV_CRASH_SERVICE_REPAIRS_VW.VEHICLE_ID Implied Constraint R
DV_CRASH_TOWS_VW.VEHICLE_ID Implied Constraint R
DV_CRASHES.VEHICLE_ID CRASH_DV_FK R
DV_CRASHES_VW.VEHICLE_ID Implied Constraint R
DV_EQUIPMENT.VEHICLE_ID DVEQ_DV_FK R
DV_FUEL_OIL.VEHICLE_ID DVFUEL_DV_FK R
DV_IMAGES.VEHICLE_ID DVIMA_DV_FK R
DV_INSPECTIONS.VEHICLE_ID DVINSP_DV_FK R
DV_INSURANCE.VEHICLE_ID DVINSUR_DV_FK R
DV_MISC_IDS.VEHICLE_ID DVMISC_DV_FK R
DV_SERVICE_RECORDS.VEHICLE_ID DVSERV_DV_FK R
DV_SERVICE_REQUEST.VEHICLE_ID DVREQST_DV_FK R
DV_STORAGE_LOCATIONS.VEHICLE_ID DVLOC_DV_FK R
FLEET_DASHBOARD_COST_VW.VEHICLE_ID Implied Constraint R
FLEET_DASHBOARD_MAINTENANCE_VW.VEHICLE_ID Implied Constraint R
FLEET_DASHBOARD_SERVICE_VW.VEHICLE_ID Implied Constraint R
JS_FIELD_ARREST_CHARGE_VW.VEHICLE_ID Implied Constraint R
JS_FIELD_ARREST_VW.VEHICLE_ID Implied Constraint R
JS_FLEET_DASH_MAINT_VW.VEHICLE_ID Implied Constraint R
JS_FLEET_VEHICLES_VW.VEHICLE_ID Implied Constraint R
PEOPLE_COMBO_ADDR_PHONES_VW.VEHICLE_ID Implied Constraint R
PEOPLE_COMBO_ADR_PH_VW.VEHICLE_ID Implied Constraint R
PEOPLE_COMBO_ADR_VW.VEHICLE_ID Implied Constraint R
PEOPLE_COMBO_PH_VW.VEHICLE_ID Implied Constraint R
USI_FLEET_VEHICLE_FORMS.VEHICLE_ID USI_FVF_DV_FK R
USI_FLEET_VEHICLES.VEHICLE_ID USI_FV_DV_FK R
USRSCRN_DV_ASSIGNMENT_VW.VEHICLE_ID Implied Constraint R
Vehicle ID
DESCRIPTION varchar2 80  √  null Vehicle description
AGENCY_CODE varchar2 30  √  null
AGENCY_CODES.AGENCY_CODE DV_AC_FK R
Agency code
LOG_ID number 0  √  null
ASSIGNMENT_LOGS.LOG_ID DV_AL_FK R
Assignment Log ID
VIN varchar2 20  √  null Vehicle Identification Number
YEAR number 38  √  null
VEHICLE_MAKE_CODE varchar2 255  √  null Code of Manufacturer
VEHICLE_MODEL_CODE varchar2 255  √  null Code for vehicle model
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
ACTIVE varchar2 1  √  'Y'
LICENSE_NUMBER varchar2 255  √  null
UNIT_NUMBER varchar2 255  √  null
VEH_CATEGORY_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_CATCD_FK R
EJS Code for Categorization of department vehicle
VEH_CATEGORY_CODE_TYPE varchar2 30  √  'VEHICLE_CATEGORY_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_CATCD_FK R
EJS Code Type for Categorization of department vehicle
ASSIGNMENT_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_ASGNCD_FK R
EJS Code for vehicle assignment
ASSIGNMENT_CODE_TYPE varchar2 30  √  'VEHICLE_ASSIGNMENT_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_ASGNCD_FK R
EJS Code Type for vehicle assignment
GROUP_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_GRPCD_FK R
EJS Code for vehicle group
GROUP_CODE_TYPE varchar2 30  √  'VEHICLE_GROUP_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_GRPCD_FK R
EJS Code Type for vehicle group
STATUS_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_STATCD_FK R
EJS Code for status of department vehicle
STATUS_CODE_TYPE varchar2 30  √  'VEHICLE_STATUS_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_STATCD_FK R
EJS Code Type for status of department vehicle
VEH_TYPE_CODE varchar2 30  √  null Type of department vehicle
VEH_STYLE_CODE varchar2 30  √  null Style of department vehicle
PRIMARY_COLOR_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_PCLR_FK R
EJS Code for primary color of department vehicle
PRIMARY_COLOR_CODE_TYPE varchar2 30  √  'VEHICLE_COLOR_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_PCLR_FK R
EJS Code Type for primary color of department vehicle
SECONDARY_COLOR_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_SECCLR_FK R
EJS Code for secondary color of department vehicle
SECONDARY_COLOR_CODE_TYPE varchar2 30  √  'VEHICLE_COLOR_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_SECCLR_FK R
EJS Code Type for secondary color of department vehicle
PURCHASE_DATE date 7  √  null Purchase date of department vehicle
PURCHASE_PRICE number 0  √  null Purchase price of department vehicle
PURCHASE_FROM_VENDOR_ID number 0  √  null
ITEM_VENDORS.VENDOR_ID DV_ITVD_FK R
ITEM_VENDOR id for purchase from vendor of department vehicle
PURCHASE_FROM_COMMENT varchar2 255  √  null Comment for purchase from vendor of department vehicle
FUNDING_SOURCE_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_FNDSRC_FK R
EJS Code for purchase funding source of department vehicle
FUNDING_SOURCE_CODE_TYPE varchar2 30  √  'VEHICLE_FUNDING_VENDORS'
EJS_CODES.CODE_TYPE DV_EJSCD_FNDSRC_FK R
EJS Code Type for purchase funding source of department vehicle
STARTING_MILEAGE number 0  √  null Mileage at purchase of department vehicle
STARTING_HOURS number 0  √  null Hours at purchase of department vehicle (if mileage not used)
WARRANTY_EXPIRATION_DATE date 7  √  null Warranty exiration date of department vehicle
WARRANTY_COMMENT varchar2 255  √  null Warranty comment of department vehicle
SOLD_DATE date 7  √  null Sold date of department vehicle
SOLD_PRICE number 0  √  null Sold price of department vehicle
SOLD_TO varchar2 2000  √  null Sold to (free text)
SOLD_MILEAGE number 0  √  null Sold mileage of department vehicle
LICENSE_STATE_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_LICST_FK R
EJS Code for license state
LICENSE_STATE_CODE_TYPE varchar2 30  √  'STATE_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_LICST_FK R
EJS Code Type for license state
BUDGET_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_BDGT_FK R
EJS Code for budget code
BUDGET_CODE_TYPE varchar2 30  √  'VEHICLE_BUDGET_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_BDGT_FK R
EJS Code Type for budget code
RATING_CODE varchar2 30  √  null
EJS_CODES.CODE DV_EJSCD_RATE_FK R
EJS Code for rating classification
RATING_CODE_TYPE varchar2 30  √  'VEHICLE_RATING_CODES'
EJS_CODES.CODE_TYPE DV_EJSCD_RATE_FK R
EJS Code Type for rating classification
MAKE_ID number 0  √  null
ITEM_MAKE_CODES.MAKE_ID DV_ITMK_FK R
MODEL_ID number 0  √  null
ITEM_MODEL_CODES.MODEL_ID DV_ITMO_FK R
STYLE_ID number 0  √  null
ITEM_STYLE_CODES.STYLE_ID DV_ITSTY_FK R
TYPE_ID number 0  √  null
ITEM_SUB_TYPE_CODES.TYPE_ID DV_ITST_FK R

Analyzed at Mon Sep 20 21:05 MDT 2021

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

Indexes:
Column(s) Type Sort Constraint Name
VEHICLE_ID Primary key Asc DV_PK
AGENCY_CODE Performance Asc DV_AC_FK_I
LOG_ID Performance Asc DV_AL_FK_I
ASSIGNMENT_CODE_TYPE + ASSIGNMENT_CODE Performance Asc/Asc DV_EJSCD_ASGNCD_FK_I
BUDGET_CODE_TYPE + BUDGET_CODE Performance Asc/Asc DV_EJSCD_BDGT_FK_I
VEH_CATEGORY_CODE_TYPE + VEH_CATEGORY_CODE Performance Asc/Asc DV_EJSCD_CATCD_FK_I
FUNDING_SOURCE_CODE_TYPE + FUNDING_SOURCE_CODE Performance Asc/Asc DV_EJSCD_FNDSRC_FK_I
GROUP_CODE_TYPE + GROUP_CODE Performance Asc/Asc DV_EJSCD_GRPCD_FK_I
LICENSE_STATE_CODE_TYPE + LICENSE_STATE_CODE Performance Asc/Asc DV_EJSCD_LICST_FK_I
PRIMARY_COLOR_CODE_TYPE + PRIMARY_COLOR_CODE Performance Asc/Asc DV_EJSCD_PCLR_FK_I
RATING_CODE_TYPE + RATING_CODE Performance Asc/Asc DV_EJSCD_RATE_FK_I
SECONDARY_COLOR_CODE_TYPE + SECONDARY_COLOR_CODE Performance Asc/Asc DV_EJSCD_SECCLR_FK_I
STATUS_CODE_TYPE + STATUS_CODE Performance Asc/Asc DV_EJSCD_STATCD_FK_I
MAKE_ID Performance Asc DV_ITMK_FK_I
MODEL_ID Performance Asc DV_ITMO_FK_I
TYPE_ID Performance Asc DV_ITST_FK_I
STYLE_ID Performance Asc DV_ITSTY_FK_I
PURCHASE_FROM_VENDOR_ID Performance Asc DV_ITVD_FK_I
LICENSE_NUMBER Performance Asc DV_LIC_NO_I
VEHICLE_MAKE_CODE + VEHICLE_MODEL_CODE Performance Asc/Asc DV_MAKE_MODEL_I
UNIT_NUMBER Performance Asc DV_UNIT_NO_I

Close relationships  within of separation: