💰 Magento_Tax · engine innodb
tax_calculation_rate
Tax Calculation Rate
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["tax_calculation_rate"]:::center n0["tax_calculation"] click n0 "/schema/table/tax_calculation" c -- tax_calculation_rate_id --> n0 n1["tax_calculation_rate_title"] click n1 "/schema/table/tax_calculation_rate_title" c -- tax_calculation_rate_id --> n1 click c "/schema/table/tax_calculation_rate" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (9)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| tax_calculation_rate_id PK | int | no | Tax Calculation Rate ID | |
| tax_country_id | varchar(2) | no | Tax Country ID | |
| tax_region_id | int | no | Tax Region ID | |
| tax_postcode | varchar(21) | yes | Tax Postcode | |
| code | varchar(255) | no | Code | |
| rate | decimal | no | Rate | |
| zip_is_range | smallint | yes | Zip Is Range | |
| zip_from | int unsigned | yes | Zip From | |
| zip_to | int unsigned | yes | Zip To |
Keys & indexes
Primary key: tax_calculation_rate_id
Indexes
- TAX_CALCULATION_RATE_TAX_COUNTRY_ID_TAX_REGION_ID_TAX_POSTCODE (tax_country_id, tax_region_id, tax_postcode) btree
- TAX_CALCULATION_RATE_CODE (code) btree
- IDX_CA799F1E2CB843495F601E56C84A626D (tax_calculation_rate_id, tax_country_id, tax_region_id, zip_is_range, tax_postcode) btree
Referenced by (2)
- tax_calculation .tax_calculation_rate_id → .tax_calculation_rate_id (on delete CASCADE)
- tax_calculation_rate_title .tax_calculation_rate_id → .tax_calculation_rate_id (on delete CASCADE)