Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“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 |