Contains reasoning items generated by a chatbot in a conversation.
| 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. | |||
| encrypted_content | text | true | Opaque reasoning payload from Azure, sent back on later turns so the model keeps its own reasoning. Null for rows written while responses were still stored on the Azure side and replayed by id. | |||
| id | uuid | uuid_generate_v4() | false | A unique, stable identifier for the record. | ||
| reasoning_id | text | false | The id assigned to this reasoning item by Azure. Used in rendering reasoning status in the UI. | |||
| 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. | |||
| summary | varchar(32376) | true | A summary of the reasoning process, if provided. | |||
| 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. |
| Name | Type | Definition |
|---|---|---|
| chatbot_conversation_messa_chatbot_conversation_messa_not_null1 | n | NOT NULL chatbot_conversation_message_id |
| chatbot_conversation_message_chatbot_conversation_message_fkey1 | FOREIGN KEY | FOREIGN KEY (chatbot_conversation_message_id) REFERENCES chatbot_conversation_messages(id) ON DELETE CASCADE |
| chatbot_conversation_message_reasoning_created_at_not_null | n | NOT NULL created_at |
| chatbot_conversation_message_reasoning_id_not_null | n | NOT NULL id |
| chatbot_conversation_message_reasoning_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| chatbot_conversation_message_reasoning_reasoning_id_not_null | n | NOT NULL reasoning_id |
| chatbot_conversation_message_reasoning_response_id_not_null | n | NOT NULL response_id |
| chatbot_conversation_message_reasoning_updated_at_not_null | n | NOT NULL updated_at |
| Name | Definition |
|---|---|
| chatbot_conversation_message_reasoning_message_id_idx | CREATE INDEX chatbot_conversation_message_reasoning_message_id_idx ON public.chatbot_conversation_message_reasoning USING btree (chatbot_conversation_message_id) |
| chatbot_conversation_message_reasoning_pkey | CREATE UNIQUE INDEX chatbot_conversation_message_reasoning_pkey ON public.chatbot_conversation_message_reasoning USING btree (id) |
| Name | Definition |
|---|---|
| set_timestamp | CREATE TRIGGER set_timestamp BEFORE UPDATE ON public.chatbot_conversation_message_reasoning FOR EACH ROW EXECUTE FUNCTION trigger_set_timestamp() |
Generated by tbls