Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |