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 SHIPID integer 10 SHIP.ID INTEG_913 R PAYMENTTYPE integer 10 UPSPAYMENTTYPE.ID INTEG_915 R ACCOUNTNUMBER varchar 10  √  null ADDRESS varchar 90  √  null CITY varchar 30  √  null STATEID integer 10  √  null STATECONST.ID INTEG_916 R ZIP varchar 10  √  null NOTIFICATIONEMAILS varchar 250  √  null EXCEPTIONEMAILS varchar 250  √  null DELIVERYEMAILS varchar 250  √  null SATURDAYDELIVERY smallint 5  √  0 DOCUMENTSONLY smallint 5  √  0 PHONE varchar 250  √  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.