← Shopware 6.4.8.1

Shopware 6.4.8.1 cms_page

CMS layout pages (Shopping Experiences) — used for category pages, landing pages, and product detail.

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
version_id binary(16) NO Primary Key, Default: ???jK¾K??u,4%
type varchar(255) NO
entity varchar(255) YES
preview_media_id binary(16) YES Index Foreign Key → media.id
locked tinyint(1) NO Default: 0
config longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

2 indexes

Index Name Columns Unique
fk.cms_page.preview_media_id preview_media_id No
PRIMARY id,version_id Yes

Relations (from this table)

1 relations

Local Field Foreign Table Foreign Field
preview_media_id media id

Relations (to this table)

12 relations

Local Field Foreign Table Foreign Field
id cms_page_translation cms_page_id
version_id cms_page_translation cms_page_version_id
id landing_page cms_page_id
version_id landing_page cms_page_version_id
id product cms_page_id
version_id product cms_page_version_id
id sales_channel home_cms_page_id
version_id sales_channel home_cms_page_version_id
id cms_section cms_page_id
version_id cms_section cms_page_version_id
id category cms_page_id
version_id category cms_page_version_id