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