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 POSTXO.XOID INTEG_1273 R XOITEM.XOID INTEG_1130 R TYPEID integer 10 10 XOTYPE.ID INTEG_1113 R STATUSID integer 10 10 XOSTATUS.ID INTEG_1115 R NUM varchar 25 FROMLGID integer 10 LOCATIONGROUP.ID INTEG_1119 R FROMATTN varchar 30  √  null FROMNAME varchar 41  √  null FROMADDRESS varchar 90  √  null FROMCITY varchar 30  √  null FROMZIP varchar 10  √  null FROMSTATEID integer 10  √  null FROMCOUNTRYID integer 10  √  null SHIPTOLGID integer 10 LOCATIONGROUP.ID INTEG_1121 R SHIPTOATTN varchar 30  √  null SHIPTONAME varchar 41  √  null SHIPTOADDRESS varchar 90  √  null SHIPTOCITY varchar 30  √  null SHIPTOZIP varchar 10  √  null SHIPTOCOUNTRYID integer 10  √  null SHIPTOSTATEID integer 10  √  null MAINLOCATIONTAGID integer 10  √  null TAG.ID INTEG_1122 R OWNERISFROM smallint 5  √  1 USERID integer 10 1 SYSUSER.ID INTEG_1124 R REVISIONNUM integer 10  √  0 DATELASTMODIFIED timestamp 19  √  null DATECREATED timestamp 19  √  null DATEISSUED timestamp 19  √  null DATECONFIRMED timestamp 19  √  null DATEFIRSTSHIP timestamp 19  √  null DATECOMPLETED timestamp 19  √  null DATESCHEDULED timestamp 19  √  null CARRIERID integer 10 CARRIER.ID INTEG_1126 R NOTE blob sub_type 1 0  √  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.