inv.warehouses
| Documentation | Inventory |
| Schema | inv |
| Name | warehouses |
| Module | Inventory |
List of physical and virtual warehouses
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | warehouse_id | int | Warehouse ID | |||||
| Warehouse ID |
||||||||
| 2 | code | nvarchar(10) | Warehouse business code | |||||
| Warehouse business code |
||||||||
| 3 | name | nvarchar(50) | Warehouse name | |||||
| Warehouse name |
||||||||
| 4 | location | nvarchar(500) | Physical location description | |||||
| Physical location description |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| inv.items | inv.warehouses | inv.items.default_warehouse_id = inv.warehouses.warehouse_id | FK_items_warehouses |
|
|
inv.items.default_warehouse_id = inv.warehouses.warehouse_id Name: FK_items_warehouses |
||||
| inv.transactions | inv.warehouses | inv.transactions.warehouse_id = inv.warehouses.warehouse_id | User-defined relation |
|
|
inv.transactions.warehouse_id = inv.warehouses.warehouse_id Name: User-defined relation |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PK_warehouses | warehouse_id | ||
| IX_warehouses | code | ||
Used by
| Name |
|---|
|
inv.warehouses
|
Exported: 2019-02-04 23:17, Last imported: 2018-02-09 20:31