Index

public.chatbot_conversation_message_tool_calls

Description

Contains tool calls made by the chatbot in a conversation. Each row is associated with a chatbot_conversation_messages row that has the role “assistant” in a many (tool calls) to one (message) relationship.

Columns

Name Type Default Nullable Children Parents Comment
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.
message_id uuid false public.chatbot_conversation_messages The chatbot_conversation_message that this row belongs to.
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_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 (message_id) REFERENCES chatbot_conversation_messages(id)
chatbot_conversation_message_tool_calls_message_id_not_null n NOT NULL message_id
chatbot_conversation_message_tool_calls_pkey PRIMARY KEY PRIMARY KEY (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_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