Table shrdb.LAWSN.ENPBATREE 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.ENTRYPARENT FK_ENPBATREE_PARENT_ID C
ENPENTRYACCESS.TREEENTRYID FK_ENPACCBATREE C
ENPENTRYACCESSLIST.TREEENTRYID Implied Constraint R
ENPENTRYATTR.TREEENTRYID FK_ENPENTRYATTR_ENPBATREE C
ENPREFCATS.TREEENTRYID Implied Constraint R
ENPREFERENCECV.TREEENTRYID Implied Constraint R
ENPREFERENCES.REFERENCEID FK_ENPREFERENCES2 C
ENPREFERENCES.TREEENTRYID FK_ENPREFERENCES1 C
ENPREFLISTVIEW.TREEENTRYID Implied Constraint R
ENPSTATSLOG.TREEENTRYID FK_STATSLOGTREE C
ENPSTATSREPORT.TREEENTRYID Implied Constraint R
ENPTREEATTRS.TREEENTRYID Implied Constraint R
INFOSETRIGHTS.TREEENTRYID FK_INFOSETRIGHTS_ENPBATREE C
SNAUDIT.TREEENTRYID FK_SNAUDIT_ENPBATREE C
ENTRYPARENT number 22  √  null
ENPBATREE.TREEENTRYID FK_ENPBATREE_PARENT_ID C
ENTRYCATEGORY number 22
ENPCATEGORIES.CATEGORYID FK_ENTRYCAT_ENTRYID R
ENTRYPUBLIC number 22 1
ENTRYOWNER number 22  √  null
ENPUSERMAP.USERID FK_USERMAP C
ENTRYSTRING nvarchar2 200
ENTRYDESC nvarchar2 100  √  null
ENTRYSUBTYPE number 22  √  -1
LVL number 22  √  null
HIERARCHY varchar2 900  √  null
CREATIONDATE date 7  √  now

Table contained 11,221 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name Anomalies
TREEENTRYID Primary key Asc PK_ENPBATREE_TREEENTRYID  
CREATIONDATE + ENTRYCATEGORY + ENTRYOWNER Performance Asc/Asc/Asc I_ENPADMIN  
ENTRYOWNER Performance Asc I_ENPBATREE_ENTOWN  
LVL Performance Asc I_ENPBATREE_ENTRYLVL  
ENTRYPARENT Performance Asc I_ENPBATREE_ENTRYPAR  
ENTRYSTRING Performance Asc I_ENPBATREE_ENTSTR  
ENTRYOWNER + ENTRYCATEGORY + ENTRYSTRING Performance Asc/Asc/Asc I_ENPBATREE_ENTUCE  
CREATIONDATE + ENTRYPUBLIC + ENTRYOWNER + ENTRYCATEGORY + TREEENTRYID Must be unique Asc/Asc/Asc/Asc/Asc I_ENPRECENT  
HIERARCHY Must be unique Asc IDX_ENPBATREE_HIERARCHY This unique column is also nullable

Close relationships  within of separation: