View shrdb.LAWSN.ENPCATATTRS 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
CATEGORYID number 22
ENPCATEGORIES.CATEGORYID Implied Constraint R
CATEGORYDESC nvarchar2 100  √  null
ATTRID number 22  √  null
ATTRDESC nvarchar2 500  √  null

Analyzed at Thu Dec 13 15:47 CST 2012

View Definition:
SELECT CATEGORYID, CATEGORYDESC, ATTRID, ATTRDESC FROM ENPCATEGORIES, ENPATTRLIST WHERE CATEGORYID = ATTRCATEGORY (+) ORDER BY CATEGORYDESC, ATTRDESC
 
Possibly Referenced Tables/Views:
ENPATTRLIST ENPCATEGORIES 


Close relationships: