Table shrdb.LAWRS.ERS_PUBLICATIONS2 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
REPORTID number 22
INSTANCEID number 22
PUBLICATIONID number 22
PUBLICATIONKEY clob 4000
KEYHASHCODE number 22
DATAMAP blob 4000  √  null
CREATED timestamp(6) 11,6  √  null
LASTACCESSED timestamp(6) 11,6  √  null
ACCESSCOUNT number 22  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
REPORTID + INSTANCEID + PUBLICATIONID Primary key Asc/Asc/Asc SYS_C0011520
REPORTID + INSTANCEID + KEYHASHCODE Performance Asc/Asc/Asc ERS_PUBLICATIONS2_KEYHASH