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 POSTWO.WOID INTEG_765 R WOASSIGNEDUSERS.WOID INTEG_742 R WOITEM.WOID INTEG_748 R NUM varchar 30 MOITEMID integer 10 MOITEM.ID INTEG_731 R TYPEID integer 10  √  null STATUSID integer 10 WOSTATUS.ID INTEG_733 R QTYTARGET integer 10  √  0 QTYORDERED integer 10  √  0 QTYSCRAPPED integer 10  √  0 USERID integer 10 1 SYSUSER.ID INTEG_735 R DATESCHEDULED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null DATECREATED timestamp 19  √  null DATESTARTED timestamp 19  √  null DATEFINISHED timestamp 19  √  null LOCATIONGROUPID integer 10  √  null LOCATIONGROUP.ID INTEG_736 R LOCATIONID integer 10  √  null LOCATION.ID INTEG_737 R NOTE blob sub_type 1 0  √  null COST double precision 15  √  0 QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_738 R CUSTOMERID integer 10  √  null CUSTOMER.ID INTEG_782 R DATESCHEDULEDTOSTART timestamp 19  √  null PRIORITYID integer 10  √  null PRIORITY.ID INTEG_983 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.