entity_brief


Description

{“what”:“A generated brief (markdown) with provenance and facts for a single entity.”,“why”:“Without it, briefs would need to be regenerated on every request and provenance would be lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.804272841+00:00”}

Columns

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

{“what”:“Entity category (e.g., repo, issue) that scopes the entity_key.”,“why”:“Without it, entity_key alone would be ambiguous across different entity types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.840689637+00:00”}

entity_key text 2147483647 null

{“what”:“String key that uniquely identifies the entity within its kind.”,“why”:“Without it, multiple entities of the same kind would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.874180238+00:00”}

repo text 2147483647 √ null

{“what”:“Repository identifier (e.g., ‘owner/name’) that the entity belongs to, if any.”,“why”:“Without it, you cannot tell which repository an entity came from.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.900804779+00:00”}

facts jsonb 2147483647 '{}'::jsonb

{“what”:“JSON object of arbitrary key-value facts about the entity, used for brief generation.”,“why”:“Without it, the brief cannot be regenerated or verified against its source facts.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.945370259+00:00”}

meaning text 2147483647 √ null

{“what”:“A short explanation of the entity’s significance, possibly derived from facts.”,“why”:“Without it, the brief lacks a concise explanation of the entity’s purpose.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:10.984311259+00:00”}

meaning_source text 2147483647 √ null

{“what”:“Source of the meaning, such as a file path or URL.”,“why”:“Without it, the origin of the meaning is unknown, reducing trust in the brief.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:11.012239629+00:00”}

meaning_model text 2147483647 √ null

{“what”:“Model or algorithm used to generate the meaning, e.g., ‘gpt-4’.”,“why”:“Without it, the provenance of the meaning is incomplete, making it hard to audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:11.077438515+00:00”}

brief_md text 2147483647 √ null

{“what”:“Markdown-formatted brief text for the entity.”,“why”:“Without it, there is no brief to display or consume.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:11.109526179+00:00”}

merkle text 2147483647 √ null

{“what”:“Hash of the brief content, used for integrity verification.”,“why”:“Without it, changes to the brief cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:11.138215524+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp of the last update to this row, in UTC.”,“why”:“Without it, you cannot know how stale the brief is.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:12:11.187124167+00:00”}

Indexes

Constraint Name Type Sort Column(s)
entity_brief_pkey Primary key Asc/Asc kind + entity_key
idx_entity_brief_repo Performance Asc repo

Relationships