Shopware 6.7.7.1 product_keyword_dictionary
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 |
| uniq.language_id_keyword | language_id,keyword | Yes |
Relations (from this table)
| Local Field | Foreign Table | Foreign Field |
|---|---|---|
| language_id | language | id |