overrides


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

Relationships