Shopware 6.7.8.1 product_translation
Translations for product names, descriptions, meta info, custom fields, and keyword lists.
| 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 | |
| Index Name | Columns | Unique |
| fk.product_translation.language_id | language_id | No |
| PRIMARY | product_id,product_version_id,language_id | Yes |
Relations (from this table)
3 relations
| Local Field | Foreign Table | Foreign Field |
| language_id | language | id |
| product_id | product | id |
| product_version_id | product | version_id |
