Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique integer identifier for each metadata row.”,“why”:“Without it, cannot reference a specific index metadata record.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:17.154020429+00:00”} |
|
| engine | varchar | 64 | null |
|
|
{“what”:“Search engine name (e.g., Elasticsearch, Solr).”,“why”:“Without it, cannot know which engine to connect to.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:17.522656184+00:00”} |
||
| version | varchar | 254 | null |
|
|
{“what”:“Engine version string (e.g., ‘7.10.2’).”,“why”:“Without it, client compatibility with the engine is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:17.794349547+00:00”} |
||
| index_name | varchar | 254 | null |
|
|
{“what”:“Actual index name in the engine (e.g., ‘products_en’).”,“why”:“Without it, cannot locate the index in the engine.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:17.920834403+00:00”} |
||
| status | varchar | 32 | √ | null |
|
|
{“what”:“Current lifecycle state (e.g., ‘active’, ‘building’, ‘failed’).”,“why”:“Without it, cannot tell if index is ready for queries.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:17.955496102+00:00”} |
|
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the metadata row was created.”,“why”:“Without it, cannot audit when index was registered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:18.026521490+00:00”} |
||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of last update to this row.”,“why”:“Without it, cannot know if metadata is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:18.096913165+00:00”} |
||
| lang_code | varchar | 10 | 'en'::character varying |
|
|
{“what”:“Language code (e.g., ‘en’, ‘fr’) for the index content.”,“why”:“Without it, cannot route queries to the correct language-specific index.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:18.172940021+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| search_index_metadata_pkey | Primary key | Asc | id |
| idx_search_index_metadata_unique_status | Must be unique | Asc/Asc/Asc/Asc | engine + version + lang_code + status |
| search_index_metadata_index_name_key | Must be unique | Asc | index_name |