Related columns Constraints Comments Legend

Legend: Primary key columns Columns with indexes Implied relationships Excluded column relationships < n > number of related tables

Column Type Size Nulls Auto Default Children Parents Comments ID integer 10 CUSTOMER.PARENTID INTEG_778 R CUSTOMERPARTS.CUSTOMERID INTEG_1284 R LOCATION.DEFAULTCUSTOMERID INTEG_1336 R POITEM.CUSTOMERID INTEG_779 R POST.CUSTOMERID INTEG_781 R QUICKLIST.CUSTOMERID INTEG_713 R RECEIPTITEM.CUSTOMERID INTEG_780 R RMA.CUSTOMERID INTEG_1217 R SO.CUSTOMERID INTEG_461 R WO.CUSTOMERID INTEG_782 R DATECREATED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null ACCOUNTID integer 10 ACCOUNT.ID INTEG_391 R STATUSID integer 10 CUSTOMERSTATUS.ID INTEG_393 R DEFAULTPAYMENTTERMSID integer 10 PAYMENTTERMS.ID INTEG_395 R DEFAULTSHIPTERMSID integer 10 SHIPTERMS.ID INTEG_397 R NAME varchar 41 LASTCHANGEDUSER varchar 15  √  null TAXEXEMPT smallint 5  √  0 TAXEXEMPTNUMBER varchar 30  √  null NOTE varchar 90  √  null SYSUSERID integer 10  √  null TAXRATEID integer 10  √  null TAXRATE.ID INTEG_400 R ACTIVEFLAG smallint 5  √  1 ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null DEFAULTSALESMANID integer 10  √  0 NUMBER varchar 30 DEFAULTCARRIERID integer 10  √  0 CARRIER.ID INTEG_45 R CREDITLIMIT double precision 15  √  0 PARENTID integer 10  √  null CUSTOMER.ID INTEG_778 R JOBDEPTH integer 10  √  1 URL varchar 256  √  null PIPELINEACCOUNTNUM integer 10  √  NULL DEFAULTSHIPSERVICEID integer 10  √  null UPSSERVICES.ID INTEG_900 R CURRENCYID integer 10  √  null CURRENCY.ID INTEG_1288 R CURRENCYRATE double precision 15  √  0 Analyzed at Sat Mar 01 08:31 PST 2014

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.