app.party_threads
TablaSeguridad a nivel de fila activa
Org-level conversations between an org and an external person or account, beyond any one engagement (Section 11.10 habit 8). The party reaches them while it holds an engagement with the org in the engagement area or an application to one of its opportunities.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Org side of the conversation.Hace referencia a app.organizations.id |
| party_person_id | uuid | Sí | External person on the other side; NULL for an account conversation.Hace referencia a app.people.id |
| party_organization_id | uuid | Sí | External account on the other side; NULL for a person conversation.Hace referencia a app.organizations.id |
| subject | text | No | Thread subject. |
| 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 |