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

View rice-2.0.krim_role_perm_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 | √ |  | null |  |  |
ROLE_NM | varchar | 80 | √ |  | null |  |  |
role_id | varchar | 40 | √ |  |  |  |
krim_role_t.ROLE_ID | Implied Constraint R
tmpl_nmspc_cd | varchar | 40 | √ |  | null |  |  |
tmpl_nm | varchar | 100 | √ |  | null |  |  |
PERM_TMPL_ID | varchar | 40 | √ |  |  |  |
krim_perm_tmpl_t.PERM_TMPL_ID | Implied Constraint R
perm_nmpsc_cd | varchar | 40 |  |  |  |  |  |
perm_nm | varchar | 100 |  |  |  |  |  |
PERM_ID | varchar | 40 |  |  |  |  |
krim_perm_t.PERM_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`,`pt`.`NMSPC_CD` AS `tmpl_nmspc_cd`,`pt`.`NM` AS `tmpl_nm`,`pt`.`PERM_TMPL_ID` AS `PERM_TMPL_ID`,`p`.`NMSPC_CD` AS `perm_nmpsc_cd`,`p`.`NM` AS `perm_nm`,`p`.`PERM_ID` AS `PERM_ID`,`a`.`NM` AS `attr_nm`,`ad`.`ATTR_VAL` AS `attr_val` from (((((`rice-2.0`.`krim_perm_t` `p` left join `rice_2_0clean`.`krim_perm_tmpl_t` `pt` on((`p`.`PERM_TMPL_ID` = `pt`.`PERM_TMPL_ID`))) left join `rice_2_0clean`.`krim_perm_attr_data_t` `ad` on((`p`.`PERM_ID` = `ad`.`PERM_ID`))) left join `rice_2_0clean`.`krim_attr_defn_t` `a` on((`ad`.`KIM_ATTR_DEFN_ID` = `a`.`KIM_ATTR_DEFN_ID`))) left join `rice_2_0clean`.`krim_role_perm_t` `rp` on((`rp`.`PERM_ID` = `p`.`PERM_ID`))) left join `rice_2_0clean`.`krim_role_t` `r` on((`rp`.`ROLE_ID` = `r`.`ROLE_ID`))) order by `r`.`NMSPC_CD`,`r`.`ROLE_NM`,`pt`.`NMSPC_CD`,`pt`.`NM`,`p`.`PERM_ID`,`a`.`NM`
Possibly Referenced Tables/Views:
krim_attr_defn_t krim_perm_attr_data_t krim_perm_t krim_perm_tmpl_t krim_role_perm_t krim_role_t

Close relationships: