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 POSTSOITEM.SOITEMID INTEG_1253 R SOITEMTOMOITEM.SOITEMID INTEG_693 R PRODUCTID integer 10  √  null PRODUCT.ID INTEG_492 R SOID integer 10 SO.ID INTEG_494 R TYPEID integer 10 SOITEMTYPE.ID INTEG_496 R STATUSID integer 10 SOITEMSTATUS.ID INTEG_498 R UOMID integer 10  √  null UOM.ID INTEG_499 R SOLINEITEM integer 10 DESCRIPTION varchar 252  √  null PRODUCTNUM varchar 70 CUSTOMERPARTNUM varchar 70  √  null TAXABLEFLAG smallint 5  √  0 DATELASTFULFILLMENT timestamp 19  √  null DATESCHEDULEDFULFILLMENT timestamp 19 'NOW' REVLEVEL varchar 15  √  null EXCHANGESOLINEITEM integer 10  √  0 QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_503 R NOTE blob sub_type 1 0  √  null SHOWITEMFLAG smallint 5 1 QTYTOFULFILL double precision 15  √  0 QTYFULFILLED double precision 15  √  0 QTYPICKED double precision 15  √  0 ITEMADJUSTID integer 10  √  null ADJUSTPERCENTAGE double precision 15  √  0 UNITPRICE double precision 15  √  0 TOTALPRICE double precision 15  √  0 ADJUSTAMOUNT double precision 15  √  0 TOTALCOST double precision 15  √  0 DATELASTMODIFIED timestamp 19  √  NULL TAXID integer 10  √  null TAXRATE.ID INTEG_263 R TAXRATE double precision 15  √  null MCTOTALPRICE 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.