💰 Magento_Tax · engine innodb

tax_calculation

Tax Calculation

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

flowchart LR
  c["tax_calculation"]:::center
  n0["tax_class"]
  click n0 "/schema/table/tax_class"
  n0 -- product_tax_class_id --> c
  n1["tax_calculation_rate"]
  click n1 "/schema/table/tax_calculation_rate"
  n1 -- tax_calculation_rate_id --> c
  n2["tax_calculation_rule"]
  click n2 "/schema/table/tax_calculation_rule"
  n2 -- tax_calculation_rule_id --> c
  click c "/schema/table/tax_calculation"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (4)

product_tax_class_id → tax_class customer_tax_class_id → tax_class tax_calculation_rate_id → tax_calculation_rate tax_calculation_rule_id → tax_calculation_rule

Columns (5)

Name	Type	Null	Comment
tax_calculation_id PK	int	no	Tax Calculation ID
tax_calculation_rate_id	int	no	Tax Calculation Rate ID
tax_calculation_rule_id	int	no	Tax Calculation Rule ID
customer_tax_class_id	smallint	no	Customer Tax Class ID
product_tax_class_id	smallint	no	Product Tax Class ID

Keys & indexes

Primary key: tax_calculation_id

Indexes

TAX_CALCULATION_TAX_CALCULATION_RULE_ID (tax_calculation_rule_id) btree
TAX_CALCULATION_CUSTOMER_TAX_CLASS_ID (customer_tax_class_id) btree
TAX_CALCULATION_PRODUCT_TAX_CLASS_ID (product_tax_class_id) btree
TAX_CALC_TAX_CALC_RATE_ID_CSTR_TAX_CLASS_ID_PRD_TAX_CLASS_ID (tax_calculation_rate_id, customer_tax_class_id, product_tax_class_id) btree

References (4)

product_tax_class_id → tax_class .class_id (on delete CASCADE)
customer_tax_class_id → tax_class .class_id (on delete CASCADE)
tax_calculation_rate_id → tax_calculation_rate .tax_calculation_rate_id (on delete CASCADE)
tax_calculation_rule_id → tax_calculation_rule .tax_calculation_rule_id (on delete CASCADE)