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

Close relationships within degrees of separation