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

View rice-2.0.krim_role_prncpl_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 |  |  |  |  |  |
ROLE_NM | varchar | 80 |  |  |  |  |  |
ROLE_ID | varchar | 40 |  |  |  |  |
krim_role_t.ROLE_ID | Implied Constraint R
PRNCPL_NM | varchar | 100 | √ |  | null |  |  |
PRNCPL_ID | varchar | 40 | √ |  |  |  |
krim_prncpl_t.PRNCPL_ID | Implied Constraint R
FIRST_NM | varchar | 40 | √ |  | null |  |  |
LAST_NM | varchar | 80 | √ |  | null |  |  |
ROLE_MBR_ID | varchar | 40 | √ |  |  |  |
krim_role_mbr_t.ROLE_MBR_ID | Implied Constraint R
attr_nm | varchar | 100 | √ |  | null |  |  |
attr_val | varchar | 400 | √ |  | null |  |  |
Analyzed at Mon May 07 20:18 PDT 2012

View Definition:
select `r`.`NMSPC_CD` AS `NMSPC_CD`,`r`.`ROLE_NM` AS `ROLE_NM`,`r`.`ROLE_ID` AS `ROLE_ID`,`p`.`PRNCPL_NM` AS `PRNCPL_NM`,`p`.`PRNCPL_ID` AS `PRNCPL_ID`,`en`.`FIRST_NM` AS `FIRST_NM`,`en`.`LAST_NM` AS `LAST_NM`,`rm`.`ROLE_MBR_ID` AS `ROLE_MBR_ID`,`ad`.`NM` AS `attr_nm`,`rmad`.`ATTR_VAL` AS `attr_val` from (((((`rice-2.0`.`krim_role_t` `r` left join `rice_2_0clean`.`krim_role_mbr_t` `rm` on((`r`.`ROLE_ID` = `rm`.`ROLE_ID`))) left join `rice_2_0clean`.`krim_role_mbr_attr_data_t` `rmad` on((`rm`.`ROLE_MBR_ID` = `rmad`.`ROLE_MBR_ID`))) left join `rice_2_0clean`.`krim_attr_defn_t` `ad` on((`rmad`.`KIM_ATTR_DEFN_ID` = `ad`.`KIM_ATTR_DEFN_ID`))) left join `rice_2_0clean`.`krim_prncpl_t` `p` on(((`rm`.`MBR_ID` = `p`.`PRNCPL_ID`) and (`rm`.`MBR_TYP_CD` = 'P')))) left join `rice_2_0clean`.`krim_entity_nm_t` `en` on((`p`.`ENTITY_ID` = `en`.`ENTITY_ID`))) where (`en`.`DFLT_IND` = 'Y') order by `r`.`NMSPC_CD`,`r`.`ROLE_NM`,`p`.`PRNCPL_NM`,`rm`.`ROLE_MBR_ID`,`ad`.`NM`
Possibly Referenced Tables/Views:
krim_attr_defn_t krim_entity_nm_t krim_prncpl_t krim_role_mbr_attr_data_t krim_role_mbr_t krim_role_t

Close relationships: