post_brief


Description

{“what”:“A row per post brief, linking a post to its generated content and metadata.”,“why”:“Without it, generated briefs cannot be persisted or retrieved per post.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:17:54.736704953+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
post_slug text 2147483647 null
post_sources.post_slug Implied Constraint R
post_tags.post_slug Implied Constraint R
post_topics.post_slug Implied Constraint R

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

Relationships