📊 Magento_Inventory · engine innodb

inventory_source_item

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

flowchart LR
  c["inventory_source_item"]:::center
  n0["inventory_source"]
  click n0 "/schema/table/inventory_source"
  n0 -- source_code --> c
  click c "/schema/table/inventory_source_item"
  classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px

Click a node to jump to that table.

Related tables (1)

source_code → inventory_source

Columns (5)

Name	Type	Null	Default
source_item_id PK	int unsigned	no
source_code	varchar(255)	no
sku	varchar(64)	no
quantity	decimal	no	0
status	smallint unsigned	no	0

Keys & indexes

Primary key: source_item_id

Unique

INVENTORY_SOURCE_ITEM_SOURCE_CODE_SKU (source_code, sku)

Indexes

INVENTORY_SOURCE_ITEM_SKU_SOURCE_CODE_QUANTITY (sku, source_code, quantity) btree

References (1)

source_code → inventory_source .source_code (on delete CASCADE)