vendororderitem

285 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
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

Indexes

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

Relationships