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.MOID INTEG_677 R NUM varchar 25 TYPEID integer 10  √  null STATUSID integer 10 MOSTATUS.ID INTEG_644 R REVISION integer 10 1 NOTE blob sub_type 1 0  √  null LOCATIONGROUPID integer 10 LOCATIONGROUP.ID INTEG_666 R DATELASTMODIFIED timestamp 19  √  null DATECREATED timestamp 19  √  null DATEISSUED timestamp 19  √  null DATECOMPLETED timestamp 19  √  null DATESCHEDULED timestamp 19  √  null USERID integer 10 1 SYSUSER.ID INTEG_668 R QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_669 R SOID integer 10  √  null SO.ID INTEG_777 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.