Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each persisted info record.”,“why”:“Without it, records cannot be referenced or updated individually.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.890717873+00:00”} |
||||
| database_id | int4 | 10 | null |
|
|
{“what”:“Identifier of the database the query runs against.”,“why”:“Without it, we don’t know which database the persisted data belongs to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.929056868+00:00”} |
|||||
| card_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the card that triggered this persistence, if any.”,“why”:“Without it, we cannot link the persisted info to a specific card.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.950577105+00:00”} |
||||
| question_slug | text | 2147483647 | null |
|
|
{“what”:“Human-readable slug for the question, e.g., ‘sales-by-month’.”,“why”:“Without it, we cannot identify the question in URLs or logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:04.980994003+00:00”} |
|||||
| table_name | text | 2147483647 | null |
|
|
{“what”:“Name of the destination table where the data is persisted.”,“why”:“Without it, we don’t know where the data is stored.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.035226733+00:00”} |
|||||
| definition | text | 2147483647 | √ | null |
|
|
{“what”:“Query definition or SQL text used to generate the data.”,“why”:“Without it, we cannot reproduce or audit the query.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.052779191+00:00”} |
||||
| query_hash | text | 2147483647 | √ | null |
|
|
{“what”:“Hash of the query definition for quick comparison.”,“why”:“Without it, we cannot detect if the query changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.069500313+00:00”} |
||||
| active | bool | 1 | false |
|
|
{“what”:“Whether this persistence is currently active (true/false).”,“why”:“Without it, we cannot filter out inactive entries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.086508045+00:00”} |
|||||
| state | text | 2147483647 | null |
|
|
{“what”:“Current state of the persistence job, e.g., ‘running’, ‘success’, ‘failed’.”,“why”:“Without it, we cannot know if the data is ready or if a refresh is needed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.120204839+00:00”} |
|||||
| refresh_begin | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp when the last refresh started.”,“why”:“Without it, we cannot measure refresh duration or schedule.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.131301705+00:00”} |
|||||
| refresh_end | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp when the last refresh finished.”,“why”:“Without it, we cannot know if refresh is still running or compute duration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.145383665+00:00”} |
||||
| state_change_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp of the last state change.”,“why”:“Without it, we cannot know how long the current state has been in effect.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.157280207+00:00”} |
||||
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message from the last failed refresh.”,“why”:“Without it, we cannot diagnose failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.170457486+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this record was created.”,“why”:“Without it, we cannot track when the persistence was set up.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.185863914+00:00”} |
|||||
| creator_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user who created this persistence.”,“why”:“Without it, we cannot attribute ownership.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:10:05.196738533+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| persisted_info_pkey | Primary key | Asc | id |
| idx_persisted_info_creator_id | Performance | Asc | creator_id |
| idx_persisted_info_database_id | Performance | Asc | database_id |
| persisted_info_card_id_key | Must be unique | Asc | card_id |