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 BOMITEM.PARTID INTEG_593 R COSTLAYER.PARTID INTEG_1163 R DEFAULTLOCATION.PARTID INTEG_1047 R INVENTORYLOG.PARTID INTEG_317 R MOITEM.PARTID INTEG_679 R PARTCOST.PARTID INTEG_328 R PARTREORDER.PARTID INTEG_311 R PARTTOTRACKING.PARTID INTEG_189 R PICKITEM.PARTID INTEG_982 R POITEM.PARTID INTEG_477 R PRODUCT.PARTID INTEG_356 R RECEIPTITEM.PARTID INTEG_807 R TAG.PARTID INTEG_338 R VENDORCOSTRULE.PARTID INTEG_792 R VENDORPARTS.PARTID INTEG_411 R WATCH.ITEMID INTEG_808 R WOITEM.PARTID INTEG_752 R XOITEM.PARTID INTEG_1135 R PARTCLASSID integer 10  √  null TYPEID integer 10 0 PARTTYPE.ID INTEG_300 R UOMID integer 10 UOM.ID INTEG_302 R NUM varchar 70 DESCRIPTION varchar 252  √  null DETAILS blob sub_type 1 0  √  null ABCCODE varchar 1  √  'N' LEADTIME integer 10  √  0 LEADTIMETOFULFILL integer 10  √  0 REV varchar 15  √  null ACTIVEFLAG smallint 5  √  0 CONTROLLEDFLAG smallint 5  √  0 SERIALIZEDFLAG smallint 5  √  0 TAXABLEFLAG smallint 5  √  0 CONFIGUREABLE smallint 5  √  0 DATECREATED timestamp 19  √  null DATELASTISSUED timestamp 19  √  null DATELASTMODIFIED timestamp 19  √  null LASTCHANGEDUSER varchar 15  √  null COGSACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_305 R INVENTORYACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_306 R WEIGHTUOMID integer 10  √  1 UOM.ID INTEG_307 R ACCOUNTINGID varchar 36  √  null ACCOUNTINGHASH varchar 30  √  null ALWAYSMANUFACTURE smallint 5  √  0 SIZEUOMID integer 10  √  2 UOM.ID INTEG_832 R UPC varchar 31  √  null URL varchar 256  √  null PICKINUOMOFPART smallint 5  √  0 DEFAULTPRODUCTID integer 10  √  null PRODUCT.ID INTEG_1338 R ADJUSTMENTACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_33 R VARIANCEACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_34 R SCRAPACCOUNTID integer 10  √  0 ASACCOUNT.ID INTEG_35 R TRACKINGFLAG smallint 5  √  0 RECEIVINGTOL double precision 15  √  0 CYCLECOUNTTOL double precision 15  √  0 WEIGHT double precision 15  √  0 WIDTH double precision 15  √  0 HEIGHT double precision 15  √  0 LEN double precision 15  √  0 STDCOST double precision 15  √  0 DEFAULTBOMID integer 10  √  10 BOM.ID INTEG_775 R TAXID integer 10  √  null TAXRATE.ID INTEG_264 R ALERTNOTE varchar 90  √  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.