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 BOM.USERID INTEG_571 R CALCATEGORY.LASTCHANGEDUSERID INTEG_881 R CALEVENT.LASTCHANGEDUSERID INTEG_449 R CURRENCY.LASTCHANGEDUSERID INTEG_1069 R CUSTOMERPARTS.LASTCHANGEDUSERID INTEG_1287 R FBSCHEDULE.LASTCHANGEDUSERID INTEG_1165 R INVENTORYLOG.USERID INTEG_1333 R MO.USERID INTEG_668 R ORDERHISTORY.USERID INTEG_1203 R PICK.USERID INTEG_1058 R PRICINGRULE.USERID INTEG_155 R RECEIPT.USERID INTEG_1316 R RMA.USERID INTEG_1221 R SHIP.SHIPPEDBY INTEG_873 R USERGROUPREL.USERID INTEG_630 R USERLOG.USERID INTEG_544 R USERPROPERTIES.USERID INTEG_1382 R USERTOLG.USERID INTEG_620 R VENDORCOSTRULE.USERID INTEG_800 R VENDORPARTS.USERID INTEG_535 R WATCH.SYSUSERID INTEG_656 R WO.USERID INTEG_735 R WOASSIGNEDUSERS.USERID INTEG_744 R XO.USERID INTEG_1124 R USERNAME varchar 15 FIRSTNAME varchar 15  √  null LASTNAME varchar 15  √  null INITIALS varchar 5  √  null USERPWD varchar 30 ACTIVEFLAG smallint 5  √  1 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.