Order Relationship Map

Order Summary

Order #18010

State: CF · First travel: 2026-07-31T07:30:00+00:00 · Completed: no

Customer: Henry Furman · Price: £1,150

#5215

£288

#5216

£862

Table Footprint

Rows for order 18010

Table	Rows
orders	1
orders_raw	1
customers	1
drivers	2
vehicles	2
transports	2
allocations	2

Leg Relationship Map

Transport legs to allocations/drivers

Leg	Driver	Vehicle	Confirmed
1	Iain MacDonald (#59)	E24 ABT	✓
2	Kieran Steven (#71)	E24 ABT	✓

Vehicle Rows

vehicles table payloads

#	Vehicle Type	Vehicle ID	Make	Model	Registration	Reference
1	Executive Minicoach (max 16ppl with luggage)	n/a	n/a	n/a	n/a	n/a
2	n/a	8	Iveco	Glance	E24 ABT	E24 ABT (Y50)

Driver Rows

drivers table payloads

#	Driver ID	Driver Name	Staff	Salesperson
1	n/a	n/a	Gemma Anderson Black	Gemma Anderson Black
2	n/a	n/a	n/a	n/a

Customer Snapshot

customers table payload

{
  "company_name": "",
  "contacts": [],
  "customer_email": "henrycfurman@gmail.com",
  "customer_id": 10935,
  "customer_name": "Henry Furman",
  "customer_phone": "+15035451125",
  "order_id": 18010,
  "phone": "+15035451125"
}