metabot_prompt


Description

{“what”:“Prompt texts for metabot interactions, each linked to a card, entity, and model.”,“why”:“Without it, prompt history and model usage per card/entity would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.851787574+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null

{“what”:“Integer primary key; unique identifier for each prompt row.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.870907040+00:00”}

model varchar 32 null

{“what”:“Identifier of the language model used, e.g. ‘gpt-4’.”,“why”:“Without it, the model that produced the prompt is unknown, breaking reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.886827254+00:00”}

card_id int4 10 null
report_card.id fk_metabot_prompt_card_id C

{“what”:“Foreign key to the card this prompt is associated with.”,“why”:“Without it, prompts cannot be linked to a specific card, losing context.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.900912211+00:00”}

entity_id bpchar 21 √ null

{“what”:“Character code identifying the entity the prompt targets.”,“why”:“Without it, prompts cannot be filtered by entity, making per-entity analysis impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.922310026+00:00”}

prompt text 2147483647 null

{“what”:“The exact prompt text sent to the model.”,“why”:“Without it, there is no prompt to send or review, so the record is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.938711048+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the prompt record was created (UTC).”,“why”:“Without it, creation time is unknown, preventing chronological ordering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.953829398+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to this prompt record (UTC).”,“why”:“Without it, modification history is lost, hindering change tracking.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.971327037+00:00”}

metabot_id int4 10 null
metabot.id fk_metabot_prompt_metabot_id C

{“what”:“Foreign key to the metabot that owns this prompt.”,“why”:“Without it, prompts cannot be scoped to a specific bot, causing cross-bot confusion.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:30.995862903+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metabot_prompt_pkey Primary key Asc id
idx_metabot_prompt_card_id Performance Asc card_id
idx_metabot_prompt_metabot_id Performance Asc metabot_id
metabot_prompt_entity_id_key Must be unique Asc entity_id

Relationships