Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each index row.”,“why”:“Uniquely identifies a row for updates and joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.179498142+00:00”} |
||||
| model_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the model this index belongs to; null for global.”,“why”:“Links index to a specific model; null means applies to all.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.223478283+00:00”} |
||||
| pk_ref | text | 2147483647 | null |
|
|
{“what”:“Primary key reference of the indexed entity as text.”,“why”:“Identifies the source row in the model’s table for lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.339512261+00:00”} |
|||||
| value_ref | text | 2147483647 | null |
|
|
{“what”:“Value reference used for indexing, e.g., a column value or key.”,“why”:“Determines the indexed value to match against queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.354181165+00:00”} |
|||||
| schedule | text | 2147483647 | null |
|
|
{“what”:“Cron expression or interval for when indexing runs.”,“why”:“Defines the refresh cadence for this index entry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.371589150+00:00”} |
|||||
| state | text | 2147483647 | null |
|
|
{“what”:“Current status of the index: pending, active, failed, etc.”,“why”:“Tracks whether the index is usable or needs attention.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.436533195+00:00”} |
|||||
| indexed_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Timestamp of the last successful indexing run.”,“why”:“Shows staleness; null if never indexed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.467506308+00:00”} |
||||
| error | text | 2147483647 | √ | null |
|
|
{“what”:“Error message from the last failed indexing attempt.”,“why”:“Provides diagnostic info when state indicates failure.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.481384477+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the index entry was created.”,“why”:“Audits creation time and supports time-based cleanup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.538406204+00:00”} |
|||||
| creator_id | int4 | 10 | null |
|
|
{“what”:“User ID of the creator of this index entry.”,“why”:“Tracks ownership for permissions and audit.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.550952915+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| model_index_pkey | Primary key | Asc | id |
| idx_model_index_creator_id | Performance | Asc | creator_id |
| idx_model_index_model_id | Performance | Asc | model_id |