Tables


XML Representation
Insertion Order Deletion Order
TABLES 317
VIEWS 48
COLUMNS 3421
Constraints 517
Routines 4

Database Properties

Database Type: MySQL - 8.0.36

Tables

Table / View Children Parents Columns Type Comments
costlayer_aud 0 2 12 Table
pick 2 5 13 Table
postwoitem 0 2 10 Table
asaccount_aud 0 1 10 Table
carrier_aud 0 1 8 Table
inventorylogtocostlayer 0 2 4 Table
posttype 1 0 2 Table
so_aud 0 13 67 Table
kititem 2 8 18 Table
customerstatus 1 0 2 Table
shippingimport 0 0 8 Table
producttree_aud 0 1 6 Table
soitem_aud 0 6 35 Table
bomitem_aud 0 5 23 Table
bomtolocation_aud 0 3 6 Table
ship 23 12 30 Table
xotype 1 0 2 Table
xoitem_aud 0 4 19 Table
sostatus 1 0 2 Table
inventorylogtype 1 0 3 Table
cartontype_aud 0 1 10 Table
taxrate_aud 0 3 18 Table
dataexport 0 1 7 Table
pickitem 0 12 19 Table
usergrouprel 0 2 3 Table
parttype 2 0 2 Table
assocpricetype 1 1 5 Table
xoitem 4 5 17 Table
trackinginfosn 0 2 4 Table
carrierservice_aud 0 2 8 Table
mostatus 1 0 2 Table
woinstruction 0 2 13 Table
bireportaccess_aud 0 3 6 Table
calevent_aud 0 2 12 Table
accountgroup_aud 0 1 4 Table
wostatus 1 0 2 Table
bomitem 2 6 21 Table
trackinginfo 2 1 9 Table
kittype 2 0 2 Table
propertycategory 1 0 2 Table
calcategory_aud 0 1 9 Table
fbschedule_aud 0 2 21 Table
location 14 4 16 Table
quicklist 1 1 3 Table
integratedapp_aud 0 1 8 Table
postransaction 0 4 15 Table
parttracking 10 1 8 Table
parttracking_aud 0 1 10 Table
pickitemstatus 1 0 2 Table
receiptstatus 1 0 2 Table
watch 0 5 13 Table
customerparts_aud 0 3 10 Table
sysproperties_aud 0 1 8 Table
receiptitemstatus 1 0 2 Table
usergroup_aud 0 1 4 Table
pabaseamounttype 2 0 2 Table
useraccess 0 1 5 Table
wo_aud 0 6 24 Table
kitdisplaytype 1 0 2 Table
moitem 3 12 26 Table
tiinventorylogsn 0 2 4 Table
trackingdecimal 0 2 4 Table
so 18 19 66 Table
countryconst_aud 0 1 5 Table
moitemstatus 1 0 2 Table
product_aud 0 4 37 Table
usertolg_aud 0 1 6 Table
shipterms_aud 0 1 6 Table
partreorder 0 2 5 Table
serial 3 1 3 Table
reporttree_aud 0 1 7 Table
userproperties_aud 0 1 10 Table
pluginproperties 0 0 4 Table
pickitem_aud 0 7 21 Table
responsibility 2 0 2 Table
trackingtext_aud 0 2 6 Table
watch_aud 0 3 15 Table
bomitemgroup_aud 0 2 7 Table
receipt_aud 0 5 11 Table
trackinginteger_aud 0 2 6 Table
parttotracking 0 2 5 Table
picktype 1 0 2 Table
postwo 1 2 11 Table
rndtype 2 0 2 Table
shipcarton 1 3 19 Table
inventorylog 2 6 18 Table
kitoption 0 2 7 Table
itemadjust_aud 0 2 13 Table
integratedappstatus 1 0 2 Table
plugindata 0 0 5 Table
post 0 4 18 Table
productincltype 1 0 2 Table
priority 8 0 2 Table
serial_aud 0 2 5 Table
assocprice 0 2 4 Table
account 12 1 2 Table
shipitem 2 8 14 Table
patype 2 0 2 Table
postxo 1 2 11 Table
product 24 10 36 Table
poitem_aud 0 6 32 Table
uomconversion 0 2 6 Table
postransaction_aud 0 3 17 Table
register_aud 0 1 4 Table
serialnum_aud 0 2 6 Table
usergrouprel_aud 0 1 5 Table
xoitemstatus 1 0 2 Table
qbclass 22 0 8 Table
postpoitem 0 4 16 Table
paymenttype 1 0 2 Table
vendorparts 0 4 14 Table
asaccounttype 1 0 2 Table
orderhistory 0 2 8 Table
customfield 0 2 10 Table
memo_aud 0 1 8 Table
receiptitem 2 16 36 Table
sysproperties 0 0 7 Table
potype 1 0 2 Table
costlayerstatus 1 0 2 Table
receiptitem_aud 0 10 37 Table
woitem_aud 0 5 16 Table
bomitemtolocation 0 3 4 Table
reporttree 2 2 5 Table
shipterms 4 0 4 Table
accounttype 1 0 2 Table
sysuser 41 0 11 Table
trackingdate_aud 0 2 6 Table
kititemtype 1 0 2 Table
partcategory 0 0 3 Table
poitemstatus 1 0 2 Table
receipttype 1 0 2 Table
paymentmethod 4 2 6 Table
bireportaccess 0 2 4 Table
bomitemgroup 1 1 5 Table
customfieldtype 1 0 3 Table
rma_aud 0 2 11 Table
calcategory 9 1 8 Table
wo 8 9 23 Table
locationtype 1 0 2 Table
qbclass_aud 0 1 9 Table
locationgroup 20 1 5 Table
notificationtype 1 0 2 Table
objecttoobject 0 1 7 Table
postorderstatus 4 0 2 Table
currency 8 1 11 Table
paymentterms 6 1 14 Table
reporttomodule 0 2 3 Table
shipcarton_aud 0 4 21 Table
pricingrule 0 8 32 Table
paymentmethod_aud 0 1 8 Table
accountgrouprelation 0 2 3 Table
objecttoobjecttype 1 0 3 Table
quicklist_aud 0 2 5 Table
integratedapp 0 1 7 Table
partcost_aud 0 2 8 Table
report 6 3 11 Table
paymentterms_aud 0 1 15 Table
uom_aud 0 1 11 Table
partcosthistory 0 1 8 Table
uom 34 1 9 Table
trackinginfosn_aud 0 2 6 Table
xo 9 10 35 Table
reporttomodule_aud 0 2 5 Table
soitemtype 3 0 2 Table
stateconst 2 1 4 Table
biscript 2 0 11 Table
quicklistitem_aud 0 2 6 Table
pluginproperties_aud 0 1 6 Table
watchtype 1 0 2 Table
contact_aud 0 3 9 Table
uomtype 1 0 2 Table
issuablestatus 2 0 2 Table
trackinginteger 0 2 4 Table
plugininfo_aud 0 1 9 Table
pickitemtype 1 0 2 Table
carrier 18 0 6 Table
kitoption_aud 0 3 8 Table
reportparameter 0 1 4 Table
image 0 0 6 Table
locationgroup_aud 0 2 6 Table
moitem_aud 0 8 28 Table
woassignedusers_aud 0 2 5 Table
customer 22 13 33 Table
woitem 3 6 14 Table
serialnum 0 2 4 Table
memo 0 0 6 Table
report_aud 0 1 13 Table
customlist 2 0 3 Table
customerincltype 1 0 2 Table
register 2 0 2 Table
countryconst 4 0 3 Table
customlistitem_aud 0 1 6 Table
company 0 2 13 Table
itemadjusttype 1 0 2 Table
databaseversion 0 0 4 Table
tagtype 1 0 2 Table
costlayer 1 2 11 Table
pricingrule_aud 0 6 33 Table
poitemtype 2 0 2 Table
vendorcostrule 0 3 10 Table
parttotracking_aud 0 2 7 Table
fbscheduleactiontype 1 0 2 Table
trackingdate 0 2 4 Table
cartontype 1 0 8 Table
partcost 0 1 7 Table
bomtolocation 0 3 4 Table
itemadjust 3 4 11 Table
addresstype 1 0 2 Table
tablereference 0 0 5 Table
vendor_aud 0 5 26 Table
vendorstatus 1 0 2 Table
bomitemtolocation_aud 0 2 6 Table
fobpoint_aud 0 1 5 Table
bominstructionitem_aud 0 2 10 Table
customfield_aud 0 1 12 Table
dataexport_aud 0 1 8 Table
paymentgateway 0 0 8 Table
usertolg 0 2 4 Table
kititem_aud 0 5 19 Table
receipt 2 8 9 Table
po_aud 0 10 52 Table
receiptitemtype 1 0 2 Table
vendorparts_aud 0 4 15 Table
partreorder_aud 0 2 7 Table
woinstruction_aud 0 3 15 Table
reportparameter_aud 0 1 5 Table
rma 2 4 10 Table
tiinventorylog 1 2 8 Table
pickstatus 1 0 2 Table
rmaitem_aud 0 6 19 Table
poitem 4 9 30 Table
poststatus 1 0 2 Table
useraccess_aud 0 1 7 Table
postxoitem 0 2 9 Table
biscript_aud 0 1 12 Table
notification 0 3 5 Table
soitem 5 8 34 Table
customer_aud 0 7 34 Table
bomitemtype 3 0 2 Table
customlistitem 0 1 4 Table
postatus 1 0 2 Table
tag 25 4 14 Table
woassignedusers 0 2 3 Table
sysuser_aud 0 1 13 Table
customerparts 0 3 9 Table
xostatus 1 0 2 Table
currency_aud 0 1 12 Table
userlog 0 1 4 Table
paymenttermstype 1 0 2 Table
plugininfo 0 0 7 Table
contact 0 3 7 Table
assocprice_aud 0 2 6 Table
calevent 0 2 11 Table
xoitemtype 1 0 2 Table
shipitem_aud 0 5 15 Table
trackingtext 0 2 4 Table
trackinginfo_aud 0 1 11 Table
stateconst_aud 0 2 6 Table
bireport_aud 0 2 9 Table
objecttoobject_aud 0 1 9 Table
producttree 0 0 4 Table
fbschedule 2 3 20 Table
mo_aud 0 3 17 Table
asaccount 12 1 9 Table
postpo 1 2 13 Table
vendorcostrule_aud 0 3 11 Table
taxrate 17 4 17 Table
bom 11 4 18 Table
mo 4 5 16 Table
rmastatus 1 0 2 Table
rmaitem 0 6 17 Table
ordertype 16 0 2 Table
bireport 2 1 8 Table
fbschedulereportparameter 0 1 4 Table
quicklistitem 0 2 4 Table
rmaitemtype 1 0 3 Table
usergroup 4 0 2 Table
module 1 1 4 Table
postsoitem 0 4 17 Table
trackingdecimal_aud 0 2 6 Table
taxratetype 1 0 2 Table
sotype 1 0 2 Table
carrierservice 6 1 6 Table
address 2 5 13 Table
company_aud 0 2 15 Table
shipstatus 1 0 2 Table
customlist_aud 0 1 5 Table
fobpoint 6 0 3 Table
location_aud 0 1 17 Table
soitemstatus 1 0 2 Table
bominstructionitem 2 1 8 Table
userproperties 0 2 8 Table
part_aud 0 3 48 Table
guiproperties 0 1 3 Table
lgsumtype 2 0 2 Table
producttotree 0 1 3 Table
parttrackingtype 1 0 2 Table
bomautocreatetype 1 0 2 Table
pick_aud 0 1 14 Table
wallet 1 1 4 Table
part 61 14 46 Table
defaultlocation_aud 0 3 6 Table
bom_aud 0 2 19 Table
uomconversion_aud 0 1 8 Table
xo_aud 0 5 36 Table
contacttype 1 0 2 Table
fbschedulehistory 0 1 4 Table
address_aud 0 2 15 Table
revinfo 107 1 3 Table
ship_aud 0 10 31 Table
accountgroup 1 0 2 Table
cardonfile 0 3 9 Table
defaultlocation 0 3 4 Table
vendor 12 9 25 Table
producttotree_aud 0 2 5 Table
po 9 16 51 Table
postso 1 2 14 Table
qtynotavailabletopick 0 1 3 View
trackinteger 0 1 3 View
tagtrackingnoserialview 0 2 11 View
qtyonorderpo 0 1 3 View
qtyonordertosend 0 1 3 View
tagserialview 0 2 12 View
addressmultilinepoview 0 1 7 View
addressmultilinesoview 0 1 4 View
qtyonorder 0 1 3 View
trackdate 0 1 3 View
qohview 0 2 6 View
totalpaidview 0 1 2 View
shipnumview 0 2 23 View
qtynotavailable 0 1 3 View
addressmultilineview 0 1 13 View
ontracview 0 0 26 View
qtyallocatedtoreceive 0 1 3 View
qtyallocatedtosend 0 1 3 View
upsview 0 1 5 View
vendorcontactview 0 1 4 View
addressmultilinexoview 0 1 7 View
nextorderview 0 2 14 View
qtyallocatedpo 0 1 3 View
qtyinventory 0 1 14 View
shippingemailview 0 2 3 View
qtyonordertoreceive 0 1 3 View
paymentview 0 2 11 View
qtyinventorytotals 0 1 8 View
shipcartonxoview 0 1 2 View
tagtrackingview 0 2 11 View
qtyonordermo 0 1 3 View
womoview 0 2 2 View
qtyallocated 0 1 3 View
customercontactview 0 0 4 View
invlogtrackingsummary 0 0 2 View
qtyallocatedso 0 1 3 View
qtydropship 0 1 3 View
trackdecimal 0 1 3 View
qtyonorderso 0 1 3 View
fedexview 0 0 16 View
qtyonhand 0 1 3 View
qtyallocatedmo 0 1 3 View
parttrackingview 0 1 10 View
qtycommitted 0 1 3 View
shipcartonpoview 0 1 2 View
shipcartonsoview 0 1 2 View
tracktext 0 1 3 View
customfieldview 0 0 10 View