← Shopware 6.7.7.1

Shopware 6.7.7.1 landing_page

Columns

7 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
version_id binary(16) NO Primary Key
active tinyint(1) NO Default: 1
cms_page_id binary(16) YES Index Foreign Key → cms_page.id
cms_page_version_id binary(16) NO Default: 0x0FA91CE3E96A4BC2BE4BD9CE752C3425 Foreign Key → cms_page.version_id
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

2 indexes

Index Name Columns Unique
fk.landing_page.cms_page_id cms_page_id,cms_page_version_id No
PRIMARY id,version_id Yes

Relations (from this table)

2 relations

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

Relations (to this table)

6 relations

Local Field Foreign Table Foreign Field
id landing_page_sales_channel landing_page_id
version_id landing_page_sales_channel landing_page_version_id
id landing_page_tag landing_page_id
version_id landing_page_tag landing_page_version_id
id landing_page_translation landing_page_id
version_id landing_page_translation landing_page_version_id