Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| task_id | text | 2147483647 | null |
|
|
{“what”:“Unique text identifier for a critique task; primary key.”,“why”:“Uniquely identifies each run for updates, retrieval, or deduplication.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.154163147+00:00”} |
||
| batch_id | text | 2147483647 | null |
|
|
{“what”:“Text identifier grouping multiple tasks submitted together.”,“why”:“Enables managing and tracking a set of tasks as one unit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.187624157+00:00”} |
||
| url | text | 2147483647 | null |
|
|
{“what”:“Target web address that was critiqued.”,“why”:“Identifies the resource being evaluated; without it, results are meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.210738845+00:00”} |
||
| status | int4 | 10 | null |
|
|
{“what”:“Integer status code; exact mapping defined in app (e.g., pending, done, error).”,“why”:“Allows filtering incomplete or failed tasks for retry or alerting.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.235908866+00:00”} |
||
| model | text | 2147483647 | null |
|
|
{“what”:“Name or version of the model that generated the critique.”,“why”:“Distinguishes results by model to compare performance or reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.277963585+00:00”} |
||
| findings | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSONB payload holding the critique output; schema varies by model.”,“why”:“Preserves the actual critique content in a flexible format for later analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.423916022+00:00”} |
|
| tokens | int8 | 19 | √ | null |
|
|
{“what”:“Number of tokens consumed by the model for this task.”,“why”:“Tracks usage for cost accounting and quota management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.485651228+00:00”} |
|
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message if the task failed; null on success.”,“why”:“Provides diagnostic info to debug failures without losing the attempt.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.507663521+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the task was created, in UTC.”,“why”:“Enables time-based ordering, retention, and auditing of task history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.571634445+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| critique_results_pkey | Primary key | Asc | task_id |
| idx_critique_batch | Performance | Asc | batch_id |