app.engagement_threads
TableRow level security on
Conversation threads between the org and the engaged party on one engagement (Section 7.3 messaging). The party reaches them while the engagement area is open (Section 8.7).
Primary key: id
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.engagements on insert; never accepted from the caller and never changed.References app.organizations.id |
| engagement_id | uuid | No | Engagement.References app.engagements.id |
| subject | text | No | Thread subject. |
| 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 |