← Shopware 6.2.0

Shopware 6.2.0 rule_condition

Individual conditions within a rule (nested tree structure with AND/OR logic).

Columns

9 columns

Column Type Nullable Additional
id binary(16) NO Primary Key
type varchar(255) NO
rule_id binary(16) NO Index Foreign Key → rule.id
parent_id binary(16) YES Index Foreign Key → rule_condition.id
value longtext YES
position int(11) NO Default: 0
custom_fields longtext YES
created_at datetime(3) NO
updated_at datetime(3) YES

Indexes

3 indexes

Index Name Columns Unique
fk.rule_condition.parent_id parent_id No
fk.rule_condition.rule_id rule_id No
PRIMARY id Yes

Relations (from this table)

2 relations

Local Field Foreign Table Foreign Field
parent_id rule_condition id
rule_id rule id

Relations (to this table)

1 relations

Local Field Foreign Table Foreign Field
id rule_condition parent_id