📦 Magento_CatalogInventory · engine innodb

cataloginventory_stock

Cataloginventory Stock

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

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

Click a node to jump to that table.

Related tables (1)

cataloginventory_stock_item → stock_id

Columns (3)

Name	Type	Null	Comment
stock_id PK	smallint unsigned	no	Stock ID
website_id	smallint unsigned	no	Website ID
stock_name	varchar(255)	yes	Stock Name

Keys & indexes

Primary key: stock_id

Indexes

CATALOGINVENTORY_STOCK_WEBSITE_ID (website_id) btree

Referenced by (1)

cataloginventory_stock_item .stock_id → .stock_id (on delete CASCADE)