View shrdb.LAWFS.DEVICEONLYUSERLIST 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
ENPUSERMAP.USERID Implied Constraint R
USERNAME nvarchar2 250  √  null

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT u.USERID, u.USERNAME FROM ENPUSERMAP u INNER JOIN EFSDELIVERYUSERS d ON u.USERNAME = d.OWNER_NAME WHERE u.USERTYPE <> 1 OR u.USERTYPE IS NULL
 
Possibly Referenced Tables/Views:


Close relationships: