search_index_metadata


Description

{“what”:“Metadata about a search index instance, including engine, version, and language.”,“why”:“Without it, no record of which search indexes exist or their configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:16.778823668+00:00”}

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

Relationships