Table shrdb.LAWFS.ENPUSERMAP 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
USERID number 22
DEVICEONLYUSERLIST.USERID Implied Constraint R
ENPBATREE.ENTRYOWNER FK_USERMAP C
ENPDELIVERYLOG.USERID FK_DELIVERYLOG C
ENPDELIVERYLOGVIEW.USERID Implied Constraint R
ENPENTRYACCESS.ACCESSID FK_ENPENTACCID C
ENPGROUPMAP.GROUPID FK_USERMAP2 C
ENPGROUPMAP.USERID FK_USERMAP1 C
ENPUSERGROUPLIST.USERID Implied Constraint R
ENPUSERLISTVIEW.USERID Implied Constraint R
USERNAME nvarchar2 250  √  null
EXTERNALUSERNAME nvarchar2 250  √  null
ENTRYTYPE number 22
USERTYPE number 22  √  null

Table contained 7,227 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
USERID Primary key Asc PK_USERMAP
ENTRYTYPE Performance Asc IDX_ENPUSERMAP_ENTYPE
USERNAME + ENTRYTYPE Must be unique Asc/Asc IDX_USERMAP
EXTERNALUSERNAME + ENTRYTYPE Must be unique Asc/Asc IDX_USERMAPEXT

Close relationships  within of separation: