Shopware 6.1.0.rc2 product_keyword_dictionary
Dictionary of searchable keywords extracted from products (used by the search indexer).
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| id | binary(16) | NO | Primary Key |
| language_id | binary(16) | NO | Primary Key Foreign Key → language.id |
| keyword | varchar(500) | NO | |
| reversed | varchar(500) | YES | STORED GENERATED |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| idx.product_keyword_dictionary.language_id | language_id | No |
| PRIMARY | id,language_id | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| language_id | language | id |