👤 Magento_Customer · engine innodb

customer_group

Customer Group

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

flowchart LR
  c["customer_group"]:::center
  n0["salesrule_product_attribute"]
  click n0 "/schema/table/salesrule_product_attribute"
  c -- customer_group_id --> n0
  n1["catalog_product_bundle_price_index"]
  click n1 "/schema/table/catalog_product_bundle_price_index"
  c -- customer_group_id --> n1
  n2["catalog_product_entity_tier_price"]
  click n2 "/schema/table/catalog_product_entity_tier_price"
  c -- customer_group_id --> n2
  n3["catalog_product_index_tier_price"]
  click n3 "/schema/table/catalog_product_index_tier_price"
  c -- customer_group_id --> n3
  n4["catalogrule_customer_group"]
  click n4 "/schema/table/catalogrule_customer_group"
  c -- customer_group_id --> n4
  n5["salesrule_customer_group"]
  click n5 "/schema/table/salesrule_customer_group"
  c -- customer_group_id --> n5
  click c "/schema/table/customer_group"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (6)

catalog_product_bundle_price_index → customer_group_id catalog_product_entity_tier_price → customer_group_id catalog_product_index_tier_price → customer_group_id catalogrule_customer_group → customer_group_id salesrule_customer_group → customer_group_id salesrule_product_attribute → customer_group_id

Columns (3)

Name	Type	Null	Default	Comment
customer_group_id PK	int unsigned	no
customer_group_code	varchar(32)	no		Customer Group Code
tax_class_id	int unsigned	no	0	Tax Class ID

Keys & indexes

Primary key: customer_group_id

Indexes

CUSTOMER_GROUP_CUSTOMER_GROUP_CODE (customer_group_code) btree

Referenced by (6)

catalog_product_bundle_price_index .customer_group_id → .customer_group_id (on delete CASCADE)
catalog_product_entity_tier_price .customer_group_id → .customer_group_id (on delete CASCADE)
catalog_product_index_tier_price .customer_group_id → .customer_group_id (on delete CASCADE)
catalogrule_customer_group .customer_group_id → .customer_group_id (on delete CASCADE)
salesrule_customer_group .customer_group_id → .customer_group_id (on delete CASCADE)
salesrule_product_attribute .customer_group_id → .customer_group_id (on delete CASCADE)