🛒 Magento_Sales · engine innodb

sales_order_tax_item

Sales Order Tax Item

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

flowchart LR
  c["sales_order_tax_item"]:::center
  n0["sales_order_item"]
  click n0 "/schema/table/sales_order_item"
  n0 -- associated_item_id --> c
  n1["sales_order_tax"]
  click n1 "/schema/table/sales_order_tax"
  n1 -- tax_id --> c
  click c "/schema/table/sales_order_tax_item"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (3)

associated_item_id → sales_order_item tax_id → sales_order_tax item_id → sales_order_item

Columns (10)

Name	Type	Null	Comment
tax_item_id PK	int unsigned	no	Tax Item ID
tax_id	int unsigned	no	Tax ID
item_id	int unsigned	yes	Item ID
tax_percent	decimal	no	Real Tax Percent For Item
amount	decimal	no	Tax amount for the item and tax rate
base_amount	decimal	no	Base tax amount for the item and tax rate
real_amount	decimal	no	Real tax amount for the item and tax rate
real_base_amount	decimal	no	Real base tax amount for the item and tax rate
associated_item_id	int unsigned	yes	Id of the associated item
taxable_item_type	varchar(32)	no	Type of the taxable item

Keys & indexes

Primary key: tax_item_id

Unique

SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID (tax_id, item_id)

Indexes

SALES_ORDER_TAX_ITEM_ITEM_ID (item_id) btree

References (3)

associated_item_id → sales_order_item .item_id (on delete CASCADE)
tax_id → sales_order_tax .tax_id (on delete CASCADE)
item_id → sales_order_item .item_id (on delete CASCADE)