Table shrdb.LAWRS.ERS_ATTRIBUTES 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
ATTRIBUTEID number 22
ERS_ATTRIBUTELIST.ATTRIBUTEID Implied Constraint R
ERS_REPORTATTRIBUTES.ATTRIBUTEID Implied Constraint R
ATTRIBUTENAME nvarchar2 160  √  null
DEFAULTVALUE nvarchar2 2000  √  null
ATTRIBUTEREQUIRED nvarchar2 4  √  null
ATTRIBUTEDESCRIPTION nvarchar2 800  √  null
READONLY nvarchar2 4  √  null
APPLYTONEWREPORTS nvarchar2 4  √  null
ATTRIBUTETYPE nvarchar2 4  √  null
ACTIVESTATUS nvarchar2 4  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
ATTRIBUTEID Primary key Asc SYS_C0011478

Close relationships: