journey_narrative


Description

{“what”:“Generated narrative text for a journey run, tailored to an audience and format.”,“why”:“Without it, there is no persisted output of the journey narrative generation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:11.741327787+00:00”}

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
journey_run.id journey_narrative_run_id_fkey C

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

Relationships