Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Integer primary key; unique row identifier.”,“why”:“Provides a stable reference for each setting row.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.776686399+00:00”} |
||||
| user_id | int4 | 10 | null |
|
|
{“what”:“ID of the user who owns this parameter value.”,“why”:“Identifies the user the setting applies to; without it, settings cannot be per-user.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.827951674+00:00”} |
|||||
| parameter_id | varchar | 36 | null |
|
|
{“what”:“String key naming the parameter (e.g., ‘theme’).”,“why”:“Determines which parameter is being set; without it, the setting is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.851760497+00:00”} |
|||||
| value | text | 2147483647 | √ | null |
|
|
{“what”:“Free-form text value for the parameter.”,“why”:“Holds the actual setting; without it, the parameter has no effect.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.891051300+00:00”} |
||||
| dashboard_id | int4 | 10 | √ | null |
|
|
{“what”:“ID of the dashboard this value applies to; null means global.”,“why”:“Allows the same parameter to have different values per dashboard; without it, settings are global only.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:14:04.914463724+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| user_parameter_value_pkey | Primary key | Asc | id |
| idx_user_parameter_value_dashboard_id | Performance | Asc | dashboard_id |
| idx_user_parameter_value_user_id | Performance | Asc | user_id |
| idx_user_parameter_value_user_id_dashboard_id_parameter_id | Performance | Asc/Asc/Asc | user_id + dashboard_id + parameter_id |