picklistitem

4822 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 null
product.id FK_B631308C4584665AR
location_id VARCHAR 36 null
warehousestoragelocation.id FK_B631308C64D218ER
sort INT 10 null
quantity DECIMAL 10,3 null
picked BIT 1 null
pickList_id VARCHAR 36 null
picklist.id FK_B631308C3F473D40R
serialNumber_id VARCHAR 36 null
productserialnumber.id FK_B631308CA907283BR
pickedQuantity DECIMAL 10,3 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_B631308C3F473D40 Performance Asc pickList_id
IDX_B631308C4584665A Performance Asc product_id
IDX_B631308C64D218E Performance Asc location_id
IDX_B631308CA907283B Performance Asc serialNumber_id

Relationships