Shopware 6.7.8.1 product_keyword_dictionary
Dictionary of searchable keywords extracted from products (used by the search indexer).
| 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 |
| Index Name | Columns | Unique |
| idx.product_keyword_dictionary.language_id | language_id | No |
| PRIMARY | id,language_id | Yes |
| uniq.language_id_keyword | language_id,keyword | Yes |
Relations (from this table)
1 relations
| Local Field | Foreign Table | Foreign Field |
| language_id | language | id |
