← Shopware 6.7.8.0

Shopware 6.7.8.0 promotion_setgroup

Set group definitions for 'buy X get Y' style promotions (package/group discounts).

Columns

7 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
promotion_id binary(16) NO Index Foreign Key → promotion.id
packager_key varchar(255) NO
sorter_key varchar(255) NO
value double NO
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

2 indexes

Index Name Columns Unique
idx.promotion_setgroup.promotion_id promotion_id No
PRIMARY id Yes

Relations (from this table)

1 relations

Local Field Foreign Table Foreign Field
promotion_id promotion id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id promotion_setgroup_rule setgroup_id