metabot


Description

{“what”:“A bot configuration tied to an entity, with optional collection grouping.”,“why”:“Without it, bot instances cannot be stored, retrieved, or associated with entities.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.424044649+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
metabot_prompt.metabot_id fk_metabot_prompt_metabot_id C

{“what”:“Unique integer identifier for each metabot row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or relationships.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.438996736+00:00”}

name varchar 254 null

{“what”:“Human-readable label for the metabot, used in UI and logs.”,“why”:“Without it, metabots cannot be distinguished by name in user-facing lists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.454713347+00:00”}

description text 2147483647 √ null

{“what”:“Free-form text describing the metabot’s purpose or behavior.”,“why”:“Without it, the metabot’s intended function is undocumented for humans.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.468849138+00:00”}

entity_id bpchar 21 √ null

{“what”:“External entity identifier (e.g., UUID) that this metabot is bound to.”,“why”:“Without it, the metabot’s target entity is unknown, breaking association.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.479576201+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of row creation, set to current time on insert.”,“why”:“Without it, there is no record of when the metabot was added.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.494273459+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone of the last modification, set to current time on insert.”,“why”:“Without it, stale or outdated metabot configurations cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.510279326+00:00”}

use_verified_content bool 1 √ false

{“what”:“Boolean flag indicating whether only verified content is used, default false.”,“why”:“Without it, the metabot’s content filtering behavior is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.536494020+00:00”}

collection_id int4 10 √ null

{“what”:“Identifier of the collection this metabot belongs to, if any.”,“why”:“Without it, the metabot’s membership in a collection is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:15.550536579+00:00”}

Indexes

Constraint Name Type Sort Column(s)
metabot_pkey Primary key Asc id
metabot_entity_id_key Must be unique Asc entity_id

Relationships