transform_tag


Description

{“what”:“Mappings between tag names and transform entities; one row per tag applied.”,“why”:“Without it, tags on transforms would be unknown, breaking tag-based filtering or grouping.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.771148016+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
transform_job_transform_tag.tag_id fk_transform_job_transform_tag_tag_id C
transform_transform_tag.tag_id fk_transform_transform_tag_tag_id C

{“what”:“Unique integer identifier for this tag assignment row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or deletes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.782522369+00:00”}

name varchar 254 null

{“what”:“Text label for the tag, e.g., ‘urgent’.”,“why”:“Without it, the tag has no displayable name, making tags indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.798595778+00:00”}

entity_id bpchar 21 √ null

{“what”:“String identifier of the transform this tag applies to.”,“why”:“Without it, the tagged transform is unknown, so tag-to-transform association is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.811547294+00:00”}

created_at timestamptz 35,6 now()

{“what”:“Timestamp with timezone when the tag was applied.”,“why”:“Without it, the time of tagging is unknown, breaking audit trails or time-based queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.833893386+00:00”}

updated_at timestamptz 35,6 now()

{“what”:“Timestamp with timezone of the last modification to this tag assignment.”,“why”:“Without it, the recency of changes is unknown, making it impossible to detect stale tags.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.850384514+00:00”}

built_in_type varchar 255 √ null

{“what”:“Optional string classifying the tag as a built-in type; null for custom tags.”,“why”:“Without it, built-in tags cannot be distinguished from user-defined ones, breaking system tag management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:07:21.860379931+00:00”}

Indexes

Constraint Name Type Sort Column(s)
transform_tag_pkey Primary key Asc id
transform_tag_entity_id_key Must be unique Asc entity_id

Relationships