Tables Relationships Utility Tables Constraints Anomalies Columns Download Rice 2.0 Schema Spy zip

View rice-2.0.krim_grp_v | Generated by SchemaSpy

Implied relationships Related columns Constraints Comments Legend |
Legend: |
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 Mon May 07 20:18 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.0`.`krim_grp_t` `g` left join `rice_2_0clean`.`krim_grp_attr_data_t` `d` on((`d`.`GRP_ID` = `g`.`GRP_ID`))) left join `rice_2_0clean`.`krim_attr_defn_t` `a` on((`a`.`KIM_ATTR_DEFN_ID` = `d`.`KIM_ATTR_DEFN_ID`))) left join `rice_2_0clean`.`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: