Table shrdb.LAWRS.ERS_RULEDETAIL 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
RULEID number 22
ERS_RULEMASTER.RULEID Implied Constraint R
ELEMENTID number 22
ERS_ELEMENTS.ELEMENTID Implied Constraint R
RULEGROUPING number 22
STRUCTUREID number 22
ERS_STRUCTURE.STRUCTUREID Implied Constraint R
OPERAND nvarchar2 100  √  null
ELEMENTVALUE2 nvarchar2 800  √  null
EXCLUDEINCLUDE nvarchar2 2  √  null
ELEMENTORDER number 22  √  null

Table contained 3,239 rows at Thu Dec 13 15:47 CST 2012

Indexes:
Column(s) Type Sort Constraint Name
RULEID + ELEMENTID + RULEGROUPING + STRUCTUREID Primary key Asc/Asc/Asc/Asc SYS_C0011495

Close relationships: