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 POSTPOITEM.POITEMID INTEG_1267 R PARTID integer 10  √  null PART.ID INTEG_477 R POID integer 10 PO.ID INTEG_479 R TYPEID integer 10 POITEMTYPE.ID INTEG_481 R STATUSID integer 10 POITEMSTATUS.ID INTEG_483 R UOMID integer 10  √  null UOM.ID INTEG_484 R POLINEITEM integer 10 DESCRIPTION varchar 252  √  null PARTNUM varchar 70 VENDORPARTNUM varchar 70 DATELASTFULFILLMENT timestamp 19  √  null DATESCHEDULEDFULFILLMENT timestamp 19 'NOW' REVLEVEL varchar 15  √  null REPAIRFLAG smallint 5  √  0 TBDCOSTFLAG smallint 5  √  0 QBCLASSID integer 10  √  1 QBCLASS.ID INTEG_489 R NOTE blob sub_type 1 0  √  null QTYTOFULFILL double precision 15  √  0 QTYFULFILLED double precision 15  √  0 QTYPICKED double precision 15  √  0 UNITCOST double precision 15  √  0 TOTALCOST double precision 15  √  0 CUSTOMERID integer 10  √  null CUSTOMER.ID INTEG_779 R TAXID integer 10  √  null TAXRATE.ID INTEG_265 R TAXRATE 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.