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 LOCATION.DEFAULTVENDORID INTEG_1337 R PO.VENDORID INTEG_438 R RMAITEM.VENDORID INTEG_1236 R TAXRATE.VENDORID INTEG_387 R VENDORCOSTRULE.VENDORID INTEG_798 R VENDORPARTS.VENDORID INTEG_413 R ACCOUNTID integer 10 ACCOUNT.ID INTEG_371 R STATUSID integer 10 VENDORSTATUS.ID INTEG_373 R DEFAULTPAYMENTTERMSID integer 10 PAYMENTTERMS.ID INTEG_375 R DEFAULTSHIPTERMSID integer 10 SHIPTERMS.ID INTEG_377 R DEFAULTCARRIERID integer 10 CARRIER.ID INTEG_379 R NAME varchar 41 DATEENTERED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null LASTCHANGEDUSER varchar 15  √  null NOTE varchar 90  √  null SYSUSERID integer 10  √  null ACTIVEFLAG smallint 5  √  1 ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null LEADTIME integer 10  √  0 ACCOUNTNUM varchar 30  √  null URL varchar 256  √  null CREDITLIMIT double precision 15  √  0 MINORDERAMOUNT double precision 15  √  0 TAXRATEID integer 10  √  null TAXRATE.ID INTEG_820 R CURRENCYID integer 10  √  null CURRENCY.ID INTEG_1166 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.