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 ASSOCPRICETYPE.ACCOUNTID INTEG_843 R ITEMADJUST.EXPENSEASACCOUNTID INTEG_157 R ITEMADJUST.INCOMEASACCOUNTID INTEG_156 R PART.ADJUSTMENTACCOUNTID INTEG_33 R PART.COGSACCOUNTID INTEG_305 R PART.INVENTORYACCOUNTID INTEG_306 R PART.SCRAPACCOUNTID INTEG_35 R PART.VARIANCEACCOUNTID INTEG_34 R POSTRANSACTION.DEPOSITTOACCOUNTID INTEG_474 R PRODUCT.INCOMEACCOUNTID INTEG_359 R TAXRATE.TAXACCOUNTID INTEG_1335 R NAME varchar 155 TYPEID integer 10  √  null ASACCOUNTTYPE.ID INTEG_276 R DATECREATED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null ACTIVEFLAG smallint 5  √  1 ACCOUNTNUMBER varchar 36  √  NULL 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.