page_brief


Description

{“what”:“A row per page content hash, holding extracted facts and processing state.”,“why”:“Without it, there is no single place to store per-page briefs, making retrieval and updates impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.436087488+00:00”}

Columns

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

{“what”:“Hash of the page’s content; the unique key for a page.”,“why”:“Without it, pages cannot be uniquely identified, so updates and lookups would be ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.466524970+00:00”}

domain text 2147483647 null
domain_brief.domain Implied Constraint R

{“what”:“Domain name (e.g., example.com) the page belongs to.”,“why”:“Without it, pages from different domains cannot be separated, and domain-specific processing is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.817700275+00:00”}

url text 2147483647 √ null

{“what”:“Full URL of the page; may be null if not captured.”,“why”:“Without it, the original source cannot be linked, making verification or re-fetching impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.831075090+00:00”}

facts jsonb 2147483647 '{}'::jsonb

{“what”:“JSON object of extracted facts keyed by fact name.”,“why”:“Without it, the page’s extracted knowledge is lost, and downstream consumers have no data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.856540923+00:00”}

meaning_ref text 2147483647 √ null

{“what”:“Identifier linking to a meaning record.”,“why”:“Without it, the page’s semantic interpretation cannot be traced.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.889829696+00:00”}

verbatim_ref text 2147483647 √ null

{“what”:“Identifier linking to a verbatim text record.”,“why”:“Without it, the exact source text cannot be retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.963315508+00:00”}

summary_ref text 2147483647 √ null

{“what”:“Identifier linking to a summary record.”,“why”:“Without it, the generated summary cannot be located.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:16.974957883+00:00”}

brief_ref text 2147483647 √ null

{“what”:“Identifier linking to a brief record.”,“why”:“Without it, the final brief cannot be associated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.003599736+00:00”}

image_shas _text 2147483647 '{}'::text[]

{“what”:“Array of hashes of images found on the page.”,“why”:“Without it, image deduplication or retrieval is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.016297364+00:00”}

complete bool 1 false

{“what”:“Flag indicating whether all processing steps have finished.”,“why”:“Without it, consumers cannot know if the brief is ready for use.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.037434897+00:00”}

certified_at timestamptz 35,6 √ null

{“what”:“Timestamp when the brief was certified as accurate.”,“why”:“Without it, the trust level of the brief is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.119496147+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp when the row was inserted.”,“why”:“Without it, audit and ordering by creation time is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.144574921+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to the row.”,“why”:“Without it, stale data cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:20:17.167300149+00:00”}

Indexes

Constraint Name Type Sort Column(s)
page_brief_pkey Primary key Asc content_hash
idx_page_brief_domain Performance Asc domain

Relationships