brief_tags


Description

{“what”:“A row is one tag assignment from a source to an entity with a confidence score.”,“why”:“Without it, entity tags from different sources cannot be distinguished or weighted by reliability.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:11:44.570589338+00:00”}

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

Relationships