Dispatch Command

Delivery Runs

delivery_run table

Total

—

Open

—

In Progress

—

Completed

—

Run Code	Dispatcher	Driver	Status	Created	Started	Completed	Actions

—

Delivery Stops

delivery_stop table

Seq	Run	Type	Label	Address	ETA	Window	Arrived	Departed	Status

—

Issue Log

issue_log table

Severity	Code	Message	Run	Stop	Created	Resolved

—

Locations

Pickups and dropoffs shown in the intake form dropdowns

Pickups

Label	Address

Dropoffs

Label	Address

Add Location

Type

Label

Address

Sort Order

Locations added here appear immediately in the intake form dropdowns. Deleting a location only removes it from future forms — existing runs are not affected.

Dispatchers

dispatchers table — dashboard access

Name	Email	Role	Last Login

Add New Dispatcher

Full Name

Temporary Password

Role

⚠ Only admins can add or remove dispatchers. Passwords are hashed with PBKDF2 — never stored in plain text.

Reports

Queries delivery_run + delivery_stop by date range

Report Parameters

Start Date

End Date

Driver Name (optional)

Status

Route AI

Claude plans the optimal route for a run — day by day, stop by stop

Plan a Route

Select Run

Driver Start Location

Max Driving Hours Per Day

Extra Notes for AI (optional)

Route Plan

✦ Select a run and generate

Plan Run

AI builds the optimal route — then populates the intake form

Run Details

Dispatcher Name

Driver Name

Driver Start Location

Run Code (optional)

Max Driving Hours / Day

Departure Date

Departure Time

Extra Notes for AI (optional)

Overnight Stay

This run may require overnight stays

Pickups

Dropoffs

AI Route Plan

✦ Add stops and generate