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.TAXRATEID INTEG_400 R ITEMADJUST.TAXRATEID INTEG_861 R KITITEM.TAXRATEID INTEG_1361 R PART.TAXID INTEG_264 R PO.TAXRATEID INTEG_266 R POITEM.TAXID INTEG_265 R PRODUCT.TAXID INTEG_135 R RECEIPTITEM.TAXID INTEG_267 R SO.TAXRATEID INTEG_464 R SOITEM.TAXID INTEG_263 R VENDOR.TAXRATEID INTEG_820 R NAME varchar 31 DEFAULTFLAG smallint 5  √  null VENDORID integer 10  √  null VENDOR.ID INTEG_387 R DATECREATED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null ACTIVEFLAG smallint 5  √  1 TYPEID integer 10  √  null TAXRATETYPE.ID INTEG_1334 R DESCRIPTION varchar 256  √  null TAXACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_1335 R UNITCOST double precision 15  √  0 RATE double precision 15  √  0 CODE varchar 5  √  null ORDERTYPEID integer 10  √  null ORDERTYPE.ID INTEG_903 R 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.