Table shrdb.LAWRS.ERS_RULEMASTER 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_RULEACCESS.RULEID Implied Constraint R
ERS_RULEDETAIL.RULEID Implied Constraint R
ERS_RULEMAPPINGS.RULEID Implied Constraint R
ERS_RULEVALUES.RULEID Implied Constraint R
ERS_STRUCTUREMAPPING.RULEID Implied Constraint R
RULENAME nvarchar2 510
RULEDESCRIPTION nvarchar2 800  √  null
STRUCTUREID number 22  √  null
ERS_STRUCTURE.STRUCTUREID Implied Constraint R
RULEOWNER nvarchar2 150  √  null
STARTDATE timestamp(6) 11,6  √  null
ENDDATE timestamp(6) 11,6  √  null
STATUS nvarchar2 100  √  null
ALLOWPARTIAL nvarchar2 100  √  null
RULEORDER number 22  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
RULEID Primary key Asc SYS_C0011497

Close relationships: