metabot_conversation


Description

{“what”:“A conversation session between a user and the bot.”,“why”:“Groups messages and state per user for context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:21.954332501+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id varchar 36 null
metabot_message.conversation_id fk_metabot_message_conversation_id R
parameter_card.parameter_id Implied Constraint R
user_parameter_value.parameter_id Implied Constraint R

{“what”:“Unique identifier for the conversation, e.g., UUID.”,“why”:“Primary key for referencing and joining.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:21.966793827+00:00”}
created_at timestamptz 35,6 now()

{“what”:“Timestamp when the conversation was created, in UTC.”,“why”:“Orders conversations and supports retention policies.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:21.980674269+00:00”}
user_id int4 10 null
core_user.id fk_metabot_conversation_user_id R

{“what”:“ID of the user who owns this conversation.”,“why”:“Links conversation to a user account for access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:21.996078785+00:00”}
summary text 2147483647 √ null

{“what”:“Short text summarizing the conversation’s content.”,“why”:“Provides a quick overview without reading full history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:22.013674888+00:00”}
state text 2147483647 √ null

{“what”:“Current state of the conversation, e.g., ‘active’ or ‘closed’.”,“why”:“Determines if the conversation accepts new messages.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:22.028714812+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metabot_conversation_pkey Primary key Asc id
idx_metabot_conversation_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation