Index

public.chatbot_conversation_message_tool_calls

Description

Contains tool call outputs in a chatbot conversation. These can be outputs from our function tools or the Azure AI Search tool. Intended for the chatbot.

Columns

Name Type Default Nullable Children Parents Comment
chatbot_conversation_message_id uuid false public.chatbot_conversation_messages The chatbot_conversation_message that this row belongs to.
created_at timestamp with time zone now() false Timestamp when the record was created.
deleted_at timestamp with time zone true Timestamp when the record was deleted. If null, the record is not deleted.
id uuid uuid_generate_v4() false A unique, stable identifier for the record.
response_id text false The ID assigned by Azure per response, is the same for every message generated in one conversation turn of the LLM (one response). Used to fetch and delete a response from the Azure API.
tool_arguments jsonb false A JSON object that contains the arguments passed to the chatbot tool.
tool_call_id varchar(255) false The ID of the specific tool call, created by Azure and needed to connect a tool result to the correct tool call.
tool_kind tool_kind ‘function’::tool_kind false The kind of the tool: is it a function tool or Azure AI Search tool.
tool_name varchar(255) false The chatbot tool that was called.
updated_at timestamp with time zone now() false Timestamp when the record was last updated. The field is updated automatically by the set_timestamp trigger.

Constraints

Name Type Definition
chatbot_conversation_message_tool_calls_created_at_not_null n NOT NULL created_at
chatbot_conversation_message_tool_calls_id_not_null n NOT NULL id
chatbot_conversation_message_tool_calls_message_id_fkey FOREIGN KEY FOREIGN KEY (chatbot_conversation_message_id) REFERENCES chatbot_conversation_messages(id)
chatbot_conversation_message_tool_calls_message_id_not_null n NOT NULL chatbot_conversation_message_id
chatbot_conversation_message_tool_calls_pkey PRIMARY KEY PRIMARY KEY (id)
chatbot_conversation_message_tool_calls_response_id_not_null n NOT NULL response_id
chatbot_conversation_message_tool_calls_tool_arguments_not_null n NOT NULL tool_arguments
chatbot_conversation_message_tool_calls_tool_call_id_not_null n NOT NULL tool_call_id
chatbot_conversation_message_tool_calls_tool_kind_not_null n NOT NULL tool_kind
chatbot_conversation_message_tool_calls_tool_name_not_null n NOT NULL tool_name
chatbot_conversation_message_tool_calls_updated_at_not_null n NOT NULL updated_at

Indexes

Name Definition
chatbot_conversation_message_tool_calls_pkey CREATE UNIQUE INDEX chatbot_conversation_message_tool_calls_pkey ON public.chatbot_conversation_message_tool_calls USING btree (id)

Triggers

Name Definition
set_timestamp CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.chatbot_conversation_message_tool_calls FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp()

Relations

er

Generated by tbls