Catalog Search Metadata table / catalog_search_metadata - Totara Learn 12 Database schema / Zoola Analytics

catalog_search_metadata table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

BIGINT

√

null

value

LONGTEXT

2147483647

null

The list of keywords

instanceid

BIGINT

null

pluginname

VARCHAR

√

null

plugintype

VARCHAR

timecreated

BIGINT

null

usermodified

BIGINT

null

timemodified

BIGINT

√

null

Showing 1 to 8 of 8 entries

Table contained -1 rows

catalog_search_metadata table indexes

Search:

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

Showing 1 to 5 of 5 entries

Catalog Search Metadata Table Schema (catalog_search_metadata)

Description

catalog_search_metadata table columns

catalog_search_metadata table indexes