📊 Magento_Inventory · engine innodb
inventory_source_stock_link
Neighbourhood (1-hop foreign-key graph — showing 2 of 2)
flowchart LR c["inventory_source_stock_link"]:::center n0["inventory_stock"] click n0 "/schema/table/inventory_stock" n0 -- stock_id --> c n1["inventory_source"] click n1 "/schema/table/inventory_source" n1 -- source_code --> c click c "/schema/table/inventory_source_stock_link" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (2)
Columns (4)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| link_id PK | int unsigned | no | ||
| stock_id | int unsigned | no | ||
| source_code | varchar(255) | no | ||
| priority | smallint unsigned | no |
Keys & indexes
Primary key: link_id
Unique
- INVENTORY_SOURCE_STOCK_LINK_STOCK_ID_SOURCE_CODE (stock_id, source_code)
Indexes
- INVENTORY_SOURCE_STOCK_LINK_STOCK_ID_PRIORITY (stock_id, priority) btree
References (2)
- stock_id → inventory_stock .stock_id (on delete CASCADE)
- source_code → inventory_source .source_code (on delete CASCADE)