app.webhook_deliveries
TablePartitioned by monthRow level security on
One delivery of one domain event to one endpoint (ADR 0003), in monthly partitions. Retried with exponential backoff for 72 hours; a replay is a new delivery of the same event.
Primary key: id, created_at
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Delivery id, UUID v7; sent as XOS-Delivery. |
| org_id | uuid | No | Owning org, derived from app.webhook_endpoints on insert; never accepted from the caller and never changed.References app.organizations.id |
| webhook_endpoint_id | uuid | No | Endpoint the event is posted to.References app.webhook_endpoints.id |
| domain_event_id | uuid | No | Domain event delivered; the body is built from it, so every attempt sends the same body.References app.domain_events.id |
| delivery_status | app.delivery_status | No | Pending, Delivering, Delivered, Retrying or Expired. |
| attempt_count | smallint | No | Attempts started. |
| next_attempt_at | timestamp with time zone | No | When the dispatcher may try next. |
| last_attempt_at | timestamp with time zone | Yes | When the latest attempt started. |
| last_response_status | smallint | Yes | HTTP status of the latest response, or null when no response arrived. |
| last_error | text | Yes | Network or HTTP error of the latest failed attempt. |
| delivered_at | timestamp with time zone | Yes | When a 2xx response arrived. |
| replay_requested_by | uuid | Yes | Person who replayed the event from Atlas, for a replay.References app.people.id |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Yes | Person who inserted the row, or null for a platform process. Set by the database.References app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Yes | Person who last changed the row, or null for a platform process. Set by the database.References app.people.id |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |