Constraints

1051 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_96DB9E93A23B42D
manufacturerupload.manufacturer_id
manufacturer.id
Restrict delete
FK_67F719D24584665A
amazonstockjob.product_id
product.id
Restrict delete
FK_67F719D219EB6921
amazonstockjob.client_id
client.id
Restrict delete
FK_739D79357A78233A
vendorconditions.internalClient_id
client.id
Restrict delete
FK_739D79354887F3F8
vendorconditions.shipping_id
shipping.id
Restrict delete
FK_739D79354C3A3BB
vendorconditions.payment_id
payment.id
Restrict delete
FK_739D793595D0AABA
vendorconditions.defaultCurrency_id
currency.id
Restrict delete
FK_739D79358334E7B
vendorconditions.productionOrderClerk_id
users.id
Restrict delete
FK_23873805810431E8
usermessagechannel_user.usermessagechannel_id
usermessagechannel.id
Cascade on delete
FK_23873805A76ED395
usermessagechannel_user.user_id
users.id
Cascade on delete
FK_67067AC6FFBBC0AB
banknotecount.banknote_id
banknote.id
Restrict delete
FK_67067AC65C3545B8
banknotecount.banknoteCountProtocol_id
banknotecountprotocol.id
Restrict delete
FK_B29D009A53C674EE
gls.offer_id
offer.id
Restrict delete
FK_8F4BA2E68D9F6D38
amazonorderadjustmentjob.order_id
orders.id
Restrict delete
FK_8F4BA2E619EB6921
amazonorderadjustmentjob.client_id
client.id
Restrict delete
FK_8F4BA2E6FDB4FBE0
amazonorderadjustmentjob.offerItem_id
offeritem.id
Restrict delete
FK_5A6741FEB9BA2274
orderbuyinglistitem.orderBuyingList_id
orderbuyinglist.id
Restrict delete
FK_5A6741FE4584665A
orderbuyinglistitem.product_id
product.id
Restrict delete
FK_5733ACCA8D9F6D38
returntrackinginfo.order_id
orders.id
Restrict delete
FK_79B37F3219EB6921
customergroupmetafield.client_id
client.id
Restrict delete
FK_79B37F326FB7FED2
customergroupmetafield.customerGroup_id
customergroup.id
Restrict delete
FK_79B37F32443707B0
customergroupmetafield.field_id
clientsheme.id
Restrict delete
FK_92DD9FF6E825CECD
csvimport_objectgroup.csvimport_id
csvimport.id
Cascade on delete
FK_92DD9FF68A52B89A
csvimport_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_AD271CF68A52B89A
manufacturer_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_AD271CF6A23B42D
manufacturer_objectgroup.manufacturer_id
manufacturer.id
Cascade on delete
FK_8DB718484887F3F8
shippingcost.shipping_id
shipping.id
Restrict delete
FK_FF9F85C0F7AAF3AD
customer_adviser.customer_target
customer.id
Cascade on delete
FK_FF9F85C0EE4FA322
customer_adviser.customer_source
customer.id
Cascade on delete
FK_90B7512C8D9F6D38
orderremind.order_id
orders.id
Restrict delete
FK_F3EACE8DF551EA2
clientvalue_oneclientvalue.clientvalue_id
clientvalue.id
Restrict delete
FK_F3EACE81A1C7247
clientvalue_oneclientvalue.oneclientvalue_id
oneclientvalue.id
Restrict delete
FK_F243A3EF53C674EE
intraship.offer_id
offer.id
Restrict delete
FK_7AF9BE07A03C589C
user_grantedwidget.grantedwidget_id
grantedwidget.id
Cascade on delete
FK_7AF9BE07A76ED395
user_grantedwidget.user_id
users.id
Cascade on delete
FK_7CBA163A2C7C2CBA
workflowaction.workflow_id
workflow.id
Restrict delete
FK_D2A0705AA76ED395
customform_user.user_id
users.id
Cascade on delete
FK_D2A0705A9268A8FA
customform_user.customform_id
customform.id
Cascade on delete
FK_D22AE5B34C7C611F
country_discount.discount_id
discount.id
Cascade on delete
FK_D22AE5B3F92F3E70
country_discount.country_id
country.id
Cascade on delete
FK_9BFB04DA4584665A
productstock.product_id
product.id
Restrict delete
FK_9BFB04DA19EB6921
productstock.client_id
client.id
Restrict delete
FK_963E89DAC413DC35
posterminal.retailStore_id
retailstore.id
Restrict delete
FK_963E89DA5DBC5E14
posterminal.wawilistener_id
wawilistener.id
Restrict delete
FK_963E89DA20917B0A
posterminal.defaultReturnLocation_id
warehousestoragelocation.id
Restrict delete
FK_963E89DA7975B7E7
posterminal.model_id
posterminalmodel.id
Restrict delete
FK_CC6300108B98976A
customformgrid_usergroupcanaddcolumns.customformgrid_id
customformgrid.id
Cascade on delete
FK_CC630010D2112630
customformgrid_usergroupcanaddcolumns.usergroup_id
usergroup.id
Cascade on delete
FK_47BECB311E88FF9F
paypaltransaction.liability_id
liability.id
Restrict delete
FK_47BECB318D9F6D38
paypaltransaction.order_id
orders.id
Restrict delete
FK_47BECB31238B66F6
paypaltransaction.accountBooking_id
accountbooking.id
Restrict delete
FK_6502ABFB4C3A3BB
orderpaymentcondition.payment_id
payment.id
Restrict delete
FK_6502ABFB8D9F6D38
orderpaymentcondition.order_id
orders.id
Restrict delete
FK_153A78114C3A3BB
liabilitypayment.payment_id
payment.id
Restrict delete
FK_153A78111E88FF9F
liabilitypayment.liability_id
liability.id
Restrict delete
FK_E6E6E4414584665A
ottostockjob.product_id
product.id
Restrict delete
FK_E6E6E44119EB6921
ottostockjob.client_id
client.id
Restrict delete
FK_AE38A76E8D9F6D38
orderreturn.order_id
orders.id
Restrict delete
FK_AE38A76E19EB6921
orderreturn.client_id
client.id
Restrict delete
FK_CCC871B19EB6921
categorymetafield.client_id
client.id
Restrict delete
FK_CCC871B443707B0
categorymetafield.field_id
clientsheme.id
Restrict delete
FK_CCC871B12469DE2
categorymetafield.category_id
category.id
Restrict delete
FK_BA6590634584665A
ebayproductjob.product_id
product.id
Restrict delete
FK_BA65906319EB6921
ebayproductjob.client_id
client.id
Restrict delete
FK_A8768A99C2B92121
customformgridcondition.customFormGrid_id
customformgrid.id
Restrict delete
FK_BF117F21699281C2
customformfield_excludeduser.customformfield_id
customformfield.id
Cascade on delete
FK_BF117F21A76ED395
customformfield_excludeduser.user_id
users.id
Cascade on delete
FK_9773404F443707B0
customermetafield.field_id
clientsheme.id
Restrict delete
FK_9773404F19EB6921
customermetafield.client_id
client.id
Restrict delete
FK_9773404F9395C3F3
customermetafield.customer_id
customer.id
Restrict delete
FK_C7CB7404F92F3E70
shippingcost_country.country_id
country.id
Cascade on delete
FK_C7CB7404CFD6A7B3
shippingcost_country.shippingcost_id
shippingcost.id
Cascade on delete
FK_27594DCF443707B0
shippingmetafield.field_id
clientsheme.id
Restrict delete
FK_27594DCF4887F3F8
shippingmetafield.shipping_id
shipping.id
Restrict delete
FK_27594DCF19EB6921
shippingmetafield.client_id
client.id
Restrict delete
FK_ED271B4BA76ED395
user_posterminalprice.user_id
users.id
Cascade on delete
FK_ED271B4BCD7F4BE9
user_posterminalprice.posterminal_id
posterminal.id
Cascade on delete
FK_A8240721A76ED395
desktopdownloadjob.user_id
users.id
Restrict delete
FK_A824072119EB6921
desktopdownloadjob.client_id
client.id
Restrict delete
FK_14D1516719EB6921
productoptionmetafield.client_id
client.id
Restrict delete
FK_14D1516742B43298
productoptionmetafield.productoption_id
productoption.id
Restrict delete
FK_14D15167443707B0
productoptionmetafield.field_id
clientsheme.id
Restrict delete
FK_DE603D7A53C674EE
dhlexpress.offer_id
offer.id
Restrict delete
FK_54085BA953C674EE
hermes.offer_id
offer.id
Restrict delete
FK_185020969395C3F3
storeregistrationtoken.customer_id
customer.id
Restrict delete
FK_7DBDF9681ED6D67C
vendorordermetafield.vendorOrder_id
vendororder.id
Restrict delete
FK_7DBDF968443707B0
vendorordermetafield.field_id
clientsheme.id
Restrict delete
FK_7DBDF96819EB6921
vendorordermetafield.client_id
client.id
Restrict delete
FK_3958997319EB6921
orderpicking.client_id
client.id
Restrict delete
FK_395899733F473D40
orderpicking.pickList_id
picklist.id
Restrict delete
FK_395899738D9F6D38
orderpicking.order_id
orders.id
Restrict delete
FK_DE545B697F8BFB6A
user_grantedpage.grantedpage_id
grantedpage.id
Cascade on delete
FK_DE545B69A76ED395
user_grantedpage.user_id
users.id
Cascade on delete
FK_590A525D4584665A
liabilityitem.product_id
product.id
Restrict delete
FK_590A525D43237701
liabilityitem.costCenter_id
costcenter.id
Restrict delete
FK_590A525DD2F28CB9
liabilityitem.agentOrder_id
orders.id
Restrict delete
FK_590A525D1E88FF9F
liabilityitem.liability_id
liability.id
Restrict delete
FK_C0145594887F3F8
shippingpackage.shipping_id
shipping.id
Restrict delete
FK_FF5758775654BF34
store.additionalSearchGrid_id
customformgrid.id
Restrict delete
FK_FF57587719EB6921
store.client_id
client.id
Restrict delete
FK_FF57587782F1BAF4
store.language_id
language.id
Restrict delete
FK_D4AA97059395C3F3
storelogintoken.customer_id
customer.id
Restrict delete
FK_61BB1806E76E9C94
vendororderitemdelivery.orderItem_id
vendororderitem.id
Restrict delete
FK_61BB1806DADBCE91
vendororderitemdelivery.relocatedLocation_id
warehousestoragelocation.id
Restrict delete
FK_61BB18065080ECDE
vendororderitemdelivery.warehouse_id
warehouse.id
Restrict delete
FK_61BB180664D218E
vendororderitemdelivery.location_id
warehousestoragelocation.id
Restrict delete
FK_61BB18064584665A
vendororderitemdelivery.product_id
product.id
Restrict delete
FK_61BB1806A907283B
vendororderitemdelivery.serialNumber_id
productserialnumber.id
Restrict delete
FK_61BB180612136921
vendororderitemdelivery.delivery_id
vendororderdelivery.id
Restrict delete
FK_329AF1E9A0F81733
ecreport.cashJournal_id
cashjournal.id
Restrict delete
FK_329AF1E9856092CE
ecreport.cashReport_id
cashreport.id
Restrict delete
FK_329AF1E9A76ED395
ecreport.user_id
users.id
Restrict delete
FK_2734999019EB6921
attributemetafield.client_id
client.id
Restrict delete
FK_27349990443707B0
attributemetafield.field_id
clientsheme.id
Restrict delete
FK_27349990B6E62EFA
attributemetafield.attribute_id
attribute.id
Restrict delete
FK_44EAB757DADBCE91
vendororderdelivery.relocatedLocation_id
warehousestoragelocation.id
Restrict delete
FK_44EAB757A76ED395
vendororderdelivery.user_id
users.id
Restrict delete
FK_44EAB7576FBD33A7
vendororderdelivery.orderReturn_id
orderreturn.id
Restrict delete
FK_44EAB7571C7C4AAD
vendororderdelivery.customerOrder_id
orders.id
Restrict delete
FK_44EAB7578D9F6D38
vendororderdelivery.order_id
vendororder.id
Restrict delete
FK_44EAB7575080ECDE
vendororderdelivery.warehouse_id
warehouse.id
Restrict delete
FK_44EAB757DD5477C4
vendororderdelivery.relocatedWarehouse_id
warehouse.id
Restrict delete
FK_DD776C9B82F1BAF4
reportcolumn.language_id
language.id
Restrict delete
FK_DD776C9B4BD2A4C0
reportcolumn.report_id
report.id
Restrict delete
FK_BE998C5B96C19C84
product_customergroup.customergroup_id
customergroup.id
Restrict delete
FK_BE998C5B4584665A
product_customergroup.product_id
product.id
Restrict delete
FK_19ED394026E88475
inventorylocationitem.inventorylocation_id
inventorylocation.id
Restrict delete
FK_19ED39404584665A
inventorylocationitem.product_id
product.id
Restrict delete
FK_19ED3940A907283B
inventorylocationitem.serialNumber_id
productserialnumber.id
Restrict delete
FK_5373C96638248176
country.currency_id
currency.id
Restrict delete
FK_B12D4A3612469DE2
inventory.category_id
category.id
Restrict delete
FK_B12D4A36BF251FBD
inventory.inventoredLocation_id
warehousestoragelocation.id
Restrict delete
FK_B12D4A36A23B42D
inventory.manufacturer_id
manufacturer.id
Restrict delete
FK_D34A04ADB3B5D8FA
product.commissionContract_id
commissioncontract.id
Restrict delete
FK_D34A04ADA23B42D
product.manufacturer_id
manufacturer.id
Restrict delete
FK_D34A04ADE1F44B34
product.createdByUser_id
users.id
Restrict delete
FK_D34A04AD8002373D
product.marketplaceCustomer_id
customer.id
Restrict delete
FK_D34A04ADE01385E8
product.serviceCustomer_id
customer.id
Restrict delete
FK_D34A04ADB2A824D8
product.tax_id
tax.id
Restrict delete
FK_D34A04ADCF69962E
product.mainCategory_id
category.id
Restrict delete
FK_D34A04ADEAB5B262
product.countryoforigin_id
country.id
Restrict delete
FK_D34A04ADD8D4EAFA
product.productIndex_id
productindex.id
Restrict delete
FK_D34A04AD727ACA70
product.parent_id
product.id
Restrict delete
FK_D34A04ADF603EE73
product.vendor_id
vendor.id
Restrict delete
FK_D34A04AD6BF700BD
product.status_id
entitystatus.id
Restrict delete
FK_D34A04AD6CF8BF97
product.mainClient_id
client.id
Restrict delete
FK_52F9D69DA76ED395
warehouse_user.user_id
users.id
Cascade on delete
FK_52F9D69D5080ECDE
warehouse_user.warehouse_id
warehouse.id
Cascade on delete
FK_C2048CB2C7C2CBA
workflow_crossclient.workflow_id
workflow.id
Cascade on delete
FK_C2048CB19EB6921
workflow_crossclient.client_id
client.id
Cascade on delete
FK_FA7AEFFB6CF8BF97
attribute.mainClient_id
client.id
Restrict delete
FK_ABB46910CFD6A7B3
shippingcost_saleschannel.shippingcost_id
shippingcost.id
Cascade on delete
FK_ABB4691032758FE
shippingcost_saleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_A56C54B6A76ED395
contact_user.user_id
users.id
Cascade on delete
FK_A56C54B6E7A1254A
contact_user.contact_id
contact.id
Cascade on delete
FK_BBF9AE31D2112630
customformgridaction_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_BBF9AE318892F2EF
customformgridaction_usergroup.customformgridaction_id
customformgridaction.id
Cascade on delete
FK_1E2AC9CED2112630
customform_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_1E2AC9CE9268A8FA
customform_usergroup.customform_id
customform.id
Cascade on delete
FK_B203B10D19EB6921
ebaycloseofferjob.client_id
client.id
Restrict delete
FK_7799189519EB6921
invoiceledger.client_id
client.id
Restrict delete
FK_CC27523ED53E5409
productlicense.directProduct_id
product.id
Restrict delete
FK_CC27523E6167798F
productlicense.directCustomer_id
customer.id
Restrict delete
FK_CC27523EFDB4FBE0
productlicense.offerItem_id
offeritem.id
Restrict delete
FK_CC27523E661C24D9
productlicense.subscriptionContractItem_id
subscriptioncontractitem.id
Restrict delete
FK_77C5FFB98D9F6D38
realinvoicejob.order_id
orders.id
Restrict delete
FK_77C5FFB919EB6921
realinvoicejob.client_id
client.id
Restrict delete
FK_72A6FD7D19EB6921
orderstatus.client_id
client.id
Restrict delete
FK_800B0581E825CECD
csvimportvariationfield.csvimport_id
csvimport.id
Restrict delete
FK_9AA3576E12469DE2
shipping_category.category_id
category.id
Cascade on delete
FK_9AA3576E4887F3F8
shipping_category.shipping_id
shipping.id
Cascade on delete
FK_A904286A19EB6921
discount_client.client_id
client.id
Cascade on delete
FK_A904286A4C7C611F
discount_client.discount_id
discount.id
Cascade on delete
FK_BA672C4419EB6921
voucherserie_client.client_id
client.id
Cascade on delete
FK_BA672C446EC643C7
voucherserie_client.voucherserie_id
voucherserie.id
Cascade on delete
FK_587532392C7C2CBA
workflowcondition.workflow_id
workflow.id
Restrict delete
FK_1D7A00254BD2A4C0
offer_report.report_id
report.id
Cascade on delete
FK_1D7A002553C674EE
offer_report.offer_id
offer.id
Cascade on delete
FK_1CEBABC9202D1EB2
commissionitem.commission_id
commission.id
Restrict delete
FK_1CEBABC94584665A
commissionitem.product_id
product.id
Restrict delete
FK_AC10413D4C3A3BB
payment_user.payment_id
payment.id
Cascade on delete
FK_AC10413DA76ED395
payment_user.user_id
users.id
Cascade on delete
FK_7970C6A0699281C2
customformfield_customergroup.customformfield_id
customformfield.id
Cascade on delete
FK_7970C6A096C19C84
customformfield_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_A393D2FBF92F3E70
state.country_id
country.id
Restrict delete
FK_999B026229A16EF5
storebanner.showInCategory_id
category.id
Restrict delete
FK_999B0262B092A811
storebanner.store_id
store.id
Restrict delete
FK_999B02624584665A
storebanner.product_id
product.id
Restrict delete
FK_999B026284A0A3ED
storebanner.content_id
content.id
Restrict delete
FK_999B026212469DE2
storebanner.category_id
category.id
Restrict delete
FK_E5086F87A76ED395
workflowactionjob.user_id
users.id
Restrict delete
FK_E5086F87FE85FD10
workflowactionjob.workflowEvent_id
workflowevent.id
Restrict delete
FK_E5086F8719EB6921
workflowactionjob.client_id
client.id
Restrict delete
FK_667C1F1496C19C84
customformgridaction_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_667C1F148892F2EF
customformgridaction_customergroup.customformgridaction_id
customformgridaction.id
Cascade on delete
FK_B6B7F54BD0408A71
liabilitypaymentfield.paymentField_id
paymentfield.id
Restrict delete
FK_B6B7F54B1E88FF9F
liabilitypaymentfield.liability_id
liability.id
Restrict delete
FK_5BB81664A76ED395
printjob.user_id
users.id
Restrict delete
FK_5BB8166419EB6921
printjob.client_id
client.id
Restrict delete
FK_5BB8166434956C29
printjob.completedByUser_id
users.id
Restrict delete
FK_75EAABD59395C3F3
customer_report.customer_id
customer.id
Cascade on delete
FK_75EAABD54BD2A4C0
customer_report.report_id
report.id
Cascade on delete
FK_CD8CF1E4584665A
product_crosssellingproduct.product_id
product.id
Restrict delete
FK_CD8CF1E64D61E3B
product_crosssellingproduct.crossselling_id
product.id
Restrict delete
FK_D64B810819EB6921
reportjob.client_id
client.id
Restrict delete
FK_D64B81084BD2A4C0
reportjob.report_id
report.id
Restrict delete
FK_764879078D9F6D38
orderinternalcomment.order_id
orders.id
Restrict delete
FK_76487907A76ED395
orderinternalcomment.user_id
users.id
Restrict delete
FK_67A8141312469DE2
category_excludedsaleschannel.category_id
category.id
Cascade on delete
FK_67A8141332758FE
category_excludedsaleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_20E02005E7A1254A
contact_excludeduser.contact_id
contact.id
Cascade on delete
FK_20E02005A76ED395
contact_excludeduser.user_id
users.id
Cascade on delete
FK_62D10A3753C674EE
internetmarke.offer_id
offer.id
Restrict delete
FK_EBC38404CFD6A7B3
shippingcost_customergroup.shippingcost_id
shippingcost.id
Cascade on delete
FK_EBC3840496C19C84
shippingcost_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_2A50DE994584665A
product_discount.product_id
product.id
Cascade on delete
FK_2A50DE994C7C611F
product_discount.discount_id
discount.id
Cascade on delete
FK_A452DE7CFDB4FBE0
realstornojob.offerItem_id
offeritem.id
Restrict delete
FK_A452DE7C19EB6921
realstornojob.client_id
client.id
Restrict delete
FK_D3C41810202D1EB2
commissionupload.commission_id
commission.id
Restrict delete
FK_98B2EE069395C3F3
customersession.customer_id
customer.id
Restrict delete
FK_98B2EE06B092A811
customersession.store_id
store.id
Restrict delete
FK_494DDEA9395C3F3
customercontact.customer_id
customer.id
Restrict delete
FK_F6F1902A19EB6921
warehouse_excludedclient.client_id
client.id
Cascade on delete
FK_F6F1902A5080ECDE
warehouse_excludedclient.warehouse_id
warehouse.id
Cascade on delete
FK_346C866396C19C84
customformaction_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_346C8663231445A3
customformaction_customergroup.customformaction_id
customformaction.id
Cascade on delete
FK_6BF14E868D9F6D38
commissioncontract_order.order_id
orders.id
Restrict delete
FK_6BF14E863529572D
commissioncontract_order.commissioncontract_id
commissioncontract.id
Restrict delete
FK_3E0BC42E67049442
accountbooking.cashReportItem_id
cashreportitem.id
Restrict delete
FK_3E0BC42E8D9F6D38
accountbooking.order_id
orders.id
Restrict delete
FK_3E0BC42E7EED73BC
accountbooking.accountSystemItemGegenkonto_id
accountsystemitem.id
Restrict delete
FK_3E0BC42E1E88FF9F
accountbooking.liability_id
liability.id
Restrict delete
FK_3E0BC42E19EB6921
accountbooking.client_id
client.id
Restrict delete
FK_3E0BC42EDED0E51A
accountbooking.accountSystemItemKonto_id
accountsystemitem.id
Restrict delete
FK_3E0BC42E4584665A
accountbooking.product_id
product.id
Restrict delete
FK_3E0BC42E856092CE
accountbooking.cashReport_id
cashreport.id
Restrict delete
FK_D7145B5A19EB6921
languagemetafield.client_id
client.id
Restrict delete
FK_D7145B5A443707B0
languagemetafield.field_id
clientsheme.id
Restrict delete
FK_D7145B5A82F1BAF4
languagemetafield.language_id
language.id
Restrict delete
FK_BB44B0494584665A
shippingcost_excludedproduct.product_id
product.id
Cascade on delete
FK_BB44B049CFD6A7B3
shippingcost_excludedproduct.shippingcost_id
shippingcost.id
Cascade on delete
FK_604D60518B98976A
customformgrid_crossclient.customformgrid_id
customformgrid.id
Cascade on delete
FK_604D605119EB6921
customformgrid_crossclient.client_id
client.id
Cascade on delete
FK_428C169419EB6921
export.client_id
client.id
Restrict delete
FK_3F6A51BB19EB6921
amazontransaction.client_id
client.id
Restrict delete
FK_3F6A51BB8D9F6D38
amazontransaction.order_id
orders.id
Restrict delete
FK_54CF73FF19EB6921
ebaystockjob.client_id
client.id
Restrict delete
FK_54CF73FF4584665A
ebaystockjob.product_id
product.id
Restrict delete
FK_A9A3972BC20714FB
reportrow.parentRow_id
reportrow.id
Restrict delete
FK_A9A3972B4BD2A4C0
reportrow.report_id
report.id
Restrict delete
FK_9D01FE74C045B03B
productoptionmaterialquantity.productOption_id
productoption.id
Restrict delete
FK_9D01FE744584665A
productoptionmaterialquantity.product_id
product.id
Restrict delete
FK_44C10AEB4584665A
productaccessory.product_id
product.id
Restrict delete
FK_44C10AEB4ADCDE3
productaccessory.accessoryProduct_id
product.id
Restrict delete
FK_4490746C12469DE2
payment_excludedcategory.category_id
category.id
Cascade on delete
FK_4490746C4C3A3BB
payment_excludedcategory.payment_id
payment.id
Cascade on delete
FK_7A067518D9F6D38
order_report.order_id
orders.id
Cascade on delete
FK_7A067514BD2A4C0
order_report.report_id
report.id
Cascade on delete
FK_DAC2B5EE825CECD
csvimportkeyfield.csvimport_id
csvimport.id
Restrict delete
FK_C16A710E4F0E27B8
productmediametafield.productmedia_id
productmedia.id
Restrict delete
FK_C16A710E19EB6921
productmediametafield.client_id
client.id
Restrict delete
FK_C16A710E443707B0
productmediametafield.field_id
clientsheme.id
Restrict delete
FK_4B482AD953C674EE
ups.offer_id
offer.id
Restrict delete
FK_81398E0982F1BAF4
customer.language_id
language.id
Restrict delete
FK_81398E095DB44BDB
customer.activeOffer_id
offer.id
Restrict delete
FK_81398E094887F3F8
customer.shipping_id
shipping.id
Restrict delete
FK_81398E0943237701
customer.costCenter_id
costcenter.id
Restrict delete
FK_81398E096D395A0F
customer.activeOffer3_id
offer.id
Restrict delete
FK_81398E096614251F
customer.defaultAddress_id
address.id
Restrict delete
FK_81398E0919EB6921
customer.client_id
client.id
Restrict delete
FK_81398E098F9ECCC2
customer.invoiceCustomer_id
customer.id
Restrict delete
FK_81398E094C3A3BB
customer.payment_id
payment.id
Restrict delete
FK_81398E09D5853D6A
customer.activeOffer2_id
offer.id
Restrict delete
FK_81398E095D83CC1
customer.state_id
state.id
Restrict delete
FK_81398E095DDE42F7
customer.creditorPayment_id
payment.id
Restrict delete
FK_81398E0941CD9E7A
customer.employer_id
customer.id
Restrict delete
FK_81398E09F92F3E70
customer.country_id
country.id
Restrict delete
FK_F8CCACC7D0408A71
offerpaymentfield.paymentField_id
paymentfield.id
Restrict delete
FK_F8CCACC753C674EE
offerpaymentfield.offer_id
offer.id
Restrict delete
FK_B4F596C1E825CECD
csvrow.csvimport_id
csvimport.id
Restrict delete
FK_7D2900345FFE0628
cashreport.ecReport_id
ecreport.id
Restrict delete
FK_7D290034A76ED395
cashreport.user_id
users.id
Restrict delete
FK_7D2900343B0ABC10
cashreport.publicKeyObject_id
publickey.id
Restrict delete
FK_7D2900345C3545B8
cashreport.banknoteCountProtocol_id
banknotecountprotocol.id
Restrict delete
FK_7D29003479443B8A
cashreport.voucherReport_id
voucherreport.id
Restrict delete
FK_7D290034A0F81733
cashreport.cashJournal_id
cashjournal.id
Restrict delete
FK_23E5C85C4C7C611F
customergroup_discount.discount_id
discount.id
Cascade on delete
FK_23E5C85C96C19C84
customergroup_discount.customergroup_id
customergroup.id
Cascade on delete
FK_B25A1FF4C23403F2
customform.builtInGrid_id
customformgrid.id
Restrict delete
FK_B25A1FF419EB6921
customform.client_id
client.id
Restrict delete
FK_E3ED04063D65BE63
retailstore_crossclient.retailstore_id
retailstore.id
Cascade on delete
FK_E3ED040619EB6921
retailstore_crossclient.client_id
client.id
Cascade on delete
FK_6762B9FE231445A3
customformaction_user.customformaction_id
customformaction.id
Cascade on delete
FK_6762B9FEA76ED395
customformaction_user.user_id
users.id
Cascade on delete
FK_D4DB71B519EB6921
language.client_id
client.id
Restrict delete
FK_FC6BD52CA4D9DA71
warehousebooking.parentLocation_id
warehousestoragelocation.id
Restrict delete
FK_FC6BD52CA907283B
warehousebooking.serialNumber_id
productserialnumber.id
Restrict delete
FK_FC6BD52C4584665A
warehousebooking.product_id
product.id
Restrict delete
FK_FC6BD52C64D218E
warehousebooking.location_id
warehousestoragelocation.id
Restrict delete
FK_FC6BD52C1645DEA9
warehousebooking.reference_id
vendororderdelivery.id
Restrict delete
FK_FC6BD52CA76ED395
warehousebooking.user_id
users.id
Restrict delete
FK_FC6BD52C2B7E3CCC
warehousebooking.bookedInClient_id
client.id
Restrict delete
FK_D52277D153C674EE
fedex.offer_id
offer.id
Restrict delete
FK_6AD9A6B919EB6921
offeritemmetafield.client_id
client.id
Restrict delete
FK_6AD9A6B9443707B0
offeritemmetafield.field_id
clientsheme.id
Restrict delete
FK_6AD9A6B93209C27C
offeritemmetafield.offeritem_id
offeritem.id
Restrict delete
FK_9B13321BF92F3E70
categorycountrytax.country_id
country.id
Restrict delete
FK_9B13321BB2A824D8
categorycountrytax.tax_id
tax.id
Restrict delete
FK_9B13321B12469DE2
categorycountrytax.category_id
category.id
Restrict delete
FK_B934F647BA98F845
orderpickingitem.orderPicking_id
orderpicking.id
Restrict delete
FK_B934F647FDB4FBE0
orderpickingitem.offerItem_id
offeritem.id
Restrict delete
FK_B934F6477FDBDE77
orderpickingitem.materialProduct_id
product.id
Restrict delete
FK_B934F647A907283B
orderpickingitem.serialNumber_id
productserialnumber.id
Restrict delete
FK_2CA540056EC643C7
category_voucherserie.voucherserie_id
voucherserie.id
Cascade on delete
FK_2CA5400512469DE2
category_voucherserie.category_id
category.id
Cascade on delete
FK_4C25296AA76ED395
usersession.user_id
users.id
Restrict delete
FK_A53845F119EB6921
product_client.client_id
client.id
Cascade on delete
FK_A53845F14584665A
product_client.product_id
product.id
Cascade on delete
FK_53B07FB89395C3F3
customerupload.customer_id
customer.id
Restrict delete
FK_5CB3E4BC4584665A
vendorproduct.product_id
product.id
Restrict delete
FK_5CB3E4BCF603EE73
vendorproduct.vendor_id
vendor.id
Restrict delete
FK_4D9803DEE7A0B42A
liability_vendororder.vendororder_id
vendororder.id
Cascade on delete
FK_4D9803DE1E88FF9F
liability_vendororder.liability_id
liability.id
Cascade on delete
FK_38FA41144584665A
product_option.product_id
product.id
Restrict delete
FK_38FA4114A7C41D6F
product_option.option_id
productoption.id
Restrict delete
FK_94AC664919EB6921
contentemailattachment_client.client_id
client.id
Cascade on delete
FK_94AC664994827BD0
contentemailattachment_client.contentemailattachment_id
contentemailattachment.id
Cascade on delete
FK_B631308C64D218E
picklistitem.location_id
warehousestoragelocation.id
Restrict delete
FK_B631308CA907283B
picklistitem.serialNumber_id
productserialnumber.id
Restrict delete
FK_B631308C3F473D40
picklistitem.pickList_id
picklist.id
Restrict delete
FK_B631308C4584665A
picklistitem.product_id
product.id
Restrict delete
FK_FABA25AE5080ECDE
retailstore_warehouse.warehouse_id
warehouse.id
Cascade on delete
FK_FABA25AE3D65BE63
retailstore_warehouse.retailstore_id
retailstore.id
Cascade on delete
FK_D57F665953C674EE
dpd.offer_id
offer.id
Restrict delete
FK_1483A5E95DBC5E14
users.wawilistener_id
wawilistener.id
Restrict delete
FK_1483A5E9A6DCF3A5
users.wawilistenerUser_id
users.id
Restrict delete
FK_963F47F28B98976A
customformgrid_usercanaddcolumns.customformgrid_id
customformgrid.id
Cascade on delete
FK_963F47F2A76ED395
customformgrid_usercanaddcolumns.user_id
users.id
Cascade on delete
FK_635305834C3A3BB
payment_excludedcustomergroup.payment_id
payment.id
Cascade on delete
FK_6353058396C19C84
payment_excludedcustomergroup.customergroup_id
customergroup.id
Cascade on delete
FK_7E455D7C4584665A
offeritem.product_id
product.id
Restrict delete
FK_7E455D7CF603EE73
offeritem.vendor_id
vendor.id
Restrict delete
FK_7E455D7C968D9E05
offeritem.commissionLiabilityItem_id
liabilityitem.id
Restrict delete
FK_7E455D7C72AE74BD
offeritem.vendorOrderItem_id
vendororderitem.id
Restrict delete
FK_7E455D7CAC08CBC
offeritem.commissionContractReturn_id
commissioncontract.id
Restrict delete
FK_7E455D7CC15851FE
offeritem.materialOfferItemSplittedFrom_id
offeritem.id
Restrict delete
FK_7E455D7C53C674EE
offeritem.offer_id
offer.id
Restrict delete
FK_7E455D7C5080ECDE
offeritem.warehouse_id
warehouse.id
Restrict delete
FK_7E455D7C6983B0D6
offeritem.accessoryVoucher_id
voucher.id
Restrict delete
FK_7E455D7C8002373D
offeritem.marketplaceCustomer_id
customer.id
Restrict delete
FK_7E455D7C56B55761
offeritem.commissionContractItem_id
commissioncontractitem.id
Restrict delete
FK_7E455D7CA98CC7A7
offeritem.exchangedOfferItem_id
offeritem.id
Restrict delete
FK_7E455D7C661C24D9
offeritem.subscriptionContractItem_id
subscriptioncontractitem.id
Restrict delete
FK_7E455D7C5DC0B8C2
offeritem.partialOffer_id
offer.id
Restrict delete
FK_3498D9F553C674EE
arriva.offer_id
offer.id
Restrict delete
FK_878DAF37699281C2
customformfield_user.customformfield_id
customformfield.id
Cascade on delete
FK_878DAF37A76ED395
customformfield_user.user_id
users.id
Cascade on delete
FK_75BCEB05E825CECD
csvimportjob.csvimport_id
csvimport.id
Restrict delete
FK_75BCEB0519EB6921
csvimportjob.client_id
client.id
Restrict delete
FK_8D94E9AE4584665A
productpicture.product_id
product.id
Restrict delete
FK_786F01CB8D9F6D38
picklistreservation_orders.order_id
orders.id
Cascade on delete
FK_786F01CB21BE202E
picklistreservation_orders.picklistreservation_id
picklistreservation.id
Cascade on delete
FK_59D5B0CF96C19C84
discountaccessory_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_59D5B0CF3B248ABE
discountaccessory_customergroup.discountaccessory_id
discountaccessory.id
Cascade on delete
FK_64C19C1727ACA70
category.parent_id
category.id
Restrict delete
FK_64C19C1649AB165
category.additionalParent_id
category.id
Restrict delete
FK_64C19C1B2A824D8
category.tax_id
tax.id
Restrict delete
FK_64C19C16CF8BF97
category.mainClient_id
client.id
Restrict delete
FK_9FF5969012469DE2
shipping_excludedcategory.category_id
category.id
Cascade on delete
FK_9FF596904887F3F8
shipping_excludedcategory.shipping_id
shipping.id
Cascade on delete
FK_997099644C3A3BB
payment_customergroup.payment_id
payment.id
Cascade on delete
FK_9970996496C19C84
payment_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_D176C3EB19EB6921
webshopexportjob.client_id
client.id
Restrict delete
FK_3190FB019EB6921
webshopimportjob.client_id
client.id
Restrict delete
FK_47F2B9CFCFD6A7B3
shippingcost_product.shippingcost_id
shippingcost.id
Cascade on delete
FK_47F2B9CF4584665A
shippingcost_product.product_id
product.id
Cascade on delete
FK_B6920A349268A8FA
customform_crossclient.customform_id
customform.id
Cascade on delete
FK_B6920A3419EB6921
customform_crossclient.client_id
client.id
Cascade on delete
FK_AE6EEF4519EB6921
shirtnetworkproduct.client_id
client.id
Restrict delete
FK_AE6EEF45FDB4FBE0
shirtnetworkproduct.offerItem_id
offeritem.id
Restrict delete
FK_4E01621B12469DE2
shippingpackage_excludedcategory.category_id
category.id
Cascade on delete
FK_4E01621BFF255BD5
shippingpackage_excludedcategory.shippingpackage_id
shippingpackage.id
Cascade on delete
FK_C7440455F92F3E70
client.country_id
country.id
Restrict delete
FK_C744045546A0AD0
client.accountSystem_id
accountsystem.id
Restrict delete
FK_C744045595D0AABA
client.defaultCurrency_id
currency.id
Restrict delete
FK_1C65015819EB6921
commission.client_id
client.id
Restrict delete
FK_1C6501589395C3F3
commission.customer_id
customer.id
Restrict delete
FK_5B3BE760A76ED395
usermetafield.user_id
users.id
Restrict delete
FK_5B3BE76019EB6921
usermetafield.client_id
client.id
Restrict delete
FK_5B3BE760443707B0
usermetafield.field_id
clientsheme.id
Restrict delete
FK_71E29770956500CC
productoption.baseMaterial_id
product.id
Restrict delete
FK_71E297706CF8BF97
productoption.mainClient_id
client.id
Restrict delete
FK_5945883E9395C3F3
customer_crossclient.customer_id
customer.id
Cascade on delete
FK_5945883E19EB6921
customer_crossclient.client_id
client.id
Cascade on delete
FK_8C25323419EB6921
ottotask.client_id
client.id
Restrict delete
FK_887C52DD443707B0
countrymetafield.field_id
clientsheme.id
Restrict delete
FK_887C52DD19EB6921
countrymetafield.client_id
client.id
Restrict delete
FK_887C52DDF92F3E70
countrymetafield.country_id
country.id
Restrict delete
FK_1587CE8DA76ED395
customformgrid_user.user_id
users.id
Cascade on delete
FK_1587CE8D8B98976A
customformgrid_user.customformgrid_id
customformgrid.id
Cascade on delete
FK_6394EFAE4887F3F8
shipping_excludedproduct.shipping_id
shipping.id
Cascade on delete
FK_6394EFAE4584665A
shipping_excludedproduct.product_id
product.id
Cascade on delete
FK_253ACC46B3B5D8FA
commissioncontractpaymentfield.commissionContract_id
commissioncontract.id
Restrict delete
FK_253ACC46D0408A71
commissioncontractpaymentfield.paymentField_id
paymentfield.id
Restrict delete
FK_C1EF9CB219EB6921
productstatistics.client_id
client.id
Restrict delete
FK_C1EF9CB24584665A
productstatistics.product_id
product.id
Restrict delete
FK_7BD39786FDB4FBE0
offeritemoptionfield.offerItem_id
offeritem.id
Restrict delete
FK_7BD397866924B7EA
offeritemoptionfield.productOptionField_id
productoptionfield.id
Restrict delete
FK_62A9ED4F8A52B89A
liability_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_62A9ED4F1E88FF9F
liability_objectgroup.liability_id
liability.id
Cascade on delete
FK_4D60A4C19395C3F3
storesession.customer_id
customer.id
Restrict delete
FK_4D60A4C1B092A811
storesession.store_id
store.id
Restrict delete
FK_1B1C129EE7A1254A
contact_customer.contact_id
contact.id
Cascade on delete
FK_1B1C129E9395C3F3
contact_customer.customer_id
customer.id
Cascade on delete
FK_685BD0A8A76ED395
entitylog.user_id
users.id
Restrict delete
FK_E52FFDEE5FFE0628
orders.ecReport_id
ecreport.id
Restrict delete
FK_E52FFDEEC8CACDD9
orders.agentLiability_id
liability.id
Restrict delete
FK_E52FFDEE4C7A5B2E
orders.salesChannel_id
saleschannel.id
Restrict delete
FK_E52FFDEE5080ECDE
orders.warehouse_id
warehouse.id
Restrict delete
FK_E52FFDEEB9BA2274
orders.orderBuyingList_id
orderbuyinglist.id
Restrict delete
FK_E52FFDEE19EB6921
orders.client_id
client.id
Restrict delete
FK_E52FFDEE3F473D40
orders.pickList_id
picklist.id
Restrict delete
FK_E52FFDEE576EF81E
orders.expedition_id
expedition.id
Restrict delete
FK_E52FFDEE4BE3C43E
orders.posTerminal_id
posterminal.id
Restrict delete
FK_E52FFDEE856092CE
orders.cashReport_id
cashreport.id
Restrict delete
FK_E52FFDEE79443B8A
orders.voucherReport_id
voucherreport.id
Restrict delete
FK_E52FFDEE1BC170BA
orders.parentShippingOrder_id
orders.id
Restrict delete
FK_E52FFDEE72E99A55
orders.parentOrder_id
orders.id
Restrict delete
FK_E52FFDEE53C674EE
orders.offer_id
offer.id
Restrict delete
FK_E52FFDEE5A494F36
orders.splittedFromOrder_id
orders.id
Restrict delete
FK_E52FFDEE17458494
orders.stornoPublicKeyObject_id
publickey.id
Restrict delete
FK_E52FFDEE43237701
orders.costCenter_id
costcenter.id
Restrict delete
FK_E52FFDEED95C1FC6
orders.clerk_id
users.id
Restrict delete
FK_E52FFDEE3B0ABC10
orders.publicKeyObject_id
publickey.id
Restrict delete
FK_3D86084FF92F3E70
payment_excludedcountry.country_id
country.id
Cascade on delete
FK_3D86084F4C3A3BB
payment_excludedcountry.payment_id
payment.id
Cascade on delete
FK_34122FF419EB6921
commissioncontract.client_id
client.id
Restrict delete
FK_34122FF44C3A3BB
commissioncontract.payment_id
payment.id
Restrict delete
FK_34122FF46BF700BD
commissioncontract.status_id
entitystatus.id
Restrict delete
FK_34122FF466C42665
commissioncontract.returnShipping_id
shipping.id
Restrict delete
FK_34122FF47B3B27A4
commissioncontract.contractGroup_id
contractgroup.id
Restrict delete
FK_34122FF49395C3F3
commissioncontract.customer_id
customer.id
Restrict delete
FK_2CCAAE63A76ED395
warehouse_excludeduser.user_id
users.id
Cascade on delete
FK_2CCAAE635080ECDE
warehouse_excludeduser.warehouse_id
warehouse.id
Cascade on delete
FK_CBC7BDFF12469DE2
category_report.category_id
category.id
Cascade on delete
FK_CBC7BDFF4BD2A4C0
category_report.report_id
report.id
Cascade on delete
FK_ECB38BFC5FD7F972
warehouse.defaultInClient_id
client.id
Restrict delete
FK_ECB38BFC4F311658
warehouse.dimensions_id
warehousedimensions.id
Restrict delete
FK_ECB38BFCF92F3E70
warehouse.country_id
country.id
Restrict delete
FK_D25954CA12469DE2
product_cachedrootcategory.category_id
category.id
Cascade on delete
FK_D25954CA4584665A
product_cachedrootcategory.product_id
product.id
Cascade on delete
FK_69AD90FFB092A811
store_disabledwidgets.store_id
store.id
Cascade on delete
FK_69AD90FFEB5FBF78
store_disabledwidgets.storewidget_id
storewidget.id
Cascade on delete
FK_CD25F7214C7C611F
customer_discount.discount_id
discount.id
Cascade on delete
FK_CD25F7219395C3F3
customer_discount.customer_id
customer.id
Cascade on delete
FK_A1433114CFD6A7B3
shippingcost_excludedcategory.shippingcost_id
shippingcost.id
Cascade on delete
FK_A143311412469DE2
shippingcost_excludedcategory.category_id
category.id
Cascade on delete
FK_E7255A611ED6D67C
vendororderupload.vendorOrder_id
vendororder.id
Restrict delete
FK_3E6861D464D218E
warehousebox.location_id
warehousestoragelocation.id
Restrict delete
FK_35DD79DB3B5D8FA
commissioncontractupload.commissionContract_id
commissioncontract.id
Restrict delete
FK_7AAFB5E296C19C84
category_customergroup.customergroup_id
customergroup.id
Restrict delete
FK_7AAFB5E212469DE2
category_customergroup.category_id
category.id
Restrict delete
FK_528A8C394C3A3BB
orderrefund.payment_id
payment.id
Restrict delete
FK_528A8C398D9F6D38
orderrefund.order_id
orders.id
Restrict delete
FK_D4E6F81F92F3E70
address.country_id
country.id
Restrict delete
FK_D4E6F815D83CC1
address.state_id
state.id
Restrict delete
FK_D4E6F819395C3F3
address.customer_id
customer.id
Restrict delete
FK_E91D96B56EC643C7
voucherserieaccessory.voucherserie_id
voucherserie.id
Restrict delete
FK_E91D96B54ADCDE3
voucherserieaccessory.accessoryProduct_id
product.id
Restrict delete
FK_2ADCCCC11CD1765A
usermessage.fromUser_id
users.id
Restrict delete
FK_2ADCCCC11A8D0551
usermessage.messageChannel_id
usermessagechannel.id
Restrict delete
FK_2ADCCCC1A763F1AE
usermessage.forUser_id
users.id
Restrict delete
FK_B6D653D24584665A
product_objectpool.product_id
product.id
Cascade on delete
FK_B6D653D2CC87415C
product_objectpool.objectpool_id
objectpool.id
Cascade on delete
FK_7525C50753C674EE
amazonprime.offer_id
offer.id
Restrict delete
FK_8BDE557319EB6921
currencymetafield.client_id
client.id
Restrict delete
FK_8BDE5573443707B0
currencymetafield.field_id
clientsheme.id
Restrict delete
FK_8BDE557338248176
currencymetafield.currency_id
currency.id
Restrict delete
FK_66A50891F603EE73
vendormetafield.vendor_id
vendor.id
Restrict delete
FK_66A50891443707B0
vendormetafield.field_id
clientsheme.id
Restrict delete
FK_66A5089119EB6921
vendormetafield.client_id
client.id
Restrict delete
FK_B18E03C719EB6921
vendor_client.client_id
client.id
Cascade on delete
FK_B18E03C7F603EE73
vendor_client.vendor_id
vendor.id
Cascade on delete
FK_BF6984C2B092A811
storefeedback.store_id
store.id
Restrict delete
FK_BF6984C29395C3F3
storefeedback.customer_id
customer.id
Restrict delete
FK_65DAAFCAE76E9C94
vendorordersubmissionitemdelivery.orderItem_id
vendororderitem.id
Restrict delete
FK_65DAAFCA4584665A
vendorordersubmissionitemdelivery.product_id
product.id
Restrict delete
FK_65DAAFCADADBCE91
vendorordersubmissionitemdelivery.relocatedLocation_id
warehousestoragelocation.id
Restrict delete
FK_65DAAFCA64D218E
vendorordersubmissionitemdelivery.location_id
warehousestoragelocation.id
Restrict delete
FK_65DAAFCAF603EE73
vendorordersubmissionitemdelivery.vendor_id
vendor.id
Restrict delete
FK_65DAAFCA12136921
vendorordersubmissionitemdelivery.delivery_id
vendororderdelivery.id
Restrict delete
FK_3F7547B17EA26E76
klarnatransaction.purchaseCountry_id
country.id
Restrict delete
FK_3F7547B1BD1BCD8A
klarnatransaction.shippingCountry_id
country.id
Restrict delete
FK_3F7547B119EB6921
klarnatransaction.client_id
client.id
Restrict delete
FK_3F7547B18D9F6D38
klarnatransaction.order_id
orders.id
Restrict delete
FK_312830A496C19C84
customergroup_objectgroup.customergroup_id
customergroup.id
Cascade on delete
FK_312830A48A52B89A
customergroup_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_A7D3275E19EB6921
csvexportjob.client_id
client.id
Restrict delete
FK_A7D3275E3A4A0296
csvexportjob.csvexport_id
csvexport.id
Restrict delete
FK_1FD18672244DF37
subscriptioncontractupload.subscriptionContract_id
subscriptioncontract.id
Restrict delete
FK_CD41AC0F8D9F6D38
payonetransaction.order_id
orders.id
Restrict delete
FK_CD41AC0F19EB6921
payonetransaction.client_id
client.id
Restrict delete
FK_32D356A64584665A
productcountrytax.product_id
product.id
Restrict delete
FK_32D356A6B2A824D8
productcountrytax.tax_id
tax.id
Restrict delete
FK_32D356A6F92F3E70
productcountrytax.country_id
country.id
Restrict delete
FK_6D358D4482F1BAF4
csvimportfield.language_id
language.id
Restrict delete
FK_6D358D44E825CECD
csvimportfield.csvimport_id
csvimport.id
Restrict delete
FK_219B8F6E4887F3F8
shipping_objectgroup.shipping_id
shipping.id
Cascade on delete
FK_219B8F6E8A52B89A
shipping_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_580D120FB092A811
store_fullpagecachingcontent.store_id
store.id
Cascade on delete
FK_580D120F84A0A3ED
store_fullpagecachingcontent.content_id
content.id
Cascade on delete
FK_989E9F449395C3F3
productcustomercondition.customer_id
customer.id
Restrict delete
FK_989E9F444584665A
productcustomercondition.product_id
product.id
Restrict delete
FK_8A4CDD1DCD7F4BE9
posterminal_user.posterminal_id
posterminal.id
Cascade on delete
FK_8A4CDD1DA76ED395
posterminal_user.user_id
users.id
Cascade on delete
FK_A0F3ECF2D2112630
customformgrid_usergroupcanremoveitems.usergroup_id
usergroup.id
Cascade on delete
FK_A0F3ECF28B98976A
customformgrid_usergroupcanremoveitems.customformgrid_id
customformgrid.id
Cascade on delete
FK_F3BF44B4584665A
productcomment.product_id
product.id
Restrict delete
FK_F3BF44BA76ED395
productcomment.user_id
users.id
Restrict delete
FK_4EBC158A76ED395
user_objectgroup.user_id
users.id
Cascade on delete
FK_4EBC1588A52B89A
user_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_867F4E7632758FE
saleschannel_warehouse.saleschannel_id
saleschannel.id
Cascade on delete
FK_867F4E765080ECDE
saleschannel_warehouse.warehouse_id
warehouse.id
Cascade on delete
FK_F2D91A2F8D9F6D38
order_pickingwarehouse.order_id
orders.id
Cascade on delete
FK_F2D91A2F5080ECDE
order_pickingwarehouse.warehouse_id
warehouse.id
Cascade on delete
FK_146157614CCC0310
product_storagelocations.warehousestoragelocation_id
warehousestoragelocation.id
Cascade on delete
FK_146157614584665A
product_storagelocations.product_id
product.id
Cascade on delete
FK_AAFD8A42CFD6A7B3
shippingcost_excludedcustomergroup.shippingcost_id
shippingcost.id
Cascade on delete
FK_AAFD8A4296C19C84
shippingcost_excludedcustomergroup.customergroup_id
customergroup.id
Cascade on delete
FK_6EAB345E8892F2EF
customformgridaction_user.customformgridaction_id
customformgridaction.id
Cascade on delete
FK_6EAB345EA76ED395
customformgridaction_user.user_id
users.id
Cascade on delete
FK_2DEDF87419EB6921
client_orderdocument.client_id
client.id
Restrict delete
FK_2DEDF874C33F7837
client_orderdocument.document_id
document.id
Restrict delete
FK_6F99AF3919EB6921
realjob.client_id
client.id
Restrict delete
FK_DDF66F0E4C3A3BB
shipping_excludedpayment.payment_id
payment.id
Cascade on delete
FK_DDF66F0E4887F3F8
shipping_excludedpayment.shipping_id
shipping.id
Cascade on delete
FK_1BBA8CA7B6E62EFA
attributevalue.attribute_id
attribute.id
Restrict delete
FK_1BBA8CA74584665A
attributevalue.product_id
product.id
Restrict delete
FK_F6E6AF5FD2112630
customformfield_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_F6E6AF5F699281C2
customformfield_usergroup.customformfield_id
customformfield.id
Cascade on delete
FK_27C8C5B49268A8FA
customform_usergroupcansave.customform_id
customform.id
Cascade on delete
FK_27C8C5B4D2112630
customform_usergroupcansave.usergroup_id
usergroup.id
Cascade on delete
FK_E952138C8D9F6D38
invoiceledgeritem.order_id
orders.id
Restrict delete
FK_E952138C14A08E46
invoiceledgeritem.invoiceLedger_id
invoiceledger.id
Restrict delete
FK_E952138C4C3A3BB
invoiceledgeritem.payment_id
payment.id
Restrict delete
FK_E952138C9395C3F3
invoiceledgeritem.customer_id
customer.id
Restrict delete
FK_5565DBF419EB6921
customformgrid.client_id
client.id
Restrict delete
FK_5565DBF45FF69B7D
customformgrid.form_id
customform.id
Restrict delete
FK_1364CE6BF92F3E70
retailstore.country_id
country.id
Restrict delete
FK_1364CE6B19EB6921
retailstore.client_id
client.id
Restrict delete
FK_82C1E65CD95C1FC6
vendororder.clerk_id
users.id
Restrict delete
FK_82C1E65CF603EE73
vendororder.vendor_id
vendor.id
Restrict delete
FK_82C1E65C5080ECDE
vendororder.warehouse_id
warehouse.id
Restrict delete
FK_82C1E65C4887F3F8
vendororder.shipping_id
shipping.id
Restrict delete
FK_82C1E65CB9BA2274
vendororder.orderBuyingList_id
orderbuyinglist.id
Restrict delete
FK_82C1E65C263E25CF
vendororder.orderStatus_id
entitystatus.id
Restrict delete
FK_82C1E65CBD1BCD8A
vendororder.shippingCountry_id
country.id
Restrict delete
FK_82C1E65C18B9AF25
vendororder.internalOrder_id
orders.id
Restrict delete
FK_82C1E65C31894D3C
vendororder.vendorCountry_id
country.id
Restrict delete
FK_82C1E65CE3C8343D
vendororder.billingState_id
state.id
Restrict delete
FK_82C1E65C19EB6921
vendororder.client_id
client.id
Restrict delete
FK_82C1E65C4FFDFEE3
vendororder.billingCountry_id
country.id
Restrict delete
FK_82C1E65C6EAEB92E
vendororder.shippingState_id
state.id
Restrict delete
FK_F3E4D5CA42B43298
productoption_objectgroup.productoption_id
productoption.id
Cascade on delete
FK_F3E4D5CA8A52B89A
productoption_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_3B59ECCCF92F3E70
liability.country_id
country.id
Restrict delete
FK_3B59ECCC1ED6D67C
liability.vendorOrder_id
vendororder.id
Restrict delete
FK_3B59ECCC43237701
liability.costCenter_id
costcenter.id
Restrict delete
FK_3B59ECCCB3B5D8FA
liability.commissionContract_id
commissioncontract.id
Restrict delete
FK_3B59ECCCF603EE73
liability.vendor_id
vendor.id
Restrict delete
FK_3B59ECCCD95C1FC6
liability.clerk_id
users.id
Restrict delete
FK_3B59ECCC19EB6921
liability.client_id
client.id
Restrict delete
FK_3B59ECCC82F1BAF4
liability.language_id
language.id
Restrict delete
FK_3B59ECCC9395C3F3
liability.customer_id
customer.id
Restrict delete
FK_3B59ECCCBB7A1966
liability.liabilityStatus_id
entitystatus.id
Restrict delete
FK_3B59ECCC5D83CC1
liability.state_id
state.id
Restrict delete
FK_3B59ECCC4C3A3BB
liability.payment_id
payment.id
Restrict delete
FK_3B7D7D82CFD6A7B3
shippingcost_excludedcountry.shippingcost_id
shippingcost.id
Cascade on delete
FK_3B7D7D82F92F3E70
shippingcost_excludedcountry.country_id
country.id
Cascade on delete
FK_A9EC886119EB6921
clientsheme.client_id
client.id
Restrict delete
FK_A9EC8861ECFF285C
clientsheme.table_id
tablesheme.id
Restrict delete
FK_A96DC5BD4584665A
productstockcondition.product_id
product.id
Restrict delete
FK_A96DC5BD19EB6921
productstockcondition.client_id
client.id
Restrict delete
FK_FD512877A76ED395
user_inversedobjectgroup.user_id
users.id
Cascade on delete
FK_FD5128778A52B89A
user_inversedobjectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_C192DB1E8D9F6D38
trackinginfo.order_id
orders.id
Restrict delete
FK_61EB42C2D2112630
customformgrid_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_61EB42C28B98976A
customformgrid_usergroup.customformgrid_id
customformgrid.id
Cascade on delete
FK_1A0570634584665A
productprice.product_id
product.id
Restrict delete
FK_1A0570634C7A5B2E
productprice.salesChannel_id
saleschannel.id
Restrict delete
FK_1A05706319EB6921
productprice.client_id
client.id
Restrict delete
FK_1A0570636FB7FED2
productprice.customerGroup_id
customergroup.id
Restrict delete
FK_C122947819EB6921
counter.client_id
client.id
Restrict delete
FK_65BFDF417FDBDE77
productoptionmaterial.materialProduct_id
product.id
Restrict delete
FK_65BFDF416924B7EA
productoptionmaterial.productOptionField_id
productoptionfield.id
Restrict delete
FK_D0E87A0A76ED395
user_grantedroute.user_id
users.id
Cascade on delete
FK_D0E87A03E9FD759
user_grantedroute.grantedroute_id
grantedroute.id
Cascade on delete
FK_29D6873E7046D53
offer.agentCustomer_id
customer.id
Restrict delete
FK_29D6873E19EB6921
offer.client_id
client.id
Restrict delete
FK_29D6873E4C3A3BB
offer.payment_id
payment.id
Restrict delete
FK_29D6873E4887F3F8
offer.shipping_id
shipping.id
Restrict delete
FK_29D6873E9C2C31D7
offer.exchangedOffer_id
offer.id
Restrict delete
FK_29D6873E82F1BAF4
offer.language_id
language.id
Restrict delete
FK_29D6873E8D9F6D38
offer.order_id
orders.id
Restrict delete
FK_29D6873EBD1BCD8A
offer.shippingCountry_id
country.id
Restrict delete
FK_29D6873EB0785805
offer.shippingPackage_id
shippingpackage.id
Restrict delete
FK_29D6873ED95C1FC6
offer.clerk_id
users.id
Restrict delete
FK_29D6873EBEBB771C
offer.offerStatus_id
entitystatus.id
Restrict delete
FK_29D6873E12C63630
offer.statusObject_id
orderstatus.id
Restrict delete
FK_29D6873E9395C3F3
offer.customer_id
customer.id
Restrict delete
FK_29D6873E4FFDFEE3
offer.billingCountry_id
country.id
Restrict delete
FK_29D6873E6EAEB92E
offer.shippingState_id
state.id
Restrict delete
FK_29D6873EE3C8343D
offer.billingState_id
state.id
Restrict delete
FK_CA030A474584665A
payment_product.product_id
product.id
Cascade on delete
FK_CA030A474C3A3BB
payment_product.payment_id
payment.id
Cascade on delete
FK_8E69D9E94584665A
productserialnumber.product_id
product.id
Restrict delete
FK_8E69D9E9B2A824D8
productserialnumber.tax_id
tax.id
Restrict delete
FK_2D1C172419EB6921
shipping.client_id
client.id
Restrict delete
FK_C15A35D9A76ED395
banknotecountprotocol.user_id
users.id
Restrict delete
FK_C15A35D9856092CE
banknotecountprotocol.cashReport_id
cashreport.id
Restrict delete
FK_C15A35D9A0F81733
banknotecountprotocol.cashJournal_id
cashjournal.id
Restrict delete
FK_D296DC42A907283B
picklistreservation.serialNumber_id
productserialnumber.id
Restrict delete
FK_D296DC4264D218E
picklistreservation.location_id
warehousestoragelocation.id
Restrict delete
FK_D296DC4249D7A7E0
picklistreservation.pickListItem_id
picklistitem.id
Restrict delete
FK_D296DC42A76ED395
picklistreservation.user_id
users.id
Restrict delete
FK_D296DC424584665A
picklistreservation.product_id
product.id
Restrict delete
FK_A28B44634BD2A4C0
reportitem.report_id
report.id
Restrict delete
FK_F124D4428A52B89A
commissioncontract_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_F124D4423529572D
commissioncontract_objectgroup.commissioncontract_id
commissioncontract.id
Cascade on delete
FK_B53BCFA2F92F3E70
shipping_country.country_id
country.id
Cascade on delete
FK_B53BCFA24887F3F8
shipping_country.shipping_id
shipping.id
Cascade on delete
FK_7BED79A23B0ABC10
voucherreportitem.publicKeyObject_id
publickey.id
Restrict delete
FK_7BED79A28D9F6D38
voucherreportitem.order_id
orders.id
Restrict delete
FK_7BED79A279443B8A
voucherreportitem.voucherReport_id
voucherreport.id
Restrict delete
FK_7BED79A2A76ED395
voucherreportitem.user_id
users.id
Restrict delete
FK_2109C2F419EB6921
maillog.client_id
client.id
Restrict delete
FK_2109C2F4A76ED395
maillog.user_id
users.id
Restrict delete
FK_E76CB8E084A0A3ED
store_seocachedcontent.content_id
content.id
Cascade on delete
FK_E76CB8E0B092A811
store_seocachedcontent.store_id
store.id
Cascade on delete
FK_2CD2B4C38A52B89A
offer_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_2CD2B4C353C674EE
offer_objectgroup.offer_id
offer.id
Cascade on delete
FK_2210DB2419EB6921
warehouse_client.client_id
client.id
Cascade on delete
FK_2210DB245080ECDE
warehouse_client.warehouse_id
warehouse.id
Cascade on delete
FK_AD0C210F727ACA70
contentcategory.parent_id
contentcategory.id
Restrict delete
FK_52509C9984A0A3ED
clientcontent.content_id
content.id
Restrict delete
FK_52509C9919EB6921
clientcontent.client_id
client.id
Restrict delete
FK_2753A2374C3A3BB
paymentfield.payment_id
payment.id
Restrict delete
FK_E901E98F19EB6921
contentmetafield.client_id
client.id
Restrict delete
FK_E901E98F443707B0
contentmetafield.field_id
clientsheme.id
Restrict delete
FK_E901E98F84A0A3ED
contentmetafield.content_id
content.id
Restrict delete
FK_D66714D34584665A
payment_onlyproduct.product_id
product.id
Cascade on delete
FK_D66714D34C3A3BB
payment_onlyproduct.payment_id
payment.id
Cascade on delete
FK_7EBC89E28A52B89A
vendor_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_7EBC89E2F603EE73
vendor_objectgroup.vendor_id
vendor.id
Cascade on delete
FK_75E8D0FDD0408A71
subscriptioncontractpaymentfield.paymentField_id
paymentfield.id
Restrict delete
FK_75E8D0FD244DF37
subscriptioncontractpaymentfield.subscriptionContract_id
subscriptioncontract.id
Restrict delete
FK_6E95EA9096C19C84
discountaccessory_excludedcustomergroup.customergroup_id
customergroup.id
Cascade on delete
FK_6E95EA903B248ABE
discountaccessory_excludedcustomergroup.discountaccessory_id
discountaccessory.id
Cascade on delete
FK_1392A5D853C674EE
voucher.offer_id
offer.id
Restrict delete
FK_1392A5D879391FD7
voucher.refundoffer_id
offer.id
Restrict delete
FK_1392A5D89395C3F3
voucher.customer_id
customer.id
Restrict delete
FK_1392A5D852905701
voucher.saleoffer_id
offer.id
Restrict delete
FK_1392A5D8F5BEA8B3
voucher.refundedDiscountVoucher_id
voucher.id
Restrict delete
FK_1392A5D86EC643C7
voucher.voucherserie_id
voucherserie.id
Restrict delete
FK_1392A5D81DF8A1EF
voucher.saleofferitem_id
offeritem.id
Restrict delete
FK_1392A5D81E88FF9F
voucher.liability_id
liability.id
Restrict delete
FK_B28DD7619EB6921
webshopproductexportjob.client_id
client.id
Restrict delete
FK_B28DD764584665A
webshopproductexportjob.product_id
product.id
Restrict delete
FK_A92F74385080ECDE
client_returnwarehouse.warehouse_id
warehouse.id
Cascade on delete
FK_A92F743819EB6921
client_returnwarehouse.client_id
client.id
Cascade on delete
FK_E2F83D154584665A
vendororderitem.product_id
product.id
Restrict delete
FK_E2F83D158D9F6D38
vendororderitem.order_id
vendororder.id
Restrict delete
FK_E2F83D156BF700BD
vendororderitem.status_id
entitystatus.id
Restrict delete
FK_E2F83D153F473D40
vendororderitem.pickList_id
materialpicklist.id
Restrict delete
FK_C2CBB30253C674EE
offermetafield.offer_id
offer.id
Restrict delete
FK_C2CBB302443707B0
offermetafield.field_id
clientsheme.id
Restrict delete
FK_C2CBB30219EB6921
offermetafield.client_id
client.id
Restrict delete
FK_4B90B07AA907283B
materialpicklistitem.serialNumber_id
productserialnumber.id
Restrict delete
FK_4B90B07A4584665A
materialpicklistitem.product_id
product.id
Restrict delete
FK_4B90B07A3F473D40
materialpicklistitem.pickList_id
materialpicklist.id
Restrict delete
FK_4B90B07A64D218E
materialpicklistitem.location_id
warehousestoragelocation.id
Restrict delete
FK_9593B51AA03C589C
user_excludedwidget.grantedwidget_id
grantedwidget.id
Cascade on delete
FK_9593B51AA76ED395
user_excludedwidget.user_id
users.id
Cascade on delete
FK_199C39F719EB6921
amazonordersendjob.client_id
client.id
Restrict delete
FK_199C39F78D9F6D38
amazonordersendjob.order_id
orders.id
Restrict delete
FK_59E3935082F1BAF4
customformfield.language_id
language.id
Restrict delete
FK_59E393507904F92F
customformfield.metafield_id
clientsheme.id
Restrict delete
FK_59E39350E1F44B34
customformfield.createdByUser_id
users.id
Restrict delete
FK_59E393509268A8FA
customformfield.customform_id
customform.id
Restrict delete
FK_46B5ACCAFF255BD5
shippingpackage_category.shippingpackage_id
shippingpackage.id
Cascade on delete
FK_46B5ACCA12469DE2
shippingpackage_category.category_id
category.id
Cascade on delete
FK_94DA59764584665A
product_attribute.product_id
product.id
Restrict delete
FK_94DA5976B6E62EFA
product_attribute.attribute_id
attribute.id
Restrict delete
FK_BCE69D554C3A3BB
retailstore_payment.payment_id
payment.id
Cascade on delete
FK_BCE69D553D65BE63
retailstore_payment.retailstore_id
retailstore.id
Cascade on delete
FK_D082CFC28D221516
vendorproductscaleprice.vendorProduct_id
vendorproduct.id
Restrict delete
FK_4692CEFCA76ED395
posterminal_priceuser.user_id
users.id
Cascade on delete
FK_4692CEFCCD7F4BE9
posterminal_priceuser.posterminal_id
posterminal.id
Cascade on delete
FK_5B22A2DEB2A824D8
taxmetafield.tax_id
tax.id
Restrict delete
FK_5B22A2DE443707B0
taxmetafield.field_id
clientsheme.id
Restrict delete
FK_5B22A2DE19EB6921
taxmetafield.client_id
client.id
Restrict delete
FK_FBDEE3308A52B89A
workflow_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_FBDEE3302C7C2CBA
workflow_objectgroup.workflow_id
workflow.id
Cascade on delete
FK_D2525B6319EB6921
picklist.client_id
client.id
Restrict delete
FK_3E24DCDF3CF562F1
orderreturnitem.wrongSerialNumber_id
productserialnumber.id
Restrict delete
FK_3E24DCDF39D39F83
orderreturnitem.wrongProduct_id
product.id
Restrict delete
FK_3E24DCDF99BA4D22
orderreturnitem.otherProduct_id
product.id
Restrict delete
FK_3E24DCDF14EEE983
orderreturnitem.otherSerialNumber_id
productserialnumber.id
Restrict delete
FK_3E24DCDF6715173E
orderreturnitem.swapDeliveryItem_id
vendororderitemdelivery.id
Restrict delete
FK_3E24DCDFA907283B
orderreturnitem.serialNumber_id
productserialnumber.id
Restrict delete
FK_3E24DCDF3AF075CF
orderreturnitem.deliveryItem_id
vendororderitemdelivery.id
Restrict delete
FK_3E24DCDF59BB1592
orderreturnitem.reason_id
orderreturnreason.id
Restrict delete
FK_3E24DCDF6FBD33A7
orderreturnitem.orderReturn_id
orderreturn.id
Restrict delete
FK_3E24DCDF7FDBDE77
orderreturnitem.materialProduct_id
product.id
Restrict delete
FK_3E24DCDFFDB4FBE0
orderreturnitem.offerItem_id
offeritem.id
Restrict delete
FK_BE3124734887F3F8
shipping_excludedcustomergroup.shipping_id
shipping.id
Cascade on delete
FK_BE31247396C19C84
shipping_excludedcustomergroup.customergroup_id
customergroup.id
Cascade on delete
FK_A7F52B64BE3C43E
cashjournal.posTerminal_id
posterminal.id
Restrict delete
FK_A7F52B634956C29
cashjournal.completedByUser_id
users.id
Restrict delete
FK_A7F52B619EB6921
cashjournal.client_id
client.id
Restrict delete
FK_468A5BA94C3A3BB
payment_category.payment_id
payment.id
Cascade on delete
FK_468A5BA912469DE2
payment_category.category_id
category.id
Cascade on delete
FK_9F9E26156FB7FED2
scaleprice.customerGroup_id
customergroup.id
Restrict delete
FK_9F9E26154584665A
scaleprice.product_id
product.id
Restrict delete
FK_9F9E261519EB6921
scaleprice.client_id
client.id
Restrict delete
FK_9F9E26154C7A5B2E
scaleprice.salesChannel_id
saleschannel.id
Restrict delete
FK_A1F6C8F984D850E0
subscriptioncontract_objectgroup.subscriptioncontract_id
subscriptioncontract.id
Cascade on delete
FK_A1F6C8F98A52B89A
subscriptioncontract_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_B4068BC819EB6921
client_pickingwarehouse.client_id
client.id
Cascade on delete
FK_B4068BC85080ECDE
client_pickingwarehouse.warehouse_id
warehouse.id
Cascade on delete
FK_F5F46947FF255BD5
shippingpackage_product.shippingpackage_id
shippingpackage.id
Cascade on delete
FK_F5F469474584665A
shippingpackage_product.product_id
product.id
Cascade on delete
FK_517EF2A632758FE
discount_saleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_517EF2A64C7C611F
discount_saleschannel.discount_id
discount.id
Cascade on delete
FK_5B25E6558D9F6D38
amazoninvoicejob.order_id
orders.id
Restrict delete
FK_5B25E65519EB6921
amazoninvoicejob.client_id
client.id
Restrict delete
FK_9282E56B4887F3F8
shipping_customergroup.shipping_id
shipping.id
Cascade on delete
FK_9282E56B96C19C84
shipping_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_EE3BFE268D9F6D38
hbci.order_id
orders.id
Restrict delete
FK_EE3BFE261E88FF9F
hbci.liability_id
liability.id
Restrict delete
FK_EE3BFE2619EB6921
hbci.client_id
client.id
Restrict delete
FK_EE3BFE26238B66F6
hbci.accountBooking_id
accountbooking.id
Restrict delete
FK_8D5A40D684A0A3ED
contentemailattachment.content_id
content.id
Restrict delete
FK_700669F719EB6921
productmetafield.client_id
client.id
Restrict delete
FK_700669F7443707B0
productmetafield.field_id
clientsheme.id
Restrict delete
FK_700669F74584665A
productmetafield.product_id
product.id
Restrict delete
FK_D49D7FD719EB6921
ebayorderjob.client_id
client.id
Restrict delete
FK_D49D7FD78D9F6D38
ebayorderjob.order_id
orders.id
Restrict delete
FK_BEC2C73553C674EE
dhlreturn.offer_id
offer.id
Restrict delete
FK_F8AAA08E9395C3F3
customer_voucherserie.customer_id
customer.id
Cascade on delete
FK_F8AAA08E6EC643C7
customer_voucherserie.voucherserie_id
voucherserie.id
Cascade on delete
FK_1FCE8CD64C3A3BB
payment_saleschannel.payment_id
payment.id
Cascade on delete
FK_1FCE8CD632758FE
payment_saleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_21939FF7443707B0
contactmetafield.field_id
clientsheme.id
Restrict delete
FK_21939FF7E7A1254A
contactmetafield.contact_id
contact.id
Restrict delete
FK_21939FF719EB6921
contactmetafield.client_id
client.id
Restrict delete
FK_32FA7DB7F54224B3
csvexportfilterrule.csvexportfilter_id
csvexportfilter.id
Restrict delete
FK_D046C167B092A811
store_nonpubliccontent.store_id
store.id
Cascade on delete
FK_D046C16784A0A3ED
store_nonpubliccontent.content_id
content.id
Cascade on delete
FK_8BACCD26856092CE
voucherreport.cashReport_id
cashreport.id
Restrict delete
FK_8BACCD26A76ED395
voucherreport.user_id
users.id
Restrict delete
FK_8BACCD26A0F81733
voucherreport.cashJournal_id
cashjournal.id
Restrict delete
FK_EF81FCF54C7C611F
discount_objectgroup.discount_id
discount.id
Cascade on delete
FK_EF81FCF58A52B89A
discount_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_C8ACCE2E12469DE2
category_client.category_id
category.id
Cascade on delete
FK_C8ACCE2E19EB6921
category_client.client_id
client.id
Cascade on delete
FK_BD1B1845887793B6
vendorconditiondiscount.condition_id
vendorconditions.id
Restrict delete
FK_4A3AC78CF92F3E70
payment_country.country_id
country.id
Cascade on delete
FK_4A3AC78C4C3A3BB
payment_country.payment_id
payment.id
Cascade on delete
FK_55EE4AC9A76ED395
mailjob.user_id
users.id
Restrict delete
FK_55EE4AC919EB6921
mailjob.client_id
client.id
Restrict delete
FK_5A9D614B4584665A
productsalecondition.product_id
product.id
Restrict delete
FK_5A9D614B19EB6921
productsalecondition.client_id
client.id
Restrict delete
FK_5A9D614B6FB7FED2
productsalecondition.customerGroup_id
customergroup.id
Restrict delete
FK_71EC8187A4CFA76C
orderstatus_objectgroup.orderstatus_id
orderstatus.id
Cascade on delete
FK_71EC81878A52B89A
orderstatus_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_A2161F6819EB6921
user_client.client_id
client.id
Restrict delete
FK_A2161F68A76ED395
user_client.user_id
users.id
Restrict delete
FK_4CA5C4808B98976A
customformgrid_customergroup.customformgrid_id
customformgrid.id
Cascade on delete
FK_4CA5C48096C19C84
customformgrid_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_366DA21932758FE
shipping_saleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_366DA2194887F3F8
shipping_saleschannel.shipping_id
shipping.id
Cascade on delete
FK_F5F780757E7877C
shirtnetworkproductviewobject.productView_id
shirtnetworkproductview.id
Restrict delete
FK_D0473C9C82F1BAF4
vendorinformation.language_id
language.id
Restrict delete
FK_D0473C9CF92F3E70
vendorinformation.country_id
country.id
Restrict delete
FK_6BECD6544584665A
amazonexportstatus.product_id
product.id
Restrict delete
FK_6BECD654A76ED395
amazonexportstatus.user_id
users.id
Restrict delete
FK_6BECD65419EB6921
amazonexportstatus.client_id
client.id
Restrict delete
FK_DDCE6D9AD395B25E
csvexport.filter_id
csvexportfilter.id
Restrict delete
FK_DDCE6D9A19EB6921
csvexport.client_id
client.id
Restrict delete
FK_C42F7784A258C4EB
report.gridReportForUser_id
users.id
Restrict delete
FK_C42F778419EB6921
report.client_id
client.id
Restrict delete
FK_C42F778482F1BAF4
report.language_id
language.id
Restrict delete
FK_F3D2E79DB092A811
storeseourl.store_id
store.id
Restrict delete
FK_E5A52A0F19EB6921
attribute_client.client_id
client.id
Cascade on delete
FK_E5A52A0FB6E62EFA
attribute_client.attribute_id
attribute.id
Cascade on delete
FK_88B32207FDB4FBE0
timetracking.offerItem_id
offeritem.id
Restrict delete
FK_88B32207E7A1254A
timetracking.contact_id
contact.id
Restrict delete
FK_88B322079395C3F3
timetracking.customer_id
customer.id
Restrict delete
FK_88B32207A76ED395
timetracking.user_id
users.id
Restrict delete
FK_DA62890C8A52B89A
vendororder_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_DA62890CE7A0B42A
vendororder_objectgroup.vendororder_id
vendororder.id
Cascade on delete
FK_692907E7321EBE7
expedition.neutralEmpfaenger_id
customer.id
Restrict delete
FK_692907E729737B8
expedition.dlfSpediteur_id
customer.id
Restrict delete
FK_692907E924DA267
expedition.frachtzahler_id
customer.id
Restrict delete
FK_692907E99E0E008
expedition.notyfier_id
customer.id
Restrict delete
FK_692907E19DD4867
expedition.borderoEmpfaenger_id
customer.id
Restrict delete
FK_692907ECA1312C5
expedition.borderoVersender_id
customer.id
Restrict delete
FK_692907EE36E5971
expedition.frachtfuehrer_id
customer.id
Restrict delete
FK_692907E62722B68
expedition.abholauftragAuftraggeber_id
customer.id
Restrict delete
FK_692907E681C8F6C
expedition.zollanmelder_id
customer.id
Restrict delete
FK_692907E869060D4
expedition.neutralVersender_id
customer.id
Restrict delete
FK_49151276FA60C8EC
customformaction.workflowAction_id
workflowevent.id
Restrict delete
FK_491512765DD59166
customformaction.customForm_id
customform.id
Restrict delete
FK_AA0D882856092CE
cashreportitem.cashReport_id
cashreport.id
Restrict delete
FK_AA0D8828D9F6D38
cashreportitem.order_id
orders.id
Restrict delete
FK_AA0D8823B0ABC10
cashreportitem.publicKeyObject_id
publickey.id
Restrict delete
FK_AA0D882A76ED395
cashreportitem.user_id
users.id
Restrict delete
FK_5A4EE1D1443707B0
ordermetafield.field_id
clientsheme.id
Restrict delete
FK_5A4EE1D18D9F6D38
ordermetafield.order_id
orders.id
Restrict delete
FK_5A4EE1D119EB6921
ordermetafield.client_id
client.id
Restrict delete
FK_A564A10812469DE2
shippingcost_category.category_id
category.id
Cascade on delete
FK_A564A108CFD6A7B3
shippingcost_category.shippingcost_id
shippingcost.id
Cascade on delete
FK_F6726397D7E17689
voucherserie.customerCardCustomer_id
customer.id
Restrict delete
FK_F67263976CF8BF97
voucherserie.mainClient_id
client.id
Restrict delete
FK_F6726397C33F7837
voucherserie.document_id
document.id
Restrict delete
FK_BAE1F3B64584665A
productmedia.product_id
product.id
Restrict delete
FK_7C4E2155B3B5D8FA
commissioncontractitem.commissionContract_id
commissioncontract.id
Restrict delete
FK_7C4E21554584665A
commissioncontractitem.product_id
product.id
Restrict delete
FK_A6A8552F3A4A0296
csvexportfield.csvexport_id
csvexport.id
Restrict delete
FK_DEB64E7D19EB6921
check24job.client_id
client.id
Restrict delete
FK_350202694584665A
shipping_product.product_id
product.id
Cascade on delete
FK_350202694887F3F8
shipping_product.shipping_id
shipping.id
Cascade on delete
FK_EED229BF4887F3F8
subscriptioncontract.shipping_id
shipping.id
Restrict delete
FK_EED229BF6BF700BD
subscriptioncontract.status_id
entitystatus.id
Restrict delete
FK_EED229BF9395C3F3
subscriptioncontract.customer_id
customer.id
Restrict delete
FK_EED229BF19EB6921
subscriptioncontract.client_id
client.id
Restrict delete
FK_EED229BF4C3A3BB
subscriptioncontract.payment_id
payment.id
Restrict delete
FK_EED229BF662DD25B
subscriptioncontract.lastOrder_id
orders.id
Restrict delete
FK_EED229BF7B3B27A4
subscriptioncontract.contractGroup_id
contractgroup.id
Restrict delete
FK_EED229BF38248176
subscriptioncontract.currency_id
currency.id
Restrict delete
FK_2F593FA78A52B89A
document_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_2F593FA7C33F7837
document_objectgroup.document_id
document.id
Cascade on delete
FK_416CA1CF9268A8FA
customform_objectgroup.customform_id
customform.id
Cascade on delete
FK_416CA1CF8A52B89A
customform_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_D8698A76896A9E0B
document.emailContent_id
content.id
Restrict delete
FK_187C125D8B98976A
customformgrid_usergroupcanadditems.customformgrid_id
customformgrid.id
Cascade on delete
FK_187C125DD2112630
customformgrid_usergroupcanadditems.usergroup_id
usergroup.id
Cascade on delete
FK_902CFB1D8A52B89A
attribute_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_902CFB1DB6E62EFA
attribute_objectgroup.attribute_id
attribute.id
Cascade on delete
FK_61F4C9A519EB6921
vendororderitemmetafield.client_id
client.id
Restrict delete
FK_61F4C9A5443707B0
vendororderitemmetafield.field_id
clientsheme.id
Restrict delete
FK_61F4C9A572AE74BD
vendororderitemmetafield.vendorOrderItem_id
vendororderitem.id
Restrict delete
FK_B158E6923A4A0296
csvexportfilter.csvexport_id
csvexport.id
Restrict delete
FK_B158E692727ACA70
csvexportfilter.parent_id
csvexportfilter.id
Restrict delete
FK_1A6B4AA68A52B89A
category_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_1A6B4AA612469DE2
category_objectgroup.category_id
category.id
Cascade on delete
FK_3E6E93F6A23B42D
manufacturermetafield.manufacturer_id
manufacturer.id
Restrict delete
FK_3E6E93F619EB6921
manufacturermetafield.client_id
client.id
Restrict delete
FK_3E6E93F6443707B0
manufacturermetafield.field_id
clientsheme.id
Restrict delete
FK_DF1CE07DA76ED395
contactmessage.user_id
users.id
Restrict delete
FK_DF1CE07DE7A1254A
contactmessage.contact_id
contact.id
Restrict delete
FK_DF1CE07D82F1BAF4
contactmessage.language_id
language.id
Restrict delete
FK_DF1CE07D84A0A3ED
contactmessage.content_id
content.id
Restrict delete
FK_DF1CE07D9395C3F3
contactmessage.customer_id
customer.id
Restrict delete
FK_58907AB66BF700BD
contractgroup.status_id
entitystatus.id
Restrict delete
FK_8E27C748B6DCDCC8
shirtnetworkproductviewobjectlogo.productViewObject_id
shirtnetworkproductviewobject.id
Restrict delete
FK_67B1C66019EB6921
ean.client_id
client.id
Restrict delete
FK_67B1C660B92BABD2
ean.fixProduct_id
product.id
Restrict delete
FK_E32365314584665A
realstockjob.product_id
product.id
Restrict delete
FK_E323653119EB6921
realstockjob.client_id
client.id
Restrict delete
FK_11E0AA9395C3F3
customer_customergroup.customer_id
customer.id
Restrict delete
FK_11E0AA96C19C84
customer_customergroup.customergroup_id
customergroup.id
Restrict delete
FK_844565C719EB6921
statemetafield.client_id
client.id
Restrict delete
FK_844565C7443707B0
statemetafield.field_id
clientsheme.id
Restrict delete
FK_844565C75D83CC1
statemetafield.state_id
state.id
Restrict delete
FK_178061B119EB6921
materialpicklist.client_id
client.id
Restrict delete
FK_AE48A79B4584665A
ottoproductjob.product_id
product.id
Restrict delete
FK_AE48A79B19EB6921
ottoproductjob.client_id
client.id
Restrict delete
FK_20CB513AC0848D2
csvimport.executedByUser_id
users.id
Restrict delete
FK_20CB51319EB6921
csvimport.client_id
client.id
Restrict delete
FK_CBC9E6B75080ECDE
warehousestoragelocation.warehouse_id
warehouse.id
Restrict delete
FK_CBC9E6B7A4D9DA71
warehousestoragelocation.parentLocation_id
warehousestoragelocation.id
Restrict delete
FK_CBC9E6B72F523FDA
warehousestoragelocation.placedProduct_id
product.id
Restrict delete
FK_CBC9E6B78D9F6D38
warehousestoragelocation.order_id
orders.id
Restrict delete
FK_CBC9E6B7B3467BC9
warehousestoragelocation.placedProductGroup_id
category.id
Restrict delete
FK_CBC9E6B77BB449EF
warehousestoragelocation.reservedByUser_id
users.id
Restrict delete
FK_4A84F5F3A76ED395
user_usergroup.user_id
users.id
Cascade on delete
FK_4A84F5F3D2112630
user_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_5983CAC219EB6921
payment_excludedclient.client_id
client.id
Cascade on delete
FK_5983CAC24C3A3BB
payment_excludedclient.payment_id
payment.id
Cascade on delete
FK_6B0F62945080ECDE
inventory_warehouse.warehouse_id
warehouse.id
Cascade on delete
FK_6B0F62949EEA759
inventory_warehouse.inventory_id
inventory.id
Cascade on delete
FK_97B3CBAA8B98976A
customformgrid_objectgroup.customformgrid_id
customformgrid.id
Cascade on delete
FK_97B3CBAA8A52B89A
customformgrid_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_FEDBB532B092A811
storecache.store_id
store.id
Restrict delete
FK_1BC8681E4584665A
realproductjob.product_id
product.id
Restrict delete
FK_1BC8681E19EB6921
realproductjob.client_id
client.id
Restrict delete
FK_9C26741D19EB6921
productpicturemetafield.client_id
client.id
Restrict delete
FK_9C26741DCD79AA2F
productpicturemetafield.productpicture_id
productpicture.id
Restrict delete
FK_9C26741D443707B0
productpicturemetafield.field_id
clientsheme.id
Restrict delete
FK_9D4ECE1D19EB6921
import.client_id
client.id
Restrict delete
FK_C3FC07EC4584665A
expeditionitem.product_id
product.id
Restrict delete
FK_C3FC07EC576EF81E
expeditionitem.expedition_id
expedition.id
Restrict delete
FK_28858571E88FF9F
liabilityupload.liability_id
liability.id
Restrict delete
FK_91CEEB4D19EB6921
clientvalue.client_id
client.id
Restrict delete
FK_91CEEB4D95E5668B
clientvalue.pluginsettings_id
pluginsettings.id
Restrict delete
FK_B642774B8D9F6D38
order_objectgroup.order_id
orders.id
Cascade on delete
FK_B642774B8A52B89A
order_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_E8590EFD4CCC0310
warehousestoragelocation_boxforuser.warehousestoragelocation_id
warehousestoragelocation.id
Cascade on delete
FK_E8590EFDA76ED395
warehousestoragelocation_boxforuser.user_id
users.id
Cascade on delete
FK_1BAF341519EB6921
ottojob.client_id
client.id
Restrict delete
FK_52D92D9A53C674EE
goexpress.offer_id
offer.id
Restrict delete
FK_516572BF2EDEDFFB
customformgridaction.customActionParameterForm_id
customform.id
Restrict delete
FK_516572BFFA60C8EC
customformgridaction.workflowAction_id
workflowevent.id
Restrict delete
FK_516572BFC2B92121
customformgridaction.customFormGrid_id
customformgrid.id
Restrict delete
FK_1EA8776A53C674EE
offerupload.offer_id
offer.id
Restrict delete
FK_15020E5A7F8BFB6A
user_excludedpage.grantedpage_id
grantedpage.id
Cascade on delete
FK_15020E5AA76ED395
user_excludedpage.user_id
users.id
Cascade on delete
FK_31BAF9A0B092A811
storemenu.store_id
store.id
Restrict delete
FK_31BAF9A03754E8F4
storemenu.filterGrid_id
customformgrid.id
Restrict delete
FK_31BAF9A0C2B92121
storemenu.customFormGrid_id
customformgrid.id
Restrict delete
FK_31BAF9A05DD59166
storemenu.customForm_id
customform.id
Restrict delete
FK_31BAF9A012469DE2
storemenu.category_id
category.id
Restrict delete
FK_31BAF9A084A0A3ED
storemenu.content_id
content.id
Restrict delete
FK_E641BE962C7C2CBA
workflow_client.workflow_id
workflow.id
Cascade on delete
FK_E641BE9619EB6921
workflow_client.client_id
client.id
Cascade on delete
FK_3D0AE6DC6CF8BF97
manufacturer.mainClient_id
client.id
Restrict delete
FK_F94805FB9268A8FA
customform_customergroup.customform_id
customform.id
Cascade on delete
FK_F94805FB96C19C84
customform_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_BDBFC5844C3A3BB
payment_excludedproduct.payment_id
payment.id
Cascade on delete
FK_BDBFC5844584665A
payment_excludedproduct.product_id
product.id
Cascade on delete
FK_44F827F7FA60C8EC
workflowactioncondition.workflowAction_id
workflowaction.id
Restrict delete
FK_C39B0629F603EE73
vendorcontact.vendor_id
vendor.id
Restrict delete
FK_DDB6F51961B5DA9B
hbci_order.hbci_id
hbci.id
Cascade on delete
FK_DDB6F5198D9F6D38
hbci_order.order_id
orders.id
Cascade on delete
FK_B7531C3219EB6921
amazonasinjob.client_id
client.id
Restrict delete
FK_B7531C324584665A
amazonasinjob.product_id
product.id
Restrict delete
FK_356CCE2C6EC643C7
voucherserie_objectgroup.voucherserie_id
voucherserie.id
Cascade on delete
FK_356CCE2C8A52B89A
voucherserie_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_CDFC735612469DE2
product_category.category_id
category.id
Restrict delete
FK_CDFC73564584665A
product_category.product_id
product.id
Restrict delete
FK_6F05319F51F39807
storemenu_customergroup.storemenu_id
storemenu.id
Cascade on delete
FK_6F05319F96C19C84
storemenu_customergroup.customergroup_id
customergroup.id
Cascade on delete
FK_C6AF3DA38D9F6D38
amazonpaytransaction.order_id
orders.id
Restrict delete
FK_C6AF3DA319EB6921
amazonpaytransaction.client_id
client.id
Restrict delete
FK_65C5981619EB6921
workflow.client_id
client.id
Restrict delete
FK_5FC9E9B85080ECDE
warehouse_objectgroup.warehouse_id
warehouse.id
Cascade on delete
FK_5FC9E9B88A52B89A
warehouse_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_4C62E6388D9F6D38
contact.order_id
orders.id
Restrict delete
FK_4C62E6386BF700BD
contact.status_id
entitystatus.id
Restrict delete
FK_4C62E638CE4DBD6C
contact.contactClerk_id
users.id
Restrict delete
FK_4C62E63819EB6921
contact.client_id
client.id
Restrict delete
FK_4C62E6389395C3F3
contact.customer_id
customer.id
Restrict delete
FK_4C62E63853C674EE
contact.offer_id
offer.id
Restrict delete
FK_4C62E638244DF37
contact.subscriptionContract_id
subscriptioncontract.id
Restrict delete
FK_B7229A6C19EB6921
ebayjob.client_id
client.id
Restrict delete
FK_DAF84AA5A23B42D
manufacturer_client.manufacturer_id
manufacturer.id
Cascade on delete
FK_DAF84AA519EB6921
manufacturer_client.client_id
client.id
Cascade on delete
FK_ACE681BA19EB6921
orderbuyinglist.client_id
client.id
Restrict delete
FK_1DF96D28A52B89A
product_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_1DF96D24584665A
product_objectgroup.product_id
product.id
Cascade on delete
FK_8E81BA7693034E33
tax.shipperCountry_id
country.id
Restrict delete
FK_380BE40712469DE2
categoryaccessory.category_id
category.id
Restrict delete
FK_380BE4074ADCDE3
categoryaccessory.accessoryProduct_id
product.id
Restrict delete
FK_1EF230F342B43298
productoptionfield.productoption_id
productoption.id
Restrict delete
FK_F02EEF7946A0AD0
accountsystemitem.accountSystem_id
accountsystem.id
Restrict delete
FK_1CE8A3C54BD2A4C0
report_objectgroup.report_id
report.id
Cascade on delete
FK_1CE8A3C58A52B89A
report_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_B1F468EA12469DE2
payment_onlycategory.category_id
category.id
Cascade on delete
FK_B1F468EA4C3A3BB
payment_onlycategory.payment_id
payment.id
Cascade on delete
FK_B215B0E33E9FD759
user_excludedroute.grantedroute_id
grantedroute.id
Cascade on delete
FK_B215B0E3A76ED395
user_excludedroute.user_id
users.id
Cascade on delete
FK_6BD2CE4A64D218E
inventorylocation.location_id
warehousestoragelocation.id
Restrict delete
FK_6BD2CE4A9EEA759
inventorylocation.inventory_id
inventory.id
Restrict delete
FK_5122FA9CB6DCDCC8
shirtnetworkproductviewobjecttext.productViewObject_id
shirtnetworkproductviewobject.id
Restrict delete
FK_D92F8F584584665A
productmaterial.product_id
product.id
Restrict delete
FK_D92F8F587FDBDE77
productmaterial.materialProduct_id
product.id
Restrict delete
FK_9376545E4BD2A4C0
reportcondition.report_id
report.id
Restrict delete
FK_2C07950A4584665A
shippingpackage_excludedproduct.product_id
product.id
Cascade on delete
FK_2C07950AFF255BD5
shippingpackage_excludedproduct.shippingpackage_id
shippingpackage.id
Cascade on delete
FK_F49A19A732758FE
product_saleschannel.saleschannel_id
saleschannel.id
Cascade on delete
FK_F49A19A74584665A
product_saleschannel.product_id
product.id
Cascade on delete
FK_4313015B8D9F6D38
ecreportitem.order_id
orders.id
Restrict delete
FK_4313015B3B0ABC10
ecreportitem.publicKeyObject_id
publickey.id
Restrict delete
FK_4313015B5FFE0628
ecreportitem.ecReport_id
ecreport.id
Restrict delete
FK_4313015BA76ED395
ecreportitem.user_id
users.id
Restrict delete
FK_4313015B4C3A3BB
ecreportitem.payment_id
payment.id
Restrict delete
FK_C280625396C19C84
customergroup_voucherserie.customergroup_id
customergroup.id
Cascade on delete
FK_C28062536EC643C7
customergroup_voucherserie.voucherserie_id
voucherserie.id
Cascade on delete
FK_E1E0B40E6CF8BF97
discount.mainClient_id
client.id
Restrict delete
FK_793E3BCC43237701
saleschannel.costCenter_id
costcenter.id
Restrict delete
FK_A58504934584665A
amazonjob.product_id
product.id
Restrict delete
FK_A585049319EB6921
amazonjob.client_id
client.id
Restrict delete
FK_E8BEBDB3FA60C8EC
workflowactionparametervalue.workflowAction_id
workflowaction.id
Restrict delete
FK_898D3131FDB4FBE0
realsendorderjob.offerItem_id
offeritem.id
Restrict delete
FK_898D313119EB6921
realsendorderjob.client_id
client.id
Restrict delete
FK_E99897A219EB6921
deletedentity.client_id
client.id
Restrict delete
FK_992A6E5F244DF37
subscriptioncontractitem.subscriptionContract_id
subscriptioncontract.id
Restrict delete
FK_992A6E5F4584665A
subscriptioncontractitem.product_id
product.id
Restrict delete
FK_53AFD658EC942BCF
pluginsettings.plugin_id
plugin.id
Restrict delete
FK_3477F23919EB6921
documentmetafield.client_id
client.id
Restrict delete
FK_3477F239C33F7837
documentmetafield.document_id
document.id
Restrict delete
FK_3477F239443707B0
documentmetafield.field_id
clientsheme.id
Restrict delete
FK_8A515480E7A0B42A
vendororder_report.vendororder_id
vendororder.id
Cascade on delete
FK_8A5154804BD2A4C0
vendororder_report.report_id
report.id
Cascade on delete
FK_E8C8328038248176
banknote.currency_id
currency.id
Restrict delete
FK_53EB464042B43298
productoption_client.productoption_id
productoption.id
Cascade on delete
FK_53EB464019EB6921
productoption_client.client_id
client.id
Cascade on delete
FK_3A995CDA2CA12A19
shirtnetworkproductview.shirtnetworkProduct_id
shirtnetworkproduct.id
Restrict delete
FK_FEC530A9E834DB68
content.contentcategory_id
contentcategory.id
Restrict delete
FK_5B7CD8174C3A3BB
payment_objectgroup.payment_id
payment.id
Cascade on delete
FK_5B7CD8178A52B89A
payment_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_9B5149C7D2112630
customformaction_usergroup.usergroup_id
usergroup.id
Cascade on delete
FK_9B5149C7231445A3
customformaction_usergroup.customformaction_id
customformaction.id
Cascade on delete
FK_E3AD22654887F3F8
shipping_excludedcountry.shipping_id
shipping.id
Cascade on delete
FK_E3AD2265F92F3E70
shipping_excludedcountry.country_id
country.id
Cascade on delete
FK_F51458C5A76ED395
shirtnetworkprintjob.user_id
users.id
Restrict delete
FK_F51458C519EB6921
shirtnetworkprintjob.client_id
client.id
Restrict delete
FK_FEDAA24B8A52B89A
content_objectgroup.objectgroup_id
objectgroup.id
Cascade on delete
FK_FEDAA24B84A0A3ED
content_objectgroup.content_id
content.id
Cascade on delete
FK_7BD641FC4584665A
product_voucherserie.product_id
product.id
Cascade on delete
FK_7BD641FC6EC643C7
product_voucherserie.voucherserie_id
voucherserie.id
Cascade on delete
FK_569A30754C7C611F
category_discount.discount_id
discount.id
Cascade on delete
FK_569A307512469DE2
category_discount.category_id
category.id
Cascade on delete
FK_8B6082C94C3A3BB
shipping_payment.payment_id
payment.id
Cascade on delete
FK_8B6082C94887F3F8
shipping_payment.shipping_id
shipping.id
Cascade on delete
FK_CD767F72A76ED395
usergoogleauthenticator.user_id
users.id
Restrict delete
FK_D09DD7B98B98976A
customform_customformgrid.customformgrid_id
customformgrid.id
Cascade on delete
FK_D09DD7B99268A8FA
customform_customformgrid.customform_id
customform.id
Cascade on delete
FK_3F25404FA76ED395
user_posterminal.user_id
users.id
Cascade on delete
FK_3F25404FCD7F4BE9
user_posterminal.posterminal_id
posterminal.id
Cascade on delete
FK_E57748E34ADCDE3
discountaccessory.accessoryProduct_id
product.id
Restrict delete
FK_E57748E34C7C611F
discountaccessory.discount_id
discount.id
Restrict delete
FK_A65336204584665A
product_report.product_id
product.id
Cascade on delete
FK_A65336204BD2A4C0
product_report.report_id
report.id
Cascade on delete
FK_FE1C2F7682F1BAF4
clientdocument.language_id
language.id
Restrict delete
FK_FE1C2F76C33F7837
clientdocument.document_id
document.id
Restrict delete
FK_FE1C2F7619EB6921
clientdocument.client_id
client.id
Restrict delete
FK_5794735B8D9F6D38
orderpayment.order_id
orders.id
Restrict delete
FK_5794735B4C3A3BB
orderpayment.payment_id
payment.id
Restrict delete
FK_5794735B38772A6A
orderpayment.paymentCondition_id
orderpaymentcondition.id
Restrict delete
FK_F52233F62EF03101
vendor.information_id
vendorinformation.id
Restrict delete
FK_F52233F6C5FBDC0F
vendor.conditions_id
vendorconditions.id
Restrict delete
FK_364101B0537A1329
contactmessageattachment.message_id
contactmessage.id
Restrict delete
FK_FB70410819EB6921
paymentmetafield.client_id
client.id
Restrict delete
FK_FB704108443707B0
paymentmetafield.field_id
clientsheme.id
Restrict delete
FK_FB7041084C3A3BB
paymentmetafield.payment_id
payment.id
Restrict delete
FK_2165A9063D65BE63
retailstore_cashlesspayment.retailstore_id
retailstore.id
Cascade on delete
FK_2165A9064C3A3BB
retailstore_cashlesspayment.payment_id
payment.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint