Table

conversations

A chat session. Escalated conversations keep history but reject new assistant turns.

id varchar PK conv_NNNN
shipment_id varchar Optional pin to one shipment; scopes retrieval.
status conversation_status not null default: open
token_budget int not null default: 200000 Per-conversation cap (ADR-004 budget rules).
tokens_used int not null default: 0
opened_at timestamptz not null
resolved_at timestamptz
index shipment_id
index status, opened_at idx_conversations_triage
ref messages.conversation_id many-to-one conversations.id