View shrdb.LAWFS.ENPREFERENCECV 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
CTYPE number 22  √  null
TREEENTRYID number 22  √  null
ENPBATREE.TREEENTRYID Implied Constraint R
REFCOUNT number 22  √  null

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT 0 AS CTYPE, TREEENTRYID, COUNT(REFERENCEID) AS REFCOUNT FROM ENPREFERENCES GROUP BY TREEENTRYID UNION SELECT 1 AS CTYPE, REFERENCEID, COUNT(TREEENTRYID) AS REFCOUNT FROM ENPREFERENCES GROUP BY REFERENCEID ORDER BY CTYPE, REFCOUNT DESC
 
Possibly Referenced Tables/Views:
ENPREFERENCES 


Close relationships: