warehousestoragelocation

49 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
inventory.inventoredLocation_id FK_B12D4A36BF251FBDR
inventorylocation.location_id FK_6BD2CE4A64D218ER
picklistitem.location_id FK_B631308C64D218ER
posterminal.defaultReturnLocation_id FK_963E89DA20917B0AR
product_storagelocations.warehousestoragelocation_id FK_146157614CCC0310C
vendororderitemdelivery.location_id FK_61BB180664D218ER
vendororderitemdelivery.relocatedLocation_id FK_61BB1806DADBCE91R
warehousebooking.location_id FK_FC6BD52C64D218ER
warehousebox.location_id FK_3E6861D464D218ER
warehouse_id VARCHAR 36 null
warehouse.id FK_CBC9E6B75080ECDER
default BIT 1 null
status VARCHAR 1 null
type VARCHAR 10 null
comment VARCHAR 255 null
sort INT 10 null
maximumWeight DECIMAL 10,4 null
width DECIMAL 10,4 null
height DECIMAL 10,4 null
length DECIMAL 10,4 null
depot VARCHAR 255 null
rack VARCHAR 255 null
tray VARCHAR 255 null
level VARCHAR 255 null
reservedWeight DECIMAL 10,4 null
reservedVolume DECIMAL 10,4 null
placedWeight DECIMAL 10,4 null
placedVolume DECIMAL 10,4 null
fixedLocation BIT 1 null
title VARCHAR 255 null
order_id VARCHAR 36 null
orders.id FK_CBC9E6B78D9F6D38R
sameProductGroups BIT 1 null
placedProductGroup_id VARCHAR 36 null
category.id FK_CBC9E6B7B3467BC9R
sameProduct BIT 1 null
placedProduct_id VARCHAR 36 null
product.id FK_CBC9E6B72F523FDAR
reserveStock BIT 1 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_CBC9E6B72F523FDA Performance Asc placedProduct_id
IDX_CBC9E6B75080ECDE Performance Asc warehouse_id
IDX_CBC9E6B78D9F6D38 Performance Asc order_id
IDX_CBC9E6B7B3467BC9 Performance Asc placedProductGroup_id

Relationships