← Shopware 6.4.17.1

Shopware 6.4.17.1 cms_section

Sections within a CMS page that define the structural layout (sidebar, full-width, etc.).

Columns

17 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
version_id binary(16) NO Primary Key, Default: ???jK¾K??u,4%
cms_page_id binary(16) NO Index Foreign Key → cms_page.id
cms_page_version_id binary(16) NO Default: ???jK¾K??u,4% Foreign Key → cms_page.version_id
position int(11) NO
type varchar(255) NO Default: default
name varchar(255) YES
locked tinyint(1) NO Default: 0
sizing_mode varchar(255) NO Default: boxed
mobile_behavior varchar(255) NO Default: wrap
background_color varchar(255) YES
background_media_id binary(16) YES Index Foreign Key → media.id
background_media_mode varchar(255) YES
css_class 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_section.background_media_id background_media_id No
fk.cms_section.cms_page_id cms_page_id,cms_page_version_id No
PRIMARY id,version_id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
background_media_id media id
cms_page_id cms_page id
cms_page_version_id cms_page version_id

Relations (to this table)

2 relations

Local Field Foreign Table Foreign Field
id cms_block cms_section_id
version_id cms_block cms_section_version_id