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 BOMITEMTOLOCATION.BOMITEMID INTEG_603 R MOITEM.BOMITEMID INTEG_681 R DESCRIPTION varchar 256 BOMID integer 10 BOM.ID INTEG_590 R TYPEID integer 10 BOMITEMTYPE.ID INTEG_592 R PARTID integer 10  √  null PART.ID INTEG_593 R QUANTITY double precision 15 1 UOMID integer 10  √  null UOM.ID INTEG_595 R PRICEADJUSTMENT double precision 15  √  0 ONETIMEITEM smallint 5  √  0 STAGE smallint 5  √  0 STAGEBOMID integer 10  √  null ADDTOSERVICE smallint 5  √  0 PRODUCTID integer 10  √  null SORTIDCONFIG integer 10 1 INSTRUCTIONURL varchar 256 INSTRUCTIONNOTE blob sub_type 1 0  √  null SORTIDINSTRUCT integer 10 1 VARIABLEQTY smallint 5  √  0 MINQTY double precision 15  √  null MAXQTY double precision 15  √  null GROUPDEFAULT smallint 5  √  1 BOMITEMGROUPID integer 10  √  null BOMITEMGROUP.ID INTEG_599 R USEITEMLOCATION smallint 5  √  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.