vendorproduct

2097 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
vendorproductscaleprice.vendorProduct_id FK_D082CFC28D221516R
product_id VARCHAR 36 null
product.id FK_5CB3E4BC4584665AR
vendor_id VARCHAR 36 null
vendor.id FK_5CB3E4BCF603EE73R
minimumAmount DECIMAL 10,4 null
acceptanceRange DECIMAL 10 null
deliveryTime INT 10 null
vendorStock DECIMAL 10,4 null
price DECIMAL 10,4 null
vendorSku VARCHAR 255 null
vendorTitle VARCHAR 255 null
comment VARCHAR 255 null
lastStockUpdate DATE 10 null
dropshipping BIT 1 null
addToOwnStock BIT 1 null
ondemand BIT 1 null
buyingUnitName VARCHAR 255 null
buying2saleUnitFormula VARCHAR 255 null
minimumAmountStep DECIMAL 10,4 null
transferPriceToProductPurchasePrice BIT 1 null
uvp DECIMAL 10,2 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
IDX_5CB3E4BC4584665A Performance Asc product_id
IDX_5CB3E4BCF603EE73 Performance Asc vendor_id
search_idx Performance Asc/Asc vendorSku + vendorTitle

Relationships