Table shrdb.LAWFS.ENPENTRYACCESS 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 FK_ENPACCBATREE C
ACCESSTYPEID number 22
ENPENTRYACCESSTYPES.ACCESSTYPEID FK_ENPENTACCTYP C
ACCESSID number 22
ENPUSERMAP.USERID FK_ENPENTACCID C

Table contained 391 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
TREEENTRYID + ACCESSID + ACCESSTYPEID Primary key Asc/Asc/Asc PK_ENTRYACCESS
ACCESSID Performance Asc I_ENPENTRYACCST
TREEENTRYID Performance Asc I_ENPENTRYACCTI

Close relationships  within of separation: