warehousestoragelocation

65 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
materialpicklistitem.location_id FK_4B90B07A64D218ER
picklistitem.location_id FK_B631308C64D218ER
picklistreservation.location_id FK_D296DC4264D218ER
posterminal.defaultReturnLocation_id FK_963E89DA20917B0AR
product_storagelocations.warehousestoragelocation_id FK_146157614CCC0310C
vendororderdelivery.relocatedLocation_id FK_44EAB757DADBCE91R
vendororderitemdelivery.location_id FK_61BB180664D218ER
vendororderitemdelivery.relocatedLocation_id FK_61BB1806DADBCE91R
vendorordersubmissionitemdelivery.location_id FK_65DAAFCA64D218ER
vendorordersubmissionitemdelivery.relocatedLocation_id FK_65DAAFCADADBCE91R
warehousebooking.location_id FK_FC6BD52C64D218ER
warehousebooking.parentLocation_id FK_FC6BD52CA4D9DA71R
warehousebox.location_id FK_3E6861D464D218ER
warehousestoragelocation.parentLocation_id FK_CBC9E6B7A4D9DA71R
warehousestoragelocation_boxforuser.warehousestoragelocation_id FK_E8590EFD4CCC0310C
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 DOUBLE 22 null
placedWeight DECIMAL 10,4 null
placedVolume DOUBLE 22 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
reservedByUser_id INT 10 √ null
users.id FK_CBC9E6B77BB449EFR
checkProductGroup BIT 1 null
bookingCheckCondition VARCHAR 255 √ null
parentLocation_id VARCHAR 36 √ null
warehousestoragelocation.id FK_CBC9E6B7A4D9DA71R
lastBookingDate DATETIME 19 √ 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_CBC9E6B77BB449EF Performance Asc reservedByUser_id
IDX_CBC9E6B78D9F6D38 Performance Asc order_id
IDX_CBC9E6B7A4D9DA71 Performance Asc parentLocation_id
IDX_CBC9E6B7B3467BC9 Performance Asc placedProductGroup_id

Relationships

Close relationships within degrees of separation