app.sms_summary_queue
TableRow level security on
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.
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| 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.References app.organizations.id |
| notification_delivery_id | uuid | No | SMS delivery held for the summary.References private.notification_deliveries_p202609.id |
| notification_created_at | timestamp with time zone | No | Partition key of the delivery, checked by the foreign key.References private.notification_deliveries_p202609.notification_created_at |
| membership_id | uuid | No | Member the summary goes to.References 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 | Yes | 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 | 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. |