These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- EV Fleet Management
- Data model
The tables behind EV Fleet Management
EV Fleet Management ships with 21 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 21
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Load Planning
All loads references Organizations, team members through Owner, and transport partners through Counterparty. Load stops references its Load; Routes stores standard lane context.
Driver and Vehicle Assignment
Load assignments references all loads, Drivers and Vehicles and carries starts at, ends at and availability check. Drivers retains license expiry, eligibility until and external authority.
Charging Evidence
Charging sessions references all loads through Parent and Organizations through Organization. Vehicle is text; energy K wh and ending SOC percent describe the recorded session result.
Fleet Readiness
Vehicles is referenced by Inspections, vehicle defects, maintenance plans and fuel transactions. Readiness is separate from Vehicles.Status.
Dispatch and Delivery
Tracking events references all loads. Proof of delivery references both Load and Stop, and load stops retains actual arrival, departure and proof references.
Activity and Financial Evidence
Review decisions, record attachments and operation receipts use Parent to reference all loads. Freight charges uses Load and retains its own Currency and Status.
Every table, by feature
- Load Planning7
- Driver and Vehicle Assignment7
- Charging Evidence8
- Fleet Readiness6
- Dispatch and Delivery7
- Activity and Financial Evidence8
- Shared and settings1
- All loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Load stops
Pickup, delivery and service stops on a load
Linked to All loads - Routes
Standard lanes between an origin and destination
Linked to Organizations - Organizations
Carrier, broker, shipper and operating companies using the platform
- Transport partners
Carriers, brokers, 3PLs and shippers linked to transport work
Linked to Organizations - Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, Organizations - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members, All loads
- Load assignments
Driver and vehicle assignment for a load
Linked to All loads, Drivers, Vehicles - All loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Drivers
Licensed drivers available for load assignment
Linked to Organizations - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Vehicle defects
Defects reported against a fleet asset
Linked to Team members, Vehicles - Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, Organizations - Organizations
Carrier, broker, shipper and operating companies using the platform
- Charging sessions
EV charging sessions supporting close a verified charging session; an actual charger receipt is required and range remains an estimate.
Linked to All loads, Organizations - All loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Organizations
Carrier, broker, shipper and operating companies using the platform
- Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations, All loads, Team members - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members, All loads - Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members, All loads - Fuel transactions
Fuel and energy purchases recorded per asset
Linked to Vehicles - Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations
- Vehicles
Powered units and trailing equipment in the fleet
Linked to Organizations - Vehicle defects
Defects reported against a fleet asset
Linked to Team members, Vehicles - Inspections
Pre-trip, post-trip and periodic inspection results
Linked to Vehicles - Maintenance plans
Preventive maintenance and service schedules
Linked to Vehicles - Team members
Dispatch, planning, safety and maintenance staff
Linked to Users, Organizations - Load assignments
Driver and vehicle assignment for a load
Linked to All loads, Drivers, Vehicles
- All loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Load assignments
Driver and vehicle assignment for a load
Linked to All loads, Drivers, Vehicles - Load stops
Pickup, delivery and service stops on a load
Linked to All loads - Tracking events
Position and milestone events reported against a load
Linked to All loads - Proof of delivery
Delivery confirmation captured at the stop
Linked to All loads, Load stops - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members, All loads - Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members, All loads
- Operation receipts
Recorded operational outcomes awaiting verification
Linked to Organizations, Team members, All loads - Review decisions
Approval, rejection and escalation decisions on records
Linked to Organizations, Team members, All loads - Record attachments
Documents, photos and signature evidence attached to records
Linked to Organizations, All loads, Team members - Freight charges
Freight, accessorial and service charges billed against a load
Linked to All loads - All loads
Planned and executed transport loads
Linked to Organizations, Team members, Transport partners - Proof of delivery
Delivery confirmation captured at the stop
Linked to All loads, Load stops - Charging sessions
EV charging sessions supporting close a verified charging session; an actual charger receipt is required and range remains an estimate.
Linked to All loads, Organizations - Fuel transactions
Fuel and energy purchases recorded per asset
Linked to Vehicles
Keys and references
Keep source identifiers distinct from human record numbers. All loads.record number identifies the load to staff, while Revision supports the current scope decision. Review decisions.source table, source record and source revision identify the reviewed subject beneath the load parent. Operation receipts.operation key identifies an operation; Action, expected revision, source record and effect references provide its context.
Charging sessions.Vehicle is not a foreign key to Vehicles. Agree a unique mapping to unit number or external fleet ID and retain how the charger receipt matches the session. Record attachments.Parent points to all loads; use the agreed related record and evidence type convention to identify session evidence without inventing a relationship.
Operation receipts.Status uses Recorded, Verified, Failed and Corrected, while result state uses Pending, Completed, Failed and needs review. Keep those meanings separate. Record attachments has Name, Name2 and Title fields; preserve the source fields during migration. Routes has no reference from all loads.Lane, so lane matching needs a naming convention. Users.User is a self-reference requiring an established identity mapping.
Migration order
- Establish Organizations, Users and team members with active state and authenticated identity mapping.
- Import transport partners, Drivers and Vehicles with organization references and external authority identifiers.
- Prepare Routes and all loads, then load stops and load assignments with valid parent and resource references.
- Import vehicle-linked Inspections, vehicle defects, maintenance plans and fuel transactions while preserving service and repair evidence.
- Add charging sessions and map their text vehicle identifiers to the intended assets and parent loads.
- Import tracking events, proof of delivery and freight charges with their load and stop context.
- Preserve record attachments, review decisions and operation receipts with original revisions, timestamps and effect references; reconcile before enabling operational actions.
Set up EV Fleet Management your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.