Table shrdb.LAWRS.ERS_REPORTNOTIFICATION 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
ACCESSTYPE nvarchar2 145
ACCESSVALUE nvarchar2 150
NOTIFICATIONTYPE nvarchar2 150
NOTIFICATIONVALUE nvarchar2 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
REPORTID + INSTANCEID + ACCESSTYPE + ACCESSVALUE + NOTIFICATIONTYPE Primary key Asc/Asc/Asc/Asc/Asc SYS_C0011491