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 MOITEM.PARENTID INTEG_678 R WO.MOITEMID INTEG_731 R WOITEM.MOITEMID INTEG_750 R DESCRIPTION varchar 256 MOID integer 10  √  null MO.ID INTEG_677 R PARENTID integer 10  √  null MOITEM.ID INTEG_678 R PARTID integer 10  √  null PART.ID INTEG_679 R BOMID integer 10  √  null BOM.ID INTEG_680 R BOMITEMID integer 10  √  null BOMITEM.ID INTEG_681 R ONETIMEITEM smallint 5  √  0 TYPEID integer 10 BOMITEMTYPE.ID INTEG_683 R STATUSID integer 10 MOITEMSTATUS.ID INTEG_685 R QTYTOFULFILL double precision 15  √  0 QTYFULFILLED double precision 15  √  0 UOMID integer 10  √  null UOM.ID INTEG_686 R DATESCHEDULED timestamp 19  √  null INSTRUCTIONURL varchar 256 INSTRUCTIONNOTE blob sub_type 1 0  √  null SORTIDINSTRUCT integer 10 1 PRICEADJUSTMENT double precision 15  √  0 STAGE smallint 5  √  0 ADDTOSERVICE smallint 5  √  0 TOTALCOST double precision 15  √  0 STAGELEVEL integer 10  √  1 QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_689 R DATESCHEDULEDTOSTART timestamp 19  √  null PRIORITYID integer 10  √  null PRIORITY.ID INTEG_946 R 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.