product

60826 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
accountbooking.product_id FK_3E0BC42E4584665AR
amazonasinjob.product_id FK_B7531C324584665AR
amazonexportstatus.product_id FK_6BECD6544584665AR
amazonjob.product_id FK_A58504934584665AR
amazonstockjob.product_id FK_67F719D24584665AR
attributevalue.product_id FK_1BBA8CA74584665AR
categoryaccessory.accessoryProduct_id FK_380BE4074ADCDE3R
commissioncontractitem.product_id FK_7C4E21554584665AR
commissionitem.product_id FK_1CEBABC94584665AR
discountaccessory.accessoryProduct_id FK_E57748E34ADCDE3R
ean.fixProduct_id FK_67B1C660B92BABD2R
ebayproductjob.product_id FK_BA6590634584665AR
ebaystockjob.product_id FK_54CF73FF4584665AR
expeditionitem.product_id FK_C3FC07EC4584665AR
inventorylocationitem.product_id FK_19ED39404584665AR
liabilityitem.product_id FK_590A525D4584665AR
materialpicklistitem.product_id FK_4B90B07A4584665AR
offeritem.product_id FK_7E455D7C4584665AR
orderbuyinglistitem.product_id FK_5A6741FE4584665AR
orderpickingitem.materialProduct_id FK_B934F6477FDBDE77R
orderreturnitem.materialProduct_id FK_3E24DCDF7FDBDE77R
orderreturnitem.otherProduct_id FK_3E24DCDF99BA4D22R
ottostockjob.product_id FK_E6E6E4414584665AR
payment_excludedproduct.product_id FK_BDBFC5844584665AC
payment_onlyproduct.product_id FK_D66714D34584665AC
payment_product.product_id FK_CA030A474584665AC
picklistitem.product_id FK_B631308C4584665AR
picklistreservation.product_id FK_D296DC424584665AR
product.parent_id FK_D34A04AD727ACA70R
product_attribute.product_id FK_94DA59764584665AR
product_cachedrootcategory.product_id FK_D25954CA4584665AC
product_category.product_id FK_CDFC73564584665AR
product_client.product_id FK_A53845F14584665AC
product_crosssellingproduct.crossselling_id FK_CD8CF1E64D61E3BR
product_crosssellingproduct.product_id FK_CD8CF1E4584665AR
product_customergroup.product_id FK_BE998C5B4584665AR
product_discount.product_id FK_2A50DE994584665AC
product_objectgroup.product_id FK_1DF96D24584665AC
product_option.product_id FK_38FA41144584665AR
product_report.product_id FK_A65336204584665AC
product_saleschannel.product_id FK_F49A19A74584665AC
product_storagelocations.product_id FK_146157614584665AC
product_voucherserie.product_id FK_7BD641FC4584665AC
productaccessory.accessoryProduct_id FK_44C10AEB4ADCDE3R
productaccessory.product_id FK_44C10AEB4584665AR
productcountrytax.product_id FK_32D356A64584665AR
productlicense.directProduct_id FK_CC27523ED53E5409R
productmaterial.materialProduct_id FK_D92F8F587FDBDE77R
productmaterial.product_id FK_D92F8F584584665AR
productmedia.product_id FK_BAE1F3B64584665AR
productmetafield.product_id FK_700669F74584665AR
productoption.baseMaterial_id FK_71E29770956500CCR
productoptionmaterial.materialProduct_id FK_65BFDF417FDBDE77R
productoptionmaterialquantity.product_id FK_9D01FE744584665AR
productpicture.product_id FK_8D94E9AE4584665AR
productprice.product_id FK_1A0570634584665AR
productsalecondition.product_id FK_5A9D614B4584665AR
productserialnumber.product_id FK_8E69D9E94584665AR
productstatistics.product_id FK_C1EF9CB24584665AR
productstock.product_id FK_9BFB04DA4584665AR
productstockcondition.product_id FK_A96DC5BD4584665AR
realproductjob.product_id FK_1BC8681E4584665AR
realstockjob.product_id FK_E32365314584665AR
scaleprice.product_id FK_9F9E26154584665AR
shipping_excludedproduct.product_id FK_6394EFAE4584665AC
shipping_product.product_id FK_350202694584665AC
shippingcost_excludedproduct.product_id FK_BB44B0494584665AC
shippingcost_product.product_id FK_47F2B9CF4584665AC
shippingpackage_excludedproduct.product_id FK_2C07950A4584665AC
shippingpackage_product.product_id FK_F5F469474584665AC
storebanner.product_id FK_999B02624584665AR
subscriptioncontractitem.product_id FK_992A6E5F4584665AR
vendororderitem.product_id FK_E2F83D154584665AR
vendororderitemdelivery.product_id FK_61BB18064584665AR
vendorordersubmissionitemdelivery.product_id FK_65DAAFCA4584665AR
vendorproduct.product_id FK_5CB3E4BC4584665AR
voucherserieaccessory.accessoryProduct_id FK_E91D96B54ADCDE3R
warehousebooking.product_id FK_FC6BD52C4584665AR
warehousestoragelocation.placedProduct_id FK_CBC9E6B72F523FDAR
webshopproductexportjob.product_id FK_B28DD764584665AR
parent_id VARCHAR 36 null
product.id FK_D34A04AD727ACA70R
vendor_id VARCHAR 36 null
vendor.id FK_D34A04ADF603EE73R
manufacturer_id VARCHAR 36 null
manufacturer.id FK_D34A04ADA23B42DR
tax_id VARCHAR 36 null
tax.id FK_D34A04ADB2A824D8R
countryoforigin_id VARCHAR 36 null
country.id FK_D34A04ADEAB5B262R
foreign_id VARCHAR 36 null
foreign_parent_id VARCHAR 36 null
title VARCHAR 255 null
active BIT 1 null
sort INT 10 null
description VARCHAR 255 null
longdescription LONGTEXT 2147483647 null
sizetable LONGTEXT 2147483647 null
additinfo LONGTEXT 2147483647 null
sku VARCHAR 255 null
price DECIMAL 10,4 null
uvp DECIMAL 10,2 null
stock DECIMAL 10,3 null
minimumStock DECIMAL 10 null
reservedStock DECIMAL 10,3 null
stockBuffer DECIMAL 10,3 null
useStock BIT 1 null
searchkeys VARCHAR 255 null
tags VARCHAR 255 null
ean VARCHAR 255 null
distean VARCHAR 25 null
mpn VARCHAR 100 null
uniquenumber VARCHAR 255 null
nonMaterial BIT 1 null
weight DOUBLE 22 null
variantName VARCHAR 255 null
icon VARCHAR 255 null
thumb VARCHAR 255 null
unitQuantity DOUBLE 22 null
unitName VARCHAR 255 null
purchasePrice DECIMAL 10,4 null
width DOUBLE 22 null
height DOUBLE 22 null
length DOUBLE 22 null
externalLink VARCHAR 255 null
externalLinkText VARCHAR 255 null
availableOn DATE 10 null
deliveryStatus INT 10 null
minDeliveryTime INT 10 null
maxDeliveryTime INT 10 null
deliveryTimeUnit VARCHAR 32 null
adult BIT 1 null
lastupdated INT 10 null
lastexported INT 10 null
mainClient_id VARCHAR 36 null
client.id FK_D34A04AD6CF8BF97R
bulkGoods BIT 1 null
minimumAge INT 10 null
isMaterial BIT 1 null
deletedAt DATETIME 19 null
materialSort INT 10 null
materialUnit VARCHAR 255 null
materialInternalName VARCHAR 255 null
materialBundleQuantity VARCHAR 255 null
additionalTitle VARCHAR 255 null
updated DATETIME 19 null
productFullTitle VARCHAR 255 null
saleUnitName VARCHAR 255 null
activeFrom DATETIME 19 null
activeTo DATETIME 19 null
saleVoucher BIT 1 null
noSalesChannel BIT 1 null
marketplaceFee DECIMAL 10,4 null
marketplaceType INT 10 null
marketplaceCustomer_id VARCHAR 36 null
customer.id FK_D34A04AD8002373DR
mainCategory_id VARCHAR 36 null
category.id FK_D34A04ADCF69962ER
buyingUnitName VARCHAR 255 null
sale2buyingUnitFormula VARCHAR 255 null
customsTariffNumber VARCHAR 32 null
orderedStock DECIMAL 10,3 null
commission BIT 1 null
commissionContract_id VARCHAR 36 null
commissioncontract.id FK_D34A04ADB3B5D8FAR
marketplacePercentFee DECIMAL 10,4 null
marketplaceFixFee DECIMAL 10,4 null
marketplaceFeeFormula VARCHAR 255 null
ignoreCalcStockOnCombinedProducts BIT 1 null
maximumStock DECIMAL 10 null
created DATETIME 19 null
skipDiscounts BIT 1 null
subscription BIT 1 null
subscriptionPeriod INT 10 null
isProductionOrder INT 10 null
salesLastMonth DECIMAL 10,3 null
salesCustomPeriod DECIMAL 10,3 null
lastSoldDate DATETIME 19 null
childrenTitles VARCHAR 255 null
childrenTitlesSet BIT 1 null
internalEan VARCHAR 25 null
calculatedPurchasePrice DECIMAL 10,4 null
bruttoPurchasePrice DECIMAL 10,4 null
isLicenseProduct BIT 1 null
licensePeriodDays INT 10 null
updatePeriodDays INT 10 null
licenseUpdatePercentPrice INT 10 null
bestBeforeProduct BIT 1 null
bestBeforeWaitingPeriod INT 10 null
serialNumberProduct BIT 1 null
customReservedStock DECIMAL 10,3 null
productIndex_id VARCHAR 36 null
productindex.id FK_D34A04ADD8D4EAFAR
salesLastYear DECIMAL 10,3 null
salesNextMonthLastYear DECIMAL 10,3 null
priceFormula LONGTEXT 2147483647 null
minPurchaseTime INT 10 null
maxPurchaseTime INT 10 null
purchaseTimeUnit VARCHAR 32 null
serviceCustomer_id VARCHAR 36 null
customer.id FK_D34A04ADE01385E8R
negativeStock DECIMAL 10,3 null
calcPricesByMaterials BIT 1 null
prepaidCard BIT 1 null
netweight DOUBLE 22 null
dummyField VARCHAR 64 null
bookingQuantity DECIMAL 10,3 null
createdByUser_id INT 10 null
users.id FK_D34A04ADE1F44B34R
status_id VARCHAR 36 null
entitystatus.id FK_D34A04AD6BF700BDR
calcProductionOrderStockByMaterials BIT 1 null
internalReservedStock DECIMAL 10,3 null
customSalesChannelStock LONGTEXT 2147483647 null
buyableFrom DATETIME 19 null
packageWidth DOUBLE 22 null
packageHeight DOUBLE 22 null
packageLength DOUBLE 22 null
uniqId VARCHAR 128 null
purchasePriceFormula LONGTEXT 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ean_idx Performance Asc ean
fulltitle_idx Performance Asc productFullTitle
IDX_D34A04AD6BF700BD Performance Asc status_id
IDX_D34A04AD6CF8BF97 Performance Asc mainClient_id
IDX_D34A04AD727ACA70 Performance Asc parent_id
IDX_D34A04AD8002373D Performance Asc marketplaceCustomer_id
IDX_D34A04ADA23B42D Performance Asc manufacturer_id
IDX_D34A04ADB2A824D8 Performance Asc tax_id
IDX_D34A04ADB3B5D8FA Performance Asc commissionContract_id
IDX_D34A04ADCF69962E Performance Asc mainCategory_id
IDX_D34A04ADD8D4EAFA Performance Asc productIndex_id
IDX_D34A04ADE01385E8 Performance Asc serviceCustomer_id
IDX_D34A04ADE1F44B34 Performance Asc createdByUser_id
IDX_D34A04ADEAB5B262 Performance Asc countryoforigin_id
IDX_D34A04ADF603EE73 Performance Asc vendor_id
internalEan_idx Performance Asc internalEan
search_idx Performance Asc/Asc foreign_id + foreign_parent_id
sku_idx Performance Asc sku
title_idx Performance Asc title
UNIQ_D34A04ADB4561F1E Must be unique Asc uniqId
uniqueNumber_idx Performance Asc uniquenumber

Relationships