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 INVENTORYLOGTOCOSTLAYER.INVENTORYLOGID INTEG_1175 R TIINVENTORYLOG.INVENTORYLOGID INTEG_1151 R EVENTDATE timestamp 19  √  'NOW' PARTID integer 10 PART.ID INTEG_317 R BEGTAGNUM integer 10  √  0 ENDTAGNUM integer 10  √  0 BEGLOCATIONID integer 10 LOCATION.ID INTEG_319 R ENDLOCATIONID integer 10 LOCATION.ID INTEG_321 R LOCATIONGROUPID integer 10  √  null LOCATIONGROUP.ID INTEG_322 R INFO varchar 100  √  null TYPEID integer 10  √  1 INVENTORYLOGTYPE.ID INTEG_1331 R USERID integer 10  √  1 SYSUSER.ID INTEG_1333 R TABLEID integer 10  √  0 RECORDID integer 10  √  0 PARTTRACKINGID integer 10  √  null CHANGEQTY double precision 15  √  0 QTYONHAND double precision 15  √  0 DATECREATED timestamp 19  √  NULL COST double precision 15  √  0 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.