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 ADDRESS.LOCATIONGROUPID INTEG_802 R BOMITEMTOLOCATION.LOCATIONGROUPID INTEG_607 R BOMTOLOCATION.LOCATIONGROUPID INTEG_579 R DEFAULTLOCATION.LOCATIONGROUPID INTEG_1051 R INVENTORYLOG.LOCATIONGROUPID INTEG_322 R LOCATION.LOCATIONGROUPID INTEG_248 R MO.LOCATIONGROUPID INTEG_666 R PARTREORDER.LOCATIONGROUPID INTEG_312 R PICK.LOCATIONGROUPID INTEG_1062 R PO.LOCATIONGROUPID INTEG_443 R RECEIPT.LOCATIONGROUPID INTEG_1318 R RMA.LOCATIONGROUPID INTEG_1223 R SHIP.LOCATIONGROUPID INTEG_1065 R SO.LOCATIONGROUPID INTEG_467 R USERTOLG.LOCATIONGROUPID INTEG_621 R WATCH.LOCATIONGROUPID INTEG_664 R WO.LOCATIONGROUPID INTEG_736 R XO.FROMLGID INTEG_1119 R XO.SHIPTOLGID INTEG_1121 R NAME varchar 30 ACTIVEFLAG smallint 5  √  1 QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_130 R DATELASTMODIFIED timestamp 19  √  NULL 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.