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 ASSOCPRICE.PRODUCTID INTEG_847 R CUSTOMERPARTS.PRODUCTID INTEG_1268 R KITITEM.KITPRODUCTID INTEG_1358 R KITITEM.PRODUCTID INTEG_1359 R KITOPTION.PRODUCTID INTEG_1374 R PART.DEFAULTPRODUCTID INTEG_1338 R QUICKLISTITEM.PRODUCTID INTEG_720 R RMAITEM.PRODUCTID INTEG_1230 R RMAITEM.PRODUCTSUBID INTEG_1235 R SOITEM.PRODUCTID INTEG_492 R PARTID integer 10  √  null PART.ID INTEG_356 R NUM varchar 70 DESCRIPTION varchar 252  √  null DETAILS blob sub_type 1 0  √  null SKU varchar 31  √  null UPC varchar 31  √  null ACTIVEFLAG smallint 5  √  1 TAXABLEFLAG smallint 5  √  1 INCOMEACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_359 R DATECREATED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null SIZEUOMID integer 10  √  2 UOM.ID INTEG_833 R WEIGHTUOMID integer 10  √  3 UOM.ID INTEG_834 R URL varchar 256  √  null UOMID integer 10 UOM.ID INTEG_836 R SELLABLEINOTHERUOMS smallint 5  √  1 DEFAULTSOITEMTYPE integer 10  √  10 SOITEMTYPE.ID INTEG_1332 R DISPLAYTYPEID integer 10  √  10 KITDISPLAYTYPE.ID INTEG_1387 R KITFLAG smallint 5 0 KITGROUPEDFLAG smallint 5  √  0 SHOWSOCOMBOFLAG smallint 5 1 USEPRICEFLAG smallint 5 1 QBCLASSID integer 10  √  null QBCLASS.ID INTEG_46 R WEIGHT double precision 15  √  0 WIDTH double precision 15  √  0 HEIGHT double precision 15  √  0 LEN double precision 15  √  0 PRICE double precision 15  √  0 TAXID integer 10  √  null TAXRATE.ID INTEG_135 R ALERTNOTE varchar 90  √  null 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.