Tables


SchemaSpy Analysis of wawi_dev

Generated on Mon Dec 16 16:13 CET 2019

XML Representation
Insertion Order Deletion Order
TABLES 405
VIEWS 0
COLUMNS 3219
Constraints 848
Anomalies 10
Routines 0

Database Properties

Database Type: MySQL - 5.7.28-1

Tables

Table / View Children Parents Columns Rows Type Comments
amazonstockjob 0 2 5 43 Table
vendorconditions 2 2 14 5 Table
banknotecount 0 2 5 2495 Table
orderreturnreason 1 0 3 7 Table
usermessagechannel_user 0 2 2 7 Table
gls 0 1 6 3 Table
amazonorderadjustmentjob 0 3 5 0 Table
pictures 0 0 3 0 Table
orderbuyinglistitem 0 2 5 39 Table
customergroupmetafield 0 3 6 6 Table
csvimport_objectgroup 0 2 2 1 Table
manufacturer_objectgroup 0 2 2 0 Table
shippingcost 9 1 18 9 Table
customer_adviser 0 2 2 0 Table
clientvalue_oneclientvalue 0 2 2 9 Table
orderremind 0 1 7 304 Table
intraship 0 1 9 532 Table
user_grantedwidget 0 2 2 0 Table
workflowaction 2 1 3 210 Table
customform_user 0 2 2 0 Table
country_discount 0 2 2 1 Table
productstock 0 2 7 4747 Table
customformgrid_usergroupcanaddcolumns 0 2 2 0 Table
posterminal 4 4 25 7 Table
workflowevent 3 0 6 31 Table
paypaltransaction 0 1 10 289 Table
orderpaymentcondition 1 2 14 100 Table
liabilitypayment 0 2 8 79 Table
orderreturn 2 2 5 360 Table
categorymetafield 0 3 6 2247 Table
customformgridcondition 0 1 8 8 Table
customermetafield 0 3 6 96 Table
shippingcost_country 0 2 2 15 Table
shippingmetafield 0 3 6 946 Table
desktopdownloadjob 0 2 8 55 Table
ebaycategory 0 0 4 17573 Table
productoptionmetafield 0 3 6 22 Table
hermes 0 1 4 1 Table
storeregistrationtoken 0 1 4 0 Table
orderpicking 1 3 7 4947 Table
user_grantedpage 0 2 2 5 Table
liabilityitem 1 3 25 1406 Table
shippingpackage 5 1 7 4 Table
store 11 3 25 2 Table
storelogintoken 0 1 4 0 Table
vendororderitemdelivery 2 7 12 21632 Table
ecreport 3 3 9 194 Table
attributemetafield 0 3 6 84 Table
vendororderdelivery 2 6 14 6510 Table
reportcolumn 0 2 12 134 Table
product_customergroup 0 2 2 120 Table
inventorylocationitem 0 3 7 622 Table
country 25 1 12 254 Table
inventory 2 2 13 114 Table
product 65 10 107 51176 Table
warehouse_user 0 2 2 0 Table
attribute 5 1 7 54 Table
shippingcost_saleschannel 0 2 2 9 Table
contact_user 0 2 2 2 Table
customform_usergroup 0 2 2 0 Table
customformgridaction_usergroup 0 2 2 0 Table
invoiceledger 1 1 4 11 Table
productlicense 0 4 12 3 Table
orderstatus 2 1 9 60 Table
csvimportvariationfield 0 1 6 5 Table
discount_client 0 2 2 12 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 37 Table
commissionitem 0 2 6 0 Table
customformfield_customergroup 0 2 2 0 Table
state 8 1 8 73 Table
storebanner 0 4 16 2 Table
lockobject 0 0 5 0 Table
workflowactionjob 0 2 7 1 Table
customformgridaction_customergroup 0 2 2 0 Table
liabilitypaymentfield 0 2 5 215 Table
printjob 0 3 16 0 Table
customer_report 0 2 2 3 Table
currency 6 0 6 7 Table
reportjob 0 2 6 0 Table
internetmarke 0 1 5 15 Table
shippingcost_customergroup 0 2 2 0 Table
product_discount 0 2 2 8 Table
commissionupload 0 1 5 0 Table
customersession 0 2 4 0 Table
customercontact 0 1 12 1 Table
warehouse_excludedclient 0 2 2 1 Table
accountbooking 1 7 128 3097 Table
commissioncontract_order 0 2 2 20 Table
customformaction_customergroup 0 2 2 0 Table
languagemetafield 0 3 6 0 Table
shippingcost_excludedproduct 0 2 2 1 Table
grantedwidget 2 0 3 378 Table
export 0 1 3 0 Table
ebaystockjob 0 2 5 24 Table
reportrow 1 2 9 0 Table
productoptionmaterialquantity 0 2 5 4 Table
productaccessory 0 2 8 4 Table
payment_excludedcategory 0 2 2 0 Table
order_report 0 2 2 2276 Table
csvimportkeyfield 0 1 5 0 Table
customer 31 12 72 1866 Table
csvrow 0 1 7 0 Table
offerpaymentfield 0 2 5 1271 Table
wawilistener 2 0 4 1 Table
cashreport 6 5 14 282 Table
customergroup_discount 0 2 2 2 Table
customform 11 1 23 57 Table
retailstore_crossclient 0 2 2 2 Table
customformaction_user 0 2 2 0 Table
language 11 1 7 17 Table
warehousebooking 0 6 18 65566 Table
offeritemmetafield 0 3 6 1243 Table
securetoken 0 0 2 122 Table
categorycountrytax 0 3 4 2 Table
orderpickingitem 0 4 6 5945 Table
category_voucherserie 0 2 2 0 Table
usersession 0 1 3 9 Table
product_client 0 2 2 53309 Table
customerupload 0 1 5 1 Table
vendorproduct 1 2 18 2114 Table
liability_vendororder 0 2 2 8 Table
product_option 0 2 2 107 Table
contentemailattachment_client 0 2 2 0 Table
picklistitem 0 4 9 4822 Table
retailstore_warehouse 0 2 2 2 Table
dpd 0 1 8 2 Table
users 49 2 23 15 Table
customformgrid_usercanaddcolumns 0 2 2 4 Table
payment_excludedcustomergroup 0 2 2 0 Table
offeritem 8 11 57 27933 Table
csvimportjob 0 2 6 0 Table
customformfield_user 0 2 2 0 Table
productpicture 0 1 6 158972 Table
category 25 3 24 137 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 0 Table
webshopimportjob 0 1 8 0 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 108 3 94 10 Table
commission 2 2 6 0 Table
usermetafield 0 3 6 0 Table
customer_crossclient 0 2 2 2 Table
productoption 6 2 7 47 Table
countrymetafield 0 3 6 29 Table
customformgrid_user 0 2 2 0 Table
shipping_excludedproduct 0 2 2 3 Table
commissioncontractpaymentfield 0 2 5 47 Table
productstatistics 0 2 8 10912 Table
liability_objectgroup 0 2 2 0 Table
storesession 0 2 4 0 Table
contact_customer 0 2 2 12 Table
entitylog 0 1 7 50559 Table
orders 29 17 62 18076 Table
payment_excludedcountry 0 2 2 0 Table
commissioncontract 8 6 18 39 Table
warehouse_excludeduser 0 2 2 0 Table
category_report 0 2 2 2 Table
warehouse 15 3 24 18 Table
store_disabledwidgets 0 2 2 0 Table
customer_discount 0 2 2 2 Table
shippingcost_excludedcategory 0 2 2 0 Table
usermessagechannel 2 0 4 3 Table
warehousebox 0 1 6 0 Table
printprotocol 0 0 4 17 Table
commissioncontractupload 0 1 5 0 Table
script 0 0 3 9 Table
realcategory 0 0 4 5324 Table
address 1 3 20 20 Table
orderrefund 0 2 9 244 Table
voucherserieaccessory 0 2 8 2 Table
usermessage 0 3 7 48 Table
amazonprime 0 1 3 0 Table
currencymetafield 0 3 6 0 Table
objectgroupitem 0 0 2 0 Table
vendor_client 0 2 2 13 Table
storefeedback 0 2 6 9 Table
csvexportjob 0 2 6 0 Table
subscriptioncontractupload 0 1 5 0 Table
productcountrytax 0 3 4 1 Table
csvimportfield 0 2 9 141 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 1 Table
saleschannel_warehouse 0 2 2 0 Table
entitystatus 6 0 5 8 Table
product_storagelocations 0 2 2 314 Table
payment 31 0 18 28 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 3169 Table
customformfield_usergroup 0 2 2 0 Table
customform_usergroupcansave 0 2 2 0 Table
invoiceledgeritem 0 4 18 559 Table
customformgrid 14 2 25 18 Table
objectgroup 27 0 3 5 Table
retailstore 5 2 13 3 Table
vendororder 6 10 56 212 Table
productoption_objectgroup 0 2 2 0 Table
liability 10 11 66 122 Table
shippingcost_excludedcountry 0 2 2 0 Table
clientsheme 19 2 13 1000 Table
downloadjob 0 0 4 0 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 29 Table
productoptionmaterial 0 2 4 13 Table
user_grantedroute 0 2 2 2 Table
offer 21 14 106 17514 Table
payment_product 0 2 2 0 Table
productserialnumber 7 1 6 104 Table
shipping 19 1 23 38 Table
banknotecountprotocol 2 3 9 262 Table
reportitem 0 1 3 0 Table
commissioncontract_objectgroup 0 2 2 0 Table
shipping_country 0 2 2 0 Table
voucherreportitem 0 4 15 299 Table
maillog 0 2 9 687 Table
storewidget 1 0 3 6 Table
store_seocachedcontent 0 2 2 0 Table
contentcategory 2 1 5 1 Table
offer_objectgroup 0 2 2 0 Table
productindex 1 0 11 0 Table
warehouse_client 0 2 2 13 Table
clientcontent 0 2 4 2 Table
paymentfield 4 1 5 8 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 2274 Table
vendororderitem 2 2 16 285 Table
offermetafield 0 3 6 9952 Table
user_excludedwidget 0 2 2 4 Table
customformfield 3 3 49 435 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 6 11 Table
taxmetafield 0 3 6 733 Table
workflow_objectgroup 0 2 2 0 Table
picklist 3 1 4 4908 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 3 9 111 Table
subscriptioncontract_objectgroup 0 2 2 0 Table
discount_saleschannel 0 2 2 0 Table
shippingpackage_product 0 2 2 1 Table
shipping_customergroup 0 2 2 0 Table
contentemailattachment 1 1 4 3 Table
hbci 0 4 17 5290 Table
productmetafield 0 3 6 27746 Table
dhlreturn 0 1 8 579 Table
customer_voucherserie 0 2 2 3 Table
payment_saleschannel 0 2 2 0 Table
csvexportfilterrule 0 1 5 6 Table
store_nonpubliccontent 0 2 2 0 Table
voucherreport 3 3 9 194 Table
discount_objectgroup 0 2 2 0 Table
category_client 0 2 2 130 Table
vendorconditiondiscount 0 1 4 0 Table
payment_country 0 2 2 0 Table
mailjob 0 4 19 0 Table
orderstatus_objectgroup 0 2 2 0 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 27 4 Table
amazonexportstatus 0 2 6 0 Table
csvexport 3 2 13 8 Table
report 12 2 21 31 Table
attribute_client 0 2 2 47 Table
storeseourl 0 1 10 321 Table
timetracking 0 4 8 14 Table
vendororder_objectgroup 0 2 2 0 Table
customformaction 3 2 10 6 Table
cashreportitem 1 4 19 5293 Table
virtualentity 0 0 2 0 Table
ordermetafield 0 3 6 0 Table
shippingcost_category 0 2 2 0 Table
voucherserie 8 2 18 469 Table
productmedia 0 1 9 15 Table
commissioncontractitem 1 2 12 74 Table
csvexportfield 0 1 5 88 Table
shipping_product 0 2 2 1 Table
subscriptioncontract 5 8 30 18 Table
oneclientvalue 1 0 4 31 Table
document_objectgroup 0 2 2 0 Table
customform_objectgroup 0 2 2 0 Table
document 7 0 11 46 Table
customformgrid_usergroupcanadditems 0 2 2 0 Table
attribute_objectgroup 0 2 2 0 Table
csvexportfilter 3 2 4 5 Table
category_objectgroup 0 2 2 0 Table
customergroup 18 0 7 26 Table
contactmessage 1 3 12 191 Table
manufacturermetafield 0 3 6 211 Table
contractgroup 2 1 4 1 Table
shirtnetworkproductviewobjectlogo 0 1 8 119 Table
ean 0 2 4 518 Table
realstockjob 0 2 5 31 Table
customer_customergroup 0 2 2 1168 Table
statemetafield 0 3 6 0 Table
csvimport 6 1 28 26 Table
warehousestoragelocation 9 4 27 49 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 99 Table
posterminalmodel 1 0 8 1 Table
storecache 0 1 5 0 Table
import 0 1 4 4 Table
liabilityupload 0 1 5 2 Table
clientvalue 1 2 4 509 Table
order_objectgroup 0 2 2 70 Table
customformgridaction 3 2 12 4 Table
offerupload 0 1 5 3 Table
user_excludedpage 0 2 2 0 Table
storemenu 0 6 34 16 Table
workflow_client 0 2 2 0 Table
publickey 5 0 5 104 Table
tablesheme 1 0 2 17 Table
manufacturer 4 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 42 Table
voucherserie_objectgroup 0 2 2 0 Table
product_category 0 2 2 2282 Table
workflow 4 1 7 113 Table
warehouse_objectgroup 0 2 2 0 Table
contact 4 6 20 87 Table
ebayjob 0 1 5 0 Table
manufacturer_client 0 2 2 184 Table
orderbuyinglist 3 1 5 31 Table
product_objectgroup 0 2 2 0 Table
categoryaccessory 0 2 8 0 Table
tax 5 1 5 8 Table
productoptionfield 1 1 9 240 Table
reservednumber 0 0 2 2316 Table
accountsystemitem 2 1 6 2050 Table
report_objectgroup 0 2 2 0 Table
payment_onlycategory 0 2 2 0 Table
user_excludedroute 0 2 2 0 Table
warehousedimensions 1 0 17 3 Table
inventorylocation 1 2 3 105 Table
shirtnetworkproductviewobjecttext 0 1 7 50 Table
productmaterial 0 2 4 15 Table
reportcondition 0 1 8 28 Table
shippingpackage_excludedproduct 0 2 2 0 Table
product_saleschannel 0 2 2 4321 Table
ecreportitem 0 5 19 457 Table
customergroup_voucherserie 0 2 2 0 Table
discount 9 1 18 11 Table
usergroup 10 0 4 2 Table
saleschannel 8 0 4 11 Table
grantedpage 2 0 3 73 Table
amazonjob 0 2 6 1 Table
workflowactionparametervalue 0 1 4 498 Table
deletedentity 0 1 5 2647 Table
documentmetafield 0 3 6 41 Table
pluginsettings 1 1 9 346 Table
subscriptioncontractitem 2 2 10 26 Table
grantedroute 2 0 3 497 Table
vendororder_report 0 2 2 1 Table
banknote 1 1 3 16 Table
productoption_client 0 2 2 47 Table
shirtnetworkproductview 1 1 7 5139 Table
content 9 1 8 41 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 4887 Table
category_discount 0 2 2 2 Table
plugin 1 0 5 21 Table
shipping_payment 0 2 2 2 Table
customform_customformgrid 0 2 2 8 Table
discountaccessory 0 2 8 0 Table
user_posterminal 0 2 2 0 Table
product_report 0 2 2 20 Table
clientdocument 0 3 8 9 Table
orderpayment 0 3 10 6997 Table
vendor 8 2 11 12 Table
contactmessageattachment 0 1 5 29 Table
paymentmetafield 0 3 6 279 Table
retailstore_cashlesspayment 0 2 2 0 Table