app.report_deliveries
TablaSeguridad a nivel de fila activa
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.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| 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.Hace referencia a app.organizations.id |
| report_schedule_id | uuid | No | Schedule delivered.Hace referencia a app.report_schedules.id |
| membership_id | uuid | No | Recipient member; the run uses their access.Hace referencia a app.memberships.id |
| report_run_id | uuid | No | Run whose file is attached.Hace referencia a 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 | Sí | When the email was handed to the transport. |
| provider_message_id | text | Sí | Message id from the email transport. |
| last_error | text | Sí | Why the delivery failed. |
| deleted_at | timestamp with time zone | Sí | 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 | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |