Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer assigned to each row.”,“why”:“Without it, rows cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.161239380+00:00”} |
||||
| created_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the row was inserted.”,“why”:“Without it, cannot determine age of cached values.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.196208590+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the last update to this row.”,“why”:“Without it, cannot know if cached values are stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.215510331+00:00”} |
|||||
| values | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized representation of the field’s distinct values.”,“why”:“Without it, the cache cannot provide the value list, forcing a recompute.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.230711281+00:00”} |
||||
| human_readable_values | text | 2147483647 | √ | null |
|
|
{“what”:“Serialized mapping of raw values to display labels.”,“why”:“Without it, only raw values are shown, losing user-friendly labels.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.249985089+00:00”} |
||||
| field_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the field these values belong to.”,“why”:“Without it, cannot associate cached values with a specific field.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.263256562+00:00”} |
|||||
| has_more_values | bool | 1 | √ | false |
|
|
{“what”:“Flag indicating whether additional values exist beyond those stored.”,“why”:“Without it, the UI cannot show a ‘load more’ option or know the list is incomplete.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.281270627+00:00”} |
||||
| type | varchar | 32 | 'full'::character varying |
|
|
{“what”:“Category of the cached value set, defaulting to ‘full’.”,“why”:“Without it, consumers cannot distinguish a complete list from a truncated one.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.291923997+00:00”} |
|||||
| hash_key | text | 2147483647 | √ | null |
|
|
{“what”:“Hash of the query parameters that produced this value set.”,“why”:“Without it, cannot distinguish cached results for different filter conditions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.302950766+00:00”} |
||||
| last_used_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last time this cache entry was accessed.”,“why”:“Without it, cannot implement LRU eviction or know which entries are unused.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:04:05.317812302+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| metabase_fieldvalues_pkey | Primary key | Asc | id |
| idx_fieldvalues_field_id | Performance | Asc | field_id |