api_external.party_threads
View
The caller's org-level conversations, with the latest message time and how many messages from others they have not read.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Thread. |
| org_id | uuid | Yes | Org. |
| org_name | text | Yes | Org name. |
| party_person_id | uuid | Yes | The caller, for a person conversation. |
| account_id | uuid | Yes | The caller's account, for an account conversation. |
| subject | text | Yes | Subject. |
| created_at | timestamp with time zone | Yes | When started. |
| last_message_at | timestamp with time zone | Yes | When the latest message was sent. |
| unread_count | bigint | Yes | Messages from others sent after the caller last read the thread. |