vendororderitem

583 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
offeritem.vendorOrderItem_id FK_7E455D7C72AE74BDR
vendororderitemdelivery.orderItem_id FK_61BB1806E76E9C94R
vendororderitemmetafield.vendorOrderItem_id FK_61F4C9A572AE74BDR
order_id VARCHAR 36 √ null
vendororder.id FK_E2F83D158D9F6D38R
product_id VARCHAR 36 √ null
product.id FK_E2F83D154584665AR
sort INT 10 null
quantity DECIMAL 10,3 null
deliveredQuantity DECIMAL 10,3 null
ean TINYTEXT 255 √ null
vendorSku TINYTEXT 255 √ null
productTitle LONGTEXT 2147483647 √ null
price DECIMAL 10,4 null
vat DECIMAL 10,2 √ null
note LONGTEXT 2147483647 √ null
variantTitle LONGTEXT 2147483647 √ null
productParameter LONGTEXT 2147483647 √ null
productOption LONGTEXT 2147483647 √ null
bestBeforeDate DATE 10 √ null
info VARCHAR 255 √ null
documentCategoryText LONGTEXT 2147483647 √ null
serialNumber VARCHAR 36 √ null
pickList_id VARCHAR 36 √ null
materialpicklist.id FK_E2F83D153F473D40R
pickDate DATETIME 19 √ null
created DATETIME 19 √ null
status_id VARCHAR 36 √ null
entitystatus.id FK_E2F83D156BF700BDR
producedDate DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_E2F83D153F473D40 Performance Asc pickList_id
IDX_E2F83D154584665A Performance Asc product_id
IDX_E2F83D156BF700BD Performance Asc status_id
IDX_E2F83D158D9F6D38 Performance Asc order_id

Relationships

Close relationships within degrees of separation