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 |
|
|
{“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 |
|
|
{“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 |