Catalog Search Metadata Table Schema (catalog_search_metadata)


Search metadata table where the search metadata are being stored

catalog_search_metadata table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
value LONGTEXT 2147483647 null

The list of keywords

instanceid BIGINT 19 null
pluginname VARCHAR 20 null
plugintype VARCHAR 20
timecreated BIGINT 19 null
usermodified BIGINT 19 null
timemodified BIGINT 19 null

Table contained -1 rows

catalog_search_metadata table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
catasearmeta_ins_ix Performance Asc instanceid
catasearmeta_inspluplu_uix Must be unique Asc/Asc/Asc instanceid + pluginname + plugintype
catasearmeta_plu2_ix Performance Asc plugintype
catasearmeta_plu_ix Performance Asc pluginname