📦 Magento_CatalogInventory · engine innodb
cataloginventory_stock_status_replica
Cataloginventory Stock Status
Columns (5)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| product_id | int unsigned | no | Product ID | |
| website_id | smallint unsigned | no | Website ID | |
| stock_id | smallint unsigned | no | Stock ID | |
| qty | decimal | no | 0 | Qty |
| stock_status | smallint unsigned | no | Stock Status |
Keys & indexes
Primary key: product_id, website_id, stock_id
Indexes
- CATALOGINVENTORY_STOCK_STATUS_STOCK_ID (stock_id) btree
- CATALOGINVENTORY_STOCK_STATUS_WEBSITE_ID (website_id) btree
- CATALOGINVENTORY_STOCK_STATUS_STOCK_STATUS (stock_status) btree