app.sms_summary_queue
TablaSeguridad a nivel de fila activa
Texts held by quiet hours (ADR 0033 decision 35). When the quiet hours end, the SMS sender sends one summary per member and org, the count of held texts and the most important one, instead of a burst; push is never held here.
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.memberships on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id |
| notification_delivery_id | uuid | No | SMS delivery held for the summary.Hace referencia a private.notification_deliveries_p202609.id |
| notification_created_at | timestamp with time zone | No | Partition key of the delivery, checked by the foreign key.Hace referencia a private.notification_deliveries_p202609.notification_created_at |
| membership_id | uuid | No | Member the summary goes to.Hace referencia a app.memberships.id |
| due_at | timestamp with time zone | No | When the member's quiet hours end, so the summary may go. |
| sent_at | timestamp with time zone | Sí | When the summary carrying this delivery was sent, or the delivery was settled otherwise. |
| 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 |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |