Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| model_index_id | int4 | 10 | √ | null |
|
|
{“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 |