Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| post_slug | text | 2147483647 | null |
|
|
{“what”:“URL-friendly identifier for a post, e.g., ‘my-post-title’.”,“why”:“Without it, rows cannot be uniquely identified, breaking all references to a post.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:54.990730762+00:00”} |
|||||||||||
| facts | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Arbitrary JSON data of facts extracted from the post.”,“why”:“Without it, the post’s factual content is lost, preventing automated fact-based analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.215404028+00:00”} |
||||||||||
| meaning_ref | text | 2147483647 | √ | null |
|
|
{“what”:“Identifier or path to the meaning definition for this post.”,“why”:“Without it, the meaning behind the post is not linked, making it impossible to verify interpretation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.433878065+00:00”} |
||||||||||
| verbatim_ref | text | 2147483647 | √ | null |
|
|
{“what”:“Reference to the verbatim source text, e.g., a URL or ID.”,“why”:“Without it, the original text cannot be located for comparison.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.668079175+00:00”} |
||||||||||
| brief_ref | text | 2147483647 | √ | null |
|
|
{“what”:“Reference to the brief document, e.g., a file path or ID.”,“why”:“Without it, the associated brief cannot be retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:55.966736529+00:00”} |
||||||||||
| angle_slug | text | 2147483647 | √ | null |
|
|
{“what”:“Slug identifying the angle or perspective used for this brief.”,“why”:“Without it, the angle of the brief is unknown, making it hard to group or filter by perspective.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:56.015646192+00:00”} |
||||||||||
| persona | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON object describing the target persona, e.g., age, role.”,“why”:“Without it, the intended audience is not defined, affecting content tone and relevance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:56.108856403+00:00”} |
||||||||||
| content_mode | text | 2147483647 | √ | null |
|
|
{“what”:“Mode of content, e.g., ‘draft’ or ‘final’.”,“why”:“Without it, the status of the content is ambiguous, risking publishing incomplete work.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:56.810273439+00:00”} |
||||||||||
| source_urls | _text | 2147483647 | √ | null |
|
|
{“what”:“List of source URLs used for the post.”,“why”:“Without it, the provenance of the content is unknown, making fact-checking impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:56.856600840+00:00”} |
||||||||||
| word_count | int4 | 10 | √ | null |
|
|
{“what”:“Number of words in the post.”,“why”:“Without it, content length cannot be measured for SEO or readability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:56.985421438+00:00”} |
||||||||||
| complete | bool | 1 | √ | false |
|
|
{“what”:“Flag indicating whether the brief is complete (true) or not (false).”,“why”:“Without it, incomplete briefs cannot be filtered out, risking use of unfinished content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:57.142881317+00:00”} |
||||||||||
| generated_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp with time zone of generation.”,“why”:“Without it, the freshness of the brief cannot be determined, leading to stale content.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.320684795+00:00”} |
||||||||||
| brief_at | timestamptz | 35,6 | √ | now() |
|
|
{“what”:“Timestamp with time zone of last update, defaults to current time.”,“why”:“Without it, the last modification time is unknown, making it hard to track changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.416708877+00:00”} |
||||||||||
| primary_keyword | text | 2147483647 | √ | null |
|
|
{“what”:“Main keyword targeted by the post.”,“why”:“Without it, SEO focus is unclear, affecting search ranking decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.436948559+00:00”} |
||||||||||
| meaning_md | text | 2147483647 | √ | null |
|
|
{“what”:“Markdown text of the meaning section.”,“why”:“Without it, the meaning content is not available for rendering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.454615547+00:00”} |
||||||||||
| verbatim_md | text | 2147483647 | √ | null |
|
|
{“what”:“Markdown text of the verbatim section.”,“why”:“Without it, the verbatim content is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.472269730+00:00”} |
||||||||||
| brief_md | text | 2147483647 | √ | null |
|
|
{“what”:“Markdown text of the brief content.”,“why”:“Without it, the brief body is absent.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:58.515720739+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| post_brief_pkey | Primary key | Asc | post_slug |