Shopware 6.7.7.1 product_translation
Columns
| Column | Type | Nullable | Additional |
|---|---|---|---|
| product_id | binary(16) | NO | Primary Key Foreign Key → product.id |
| product_version_id | binary(16) | NO | Primary Key Foreign Key → product.version_id |
| language_id | binary(16) | NO | Primary Key Foreign Key → language.id |
| meta_description | varchar(255) | YES | |
| name | varchar(255) | YES | |
| keywords | mediumtext | YES | |
| description | mediumtext | YES | |
| meta_title | varchar(255) | YES | |
| pack_unit | varchar(255) | YES | |
| custom_fields | json | YES | |
| slot_config | json | YES | |
| created_at | datetime(3) | NO | |
| updated_at | datetime(3) | YES | |
| pack_unit_plural | varchar(255) | YES | |
| custom_search_keywords | json | YES |
Indexes
| Index Name | Columns | Unique |
|---|---|---|
| fk.product_translation.language_id | language_id | No |
| PRIMARY | product_id,product_version_id,language_id | Yes |