app.report_deliveries
TableRow level security on
One email of a scheduled report to one recipient (Section 4.6.4): the run made as that member for the slot, and whether the email went out. Written only by the scheduler and the delivery worker.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.report_schedules on insert; never accepted from the caller and never changed.References app.organizations.id |
| report_schedule_id | uuid | No | Schedule delivered.References app.report_schedules.id |
| membership_id | uuid | No | Recipient member; the run uses their access.References app.memberships.id |
| report_run_id | uuid | No | Run whose file is attached.References app.report_runs.id |
| scheduled_for | timestamp with time zone | No | The schedule slot this delivery is for. |
| delivery_status | text | No | Queued, Sent or Failed. |
| sent_at | timestamp with time zone | Yes | When the email was handed to the transport. |
| provider_message_id | text | Yes | Message id from the email transport. |
| last_error | text | Yes | Why the delivery failed. |
| deleted_at | timestamp with time zone | Yes | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| 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 |