Table rice-2.2.0-SNAPSHOT.krms_prop_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
PROP_ID varchar 40
krms_cmpnd_prop_props_t.CMPND_PROP_ID KRMS_CMPND_PROP_PROPS_FK2 R
krms_cmpnd_prop_props_t.PROP_ID KRMS_CMPND_PROP_PROPS_FK1 R
krms_prop_parm_t.PROP_ID KRMS_PROP_PARM_FK1 R
krms_rule_t.PROP_ID KRMS_RULE_FK1 R
DESC_TXT varchar 100  √  null
TYP_ID varchar 40  √  null
krms_typ_t.TYP_ID KRMS_PROP_FK2 R
DSCRM_TYP_CD varchar 10
CMPND_OP_CD varchar 40  √  null
RULE_ID varchar 40
krms_rule_t.RULE_ID Implied Constraint R
VER_NBR decimal 8 0
CMPND_SEQ_NO decimal 5  √  null

Table contained 20 rows at Fri May 10 14:36 PDT 2013

Indexes:
Column(s) Type Sort Constraint Name
PROP_ID Primary key Asc PRIMARY
TYP_ID Performance Asc KRMS_PROP_FK2
RULE_ID Performance Asc KRMS_PROP_TI1

Close relationships  within of separation: