Table slot9.WORLD.TSTA.DV_FUEL_OIL
This table stores department vehicle fuel and oil change records
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
FUEL_OIL_ID number 0 Unique identifier for fuel/oil record
VEHICLE_ID number 0
DEPARTMENT_VEHICLES.VEHICLE_ID DVFUEL_DV_FK R
Department vehicle id
ODOMETER number 0  √  null Department vehicle current odometer reading
DATE_TIME date 7  √  null Date/time of transaction
OFF_DUTY_MILES number 0  √  null Number of miles driven off duty
FUEL_GALLONS number 0  √  null Gallons of gas added
FUEL_COST number 0  √  null Cost of added gas
FUEL_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DVFUEL_EJSCD_FUEL_FK R
EJS CODES code for fuel type
FUEL_TYPE_CODE_TYPE varchar2 30  √  'FUEL_TYPE_CODES'
EJS_CODES.CODE_TYPE DVFUEL_EJSCD_FUEL_FK R
EJS CODES code type for fuel type
OIL_QUANTITY number 0  √  null Amount of oil added
OIL_COST number 0  √  null Cost of oil added
FLUID_CODE varchar2 30  √  null
EJS_CODES.CODE DVFUEL_EJSCD_FLUID_FK R
EJS CODES code for misc fluid type
FLUID_CODE_TYPE varchar2 30  √  'VEHICLE_FLUID_TYPE_CODES'
EJS_CODES.CODE_TYPE DVFUEL_EJSCD_FLUID_FK R
EJS CODES code type for misc fluid type
FLUID_COST number 0  √  null Cost of misc fluid
VENDOR varchar2 100  √  null Vendor of gas/oil (FREE TEXT)
VENDOR_ID number 0  √  null
ITEM_VENDORS.VENDOR_ID DVFUEL_ITVD_FK R
Vendor of gas/oil (FK TO DV_SERVICE_VENDORS)
COMMENTS varchar2 255  √  null Comments
ASSIGNED_USER_ID varchar2 100  √  null
IJIS_USER_PROFILES.LOGIN_ID DVFUEL_IUP_FK R
Responsible/Assigned officer
PAYMENT_TYPE_CODE varchar2 30  √  null
EJS_CODES.CODE DVFUEL_EJSCD_PAY_FK R
EJS CODES code for payment type
PAYMENT_TYPE_CODE_TYPE varchar2 30  √  'FUEL_PAYMENT_TYPE_CODES'
EJS_CODES.CODE_TYPE DVFUEL_EJSCD_PAY_FK R
EJS CODES code type for payment type
PAYMENT_ID varchar2 100  √  null Free text value for payment type - voucher id, gas card pin, etc
CREATOR_ID varchar2 100  √  null
CREATOR_DATE date 7  √  null
UPDATOR_ID varchar2 100  √  null
UPDATOR_DATE date 7  √  null
REC_ID number 0  √  null
ASSIGNMENT_VEHICLE_ID number 0  √  null
ASSIGNMENT_VEHICLES.ASSIGNMENT_VEHICLE_ID DVFUEL_AV_FK R
SERVICE_INTERVAL_CODE_TYPE varchar2 30  √  'VEHICLE_SERVICE_INTERVAL_CODES'
EJS_CODES.CODE_TYPE DVFUEL_EJSCD_SERV_INT_FK R
EJS CODES code type for service interval
SERVICE_INTERVAL_CODE varchar2 100  √  null
EJS_CODES.CODE DVFUEL_EJSCD_SERV_INT_FK R
EJS CODES code for service interval

Analyzed at Mon Sep 20 21:05 MDT 2021

Requirements (check constraints):
Constraint Constraint Name
"FUEL_OIL_ID" IS NOT NULL DVFUEL_ID_NN
"VEHICLE_ID" IS NOT NULL DVFUEL_VEH_ID_NN

Indexes:
Column(s) Type Sort Constraint Name Anomalies
FUEL_OIL_ID Primary key Asc DVFUEL_PK  
ASSIGNMENT_VEHICLE_ID Must be unique Asc DVFUEL_AV_UK This unique column is also nullable
VEHICLE_ID Performance Asc DVFUEL_DV_FK_I  
FLUID_CODE_TYPE + FLUID_CODE Performance Asc/Asc DVFUEL_EJSCD_FLUID_FK_I  
FUEL_TYPE_CODE_TYPE + FUEL_TYPE_CODE Performance Asc/Asc DVFUEL_EJSCD_FUEL_FK_I  
PAYMENT_TYPE_CODE_TYPE + PAYMENT_TYPE_CODE Performance Asc/Asc DVFUEL_EJSCD_PAY_FK_I  
SERVICE_INTERVAL_CODE_TYPE + SERVICE_INTERVAL_CODE Performance Asc/Asc DVFUEL_EJSCD_SERV_INT_FK_I  
VENDOR_ID Performance Asc DVFUEL_ITVD_FK_I  
ASSIGNED_USER_ID Performance Asc DVFUEL_IUP_FK_I  

Close relationships  within of separation: