public.email_send_state

Synced from docs/generated/erd/ — do not hand-edit.
Regenerate with bun run docs:erd (needs staging reader), then this script runs automatically.
Labels: docs/db/erd-table-labels.yml · Runbook: docs/runbooks/erd-schema-docs.md

Description

SINGLETON dispatcher tuning/throttle state (batch size, delay, TTLs) — Not: A per-send or per-recipient record — despite the name it logs nothing

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
auth_email_ttl_minutes	integer	15	false
batch_size	integer	10	false
id	integer	1	false
last_drain_trigger_at	timestamp with time zone		true
retry_after_until	timestamp with time zone		true
send_delay_ms	integer	200	false
transactional_email_ttl_minutes	integer	60	false
updated_at	timestamp with time zone	now()	false

Viewpoints

Name	Definition
Communications & Journeys	Email campaigns, segments, templates, send/hygiene state, and journey engine (journeys/nodes/edges/runs). Catalog §4.1, §4.4. # email_automations + automation_executions dropped #2213 (P3 UNIT 2) — # journeys.* is the live automation surface; do not re-list those tables here.

Constraints

Name	Type	Definition
email_send_state_id_check	CHECK	CHECK ((id = 1))
email_send_state_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
email_send_state_pkey	CREATE UNIQUE INDEX email_send_state_pkey ON public.email_send_state USING btree (id)

Relations

erDiagram


"public.email_send_state" {
}

---

Generated by tbls