generations


Description

{“what”:“One row per AI generation attempt, keyed by prompt_id.”,“why”:“Without it, no history exists of which prompt produced which output or failed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.104901689+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
prompt_id text 2147483647 null

{“what”:“Unique text ID of the originating prompt; primary key.”,“why”:“Without it, generations cannot be uniquely referenced or linked to their prompt.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.136864775+00:00”}

timestamp float8 17,17 √ null

{“what”:“Unix epoch time in seconds (with fractional part) when the generation was recorded.”,“why”:“Without it, the order and timing of generations is unknown, making debugging and rate limiting impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.154006052+00:00”}

template text 2147483647 √ null

{“what”:“The prompt template text that was filled with params to produce the prompt.”,“why”:“Without it, you cannot reproduce the exact prompt or understand how params were applied.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.171801342+00:00”}

params text 2147483647 √ null

{“what”:“JSON-encoded parameters substituted into the template for this generation.”,“why”:“Without it, the specific inputs that produced the output are lost, preventing reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.204991534+00:00”}

status text 2147483647 √ null

{“what”:“Outcome status of the generation, e.g., ‘success’ or ‘error’.”,“why”:“Without it, you cannot filter successful vs failed generations for monitoring or retries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.246618310+00:00”}

outputs text 2147483647 √ null

{“what”:“JSON-encoded output(s) produced by the generation, if any.”,“why”:“Without it, the generated content is unavailable for downstream use or inspection.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.263695185+00:00”}

duration_ms float8 17,17 √ null

{“what”:“Elapsed time of the generation in milliseconds.”,“why”:“Without it, performance issues cannot be identified or compared across generations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.282170646+00:00”}

error text 2147483647 √ null

{“what”:“Error message or stack trace if the generation failed; null on success.”,“why”:“Without it, the cause of failures is unknown, making debugging impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:17:14.305358244+00:00”}

Indexes

Constraint Name Type Sort Column(s)
generations_pkey Primary key Asc prompt_id

Relationships