Table shrdb.LAWRS.ERS_STRUCTURE 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
STRUCTUREID number 22
ERS_RULEDETAIL.STRUCTUREID Implied Constraint R
ERS_RULEMASTER.STRUCTUREID Implied Constraint R
ERS_RULEVALUES.STRUCTUREID Implied Constraint R
ERS_STRUCTUREMAPPING.STRUCTUREID Implied Constraint R
ERS_STRUCTURETEMPLATE.STRUCTUREID Implied Constraint R
ERS_STRUCTURETOFIELDMAP.STRUCTUREID Implied Constraint R
STRUCTURENAME nvarchar2 1020
STRUCTUREDESCRIPTION nvarchar2 800  √  null
STATUS nvarchar2 100  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
STRUCTUREID Primary key Asc SYS_C0011506

Close relationships: