View shrdb.LAWSN.ENPSTATSREPORT 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
ENTRYCATEGORY number 22
ENTRYSTRING nvarchar2 200
ENTRYDESC nvarchar2 100  √  null
STATSDESC nvarchar2 500
STATSVALUE number 22

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT A.TREEENTRYID, B.ENTRYCATEGORY, B.ENTRYSTRING, B.ENTRYDESC, C.STATSDESC, A.STATSVALUE FROM ENPSTATSLOG A, ENPBATREE B, ENPSTATSLOGTYPES C WHERE A.TREEENTRYID = B.TREEENTRYID AND A.STATSTYPE = C.STATSTYPE
 
Possibly Referenced Tables/Views:
ENPBATREE ENPSTATSLOG ENPSTATSLOGTYPES 


Close relationships: