critique_results


Description

{“what”:“Result of a single critique task: one row per task_id.”,“why”:“Without it, critique outcomes and metadata are lost, preventing audit and retry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:26:16.103110250+00:00”}

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

Relationships