Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| kind | text | 2147483647 | 'repo'::text |
|
|
{“what”:“Entity type the tag applies to, e.g. ‘repo’; default ‘repo’.”,“why”:“Distinguishes tag namespaces across entity types; without it, same entity_key could collide across types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.624591020+00:00”} |
||
| entity_key | text | 2147483647 | null |
|
|
{“what”:“Unique identifier of the tagged entity within its kind.”,“why”:“Identifies which entity the tag belongs to; without it, tags cannot be attached to a specific item.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.643311448+00:00”} |
||
| tag | text | 2147483647 | null |
|
|
{“what”:“The tag label itself, e.g. ‘machine-learning’.”,“why”:“The actual classification term; without it, no tag content exists.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.656394012+00:00”} |
||
| source | text | 2147483647 | null |
|
|
{“what”:“Origin of the tag assignment, e.g. ‘github’ or ‘manual’.”,“why”:“Tracks provenance so conflicting tags from different sources can be compared or filtered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.729782685+00:00”} |
||
| confidence | float4 | 8,8 | 0.9 |
|
|
{“what”:“Numeric confidence score for the tag, from 0 to 1; default 0.9.”,“why”:“Allows weighting or thresholding tags by reliability; without it, all tags are equally trusted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.738627587+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the tag assignment was created, in UTC.”,“why”:“Enables time-based auditing and freshness checks; without it, tag age is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.754930353+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| brief_tags_pkey | Primary key | Asc/Asc/Asc/Asc | kind + entity_key + tag + source |
| idx_brief_tags_key | Performance | Asc | entity_key |
| idx_brief_tags_tag | Performance | Asc | tag |