Tables


SchemaSpy Analysis of wawi_dev

Generated on Tue Jul 05 15:45 CEST 2022

XML Representation
Insertion Order Deletion Order
TABLES 469
VIEWS 0
COLUMNS 3994
Constraints 1008
Anomalies 18
Routines 0

Database Properties

Database Type: MySQL - 5.7.38-1

Tables

Table / View Children Parents Columns Rows Type Comments
manufacturerupload 0 1 5 2 Table
amazonstockjob 0 2 5 3 Table
vendorconditions 2 5 18 9 Table
banknotecount 0 2 5 2495 Table
orderreturnreason 1 0 4 7 Table
usermessagechannel_user 0 2 2 16 Table
gls 0 1 8 3 Table
amazonorderadjustmentjob 0 3 5 0 Table
pictures 0 0 3 0 Table
orderbuyinglistitem 0 2 5 39 Table
customergroupmetafield 0 3 6 35 Table
csvimport_objectgroup 0 2 2 1 Table
manufacturer_objectgroup 0 2 2 0 Table
shippingcost 9 1 19 11 Table
customer_adviser 0 2 2 2 Table
clientvalue_oneclientvalue 0 2 2 6 Table
orderremind 0 1 7 403 Table
intraship 0 1 9 532 Table
user_grantedwidget 0 2 2 8 Table
workflowaction 2 1 3 360 Table
customform_user 0 2 2 0 Table
country_discount 0 2 2 1 Table
productstock 0 2 9 5749 Table
customformgrid_usergroupcanaddcolumns 0 2 2 0 Table
posterminal 6 4 27 7 Table
workflowevent 3 0 9 48 Table
paypaltransaction 0 1 11 584 Table
orderpaymentcondition 1 2 14 100 Table
liabilitypayment 0 2 8 106 Table
ottostockjob 0 2 6 0 Table
orderreturn 2 2 7 510 Table
categorymetafield 0 3 6 14744 Table
ebayproductjob 0 2 5 61 Table
customformgridcondition 0 1 8 30 Table
customformfield_excludeduser 0 2 2 0 Table
customermetafield 0 3 6 326 Table
shippingcost_country 0 2 2 15 Table
shippingmetafield 0 3 6 1697 Table
user_posterminalprice 0 2 2 0 Table
desktopdownloadjob 0 2 8 132 Table
ebaycategory 0 0 5 18729 Table
productoptionmetafield 0 3 6 47 Table
dhlexpress 0 1 7 5 Table
hermes 0 1 4 1 Table
storeregistrationtoken 0 1 4 0 Table
vendorordermetafield 0 3 6 2 Table
orderpicking 1 3 7 4950 Table
user_grantedpage 0 2 2 14 Table
liabilityitem 1 3 26 1685 Table
shippingpackage 5 1 7 4 Table
store 11 3 31 4 Table
storelogintoken 0 1 4 0 Table
vendororderitemdelivery 2 7 13 31079 Table
ecreport 3 3 9 369 Table
attributemetafield 0 3 6 258 Table
vendororderdelivery 3 7 18 8735 Table
reportcolumn 0 2 14 308 Table
product_customergroup 0 2 2 135 Table
inventorylocationitem 0 3 7 730 Table
country 25 1 15 254 Table
inventory 2 3 16 189 Table
product 81 13 130 62816 Table
warehouse_user 0 2 2 0 Table
workflow_crossclient 0 2 2 0 Table
attribute 5 1 9 104 Table
shippingcost_saleschannel 0 2 2 9 Table
contact_user 0 2 2 5 Table
customform_usergroup 0 2 2 0 Table
customformgridaction_usergroup 0 2 2 0 Table
invoiceledger 1 1 4 13 Table
productlicense 0 4 12 3 Table
realinvoicejob 0 2 4 0 Table
orderstatus 2 1 10 75 Table
csvimportvariationfield 0 1 6 8 Table
discount_client 0 2 2 22 Table
shipping_category 0 2 2 0 Table
voucherserie_client 0 2 2 663 Table
offer_report 0 2 2 0 Table
workflowcondition 0 1 4 59 Table
commissionitem 0 2 6 0 Table
payment_user 0 2 2 5 Table
customformfield_customergroup 0 2 2 0 Table
state 8 1 8 83 Table
storebanner 0 5 17 2 Table
lockobject 0 0 5 6 Table
workflowactionjob 0 3 8 0 Table
customformgridaction_customergroup 0 2 2 0 Table
liabilitypaymentfield 0 2 5 321 Table
printjob 0 4 18 110 Table
customer_report 0 2 2 3 Table
product_crosssellingproduct 0 2 2 4 Table
currency 6 0 6 7 Table
reportjob 0 2 6 0 Table
orderinternalcomment 0 2 7 48 Table
category_excludedsaleschannel 0 2 2 5 Table
contact_excludeduser 0 2 2 0 Table
internetmarke 0 1 5 15 Table
shippingcost_customergroup 0 2 2 0 Table
product_discount 0 2 2 2772 Table
realstornojob 0 2 4 0 Table
commissionupload 0 1 5 0 Table
customersession 0 2 4 9 Table
customercontact 0 1 12 1 Table
warehouse_excludedclient 0 2 2 2 Table
accountbooking 1 8 129 4464 Table
commissioncontract_order 0 2 2 20 Table
customformaction_customergroup 0 2 2 0 Table
languagemetafield 0 3 6 3 Table
shippingcost_excludedproduct 0 2 2 1 Table
customformgrid_crossclient 0 2 2 0 Table
grantedwidget 2 0 3 380 Table
export 0 1 3 0 Table
ebaystockjob 0 2 5 29 Table
reportrow 1 2 9 0 Table
productoptionmaterialquantity 0 2 5 4 Table
productaccessory 0 2 10 5 Table
payment_excludedcategory 0 2 2 0 Table
order_report 0 2 2 4584 Table
csvimportkeyfield 0 1 5 0 Table
customer 44 14 80 1920 Table
ups 0 1 5 19 Table
csvrow 0 1 7 0 Table
offerpaymentfield 0 2 5 1271 Table
wawilistener 2 0 4 3 Table
cashreport 6 6 21 375 Table
customergroup_discount 0 2 2 3 Table
customform 12 2 34 2358 Table
retailstore_crossclient 0 2 2 2 Table
customformaction_user 0 2 2 0 Table
language 12 1 7 33 Table
warehousebooking 0 7 19 75762 Table
fedex 0 1 6 2 Table
offeritemmetafield 0 3 6 1786 Table
securetoken 0 0 2 122 Table
categorycountrytax 0 3 4 4 Table
orderpickingitem 0 4 6 5948 Table
category_voucherserie 0 2 2 1 Table
usersession 0 1 3 14 Table
product_client 0 2 2 64573 Table
customerupload 0 1 5 10 Table
vendorproduct 1 2 22 2101 Table
liability_vendororder 0 2 2 8 Table
product_option 0 2 2 107 Table
contentemailattachment_client 0 2 2 2 Table
picklistitem 1 4 9 4821 Table
retailstore_warehouse 0 2 2 2 Table
dpd 0 1 8 28 Table
users 66 2 23 19 Table
customformgrid_usercanaddcolumns 0 2 2 4 Table
payment_excludedcustomergroup 0 2 2 0 Table
offeritem 13 13 68 36000 Table
arriva 0 1 7 1 Table
csvimportjob 0 2 6 0 Table
customformfield_user 0 2 2 19 Table
productpicture 1 1 7 176421 Table
picklistreservation_orders 0 2 2 0 Table
category 29 4 36 6507 Table
ext_translations 0 0 6 178813 Table
shipping_excludedcategory 0 2 2 0 Table
payment_customergroup 0 2 2 0 Table
webshopexportjob 0 1 8 1 Table
ottobrand 0 0 2 24723 Table
webshopimportjob 0 1 8 1 Table
shippingcost_product 0 2 2 0 Table
customform_crossclient 0 2 2 2 Table
shirtnetworkproduct 1 2 19 137 Table
shippingpackage_excludedcategory 0 2 2 0 Table
client 134 3 137 22 Table
commission 2 2 6 0 Table
usermetafield 0 3 6 0 Table
customer_crossclient 0 2 2 4 Table
ottotask 0 1 6 4 Table
productoption 6 2 7 50 Table
countrymetafield 0 3 6 29 Table
customformgrid_user 0 2 2 0 Table
amazonbrowsenode 0 0 3 21399 Table
shipping_excludedproduct 0 2 2 3 Table
commissioncontractpaymentfield 0 2 5 60 Table
productstatistics 0 2 14 21673 Table
liability_objectgroup 0 2 2 1 Table
offeritemoptionfield 0 2 4 0 Table
storesession 0 2 4 0 Table
contact_customer 0 2 2 22 Table
entitylog 0 1 7 91068 Table
orders 37 19 75 23283 Table
payment_excludedcountry 0 2 2 0 Table
commissioncontract 8 6 18 42 Table
warehouse_excludeduser 0 2 2 1 Table
category_report 0 2 2 2 Table
ottocategory 0 0 4 11585 Table
product_cachedrootcategory 0 2 2 0 Table
warehouse 18 3 28 25 Table
tse 0 0 11 1 Table
store_disabledwidgets 0 2 2 0 Table
customer_discount 0 2 2 3 Table
shippingcost_excludedcategory 0 2 2 0 Table
usermessagechannel 2 0 4 8 Table
vendororderupload 0 1 5 0 Table
warehousebox 0 1 6 0 Table
printprotocol 0 0 4 189 Table
commissioncontractupload 0 1 5 0 Table
script 0 0 3 73 Table
category_customergroup 0 2 2 7 Table
realcategory 0 0 4 5324 Table
address 1 3 22 35 Table
orderrefund 0 2 9 244 Table
voucherserieaccessory 0 2 8 2 Table
product_objectpool 0 2 2 0 Table
usermessage 0 3 7 142 Table
amazonprime 0 1 3 5 Table
currencymetafield 0 3 6 0 Table
objectgroupitem 0 0 2 0 Table
vendormetafield 0 3 6 10 Table
vendor_client 0 2 2 43 Table
storefeedback 0 2 6 9 Table
vendorordersubmissionitemdelivery 0 5 10 41 Table
csvexportjob 0 2 6 0 Table
subscriptioncontractupload 0 1 5 0 Table
productcountrytax 0 3 4 0 Table
csvimportfield 0 2 10 220 Table
shipping_objectgroup 0 2 2 0 Table
store_fullpagecachingcontent 0 2 2 0 Table
customformgrid_usergroupcanremoveitems 0 2 2 0 Table
posterminal_user 0 2 2 10 Table
user_objectgroup 0 2 2 0 Table
saleschannel_warehouse 0 2 2 0 Table
entitystatus 8 0 5 18 Table
order_pickingwarehouse 0 2 2 4 Table
product_storagelocations 0 2 2 368 Table
payment 33 0 18 42 Table
shippingcost_excludedcustomergroup 0 2 2 0 Table
client_orderdocument 0 2 2 1 Table
customformgridaction_user 0 2 2 0 Table
realjob 0 1 5 0 Table
shipping_excludedpayment 0 2 2 0 Table
attributevalue 0 2 6 6049 Table
customformfield_usergroup 0 2 2 0 Table
customform_usergroupcansave 0 2 2 0 Table
ottoattribute 0 0 3 6859 Table
invoiceledgeritem 0 4 18 679 Table
customformgrid 16 2 38 528 Table
objectgroup 27 0 3 6 Table
retailstore 5 2 13 3 Table
vendororder 8 12 72 460 Table
productoption_objectgroup 0 2 2 0 Table
liability 10 11 70 187 Table
shippingcost_excludedcountry 0 2 2 0 Table
clientsheme 24 2 18 6400 Table
downloadjob 0 0 4 1 Table
productstockcondition 0 2 11 3 Table
user_inversedobjectgroup 0 2 2 0 Table
trackinginfo 0 1 5 51 Table
customformgrid_usergroup 0 2 2 0 Table
productprice 0 4 9 47 Table
counter 0 1 4 2 Table
productoptionmaterial 0 2 4 13 Table
user_grantedroute 0 2 2 4 Table
offer 28 16 122 23801 Table
payment_product 0 2 2 0 Table
costcenter 3 0 3 1 Table
productserialnumber 9 1 11 271 Table
shipping 21 1 24 41 Table
banknotecountprotocol 2 3 9 262 Table
picklistreservation 1 5 14 0 Table
reportitem 0 1 3 0 Table
commissioncontract_objectgroup 0 2 2 0 Table
shipping_country 0 2 2 0 Table
voucherreportitem 0 4 21 318 Table
avocadocategory 0 0 3 825 Table
maillog 0 2 9 5810 Table
storewidget 1 0 3 15 Table
store_seocachedcontent 0 2 2 0 Table
contentcategory 2 1 5 5 Table
offer_objectgroup 0 2 2 0 Table
productindex 1 0 25 27 Table
warehouse_client 0 2 2 25 Table
clientcontent 0 2 4 7 Table
paymentfield 4 1 5 9 Table
contentmetafield 0 3 6 3 Table
payment_onlyproduct 0 2 2 0 Table
vendor_objectgroup 0 2 2 0 Table
subscriptioncontractpaymentfield 0 2 5 34 Table
voucher 2 8 19 5702 Table
client_returnwarehouse 0 2 2 0 Table
webshopproductexportjob 0 2 4 39 Table
vendororderitem 3 4 26 658 Table
materialpicklistitem 0 4 9 43 Table
offermetafield 0 3 6 12764 Table
user_excludedwidget 0 2 2 9 Table
amazonordersendjob 0 2 4 0 Table
customformfield 4 3 61 19373 Table
shippingpackage_category 0 2 2 0 Table
product_attribute 0 2 2 0 Table
retailstore_payment 0 2 2 0 Table
vendorproductscaleprice 0 1 7 1261 Table
posterminal_priceuser 0 2 2 0 Table
taxmetafield 0 3 6 1573 Table
workflow_objectgroup 0 2 2 0 Table
picklist 3 1 4 4907 Table
orderreturnitem 0 9 13 537 Table
accountsystem 2 0 3 3 Table
shipping_excludedcustomergroup 0 2 2 0 Table
cashjournal 4 3 8 7 Table
payment_category 0 2 2 0 Table
scaleprice 0 4 12 194 Table
subscriptioncontract_objectgroup 0 2 2 0 Table
client_pickingwarehouse 0 2 2 0 Table
discount_saleschannel 0 2 2 1 Table
shippingpackage_product 0 2 2 1 Table
amazoninvoicejob 0 2 4 8 Table
shipping_customergroup 0 2 2 0 Table
contentemailattachment 1 1 5 5 Table
hbci 1 4 18 361 Table
productmetafield 0 3 6 121261 Table
dhlreturn 0 1 8 579 Table
ebayorderjob 0 2 5 0 Table
customer_voucherserie 0 2 2 15 Table
payment_saleschannel 0 2 2 4 Table
csvexportfilterrule 0 1 5 6 Table
store_nonpubliccontent 0 2 2 0 Table
voucherreport 3 3 9 369 Table
discount_objectgroup 0 2 2 0 Table
category_client 0 2 2 5963 Table
vendorconditiondiscount 0 1 4 0 Table
payment_country 0 2 2 3 Table
mailjob 0 4 19 46 Table
orderstatus_objectgroup 0 2 2 0 Table
productsalecondition 0 3 7 3 Table
customformgrid_customergroup 0 2 2 0 Table
user_client 0 2 2 5 Table
shipping_saleschannel 0 2 2 3 Table
shirtnetworkproductviewobject 2 1 19 169 Table
vendorinformation 1 2 30 10 Table
amazonexportstatus 0 2 7 0 Table
csvexport 3 2 13 8 Table
report 12 3 31 62 Table
attribute_client 0 2 2 105 Table
storeseourl 0 1 11 332 Table
timetracking 0 4 8 16 Table
vendororder_objectgroup 0 2 2 0 Table
expedition 2 10 55 8 Table
customformaction 3 2 16 218 Table
cashreportitem 1 4 23 5903 Table
virtualentity 0 0 2 0 Table
ordermetafield 0 3 6 0 Table
shippingcost_category 0 2 2 0 Table
voucherserie 8 3 20 602 Table
productmedia 0 1 9 17 Table
commissioncontractitem 1 2 12 74 Table
csvexportfield 0 1 5 88 Table
check24job 0 1 5 0 Table
shipping_product 0 2 2 1 Table
subscriptioncontract 5 8 35 22 Table
oneclientvalue 1 0 4 78 Table
document_objectgroup 0 2 2 0 Table
customform_objectgroup 0 2 2 0 Table
document 7 1 18 53 Table
customformgrid_usergroupcanadditems 0 2 2 0 Table
attribute_objectgroup 0 2 2 0 Table
csvexportfilter 3 2 4 5 Table
vendororderitemmetafield 0 3 6 55 Table
category_objectgroup 0 2 2 0 Table
customergroup 21 0 11 32 Table
contactmessage 1 5 16 343 Table
manufacturermetafield 0 3 6 211 Table
contractgroup 2 1 5 3 Table
shirtnetworkproductviewobjectlogo 0 1 8 119 Table
ean 0 2 4 518 Table
realstockjob 0 2 5 289 Table
customer_customergroup 0 2 2 1813 Table
statemetafield 0 3 6 0 Table
materialpicklist 2 1 4 29 Table
csvimport 6 2 33 52 Table
warehousestoragelocation 17 6 35 65 Table
user_usergroup 0 2 2 5 Table
payment_excludedclient 0 2 2 2 Table
customformgrid_objectgroup 0 2 2 0 Table
inventory_warehouse 0 2 2 128 Table
posterminalmodel 1 0 8 1 Table
storecache 0 1 5 0 Table
realproductjob 0 2 4 0 Table
productpicturemetafield 0 3 6 0 Table
expeditionitem 0 2 41 9 Table
import 0 1 4 7 Table
liabilityupload 0 1 5 3 Table
clientvalue 1 2 4 1139 Table
order_objectgroup 0 2 2 70 Table
warehousestoragelocation_boxforuser 0 2 2 2 Table
goexpress 0 1 5 21 Table
ottojob 0 1 5 0 Table
customformgridaction 3 3 20 2081 Table
objectpool 1 0 3 2 Table
offerupload 0 1 5 8 Table
user_excludedpage 0 2 2 39 Table
storemenu 1 6 37 32 Table
workflow_client 0 2 2 0 Table
publickey 6 0 5 104 Table
tablesheme 1 0 3 19 Table
manufacturer 6 1 8 185 Table
customform_customergroup 0 2 2 0 Table
payment_excludedproduct 0 2 2 0 Table
vendorcontact 0 1 12 1 Table
workflowactioncondition 0 1 4 94 Table
hbci_order 0 2 2 8 Table
amazonasinjob 0 2 4 0 Table
voucherserie_objectgroup 0 2 2 0 Table
product_category 0 2 2 13514 Table
storemenu_customergroup 0 2 2 0 Table
workflow 5 1 8 192 Table
warehouse_objectgroup 0 2 2 0 Table
tsenonfiskaltransaction 0 0 7 127 Table
contact 5 7 23 151 Table
ebayjob 0 1 5 1 Table
manufacturer_client 0 2 2 226 Table
orderbuyinglist 3 1 5 31 Table
product_objectgroup 0 2 2 0 Table
categoryaccessory 0 2 10 5 Table
tax 5 1 7 56 Table
productoptionfield 2 1 10 384 Table
reservednumber 0 0 2 4498 Table
accountsystemitem 2 1 6 2050 Table
report_objectgroup 0 2 2 0 Table
payment_onlycategory 0 2 2 1 Table
user_excludedroute 0 2 2 3 Table
warehousedimensions 1 0 17 3 Table
inventorylocation 1 2 3 182 Table
shirtnetworkproductviewobjecttext 0 1 7 50 Table
productmaterial 0 2 5 36 Table
reportcondition 0 1 8 50 Table
shippingpackage_excludedproduct 0 2 2 0 Table
product_saleschannel 0 2 2 5439 Table
ecreportitem 0 5 23 511 Table
customergroup_voucherserie 0 2 2 1 Table
discount 9 1 21 22 Table
usergroup 10 0 6 4 Table
saleschannel 10 1 5 19 Table
grantedpage 2 0 3 73 Table
amazonjob 0 2 6 15 Table
workflowactionparametervalue 0 1 4 1030 Table
realsendorderjob 0 2 4 0 Table
deletedentity 0 1 5 4204 Table
documentmetafield 0 3 6 41 Table
pluginsettings 1 1 9 532 Table
subscriptioncontractitem 2 2 10 26 Table
grantedroute 2 0 3 497 Table
vendororder_report 0 2 2 1 Table
banknote 1 1 3 19 Table
productoption_client 0 2 2 57 Table
shirtnetworkproductview 1 1 7 5139 Table
content 12 1 12 67 Table
payment_objectgroup 0 2 2 0 Table
customformaction_usergroup 0 2 2 0 Table
shipping_excludedcountry 0 2 2 0 Table
shirtnetworkprintjob 0 2 7 40 Table
content_objectgroup 0 2 2 0 Table
product_voucherserie 0 2 2 5662 Table
category_discount 0 2 2 4 Table
plugin 1 0 5 21 Table
shipping_payment 0 2 2 2 Table
customform_customformgrid 0 2 2 1734 Table
discountaccessory 0 2 8 4 Table
user_posterminal 0 2 2 0 Table
product_report 0 2 2 22 Table
clientdocument 0 3 10 10 Table
orderpayment 0 3 15 11746 Table
vendor 10 2 11 20 Table
contactmessageattachment 0 1 6 40 Table
paymentmetafield 0 3 6 279 Table
retailstore_cashlesspayment 0 2 2 0 Table