← Shopware 6.4.14.0

Shopware 6.4.14.0 cms_page_translation

Translations for CMS page names.

Columns

7 columns

Column Type Nullable Additional
cms_page_id binary(16) NO Primary Key Foreign Key → cms_page.id
cms_page_version_id binary(16) NO Primary Key, Default: ???jK¾K??u,4% Foreign Key → cms_page.version_id
language_id binary(16) NO Primary Key Foreign Key → language.id
name varchar(255) YES
custom_fields longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

3 indexes

Index Name Columns Unique
fk.cms_page_translation.cms_page_id cms_page_id,cms_page_version_id No
fk.cms_page_translation.language_id language_id No
PRIMARY cms_page_id,language_id,cms_page_version_id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
cms_page_id cms_page id
cms_page_version_id cms_page version_id
language_id language id