Table shrdb.LAWRS.ERS_REPORTDATASOURCES 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
INDEXNUMBER number 22
REPORTDATASOURCE nvarchar2 200  √  null
RSDATASOURCE nvarchar2 200  √  null
DATASOURCETYPE nvarchar2 100  √  null
DEFAULTUSER nvarchar2 150  √  null
DEFAULTPASSWORD nvarchar2 150  √  null
APPLYTO number 22  √  null
OVERRIDEUSER number 22  √  null

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

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