SchemaSpy Analysis of tjporter Generated by
SchemaSpy
Generated by SchemaSpy on Sun Jan 22 16:40 EST 2012
Database Type: MySQL - 5.0.51a-24+lenny5 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
accountgroups 1 1 5 15
accountsection 1 2 7
areas 1 2 1
assetmanager 8 0
audittrail 1 3 11
bankaccounts 1 1 7 2
banktrans 2 12 0
bom 4 8 0
chartdetails 2 6 807
chartmaster 7 1 3 145
cogsglpostings 5 1
companies 26 1
config 2 80
contractbom 2 4 0
contractcharges 2 7 0
contractreqts 1 5 0
contracts 2 4 14 0
currencies 4 6 5
custallocns 2 5 0
custbranch 9 6 32 4
custcontacts 7 0
custnotes 6 0
debtorsmaster 1 5 30 4
debtortrans 3 3 23 0
debtortranstaxes 2 3 0
debtortype 1 2 4
debtortypenotes 6 0
deliverynotes 3 8 0
discountmatrix 1 4 0
edi_orders_seg_groups 3 38
edi_orders_segs 4 95
ediitemmapping 4 0
edimessageformat 6 0
emailsettings 9 0
factorcompanies 12 0
fixedassetcategories 8 0
fixedassetlocations 3 0
fixedassets 14 0
fixedassettrans 9 0
freightcosts 2 10 0
geocode_param 7 0
gltrans 3 12 0
grns 2 10 0
holdreasons 1 3 3
lastcostrollup 11 0
locations 16 1 16 1
locstock 2 4 12
loctransfers 3 8 0 Stores Shipments To And From Locations
mrpcalendar 3 0
mrpdemands 2 5 0
mrpdemandtypes 1 2 0
mrpplannedorders 8 0
offers 2 9 0
orderdeliverydifferenceslog 4 7 0
paymentmethods 5 4
paymentterms 2 4 3
pcashdetails 9 0
pcexpenses 1 1 3 0
pctabexpenses 2 2 0
pctabs 5 9 0
pctypetabs 2 2 0
periods 5 2 5
pickinglistdetails 1 5 0
pickinglists 1 1 5 0
prices 3 8 10
purchdata 2 11 1
purchorderauth 5 1
purchorderdetails 1 1 19 0
purchorders 1 2 35 0
recurringsalesorders 1 2 24 0
recurrsalesorderdetails 2 6 0
reportcolumns 1 14 0
reportfields 9 0
reportheaders 1 18 0
reportlinks 3 0
reports 71 0
salesanalysis 1 14 0
salescat 1 3 15
salescatprod 2 2 3
salesglpostings 6 1
salesman 1 8 1
salesorderdetails 2 2 15 2
salesorders 4 4 28 2
salestypes 3 2 1
scripts 3 372
securitygroups 2 2 46
securityroles 1 2 9
securitytokens 1 2 15
shipmentcharges 2 6 0
shipments 1 1 7 0
shippers 3 3 3
stockcategory 2 8 31
stockcatproperties 9 35
stockcheckfreeze 2 4 0
stockcounts 2 5 0
stockitemproperties 3 106
stockmaster 19 2 29 12
stockmoves 1 4 18 0
stockmovestaxes 1 5 0
stockserialitems 2 2 6 0
stockserialmoves 3 5 0
suppallocs 2 5 0
suppliercontacts 1 8 0
suppliers 7 3 28 2
suppliertype 2 1
supptrans 3 2 16 0
supptranstaxes 2 3 0
systypes 7 3 33
tags 2 0
taxauthorities 5 2 8 1
taxauthrates 3 4 5
taxcategories 2 2 3
taxgroups 3 2 2
taxgrouptaxes 2 4 1
taxprovinces 2 2 2
unitsofmeasure 2 5
woitems 2 2 6 0
worequirements 4 6 0
workcentres 2 1 7 0
workorders 2 1 6 0
woserialnos 5 0
www_users 3 1 19 1
           
122 Tables     1,042 1,970  
0 Views     0