From Bright Pattern Documentation
ia2_intents
The ia2_intents table contains records of detected intents and their origins, such as categorization, autoscoring, or checklists. It tracks the frequency and specific topics mentioned by either the customer or the agent.
Description of Data
The following table provides the column name, data types, and description for the ia2_intents table.
| Column Name | Data Type | Description |
| customer_slice_id | BINARY(16) - Indexed | Identifier for the customer slice |
| agent_slice_id | BINARY(16) - Indexed | Identifier for the agent slice |
| party | VARCHAR(8) NOT NULL | Party identifier (customer/agent) |
| mentioning | VARCHAR(255) NOT NULL - Indexed | Name of detected intent |
| count | INT(11) | Count or frequency of the intent occurrence |
| origin | ENUM NOT NULL | Origin of the intent, Values: 'CATEGORIZATION', 'AUTOSCORING', 'SUGGESTION', 'CHECKLIST' |
| historical_interaction_id | VARCHAR(36) NOT NULL - Indexed | Unique identifier of the conversation |