Table slot9.WORLD.TSTA.DISPATCH_EVENT_VEHICLES
This table stores the vehicle information related to a Call for Service.
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
DISPATCH_VEHICLE_ID number 0
DISPATCH_EVENT_VEHICLES_VW.DISPATCH_VEHICLE_ID Implied Constraint R
DISPATCH_PERSON_VEHICLES.DISPATCH_VEHICLE_ID DPV_DEV_FK C
Sequence-generated unique ID of a vehicle associated with a CFS event.
DISPATCH_ID number 0
DISPATCH_EVENTS.DISPATCH_ID DEV_DISPTCH_FK C
Unique ID of the CFS event.
VEH_VEHICLE_ID number 0  √  null
VEHICLES.VEHICLE_ID DEV_VEH_FK R
Unique ID of the vehicle in a corresponding Master Vehicle record, if any.
CAD_VEHICLE_ID varchar2 100  √  null Unique ID of the vehicle in the sending CAD system.
VIN varchar2 20  √  null Vehicle Identification Number
VEHICLE_YEAR number 38  √  null Model year of the vehicle.
MAKE varchar2 30  √  null Vehicle make.
MODEL varchar2 30  √  null Vehicle model
STYLE varchar2 30  √  null Vehicle style
VEHICLE_TYPE varchar2 30  √  null Vehicle type
LIC_NUMBER varchar2 12  √  null Vehicle license plate number
LIC_TYPE varchar2 30  √  null Vehicle license plate type
LIC_STATE varchar2 30  √  null State issuing vehicle license plate
LIC_MONTH number 2  √  null 2-digit month of license plate expiration.
LIC_YEAR number 4  √  null 4-digit year of license plate expiration.
BOTTOM_COLOR varchar2 30  √  null Secondary color of vehicle
TOP_COLOR varchar2 30  √  null Primary color of vehicle
COND varchar2 30  √  null Condition of vehicle
DAMAGE varchar2 30  √  null Vehicle damage.
DAMAGE_DESC varchar2 240  √  null Detailed description of vehicle damage.
MISC_ID varchar2 100  √  null Miscellaneous ID of vehicle
VEHICLE_VALUE number 0  √  null Monetary value of vehicle.
ODOMETER number 11,1  √  null Odometer reading for vehicle
DATE_OF_INFO date 7  √  null Date this vehicle information obtained.
COMMENTS varchar2 4000  √  null Comments or remarks regarding this vehicle.
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
REC_ID number 0  √  null
INSURANCE_COMPANY varchar2 80  √  null Insurance Company for this vehicle.

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"DISPATCH_ID" IS NOT NULL DEV_DISPATCH_ID_NN
"DISPATCH_VEHICLE_ID" IS NOT NULL DEV_DISPATCH_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
DISPATCH_VEHICLE_ID Primary key Asc DEV_PK
CAD_VEHICLE_ID Performance Asc DEV_CAD_VEHICLE_ID_I
DISPATCH_ID Performance Asc DEV_DISPTCH_FK_I
LIC_NUMBER Performance Asc DEV_LIC_NUMBER_I
MAKE Performance Asc DEV_MAKE_I
MODEL Performance Asc DEV_MODEL_I
VEH_VEHICLE_ID Performance Asc DEV_VEH_FK_I
VIN Performance Asc DEV_VIN_I

Close relationships  within of separation: