📊 Magento_Inventory · engine innodb
inventory_source
Neighbourhood (1-hop foreign-key graph — showing 3 of 3)
flowchart LR c["inventory_source"]:::center n0["inventory_source_stock_link"] click n0 "/schema/table/inventory_source_stock_link" c -- source_code --> n0 n1["inventory_source_carrier_link"] click n1 "/schema/table/inventory_source_carrier_link" c -- source_code --> n1 n2["inventory_source_item"] click n2 "/schema/table/inventory_source_item" c -- source_code --> n2 click c "/schema/table/inventory_source" classDef center fill:#eef2ff,stroke:#6366f1,color:#3730a3,stroke-width:1.5px
Click a node to jump to that table.
Related tables (3)
Columns (20)
| Name | Type | Null | Default | Comment |
|---|---|---|---|---|
| source_code | varchar(255) | no | ||
| name | varchar(255) | no | ||
| enabled | smallint unsigned | no | 1 | |
| description | text | yes | ||
| latitude | decimal | yes | ||
| longitude | decimal | yes | ||
| country_id | varchar(2) | no | ||
| region_id | int unsigned | yes | ||
| region | varchar(255) | yes | ||
| city | varchar(255) | yes | ||
| street | varchar(255) | yes | ||
| postcode | varchar(255) | no | ||
| contact_name | varchar(255) | yes | ||
| varchar(255) | yes | |||
| phone | varchar(255) | yes | ||
| fax | varchar(255) | yes | ||
| use_default_carrier_config | smallint unsigned | no | 1 | |
| is_pickup_location_active | boolean | no | 0 | |
| frontend_name | varchar | yes | ||
| frontend_description | text | yes |
Keys & indexes
Primary key: source_code
Referenced by (3)
- inventory_source_carrier_link .source_code → .source_code (on delete CASCADE)
- inventory_source_item .source_code → .source_code (on delete CASCADE)
- inventory_source_stock_link .source_code → .source_code (on delete CASCADE)