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

View rice-2.0.krim_rsp_role_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
--- | --- | --- | --- | --- | --- | --- | --- | ---
rsp_tmpl_nmspc_cd | varchar | 40 | √ |  | null |  |  |
rsp_tmpl_nm | varchar | 100 | √ |  | null |  |  |
rsp_nmspc_cd | varchar | 40 |  |  |  |  |  |
rsp_nm | varchar | 100 |  |  |  |  |  |
rsp_id | varchar | 40 |  |  |  |  |
krim_rsp_t.RSP_ID | Implied Constraint R
attr_nm | varchar | 100 | √ |  | null |  |  |
attr_val | varchar | 400 | √ |  | null |  |  |
NMSPC_CD | varchar | 40 | √ |  | null |  |  |
ROLE_NM | varchar | 80 | √ |  | null |  |  |
ROLE_ID | varchar | 40 | √ |  | null |  |
krim_role_t.ROLE_ID | Implied Constraint R
Analyzed at Mon May 07 20:18 PDT 2012

View Definition:
select `rspt`.`NMSPC_CD` AS `rsp_tmpl_nmspc_cd`,`rspt`.`NM` AS `rsp_tmpl_nm`,`rsp`.`NMSPC_CD` AS `rsp_nmspc_cd`,`rsp`.`NM` AS `rsp_nm`,`rsp`.`RSP_ID` AS `rsp_id`,`a`.`NM` AS `attr_nm`,`d`.`ATTR_VAL` AS `attr_val`,`r`.`NMSPC_CD` AS `NMSPC_CD`,`r`.`ROLE_NM` AS `ROLE_NM`,`rr`.`ROLE_ID` AS `ROLE_ID` from (((((`rice-2.0`.`krim_rsp_t` `rsp` left join `rice_2_0clean`.`krim_rsp_tmpl_t` `rspt` on((`rsp`.`RSP_TMPL_ID` = `rspt`.`RSP_TMPL_ID`))) left join `rice_2_0clean`.`krim_rsp_attr_data_t` `d` on((`rsp`.`RSP_ID` = `d`.`RSP_ID`))) left join `rice_2_0clean`.`krim_attr_defn_t` `a` on((`d`.`KIM_ATTR_DEFN_ID` = `a`.`KIM_ATTR_DEFN_ID`))) left join `rice_2_0clean`.`krim_role_rsp_t` `rr` on((`rr`.`RSP_ID` = `rsp`.`RSP_ID`))) left join `rice_2_0clean`.`krim_role_t` `r` on((`rr`.`ROLE_ID` = `r`.`ROLE_ID`))) order by `rspt`.`NMSPC_CD`,`rspt`.`NM`,`rsp`.`NMSPC_CD`,`rsp`.`NM`,`rsp`.`RSP_ID`,`a`.`NM`,`d`.`ATTR_VAL`
Possibly Referenced Tables/Views:
krim_attr_defn_t krim_role_rsp_t krim_role_t krim_rsp_attr_data_t krim_rsp_t krim_rsp_tmpl_t

Close relationships: