vendororderitemdelivery

31081 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
orderreturnitem.deliveryItem_id FK_3E24DCDF3AF075CFR
orderreturnitem.swapDeliveryItem_id FK_3E24DCDF6715173ER
product_id VARCHAR 36 √ null
product.id FK_61BB18064584665AR
delivery_id VARCHAR 36 √ null
vendororderdelivery.id FK_61BB180612136921R
warehouse_id VARCHAR 36 √ null
warehouse.id FK_61BB18065080ECDER
location_id VARCHAR 36 √ null
warehousestoragelocation.id FK_61BB180664D218ER
created DATETIME 19 null
slipNumber VARCHAR 30 √ null
quantity DECIMAL 10,3 null
remainingQuantity INT 10 √ null
orderItem_id VARCHAR 36 √ null
vendororderitem.id FK_61BB1806E76E9C94R
serialNumber_id VARCHAR 36 √ null
productserialnumber.id FK_61BB1806A907283BR
relocatedLocation_id VARCHAR 36 √ null
warehousestoragelocation.id FK_61BB1806DADBCE91R
negativeQuantity DECIMAL 10,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_61BB180612136921 Performance Asc delivery_id
IDX_61BB18064584665A Performance Asc product_id
IDX_61BB18065080ECDE Performance Asc warehouse_id
IDX_61BB180664D218E Performance Asc location_id
IDX_61BB1806A907283B Performance Asc serialNumber_id
IDX_61BB1806DADBCE91 Performance Asc relocatedLocation_id
IDX_61BB1806E76E9C94 Performance Asc orderItem_id

Relationships

Close relationships within degrees of separation