ai_chat_turn table - SuperOffice

ai_chat_turn Table (461)

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	Nullable
ai_chat_turn_id	Primary key	PK	No
associate_id	User id that is chatting with the bot	FK associate	No
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)	No
timestamp	When the chat happened (UTC)	UtcDateTime	No
user_prompt	What the user typed	Clob	Yes
user_displaytext	Display this text instead of the prompt (if set) - could be set by action	Clob	Yes
bot_response	AI Bot response to user_prompt - usually text	Clob	Yes
bot_actions	Suggested actions (string dictionary) in JSON. NULL if not set	Clob	Yes
attachments	JSON Array of bot - NULL if not set	Clob	Yes

Indexes

Fields	Types	Description
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.

Related topics

What's new in version 11.5.755.0 What's new in version 11.6.943.0 What's new in version 11.7.727.0 What's new in version 11.8.788.0 What's new in version 11.9.1204.0 What's new in version 12.0.342.0

⌘I