Table /home/ilopez/git/fishbowldatadictionary/data/Fishbowl2013.5.FDB.SYSUSER
X

 Generated by
SchemaSpy
Legend: SourceForge.net
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
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
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 Mon Jul 01 09:44 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name Anomalies
Must be unique RDB$53 These unique columns are also nullable
ID Must be unique Asc RDB$PRIMARY52  

Close relationships  within of separation: