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 |