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 POITEM.POID INTEG_479 R POSTPO.POID INTEG_1259 R CARRIERID integer 10 CARRIER.ID INTEG_426 R FOBPOINTID integer 10 FOBPOINT.ID INTEG_428 R PAYMENTTERMSID integer 10 PAYMENTTERMS.ID INTEG_430 R REMITCOUNTRYID integer 10  √  null REMITSTATEID integer 10  √  null SHIPTERMSID integer 10 SHIPTERMS.ID INTEG_432 R SHIPTOCOUNTRYID integer 10  √  null SHIPTOSTATEID integer 10  √  null TYPEID integer 10 POTYPE.ID INTEG_434 R STATUSID integer 10 POSTATUS.ID INTEG_436 R VENDORID integer 10 VENDOR.ID INTEG_438 R USERNAME varchar 15  √  null NUM varchar 25 VENDORSO varchar 25  √  null VENDORCONTACT varchar 30  √  null REMITTONAME varchar 60  √  null REMITADDRESS varchar 90  √  null REMITCITY varchar 30  √  null REMITZIP varchar 10  √  null BUYER varchar 30  √  null SHIPTONAME varchar 60  √  null SHIPTOADDRESS varchar 90  √  null SHIPTOCITY varchar 30  √  null SHIPTOZIP varchar 10  √  null DELIVERTO varchar 30  √  null REVISIONNUM integer 10  √  0 DATELASTMODIFIED timestamp 19  √  null DATECREATED timestamp 19  √  null DATEISSUED timestamp 19  √  null DATECONFIRMED timestamp 19  √  null DATEREVISION timestamp 19  √  null DATEFIRSTSHIP timestamp 19  √  null DATECOMPLETED timestamp 19  √  null QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_441 R LOCATIONGROUPID integer 10 LOCATIONGROUP.ID INTEG_443 R NOTE blob sub_type 1 0  √  null CUSTOMERSO varchar 25  √  null URL varchar 256  √  null TAXRATEID integer 10  √  null TAXRATE.ID INTEG_266 R TOTALTAX double precision 15  √  null TAXRATENAME varchar 31  √  null TOTALINCLUDESTAX smallint 5  √  0 CURRENCYID integer 10  √  null CURRENCY.ID INTEG_1155 R CURRENCYRATE double precision 15  √  1 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.