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 MO.SOID INTEG_777 R POSTRANSACTION.SOID INTEG_471 R POSTSO.SOID INTEG_1244 R SOITEM.SOID INTEG_494 R STATUSID integer 10 SOSTATUS.ID INTEG_453 R CARRIERID integer 10  √  null CARRIER.ID INTEG_805 R FOBPOINTID integer 10 FOBPOINT.ID INTEG_455 R PAYMENTTERMSID integer 10 PAYMENTTERMS.ID INTEG_457 R BILLTOCOUNTRYID integer 10  √  null BILLTOSTATEID integer 10  √  null SHIPTERMSID integer 10  √  null SHIPTERMS.ID INTEG_804 R SHIPTOCOUNTRYID integer 10  √  null SHIPTOSTATEID integer 10  √  null TYPEID integer 10 SOTYPE.ID INTEG_459 R CUSTOMERID integer 10 CUSTOMER.ID INTEG_461 R USERNAME varchar 15  √  null NUM varchar 25 CUSTOMERPO varchar 25  √  null CUSTOMERCONTACT varchar 30  √  null BILLTONAME varchar 60  √  null BILLTOADDRESS varchar 90  √  null BILLTOCITY varchar 30  √  null BILLTOZIP varchar 10  √  null SALESMAN varchar 30  √  null SALESMANINITIALS varchar 5  √  null SHIPTONAME varchar 60  √  null SHIPTOADDRESS varchar 90  √  null SHIPTOCITY varchar 30  √  null SHIPTOZIP varchar 10  √  null REVISIONNUM integer 10  √  0 DATELASTMODIFIED timestamp 19  √  null DATECREATED timestamp 19  √  null DATEISSUED timestamp 19  √  null DATEREVISION timestamp 19  √  null DATEFIRSTSHIP timestamp 19  √  null DATECOMPLETED timestamp 19  √  null TAXRATEID integer 10  √  null TAXRATE.ID INTEG_464 R TAXRATENAME varchar 31  √  'None' QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_465 R LOCATIONGROUPID integer 10 LOCATIONGROUP.ID INTEG_467 R NOTE blob sub_type 1 0  √  null REGISTERID integer 10  √  0 RESIDENTIALFLAG smallint 5  √  0 VENDORPO varchar 25  √  null TOTALTAX double precision 15  √  0 COST double precision 15  √  0 TAXRATE double precision 15  √  0 URL varchar 256  √  null TOTALINCLUDESTAX smallint 5  √  0 UPSSERVICEID integer 10  √  null UPSSERVICES.ID INTEG_899 R PRIORITYID integer 10  √  null PRIORITY.ID INTEG_945 R CURRENCYID integer 10  √  null CURRENCY.ID INTEG_1289 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.