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 RECEIPTID integer 10 RECEIPT.ID INTEG_1322 R LOCATIONID integer 10  √  null RESPONSIBILITYID integer 10  √  null TYPEID integer 10 RECEIPTITEMTYPE.ID INTEG_1324 R PARTTYPEID integer 10 PARTTYPE.ID INTEG_1326 R TAGID integer 10  √  null REASON varchar 90  √  null PARTID integer 10  √  null PART.ID INTEG_807 R SHIPITEMID integer 10  √  null ORDERITEMID integer 10  √  null STATUSID integer 10 10 RECEIPTITEMSTATUS.ID INTEG_1328 R UOMID integer 10 UOM.ID INTEG_1330 R DATERECEIVED timestamp 19  √  null DATERECONCILED timestamp 19  √  null TRACKINGNUM varchar 30  √  null CARRIERID integer 10  √  null CARRIER.ID INTEG_806 R PACKAGECOUNT integer 10  √  1 DELIVERTO varchar 30  √  null BILLVENDORFLAG smallint 5  √  1 DATELASTMODIFIED timestamp 19  √  null QTY double precision 15  √  0 BILLEDTOTALCOST double precision 15  √  0 LANDEDTOTALCOST double precision 15  √  0 CUSTOMERID integer 10  √  null CUSTOMER.ID INTEG_780 R TAXID integer 10  √  null TAXRATE.ID INTEG_267 R TAXRATE double precision 15  √  0 REFNO varchar 20  √  null DATEBILLED 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.