Table rice-2.1.1.krms_actn_t 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
ACTN_ID varchar 40
krms_actn_attr_t.ACTN_ID KRMS_ACTN_ATTR_FK1 R
NM varchar 40  √  null
DESC_TXT varchar 4000  √  null
TYP_ID varchar 40
krew_typ_t.TYP_ID Implied Constraint R
RULE_ID varchar 40  √  null
krms_rule_t.RULE_ID KRMS_ACTN_FK1 R
SEQ_NO decimal 5  √  null
VER_NBR decimal 8 0
NMSPC_CD varchar 40

Table contained 1 rows at Tue Sep 18 22:24 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ACTN_ID Primary key Asc PRIMARY
ACTN_ID + RULE_ID + SEQ_NO Must be unique Asc/Asc/Asc KRMS_ACTN_TC2
TYP_ID Performance Asc KRMS_ACTN_TI1
RULE_ID Performance Asc KRMS_ACTN_TI2
RULE_ID + SEQ_NO Performance Asc/Asc KRMS_ACTN_TI3

Close relationships  within of separation: