model_index


Description

{“what”:“Index definitions for models, including schedule and state.”,“why”:“Centralizes per-model indexing configuration and status for monitoring.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:08:57.139831445+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
model_index_value.model_index_id fk_model_index_value_model_id C

{“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
report_card.id fk_model_index_model_id C

{“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
core_user.id fk_model_index_creator_id C

{“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

Relationships