Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | √ | null |
|
|
{“what”:“Unique numeric ID for each override row.”,“why”:“Needed to reference individual overrides for updates, deletes, or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.275825387+00:00”} |
|
| path | text | 2147483647 | null |
|
|
{“what”:“Configuration key path (e.g., ‘settings.timeout’) that the override applies to.”,“why”:“Identifies which setting is being overridden; without it, the target is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.306650155+00:00”} |
||
| device | text | 2147483647 | null |
|
|
{“what”:“Device identifier (e.g., hostname or serial) for which this override is active.”,“why”:“Scopes the override to a specific device; without it, overrides would apply globally.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.354650112+00:00”} |
||
| category | text | 2147483647 | null |
|
|
{“what”:“Classification of the override (e.g., ‘bugfix’, ‘temporary’, ‘customer’).”,“why”:“Groups overrides for reporting or filtering; without it, override types are indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.380025294+00:00”} |
||
| reason | text | 2147483647 | ''::text |
|
|
{“what”:“Free-text explanation for why the override exists.”,“why”:“Provides audit trail for future maintainers; without it, the rationale is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.397690943+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the override was inserted, in UTC.”,“why”:“Tracks when the override was added for auditing and cleanup; without it, override age is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:03.410989108+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| overrides_pkey | Primary key | Asc | id |
| overrides_path_device_key | Must be unique | Asc/Asc | path + device |