Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID primary key; unique identifier for each narrative row.”,“why”:“Without it, narratives cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.787634157+00:00”} |
|||||
| run_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the journey run this narrative belongs to; links to run table.”,“why”:“Without it, narratives cannot be associated with a specific run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.927584214+00:00”} |
|||||
| audience | text | 2147483647 | null |
|
|
{“what”:“Target audience label such as ‘executive’ or ‘technical’.”,“why”:“Without it, narratives cannot be filtered by intended reader.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.942133839+00:00”} |
|||||
| format | text | 2147483647 | 'markdown'::text |
|
|
{“what”:“Output format like ‘markdown’ or ‘html’; default ‘markdown’.”,“why”:“Without it, rendering cannot choose the correct parser.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.964413118+00:00”} |
|||||
| body | text | 2147483647 | null |
|
|
{“what”:“Full narrative text in the specified format.”,“why”:“Without it, there is no content to display.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.998452018+00:00”} |
|||||
| model | text | 2147483647 | √ | null |
|
|
{“what”:“Name/version of LLM that generated the body; null if unknown.”,“why”:“Without it, generation provenance and reproducibility are lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:12.022642063+00:00”} |
||||
| generated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when narrative was created; timezone-aware.”,“why”:“Without it, narrative freshness and ordering are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:12.047328048+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| journey_narrative_pkey | Primary key | Asc | id |
| idx_narrative_run | Performance | Asc/Asc | run_id + audience |