Table slot9.WORLD.TSTA.ASSIGNMENT_VEHICLES
This table stores vehicles used in an assignment 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 38
DEPARTMENT_VEHICLES.VEHICLE_ID AV_DV_FK R
Unique Vehicle ID.
START_DATE_TIME date 7  √  null Date and time the vehicle was checked out.
END_DATE_TIME date 7  √  null Date and time the vehicle was checked in.
CREATOR_DATE date 7  √  null Date of record creation
CREATOR_ID varchar2 100  √  null Person creating the record
UPDATOR_DATE date 7  √  null Date of last update
UPDATOR_ID varchar2 100  √  null Person who last updated the record
COMMENTS varchar2 2000  √  null
REC_ID number 0  √  null
MILEAGE_OUT number 0  √  null Odometer reading when vehicle was checked out.
MILEAGE_IN number 0  √  null Odometer reading when vehicle was checked in.
FUEL_USED number 0  √  null The amount of fuel used during the assignment.
OIL_USED number 0  √  null The amount of oil used during the assignment.
ASSIGN_ID number 0
ASSIGNMENTS.ASSIGN_ID AV_ASSIG_FK R
FUEL_COST number 0  √  null
OIL_COST number 0  √  null
REPAIR_COST number 0  √  null
ASSIGNMENT_VEHICLE_ID number 0
DV_FUEL_OIL.ASSIGNMENT_VEHICLE_ID DVFUEL_AV_FK R
FUEL_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE AV_EJSCD_FUELTYP_FK R
FUEL_TYPE_CODE_TYPE varchar2 30  √  'FUEL_TYPE_CODES'
EJS_CODES.CODE_TYPE AV_EJSCD_FUELTYP_FK R
FLUID_CODE varchar2 30  √  null
EJS_CODES.CODE AV_EJSCD_FLTYP_FK R
FLUID_CODE_TYPE varchar2 30  √  'VEHCILE_FLUID_TYPE_CODES'
EJS_CODES.CODE_TYPE AV_EJSCD_FLTYP_FK R
FLUID_COST number 0  √  null
VENDOR varchar2 100  √  null
VENDOR_ID number 0  √  null
ITEM_VENDORS.VENDOR_ID AV_ITVD_FK R
PAYMENT_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE AV_EJSCD_PAYTYP_FK R
PAYMENT_TYPE_CODE_TYPE varchar2 30  √  'FUEL_PAYMENT_TYPE_CODES'
EJS_CODES.CODE_TYPE AV_EJSCD_PAYTYP_FK R
OFF_DUTY_MILES number 0  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"ASSIGN_ID" IS NOT NULL AV_ASSIGN_ID_NN
"ASSIGNMENT_VEHICLE_ID" IS NOT NULL AV_ID_NN
"VEHICLE_ID" IS NOT NULL AV_VEHICLE_ID_NN

Indexes:
Column(s) Type Sort Constraint Name
ASSIGNMENT_VEHICLE_ID Primary key Asc AV_PK
ASSIGN_ID Performance Asc AV_ASSIG_FK_I
VEHICLE_ID Performance Asc AV_DV_FK_I
FLUID_CODE_TYPE + FLUID_CODE Performance Asc/Asc AV_EJSCD_FLTYP_FK_I
FUEL_TYPE_CODE_TYPE + FUEL_TYPE_CODE Performance Asc/Asc AV_EJSCD_FUELTYP_FK_I
PAYMENT_TYPE_CODE_TYPE + PAYMENT_TYPE_CODE Performance Asc/Asc AV_EJSCD_PAYTYP_FK_I
VENDOR_ID Performance Asc AV_ITVD_FK_I
ASSIGN_ID + VEHICLE_ID Must be unique Asc/Asc AV_VEH_ASSGN_UK

Close relationships  within of separation: