📦 Magento_CatalogRule · engine innodb

catalogrule

CatalogRule

Neighbourhood (1-hop foreign-key graph — showing 2 of 2)

flowchart LR
  c["catalogrule"]:::center
  n0["catalogrule_customer_group"]
  click n0 "/schema/table/catalogrule_customer_group"
  c -- rule_id --> n0
  n1["catalogrule_website"]
  click n1 "/schema/table/catalogrule_website"
  c -- rule_id --> n1
  click c "/schema/table/catalogrule"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (2)

catalogrule_customer_group → rule_id catalogrule_website → rule_id

Columns (12)

Name	Type	Null	Default	Comment
rule_id PK	int unsigned	no		Entity ID
name	varchar(255)	yes		Name
description	text	yes		Description
from_date	date	yes		From
to_date	date	yes		To
is_active	smallint	no	0	Is Active
conditions_serialized	mediumtext	yes		Conditions Serialized
actions_serialized	mediumtext	yes		Actions Serialized
stop_rules_processing	smallint	no	1	Stop Rules Processing
sort_order	int unsigned	no	0	Sort Order
simple_action	varchar(32)	yes		Simple Action
discount_amount	decimal	no	0	Discount Amount

Keys & indexes

Primary key: rule_id

Indexes

CATALOGRULE_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE (is_active, sort_order, to_date, from_date) btree

Referenced by (2)

catalogrule_customer_group .rule_id → .rule_id (on delete CASCADE)
catalogrule_website .rule_id → .rule_id (on delete CASCADE)