Tables


SchemaSpy Analysis of wawi_dev

Generated on Tue Mar 19 11:12 CET 2024

XML Representation
Insertion Order Deletion Order
TABLES 485
VIEWS 0
COLUMNS 4274
Constraints 1051
Anomalies 23
Routines 0

Database Properties

Database Type: MySQL - 5.5.5-10.5.23-MariaDB-0+deb11u1

Tables

Table / View Children Parents Columns Rows Type Comments
manufacturerupload 0 1 5 9 Table
amazonstockjob 0 2 5 197 Table
vendorconditions 2 5 18 19 Table
usermessagechannel_user 0 2 2 21 Table
banknotecount 0 2 5 8028 Table
orderreturnreason 1 0 4 8 Table
gls 0 1 8 3 Table
amazonorderadjustmentjob 0 3 5 4 Table
pictures 0 0 3 0 Table
orderbuyinglistitem 0 2 5 84 Table
returntrackinginfo 0 1 4 8 Table
customergroupmetafield 0 3 6 40 Table
csvimport_objectgroup 0 2 2 1 Table
manufacturer_objectgroup 0 2 2 0 Table
shippingcost 9 1 19 17 Table
customer_adviser 0 2 2 2 Table
orderremind 0 1 7 613 Table
clientvalue_oneclientvalue 0 2 2 5 Table
intraship 0 1 9 700 Table
user_grantedwidget 0 2 2 8 Table
workflowaction 2 1 3 464 Table
customform_user 0 2 2 0 Table
country_discount 0 2 2 1 Table
productstock 0 2 10 6858 Table
posterminal 6 4 27 10 Table
customformgrid_usergroupcanaddcolumns 0 2 2 0 Table
workflowevent 3 0 9 93 Table
paypaltransaction 0 3 14 861 Table
orderpaymentcondition 1 2 14 139 Table
liabilitypayment 0 2 8 135 Table
ottostockjob 0 2 6 2 Table
orderreturn 2 2 7 689 Table
categorymetafield 0 3 6 15735 Table
ebayproductjob 0 2 5 137 Table
customformgridcondition 0 1 8 49 Table
customformfield_excludeduser 0 2 2 6 Table
customermetafield 0 3 6 374 Table
shippingcost_country 0 2 2 20 Table
shippingmetafield 0 3 6 2876 Table
user_posterminalprice 0 2 2 0 Table
desktopdownloadjob 0 2 8 319 Table
ebaycategory 0 0 5 22736 Table
productoptionmetafield 0 3 6 47 Table
dhlexpress 0 1 7 17 Table
hermes 0 1 4 1 Table
storeregistrationtoken 0 1 4 0 Table
vendorordermetafield 0 3 6 2 Table
orderpicking 1 3 7 7437 Table
user_grantedpage 0 2 2 21 Table
liabilityitem 1 4 30 1708 Table
shippingpackage 5 1 7 7 Table
store 11 3 31 4 Table
storelogintoken 0 1 4 0 Table
vendororderitemdelivery 2 7 14 36717 Table
ecreport 3 3 9 459 Table
attributemetafield 0 3 6 269 Table
vendororderdelivery 3 7 18 9812 Table
reportcolumn 0 2 15 514 Table
product_customergroup 0 2 2 269 Table
inventorylocationitem 0 3 7 888 Table
country 27 1 15 254 Table
inventory 2 3 16 225 Table
product 85 13 136 66084 Table
warehouse_user 0 2 2 0 Table
workflow_crossclient 0 2 2 0 Table
attribute 5 1 10 108 Table
shippingcost_saleschannel 0 2 2 9 Table
contact_user 0 2 2 5 Table
customformgridaction_usergroup 0 2 2 0 Table
customform_usergroup 0 2 2 0 Table
ebaycloseofferjob 0 1 3 0 Table
invoiceledger 1 1 4 15 Table
productlicense 0 4 12 4 Table
realinvoicejob 0 2 4 0 Table
orderstatus 2 1 10 85 Table
csvimportvariationfield 0 1 6 12 Table
shipping_category 0 2 2 0 Table
discount_client 0 2 2 27 Table
voucherserie_client 0 2 2 1143 Table
workflowcondition 0 1 4 83 Table
offer_report 0 2 2 0 Table
commissionitem 0 2 6 0 Table
payment_user 0 2 2 4 Table
customformfield_customergroup 0 2 2 0 Table
state 8 1 8 89 Table
storebanner 0 5 17 2 Table
lockobject 0 0 5 29 Table
workflowactionjob 0 3 9 0 Table
customformgridaction_customergroup 0 2 2 0 Table
liabilitypaymentfield 0 2 5 648 Table
printjob 0 4 18 285 Table
customer_report 0 2 2 2 Table
product_crosssellingproduct 0 2 2 3 Table
currency 6 0 6 8 Table
reportjob 0 2 6 0 Table
orderinternalcomment 0 2 7 73 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 3 Table
product_discount 0 2 2 2996 Table
realstornojob 0 2 4 0 Table
commissionupload 0 1 5 0 Table
customersession 0 2 4 16 Table
customercontact 0 1 13 2 Table
warehouse_excludedclient 0 2 2 2 Table
customformaction_customergroup 0 2 2 0 Table
commissioncontract_order 0 2 2 23 Table
accountbooking 2 8 132 6280 Table
languagemetafield 0 3 6 4 Table
shippingcost_excludedproduct 0 2 2 2 Table
customformgrid_crossclient 0 2 2 0 Table
export 0 1 3 0 Table
grantedwidget 2 0 3 851 Table
amazontransaction 0 2 11 16616 Table
ebaystockjob 0 2 5 67 Table
reportrow 1 2 9 2 Table
productoptionmaterialquantity 0 2 5 4 Table
productaccessory 0 2 10 5 Table
payment_excludedcategory 0 2 2 1 Table
order_report 0 2 2 6416 Table
csvimportkeyfield 0 1 5 0 Table
productmediametafield 0 3 6 0 Table
ups 0 1 5 22 Table
customer 46 14 81 2135 Table
offerpaymentfield 0 2 5 3738 Table
csvrow 0 1 7 0 Table
wawilistener 2 0 4 3 Table
cashreport 6 6 22 463 Table
customergroup_discount 0 2 2 6 Table
customform 12 2 45 4300 Table
retailstore_crossclient 0 2 2 3 Table
customformaction_user 0 2 2 0 Table
language 12 1 7 52 Table
warehousebooking 0 7 19 88213 Table
securetoken 0 0 2 208 Table
fedex 0 1 6 2 Table
offeritemmetafield 0 3 6 2597 Table
categorycountrytax 0 3 4 6 Table
orderpickingitem 0 4 7 8669 Table
category_voucherserie 0 2 2 1 Table
usersession 0 1 3 16 Table
product_client 0 2 2 72883 Table
customerupload 0 1 5 9 Table
vendorproduct 1 2 29 2460 Table
liability_vendororder 0 2 2 14 Table
product_option 0 2 2 115 Table
contentemailattachment_client 0 2 2 2 Table
picklistitem 1 4 9 7774 Table
retailstore_warehouse 0 2 2 5 Table
dpd 0 1 9 41 Table
users 69 2 23 20 Table
customformgrid_usercanaddcolumns 0 2 2 4 Table
payment_excludedcustomergroup 0 2 2 0 Table
offeritem 13 14 71 40669 Table
arriva 0 1 7 1 Table
customformfield_user 0 2 2 30 Table
csvimportjob 0 2 6 0 Table
productpicture 1 1 8 189373 Table
picklistreservation_orders 0 2 2 0 Table
discountaccessory_customergroup 0 2 2 2 Table
category 29 4 41 6440 Table
shipping_excludedcategory 0 2 2 0 Table
ext_translations 0 0 6 201752 Table
payment_customergroup 0 2 2 0 Table
webshopexportjob 0 1 8 0 Table
ottobrand 0 0 3 39431 Table
webshopimportjob 0 1 8 0 Table
shippingcost_product 0 2 2 1 Table
customform_crossclient 0 2 2 2 Table
shirtnetworkproduct 1 2 19 145 Table
shippingpackage_excludedcategory 0 2 2 0 Table
client 142 3 143 25 Table
commission 2 2 6 0 Table
usermetafield 0 3 6 1 Table
productoption 6 2 7 59 Table
customer_crossclient 0 2 2 5 Table
ottotask 0 1 6 5 Table
countrymetafield 0 3 6 35 Table
customformgrid_user 0 2 2 0 Table
amazonbrowsenode 0 0 3 20382 Table
shipping_excludedproduct 0 2 2 3 Table
commissioncontractpaymentfield 0 2 5 80 Table
productstatistics 0 2 16 25929 Table
offeritemoptionfield 0 2 4 0 Table
liability_objectgroup 0 2 2 1 Table
storesession 0 2 4 2 Table
contact_customer 0 2 2 23 Table
entitylog 0 1 8 161708 Table
orders 42 19 81 23452 Table
payment_excludedcountry 0 2 2 0 Table
commissioncontract 8 6 21 48 Table
warehouse_excludeduser 0 2 2 1 Table
category_report 0 2 2 2 Table
ottocategory 0 0 4 14294 Table
warehouse 18 3 28 28 Table
product_cachedrootcategory 0 2 2 0 Table
tse 0 0 11 2 Table
store_disabledwidgets 0 2 2 0 Table
customer_discount 0 2 2 3 Table
shippingcost_excludedcategory 0 2 2 2 Table
vendororderupload 0 1 5 2 Table
usermessagechannel 2 0 4 10 Table
warehousebox 0 1 6 0 Table
printprotocol 0 0 4 684 Table
script 0 0 3 107 Table
commissioncontractupload 0 1 5 2 Table
category_customergroup 0 2 2 7 Table
realcategory 0 0 4 5531 Table
orderrefund 0 2 12 832 Table
address 1 3 23 41 Table
voucherserieaccessory 0 2 8 2 Table
usermessage 0 3 7 180 Table
product_objectpool 0 2 2 0 Table
amazonprime 0 1 3 0 Table
currencymetafield 0 3 6 3 Table
objectgroupitem 0 0 2 0 Table
vendormetafield 0 3 6 13 Table
vendor_client 0 2 2 60 Table
storefeedback 0 2 6 9 Table
vendorordersubmissionitemdelivery 0 6 12 330 Table
klarnatransaction 0 4 22 2659 Table
customergroup_objectgroup 0 2 2 1 Table
csvexportjob 0 2 6 0 Table
subscriptioncontractupload 0 1 5 0 Table
payonetransaction 0 2 13 0 Table
productcountrytax 0 3 4 1 Table
csvimportfield 0 2 10 398 Table
shipping_objectgroup 0 2 2 0 Table
store_fullpagecachingcontent 0 2 2 0 Table
productcustomercondition 0 2 5 1 Table
posterminal_user 0 2 2 16 Table
customformgrid_usergroupcanremoveitems 0 2 2 0 Table
productcomment 0 2 8 0 Table
user_objectgroup 0 2 2 1 Table
saleschannel_warehouse 0 2 2 0 Table
entitystatus 9 0 5 17 Table
order_pickingwarehouse 0 2 2 6 Table
product_storagelocations 0 2 2 857 Table
payment 33 0 20 47 Table
shippingcost_excludedcustomergroup 0 2 2 0 Table
customformgridaction_user 0 2 2 0 Table
client_orderdocument 0 2 2 1 Table
realjob 0 1 5 0 Table
shipping_excludedpayment 0 2 2 0 Table
attributevalue 0 2 6 8036 Table
customformfield_usergroup 0 2 2 1 Table
customform_usergroupcansave 0 2 2 0 Table
ottoattribute 0 0 3 6859 Table
invoiceledgeritem 0 4 18 707 Table
customformgrid 16 2 41 1089 Table
objectgroup 28 0 10 10 Table
retailstore 5 2 13 5 Table
vendororder 8 13 77 518 Table
productoption_objectgroup 0 2 2 0 Table
liability 11 12 74 242 Table
shippingcost_excludedcountry 0 2 2 0 Table
clientsheme 27 2 18 9934 Table
downloadjob 0 0 4 3 Table
productstockcondition 0 2 11 3 Table
user_inversedobjectgroup 0 2 2 0 Table
trackinginfo 0 1 5 145 Table
customformgrid_usergroup 0 2 2 0 Table
productprice 0 4 10 68 Table
counter 0 1 4 4 Table
productoptionmaterial 0 2 4 16 Table
user_grantedroute 0 2 2 10 Table
offer 28 16 129 26110 Table
payment_product 0 2 2 0 Table
costcenter 5 0 3 1 Table
productserialnumber 10 2 12 548 Table
shipping 21 1 24 58 Table
banknotecountprotocol 2 3 9 487 Table
picklistreservation 1 5 14 0 Table
reportitem 0 1 3 0 Table
commissioncontract_objectgroup 0 2 2 0 Table
openaipromptset 0 0 7 2 Table
shipping_country 0 2 2 3 Table
voucherreportitem 0 4 21 444 Table
maillog 0 2 9 11710 Table
avocadocategory 0 0 3 825 Table
storewidget 1 0 3 16 Table
store_seocachedcontent 0 2 2 0 Table
offer_objectgroup 0 2 2 0 Table
warehouse_client 0 2 2 30 Table
productindex 1 0 33 42 Table
contentcategory 2 1 5 5 Table
clientcontent 0 2 4 7 Table
paymentfield 4 1 5 10 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 53 Table
discountaccessory_excludedcustomergroup 0 2 2 1 Table
voucher 2 8 21 5082 Table
webshopproductexportjob 0 2 4 137 Table
client_returnwarehouse 0 2 2 0 Table
vendororderitem 4 4 27 959 Table
offermetafield 0 3 6 20758 Table
materialpicklistitem 0 4 9 59 Table
user_excludedwidget 0 2 2 8 Table
amazonordersendjob 0 2 4 0 Table
customformfield 4 4 70 47147 Table
shippingpackage_category 0 2 2 0 Table
product_attribute 0 2 2 0 Table
retailstore_payment 0 2 2 2 Table
vendorproductscaleprice 0 1 7 1504 Table
posterminal_priceuser 0 2 2 0 Table
taxmetafield 0 3 6 1643 Table
workflow_objectgroup 0 2 2 0 Table
picklist 3 1 4 6751 Table
orderreturnitem 0 11 15 964 Table
accountsystem 2 0 3 3 Table
shipping_excludedcustomergroup 0 2 2 0 Table
cashjournal 4 3 8 10 Table
payment_category 0 2 2 0 Table
scaleprice 0 4 14 254 Table
subscriptioncontract_objectgroup 0 2 2 0 Table
client_pickingwarehouse 0 2 2 1 Table
shippingpackage_product 0 2 2 3 Table
discount_saleschannel 0 2 2 2 Table
amazoninvoicejob 0 2 4 1 Table
shipping_customergroup 0 2 2 0 Table
hbci 1 4 18 1591 Table
contentemailattachment 1 1 5 7 Table
productmetafield 0 3 6 169977 Table
ebayorderjob 0 2 5 0 Table
dhlreturn 0 1 8 796 Table
customer_voucherserie 0 2 2 53 Table
payment_saleschannel 0 2 2 4 Table
contactmetafield 0 3 6 2 Table
csvexportfilterrule 0 1 5 6 Table
store_nonpubliccontent 0 2 2 0 Table
voucherreport 3 3 9 459 Table
discount_objectgroup 0 2 2 0 Table
category_client 0 2 2 6673 Table
vendorconditiondiscount 0 1 4 2 Table
payment_country 0 2 2 3 Table
mailjob 0 4 19 16 Table
productsalecondition 0 3 7 12 Table
orderstatus_objectgroup 0 2 2 1 Table
user_client 0 2 2 7 Table
customformgrid_customergroup 0 2 2 0 Table
shipping_saleschannel 0 2 2 3 Table
shirtnetworkproductviewobject 2 1 19 180 Table
vendorinformation 1 2 30 20 Table
amazonexportstatus 0 3 8 0 Table
csvexport 3 2 13 8 Table
report 12 3 34 94 Table
storeseourl 0 1 11 355 Table
attribute_client 0 2 2 158 Table
timetracking 0 4 12 28 Table
vendororder_objectgroup 0 2 2 0 Table
expedition 2 10 55 13 Table
customformaction 3 2 16 407 Table
cashreportitem 1 4 23 8284 Table
virtualentity 0 0 2 0 Table
ordermetafield 0 3 6 0 Table
shippingcost_category 0 2 2 1 Table
voucherserie 8 3 22 717 Table
productmedia 1 1 9 30 Table
commissioncontractitem 1 2 13 96 Table
csvexportfield 0 1 5 88 Table
check24job 0 1 5 0 Table
shipping_product 0 2 2 0 Table
subscriptioncontract 5 8 36 26 Table
oneclientvalue 1 0 4 116 Table
document_objectgroup 0 2 2 0 Table
customform_objectgroup 0 2 2 0 Table
document 7 1 20 61 Table
customformgrid_usergroupcanadditems 0 2 2 0 Table
attribute_objectgroup 0 2 2 0 Table
vendororderitemmetafield 0 3 6 109 Table
csvexportfilter 3 2 4 5 Table
category_objectgroup 0 2 2 0 Table
customergroup 24 0 11 43 Table
manufacturermetafield 0 3 6 265 Table
contactmessage 1 5 16 408 Table
contractgroup 2 1 5 4 Table
shirtnetworkproductviewobjectlogo 0 1 8 128 Table
ean 0 2 4 518 Table
realstockjob 0 2 5 134 Table
customer_customergroup 0 2 2 2435 Table
statemetafield 0 3 6 0 Table
materialpicklist 2 1 4 44 Table
ottoproductjob 0 2 4 0 Table
csvimport 6 2 36 69 Table
warehousestoragelocation 17 6 35 70 Table
user_usergroup 0 2 2 5 Table
payment_excludedclient 0 2 2 2 Table
inventory_warehouse 0 2 2 169 Table
posterminalmodel 1 0 8 2 Table
customformgrid_objectgroup 0 2 2 0 Table
storecache 0 1 5 0 Table
realproductjob 0 2 4 0 Table
productpicturemetafield 0 3 6 0 Table
import 0 1 4 9 Table
expeditionitem 0 2 41 11 Table
liabilityupload 0 1 5 5 Table
clientvalue 1 2 4 1189 Table
order_objectgroup 0 2 2 75 Table
warehousestoragelocation_boxforuser 0 2 2 2 Table
ottojob 0 1 5 0 Table
goexpress 0 1 5 23 Table
objectpool 1 0 3 1 Table
customformgridaction 3 3 21 4952 Table
offerupload 0 1 5 20 Table
user_excludedpage 0 2 2 39 Table
storemenu 1 6 37 33 Table
workflow_client 0 2 2 0 Table
publickey 6 0 5 473 Table
tablesheme 1 0 3 26 Table
manufacturer 6 1 8 253 Table
customform_customergroup 0 2 2 0 Table
payment_excludedproduct 0 2 2 0 Table
workflowactioncondition 0 1 4 121 Table
vendorcontact 0 1 13 3 Table
hbci_order 0 2 2 0 Table
amazonasinjob 0 2 4 0 Table
voucherserie_objectgroup 0 2 2 0 Table
product_category 0 2 2 14128 Table
storemenu_customergroup 0 2 2 0 Table
amazonpaytransaction 0 2 17 47 Table
workflow 5 1 8 293 Table
warehouse_objectgroup 0 2 2 1 Table
tsenonfiskaltransaction 0 0 7 405 Table
contact 6 7 26 209 Table
ebayjob 0 1 5 1 Table
manufacturer_client 0 2 2 309 Table
orderbuyinglist 3 1 5 75 Table
product_objectgroup 0 2 2 0 Table
tax 6 1 7 62 Table
categoryaccessory 0 2 10 4 Table
productoptionfield 2 1 10 399 Table
reservednumber 0 0 2 10944 Table
accountsystemitem 2 1 6 2086 Table
report_objectgroup 0 2 2 0 Table
payment_onlycategory 0 2 2 1 Table
user_excludedroute 0 2 2 4 Table
warehousedimensions 1 0 17 14 Table
inventorylocation 1 2 3 210 Table
shirtnetworkproductviewobjecttext 0 1 7 52 Table
productmaterial 0 2 5 45 Table
reportcondition 0 1 8 73 Table
shippingpackage_excludedproduct 0 2 2 0 Table
product_saleschannel 0 2 2 6230 Table
ecreportitem 0 5 23 662 Table
customergroup_voucherserie 0 2 2 1 Table
discount 9 1 22 26 Table
usergroup 10 0 6 5 Table
saleschannel 10 1 5 19 Table
grantedpage 2 0 3 96 Table
amazonjob 0 2 6 197 Table
workflowactionparametervalue 0 1 4 1338 Table
realsendorderjob 0 2 4 0 Table
deletedentity 0 1 5 6045 Table
subscriptioncontractitem 2 2 10 32 Table
pluginsettings 1 1 9 782 Table
documentmetafield 0 3 6 61 Table
grantedroute 2 0 3 545 Table
vendororder_report 0 2 2 1 Table
banknote 1 1 3 22 Table
productoption_client 0 2 2 73 Table
shirtnetworkproductview 1 1 7 5680 Table
content 12 1 13 78 Table
payment_objectgroup 0 2 2 0 Table
customformaction_usergroup 0 2 2 1 Table
shipping_excludedcountry 0 2 2 0 Table
shirtnetworkprintjob 0 2 7 51 Table
content_objectgroup 0 2 2 0 Table
product_voucherserie 0 2 2 5256 Table
category_discount 0 2 2 4 Table
plugin 1 0 5 49 Table
shipping_payment 0 2 2 2 Table
usergoogleauthenticator 0 1 6 2 Table
customform_customformgrid 0 2 2 3549 Table
user_posterminal 0 2 2 0 Table
discountaccessory 2 2 9 5 Table
product_report 0 2 2 26 Table
clientdocument 0 3 11 13 Table
orderpayment 0 3 18 10554 Table
vendor 10 2 12 25 Table
contactmessageattachment 0 1 6 43 Table
paymentmetafield 0 3 6 345 Table
retailstore_cashlesspayment 0 2 2 1 Table