Table Type: Historical Data
This table stores the speech and text analytics categories detected for a conversation.
Each row represents one detected category for one conversation. The category metadata is stored alongside the conversation id to support querying and auditing of extracted category data.
Columns
| Column | Type | Modifiers | Notes |
|---|---|---|---|
| id | string | Primary Key | The unique identifier for the conversation category row. |
| db_last_updated | datetime | When this record was last updated in UTC. | |
| db_when_created | datetime | When this record was created in UTC. | |
| db_when_deleted | datetime | When this record was deleted in UTC. NULL if not deleted. | |
| conversation_id | string | The conversation id. | |
| category_id | string | The detected category id. | |
| name | string | The detected category name. | |
| description | string | The detected category description. | |
| interaction_type | string | The category interaction type. | |
| criteria_json | string | The category criteria serialized as JSON. |