model_index_value


Description

{“what”:“Holds one indexed value per model row per index definition.”,“why”:“Without it, indexed lookups on model fields have no data to search.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:08.875016708+00:00”}

Columns

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

{“what”:“Identifier of the index definition this value belongs to.”,“why”:“Without it, values from different indexes would be indistinguishable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:08.981685274+00:00”}

model_pk int8 19 null

{“what”:“Primary key of the model row this value is indexed for.”,“why”:“Without it, the value cannot be linked to its owning record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:09.042369425+00:00”}

name text 2147483647 null

{“what”:“The actual text value being indexed for the field.”,“why”:“Without it, the index has no content to match against.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:09:09.133669978+00:00”}

Indexes

Constraint Name Type Sort Column(s)
unique_model_index_value_model_index_id_model_pk Must be unique Asc/Asc model_index_id + model_pk

Relationships