View shrdb.LAWSN.ENPREFCATS 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
TREECATEGORY number 22
REFERENCEID number 22
REFCATEGORY number 22

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT A.TREEENTRYID, B.ENTRYCATEGORY AS TREECATEGORY, A.REFERENCEID, C.ENTRYCATEGORY AS REFCATEGORY FROM ENPREFERENCES A, ENPBATREE B, ENPBATREE C WHERE A.TREEENTRYID = B.TREEENTRYID AND A.REFERENCEID = C.TREEENTRYID
 
Possibly Referenced Tables/Views:
ENPBATREE ENPREFERENCES 


Close relationships: