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 SHIPCARTON.SHIPID INTEG_517 R SHIPITEM.SHIPID INTEG_526 R SHIPUPSDETAILS.SHIPID INTEG_913 R UPSRETURNSHIPMENT.SHIPID INTEG_928 R ORDERTYPEID integer 10 ORDERTYPE.ID INTEG_507 R ORDERID integer 10  √  0 CARRIERID integer 10 CARRIER.ID INTEG_509 R FOBPOINTID integer 10 FOBPOINT.ID INTEG_511 R STATUSID integer 10 SHIPSTATUS.ID INTEG_513 R SHIPTOID integer 10  √  0 INVOICEID integer 10  √  null CARTONCOUNT integer 10  √  0 DATECREATED timestamp 19  √  null DATESHIPPED timestamp 19  √  null INVOICENO varchar 15  √  null INVOICEDFLAG smallint 5  √  0 NOTE blob sub_type 1 0  √  null LOCATIONGROUPID integer 10 LOCATIONGROUP.ID INTEG_1065 R BILLOFLADING varchar 20  √  null OWNERISFROM smallint 5  √  1 INVOICEAMOUNT double precision 15  √  0 INVOICEAMOUNTPAID double precision 15  √  0 DATELASTMODIFIED timestamp 19  √  NULL NUM varchar 35 SHIPPEDBY integer 10  √  null SYSUSER.ID INTEG_873 R UPSSERVICEID integer 10  √  null UPSSERVICES.ID INTEG_884 R SHIPMENTIDENTIFICATIONNUMBER varchar 32  √  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.