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 KITOPTION.KITITEMID INTEG_1372 R DESCRIPTION varchar 256  √  null KITITEMTYPEID integer 10 KITITEMTYPE.ID INTEG_1356 R KITPRODUCTID integer 10 PRODUCT.ID INTEG_1358 R PRODUCTID integer 10  √  null PRODUCT.ID INTEG_1359 R DISCOUNTID integer 10  √  null ITEMADJUST.ID INTEG_1360 R TAXRATEID integer 10  √  null TAXRATE.ID INTEG_1361 R UOMID integer 10  √  null UOM.ID INTEG_1365 R SORTORDER integer 10  √  0 NOTE blob sub_type 1 0  √  null SOITEMTYPEID integer 10  √  null SOITEMTYPE.ID INTEG_1366 R KITTYPEID integer 10 KITTYPE.ID INTEG_1368 R DATECREATED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null DEFAULTQTY double precision 15  √  0 MINQTY double precision 15  √  0 MAXQTY double precision 15  √  0 QTYPRICEADJUSTMENT 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.