🛒 Magento_Sales · engine innodb
sales_order_tax
Sales Order Tax Table
Neighbourhood (1-hop foreign-key graph — showing 1 of 1)
flowchart LR c["sales_order_tax"]:::center n0["sales_order_tax_item"] click n0 "/schema/table/sales_order_tax_item" c -- tax_id --> n0 click c "/schema/table/sales_order_tax" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (1)
Columns (11)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| tax_id PK | int unsigned | no | Tax ID | |
| order_id | int unsigned | no | Order ID | |
| code | varchar(255) | yes | Code | |
| title | varchar(255) | yes | Title | |
| percent | decimal | yes | Percent | |
| amount | decimal | yes | Amount | |
| priority | int | no | Priority | |
| position | int | no | Position | |
| base_amount | decimal | yes | Base Amount | |
| process | smallint | no | Process | |
| base_real_amount | decimal | yes | Base Real Amount |
Keys & indexes
Primary key: tax_id
Indexes
- SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION (order_id, priority, position) btree
Referenced by (1)
- sales_order_tax_item .tax_id → .tax_id (on delete CASCADE)