← Shopware 6.3.5.1

Shopware 6.3.5.1 cms_page

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

Columns

8 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
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 Yes

Relations (from this table)

1 relations

Local Field Foreign Table Foreign Field
preview_media_id media id

Relations (to this table)

5 relations

Local Field Foreign Table Foreign Field
id category cms_page_id
id cms_page_translation cms_page_id
id product cms_page_id
id landing_page cms_page_id
id cms_section cms_page_id