Table shrdb.LAWRS.ERS_REPORTS 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
REPORTTYPE nvarchar2 100
DESCRIPTION nvarchar2 510  √  null
CREATED timestamp(6) 11,6  √  null
LASTMODIFIED timestamp(6) 11,6  √  null
STARTED timestamp(6) 11,6  √  null
FINISHED timestamp(6) 11,6  √  null
OWNER nvarchar2 150  √  null
PUBLISHER nvarchar2 150  √  null
REPORTNAME nvarchar2 200  √  null
ARCHIVEINSTANCES number 22  √  null
OUTPUTTYPE nvarchar2 100  √  null
DATASOURCE nvarchar2 100  √  null
DBUSER nvarchar2 150  √  null
DBPASSWORD nvarchar2 150  √  null
DBUSELOGIN nvarchar2 4  √  null
DEFAULTDESTINATION nvarchar2 100  √  null
INSTANCECOMMAND nvarchar2 1000  √  null
INSTANCENAME nvarchar2 500  √  null
CATEGORY nvarchar2 100  √  null
STATUS number 22  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
REPORTID + INSTANCEID + REPORTTYPE Primary key Asc/Asc/Asc SYS_C0011493