Table shrdb.LAWRS.ERS_DISTRIBUTIONOPTIONS 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
SCHEDULENAME nvarchar2 100
OUTPUTTYPE nvarchar2 100  √  null
EMAILENABLED nvarchar2 2  √  null
PRINTERENABLED nvarchar2 2  √  null
MSGFORMAT nvarchar2 100  √  null
EMAILTEXT nclob 4000  √  null
EMAILSUBJECT nvarchar2 510  √  null
RECIPIENTS nvarchar2 1020  √  null
MIMETYPE nvarchar2 100  √  null
UNSUBSCRIBE nvarchar2 2  √  null
SENDBCC nvarchar2 2  √  null
PRINTERS nvarchar2 800  √  null
BURSTINGENABLED nvarchar2 2  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
REPORTID + SCHEDULENAME Primary key Asc/Asc SYS_C0011517