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 NAME varchar 41 DESCRIPTION blob sub_type 1 0  √  null ISACTIVE smallint 5  √  1 PRODUCTINCLTYPEID smallint 5 PRODUCTINCLTYPE.ID INTEG_151 R PRODUCTINCLID integer 10  √  0 PAAPPLIES smallint 5  √  1 PATYPEID smallint 5  √  1 PABASEAMOUNTTYPEID smallint 5  √  3 RNDAPPLIES smallint 5  √  0 RNDTYPEID smallint 5  √  2 RNDISMINUS smallint 5  √  1 CUSTOMERINCLTYPEID smallint 5 CUSTOMERINCLTYPE.ID INTEG_153 R CUSTOMERINCLID integer 10  √  0 DATEAPPLIES smallint 5  √  0 DATEBEGIN timestamp 19  √  null DATEEND timestamp 19  √  null QTYAPPLIES smallint 5  √  0 SPCAPPLIES smallint 5  √  0 SPCBUYX integer 10  √  0 SPCGETYFREE integer 10  √  0 ISAUTOAPPLY smallint 5  √  1 ISTIER2 smallint 5  √  0 DATECREATED timestamp 19  √  'NOW' DATELASTMODIFIED timestamp 19  √  'NOW' USERID integer 10 1 SYSUSER.ID INTEG_155 R QTYMIN double precision 15  √  0 QTYMAX double precision 15  √  0 PAPERCENT double precision 15  √  0 PAAMOUNT double precision 15  √  0 RNDTOAMOUNT double precision 15  √  0 RNDPMAMOUNT 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.