← Shopware 6.4.1.0

Shopware 6.4.1.0 rule

Rule Builder rules — reusable conditions used across promotions, shipping, payment, and flows.

Columns

10 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
name varchar(500) NO
description longtext YES
priority int(11) NO
payload longblob YES
invalid tinyint(1) NO Default: 0
module_types longtext YES
custom_fields longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

1 indexes

Index Name Columns Unique
PRIMARY id Yes

Relations (to this table)

12 relations

Local Field Foreign Table Foreign Field
id shipping_method availability_rule_id
id product_price rule_id
id rule_condition rule_id
id promotion_persona_rule rule_id
id promotion_order_rule rule_id
id event_action_rule rule_id
id promotion_discount_rule rule_id
id payment_method availability_rule_id
id promotion_cart_rule rule_id
id shipping_method_price calculation_rule_id
id shipping_method_price rule_id
id promotion_setgroup_rule rule_id