Vehicle master, driver management, trip logging, GPS tracking, fuel management, and vehicle maintenance for construction fleet.
Fleet Management handles all vehicles used in construction operations — trucks, pickups, water tankers, buses, and specialized vehicles. Each vehicle is registered with RC/insurance details, assigned to drivers, and tracked via GPS. Trip logs capture route, distance, fuel, and payload. Maintenance is scheduled based on odometer readings or time intervals.
| Status | Description | Allowed Actions | Next States |
|---|---|---|---|
| Active | Vehicle operational and available | Assign, Log Trip | On Trip, Maintenance |
| On Trip | Vehicle currently on assigned trip | Track GPS, Complete Trip | Active |
| Maintenance | Scheduled service or repair | Complete, Return to Active | Active |
| Breakdown | Vehicle non-operational | Create Repair Order | Maintenance |
| Decommissioned | Vehicle retired from fleet | View History, Dispose | — |
vehicle_id — PKtenant_id — FK → organization.tenantregistration_number, vehicle_type — RC number and categorymake, model, year, fuel_type — Specificationsinsurance_expiry, fitness_expiry — Compliance datesodometer_reading, status — Current statedriver_id — PKemployee_id — FK → organization.employeelicense_number, license_type, license_expiry — Driving license detailsis_active — Availability flagtrip_id — PKvehicle_id — FK → fleet.vehicledriver_id — FK → fleet.drivertrip_date, start_time, end_time — Trip timingstart_km, end_km, distance — Odometer-based distancepurpose, route, payload_tons — Trip detailsgps_id — PKvehicle_id — FK → fleet.vehicletimestamp, latitude, longitude, speed — Real-time position and speedignition_status, geo_fence_alert — Monitoring flagsmaintenance_id — PKvehicle_id — FK → fleet.vehicleservice_type — routine | repair | tire | batteryscheduled_km, actual_km — Odometer-based schedulingcost, vendor — Service detailsRegister vehicle with RC details, insurance, fitness certificate, and PUC. System tracks expiry dates and sends renewal alerts 30 days in advance.
Assign qualified driver to vehicle. System checks license type matches vehicle category (LMV/HMV) and license validity. One driver per vehicle at a time.
Driver/coordinator logs trip with purpose, route, start/end odometer, and payload. System auto-calculates distance. GPS data correlated with trip log for route verification.
Real-time GPS tracking with geo-fence alerts for unauthorized movement. Speed monitoring with alerts for exceeding site speed limits. Historical route playback available.
Schedule routine maintenance at odometer intervals (e.g., every 10,000 km). Track tire replacements, battery changes, and body repairs. Cost tracked per vehicle for TCO analysis.
-- Total cost of ownership per vehicle SELECT v.registration_number, v.vehicle_type, SUM(vf.fuel_cost) AS total_fuel, SUM(vm.cost) AS total_maintenance, SUM(tl.distance) AS total_km, ROUND((SUM(vf.fuel_cost) + SUM(vm.cost)) / NULLIF(SUM(tl.distance), 0), 2) AS cost_per_km FROM fleet.vehicle v LEFT JOIN fleet.vehicle_fuel vf ON vf.vehicle_id = v.vehicle_id LEFT JOIN fleet.vehicle_maintenance vm ON vm.vehicle_id = v.vehicle_id LEFT JOIN fleet.trip_log tl ON tl.vehicle_id = v.vehicle_id GROUP BY v.vehicle_id;