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.
- Warehouse + Fleet + Delivery
- Data model
The tables behind Warehouse + Fleet + Delivery
Warehouse + Fleet + Delivery ships with 15 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
- 15
- Features
- 6
- Change it
- Add fields and tables in Proto
How the model is organised
Operating scope
Organizations, team members and Users identify the team; transport partners identifies the load counterparty. Exchange rates is read-only effective rate context.
Movement
Loads is the parent for ordered load stops, committed load assignments and loading handoffs.
Fleet
Drivers and Vehicles provide assignment resources; vehicle defects preserves severity, repair evidence and release time.
Control
Review decisions, operation receipts and record attachments link independent decisions, durable action results and evidence back to Loads.
Every table, by feature
- Loads and dispatch9
- Fleet and assignments5
- Stops and delivery4
- Warehouse custody6
- Partners and organizations6
- Review and evidence6
- Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners - Load stops
Ordered pickup and delivery stops within a load with appointment windows
Linked to Loads - Load assignments
Driver and vehicle assignments to loads with committed start and end times
Linked to Loads, Drivers, Vehicles - Loading handoffs
Warehouse-to-driver custody handoff extensions with review and completion state
Linked to Loads, Organizations - Operation receipts
Idempotent operation receipts recording executed or failed actions with stable keys
Linked to Loads - Review decisions
Independent approval, rejection or return decisions on a source revision
Linked to Loads, Team members - Transport partners
Eligible carriers and transport partners with contact and eligibility notes
Linked to Organizations - Organizations
Logistics operating organizations with time zone, currency and active scope
- Team members
Staff membership linking platform users to organizations with operational roles
Linked to Organizations, Users
- Load assignments
Driver and vehicle assignments to loads with committed start and end times
Linked to Loads, Drivers, Vehicles - Drivers
Driver roster with eligibility expiry and external authority reference
- Vehicles
Fleet vehicles with equipment class, capacity, readiness and external fleet id
- Vehicle defects
Reported vehicle defects with severity, repair evidence and release time
Linked to Vehicles - Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners
- Load stops
Ordered pickup and delivery stops within a load with appointment windows
Linked to Loads - Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners - Record attachments
Evidence files attached to loads with visibility and evidence type
Linked to Loads, Team members - Operation receipts
Idempotent operation receipts recording executed or failed actions with stable keys
Linked to Loads
- Loading handoffs
Warehouse-to-driver custody handoff extensions with review and completion state
Linked to Loads, Organizations - Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners - Review decisions
Independent approval, rejection or return decisions on a source revision
Linked to Loads, Team members - Operation receipts
Idempotent operation receipts recording executed or failed actions with stable keys
Linked to Loads - Record attachments
Evidence files attached to loads with visibility and evidence type
Linked to Loads, Team members - Organizations
Logistics operating organizations with time zone, currency and active scope
- Organizations
Logistics operating organizations with time zone, currency and active scope
- Team members
Staff membership linking platform users to organizations with operational roles
Linked to Organizations, Users - Users
Users
Linked to Users - Transport partners
Eligible carriers and transport partners with contact and eligibility notes
Linked to Organizations - Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners - Exchange rates
Read-only effective exchange rates for this app.
- Review decisions
Independent approval, rejection or return decisions on a source revision
Linked to Loads, Team members - Operation receipts
Idempotent operation receipts recording executed or failed actions with stable keys
Linked to Loads - Record attachments
Evidence files attached to loads with visibility and evidence type
Linked to Loads, Team members - Loads
Freight loads from pickup to delivery with promised windows, freight value and lifecycle
Linked to Organizations, Team members, Transport partners - Loading handoffs
Warehouse-to-driver custody handoff extensions with review and completion state
Linked to Loads, Organizations - Team members
Staff membership linking platform users to organizations with operational roles
Linked to Organizations, Users
Keys and references
Loads uses record number as its business reference. Load assignments.Load, loading handoffs.Parent, load stops.Parent, operation receipts.Parent, review decisions.Parent and record attachments.Parent point to Loads. Load assignments also refers to Drivers and Vehicles. Team members links Users to Organizations; Loads.Owner refers to team members. Review decisions.Reviewer and record attachments.uploaded by refer to team members. Keep operation keys stable across retries and compare source and expected revisions before applying a decision or action.
Migration order
- Bring in Organizations and Users, then team members and transport partners.
- Bring in Drivers and Vehicles, followed by vehicle defects.
- Bring in Loads with owner, organization and counterparty references.
- Add load stops, load assignments and loading handoffs under the correct load.
- Bring in review decisions, operation receipts and record attachments with their source references and history.
- Verify the read-only exchange rates source and reconcile effective dates before using currency context.
Set up Warehouse + Fleet + Delivery your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.