vendorordersubmissionitemdelivery

27 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
product_id VARCHAR 36 √ null
product.id FK_65DAAFCA4584665AR
delivery_id VARCHAR 36 √ null
vendororderdelivery.id FK_65DAAFCA12136921R
location_id VARCHAR 36 √ null
warehousestoragelocation.id FK_65DAAFCA64D218ER
quantity DECIMAL 10,3 null
serialNumber VARCHAR 36 √ null
bestBeforeDate VARCHAR 36 √ null
relocatedLocation_id VARCHAR 36 √ null
warehousestoragelocation.id FK_65DAAFCADADBCE91R
vendor_id VARCHAR 36 √ null
vendor.id FK_65DAAFCAF603EE73R
purchasePrice DECIMAL 10,4 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_65DAAFCA12136921 Performance Asc delivery_id
IDX_65DAAFCA4584665A Performance Asc product_id
IDX_65DAAFCA64D218E Performance Asc location_id
IDX_65DAAFCADADBCE91 Performance Asc relocatedLocation_id
IDX_65DAAFCAF603EE73 Performance Asc vendor_id

Relationships

Close relationships within degrees of separation