← Shopware 6.7.7.1

Shopware 6.7.7.1 product_download

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
version_id binary(16) NO Primary Key
position int NO Default: 1
product_id binary(16) NO Index Foreign Key → product.id
product_version_id binary(16) NO Foreign Key → product.version_id
media_id binary(16) NO Index Foreign Key → media.id
custom_fields json YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

3 indexes

Index Name Columns Unique
fk.product_download.media_id media_id No
fk.product_download.product_id product_id,product_version_id No
PRIMARY id,version_id Yes

Relations (from this table)

3 relations

Local Field Foreign Table Foreign Field
media_id media id
product_id product id
product_version_id product version_id