Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for this cache configuration.”,“why”:“Without it, rows cannot be referenced or updated uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:41.888070364+00:00”} |
|
| model | varchar | 32 | null |
|
|
{“what”:“Name of the model class or table this config applies to.”,“why”:“Without it, the config cannot be scoped to a specific model type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:41.928069524+00:00”} |
||
| model_id | int4 | 10 | null |
|
|
{“what”:“Primary key value of the model instance this config targets.”,“why”:“Without it, the config cannot be tied to a specific record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:41.979577262+00:00”} |
||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this configuration row was created.”,“why”:“Without it, audit and debugging of config changes lose creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:41.995065152+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to this configuration.”,“why”:“Without it, stale configs cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.013636641+00:00”} |
||
| strategy | text | 2147483647 | null |
|
|
{“what”:“Caching strategy name, e.g., ‘full’, ‘incremental’.”,“why”:“Without it, the cache refresh method is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.029512301+00:00”} |
||
| config | text | 2147483647 | null |
|
|
{“what”:“JSON or serialized settings for the strategy.”,“why”:“Without it, strategy parameters are missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.046678593+00:00”} |
||
| state | text | 2147483647 | √ | null |
|
|
{“what”:“Current cache state, e.g., ‘active’, ‘invalid’.”,“why”:“Without it, cache validity cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.065863587+00:00”} |
|
| invalidated_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the cache was last invalidated.”,“why”:“Without it, time since invalidation is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.087624016+00:00”} |
|
| next_run_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Scheduled time for the next cache refresh.”,“why”:“Without it, refresh scheduling is impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.108527187+00:00”} |
|
| refresh_automatically | bool | 1 | √ | false |
|
|
{“what”:“Flag indicating whether the cache refreshes automatically.”,“why”:“Without it, automatic refresh behavior is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:02:42.134575609+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| cache_config_pkey | Primary key | Asc | id |
| idx_cache_config_unique_model | Must be unique | Asc/Asc | model + model_id |