View rice-2.1.1.krim_grp_v 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
NMSPC_CD varchar 40
grp_nm varchar 80
GRP_ID varchar 40
krim_grp_t.GRP_ID Implied Constraint R
grp_typ_nm varchar 100  √  null
attr_nm varchar 100  √  null
attr_val varchar 400  √  null

Analyzed at Tue Sep 18 22:24 PDT 2012

View Definition:
select `g`.`NMSPC_CD` AS `NMSPC_CD`,`g`.`GRP_NM` AS `grp_nm`,`g`.`GRP_ID` AS `GRP_ID`,`t`.`NM` AS `grp_typ_nm`,`a`.`NM` AS `attr_nm`,`d`.`ATTR_VAL` AS `attr_val` from (((`rice-2.1.1`.`krim_grp_t` `g` left join `rice_2_1_1clean`.`krim_grp_attr_data_t` `d` on((`d`.`GRP_ID` = `g`.`GRP_ID`))) left join `rice_2_1_1clean`.`krim_attr_defn_t` `a` on((`a`.`KIM_ATTR_DEFN_ID` = `d`.`KIM_ATTR_DEFN_ID`))) left join `rice_2_1_1clean`.`krim_typ_t` `t` on((`g`.`KIM_TYP_ID` = `t`.`KIM_TYP_ID`)))
 
Possibly Referenced Tables/Views:
krim_attr_defn_t krim_grp_attr_data_t krim_grp_t krim_typ_t 


Close relationships: