ai_chat_turn Table (462)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
Contains AI Chatbot history - contains whole chat, not just what is sent to the chatbot. History is ready ordered by timestamp
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| ai_chat_turn_id | Primary key | PK | |
| associate_id | User id that is chatting with the bot | FK associate | |
| chat_id | The name of this chat topic - usually soproto + id (contact-123, sale-43, diary) but could also be an arbitrary name | String(40) | |
| timestamp | When the chat happened (UTC) | UtcDateTime | |
| user_prompt | What the user typed | Clob | ● |
| user_displaytext | Display this text instead of the prompt (if set) - could be set by action | Clob | ● |
| bot_response | AI Bot response to user_prompt - usually text | Clob | ● |
| bot_actions | Suggested actions (string dictionary) in JSON. NULL if not set | Clob | ● |
| attachments | JSON Array of bot - NULL if not set | Clob | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| ai_chat_turn_id | PK | Clustered, Unique |
| associate_id | FK | Index |
| timestamp | UtcDateTime | Index |
| associate_id, chat_id, timestamp | FK, String(40), UtcDateTime | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
Replication Flags
- None
Security Flags
- No access control via user's Role.