Table Type: Realtime Data
This table stores real-time data about email conversations in a queue, or being handled after going through a queue.
As soon as an emil conversation is connected to a queue, a record is created in this table. The record is updated as the conversation progresses through the queue, and is deleted when all the conversation participants have disconnected from the queue.
It contains information about the conversation, the queue, the latest session, the latest participant, and the latest communication.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | The ID of the conversation |
| db_last_updated | datetime | The last time this record was updated in the database | |
| db_when_created | datetime | The time this record was created in the database | |
| connected_time | datetime | The time the conversation was connected | |
| queue_id | string | The ID of the queue | |
| purpose | string | The purpose of the latest participant. One of: acd, agent, api, botflow, campaign, customer, dialer, external, fax, group, inbound, ivr, manual, outbound, station, user, voicemail, voicesurveyflow or workflow | |
| state | string | State of the latest participant - one of: alerting, dialing, contacting, offering, connected, disconnected, terminated, uploading, converting, transmitting, scheduled or none | |
| direction | string | The direction of the latest participant. One of: inbound or outbound | |
| participant_id | string | The ID of the latest participant | |
| user_id | string | The ID of the user if the latest participant is a user, or NULL. | |
| subject | string | For emails, The subject of the email. | |
| to_address | string | The email address the conversation was initially sent to | |
| from_address | string | The email address the conversation was sent from |