View shrdb.LAWFS.ENPENTRYACCESSLIST 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
TREEENTRYID number 22
ENPBATREE.TREEENTRYID Implied Constraint R
ENTRYTYPE number 22
ACCESSID number 22
USERNAME nvarchar2 250  √  null

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT A.TREEENTRYID, B.ENTRYTYPE, A.ACCESSID, B.USERNAME FROM ENPENTRYACCESS A, ENPUSERMAP B WHERE A.ACCESSID = B.USERID
 
Possibly Referenced Tables/Views:
ENPENTRYACCESS ENPUSERMAP 


Close relationships: