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

View rice-2.0.krim_rsp_attr_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
--- | --- | --- | --- | --- | --- | --- | --- | ---
responsibility_type_name | varchar | 100 | √ |  | null |  |  |
rsp_TEMPLATE_NAME | varchar | 100 |  |  |  |  |  |
rsp_namespace_code | varchar | 40 |  |  |  |  |  |
rsp_NAME | varchar | 100 |  |  |  |  |  |
rsp_id | varchar | 40 |  |  |  |  |
krim_rsp_t.RSP_ID | Implied Constraint R
attribute_name | varchar | 100 | √ |  | null |  |  |
attribute_value | varchar | 400 | √ |  | null |  |  |
Analyzed at Mon May 07 20:18 PDT 2012

View Definition:
select `rice-2.0`.`krim_typ_t`.`NM` AS `responsibility_type_name`,`rice_2_0clean`.`krim_rsp_tmpl_t`.`NM` AS `rsp_TEMPLATE_NAME`,`rice_2_0clean`.`krim_rsp_t`.`NMSPC_CD` AS `rsp_namespace_code`,`rice_2_0clean`.`krim_rsp_t`.`NM` AS `rsp_NAME`,`rice_2_0clean`.`krim_rsp_t`.`RSP_ID` AS `rsp_id`,`rice_2_0clean`.`krim_attr_defn_t`.`NM` AS `attribute_name`,`rice_2_0clean`.`krim_rsp_attr_data_t`.`ATTR_VAL` AS `attribute_value` from ((((`rice_2_0clean`.`krim_rsp_t` join `rice_2_0clean`.`krim_rsp_attr_data_t` on((`rice_2_0clean`.`krim_rsp_t`.`RSP_ID` = `rice_2_0clean`.`krim_rsp_attr_data_t`.`RSP_ID`))) join `rice_2_0clean`.`krim_attr_defn_t` on((`rice_2_0clean`.`krim_rsp_attr_data_t`.`KIM_ATTR_DEFN_ID` = `rice_2_0clean`.`krim_attr_defn_t`.`KIM_ATTR_DEFN_ID`))) join `rice_2_0clean`.`krim_rsp_tmpl_t` on((`rice_2_0clean`.`krim_rsp_t`.`RSP_TMPL_ID` = `rice_2_0clean`.`krim_rsp_tmpl_t`.`RSP_TMPL_ID`))) join `rice_2_0clean`.`krim_typ_t` on((`rice_2_0clean`.`krim_rsp_tmpl_t`.`KIM_TYP_ID` = `rice_2_0clean`.`krim_typ_t`.`KIM_TYP_ID`))) order by `rice_2_0clean`.`krim_rsp_tmpl_t`.`NM`,`rice_2_0clean`.`krim_rsp_t`.`NM`,`rice_2_0clean`.`krim_attr_defn_t`.`NM`
Possibly Referenced Tables/Views:
krim_attr_defn_t krim_rsp_attr_data_t krim_rsp_t krim_rsp_tmpl_t krim_typ_t

Close relationships: