← Shopware 6.7.7.1

Shopware 6.7.7.1 cms_section

Columns

18 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
version_id binary(16) NO Primary Key, Default: 0x0FA91CE3E96A4BC2BE4BD9CE752C3425
cms_page_id binary(16) NO Index Foreign Key → cms_page.id
cms_page_version_id binary(16) NO Default: 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 Foreign Key → cms_page.version_id
position int 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
visibility json YES
css_class varchar(255) YES
custom_fields json 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