Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Integer primary key; unique identifier for a label.”,“why”:“Needed to reference labels from other tables; without it, labels cannot be uniquely identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:45.713617485+00:00”} |
||||
| name | varchar | 254 | null |
|
|
{“what”:“Human-readable label text, e.g. ‘Urgent’.”,“why”:“Shown in UI; without it, the label has no display text.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:45.752299457+00:00”} |
|||||
| slug | varchar | 254 | null |
|
|
{“what”:“URL-safe unique string, e.g. ‘urgent’.”,“why”:“Used in URLs/API lookups; without it, references are ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:45.808899850+00:00”} |
|||||
| icon | varchar | 128 | √ | null |
|
|
{“what”:“Optional icon name or path for the label.”,“why”:“Provides visual cue in UI; without it, labels are text-only.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:03:45.825022024+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| label_pkey | Primary key | Asc | id |
| idx_label_slug | Performance | Asc | slug |
| label_slug_key | Must be unique | Asc | slug |