Table Type: Realtime Data
This table stores real-time data about a conversation in a queue, or being handled after going through a queue.
As soon as a 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 never deleted.
(see the delete_queue_conversation_detail stored procedure to delete records from this table).
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| conversation_id | string | Primary Key | The unique identifier 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 | |
| external_tag | string | The external tag of the conversation | |
| address | string | The address of the conversation | |
| utilization_label_id | string | The ID of the utilization label | |
| recording_state | string | The recording state of the conversation - one of: None, Active, Paused | |
| is_finished | boolean | Required | Indicates if the conversation is finished or in-progress |