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.LOCATIONID INTEG_605 R BOMTOLOCATION.LOCATIONID INTEG_577 R DEFAULTLOCATION.LOCATIONID INTEG_1049 R INVENTORYLOG.BEGLOCATIONID INTEG_319 R INVENTORYLOG.ENDLOCATIONID INTEG_321 R TAG.LOCATIONID INTEG_340 R WO.LOCATIONID INTEG_737 R TYPEID integer 10 LOCATIONTYPE.ID INTEG_245 R PARENTID integer 10  √  0 NAME varchar 30 DESCRIPTION varchar 252  √  null COUNTEDASAVAILABLE smallint 5  √  1 DEFAULTFLAG smallint 5  √  0 ACTIVEFLAG smallint 5  √  1 PICKABLE smallint 5  √  1 RECEIVABLE smallint 5  √  1 LOCATIONGROUPID integer 10 LOCATIONGROUP.ID INTEG_248 R SORTORDER integer 10  √  0 DEFAULTCUSTOMERID integer 10  √  null CUSTOMER.ID INTEG_1336 R DEFAULTVENDORID integer 10  √  null VENDOR.ID INTEG_1337 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.