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

View rice-2.0.krim_rsp_role_actn_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_nmspc_cd | varchar | 40 |  |  |  |  |  |
rsp_id | varchar | 40 |  |  |  |  |
krim_rsp_t.RSP_ID | Implied Constraint R
NMSPC_CD | varchar | 40 | √ |  | null |  |  |
ROLE_NM | varchar | 80 | √ |  | null |  |  |
ROLE_ID | varchar | 40 | √ |  | null |  |
krim_role_t.ROLE_ID | Implied Constraint R
MBR_ID | varchar | 40 | √ |  | null |  |  |
MBR_TYP_CD | char | 1 | √ |  | P |  |  |
ROLE_MBR_ID | varchar | 40 | √ |  |  |  |
krim_role_mbr_t.ROLE_MBR_ID | Implied Constraint R
ACTN_TYP_CD | varchar | 40 | √ |  | null |  |  |
ACTN_PLCY_CD | varchar | 40 | √ |  | null |  |  |
FRC_ACTN | varchar | 1 | √ |  | N |  |  |
PRIORITY_NBR | decimal | 3 | √ |  | null |  |  |
Analyzed at Mon May 07 20:18 PDT 2012

View Definition:
select `rsp`.`NMSPC_CD` AS `rsp_nmspc_cd`,`rsp`.`RSP_ID` AS `rsp_id`,`r`.`NMSPC_CD` AS `NMSPC_CD`,`r`.`ROLE_NM` AS `ROLE_NM`,`rr`.`ROLE_ID` AS `ROLE_ID`,`rm`.`MBR_ID` AS `MBR_ID`,`rm`.`MBR_TYP_CD` AS `MBR_TYP_CD`,`rm`.`ROLE_MBR_ID` AS `ROLE_MBR_ID`,`actn`.`ACTN_TYP_CD` AS `ACTN_TYP_CD`,`actn`.`ACTN_PLCY_CD` AS `ACTN_PLCY_CD`,`actn`.`FRC_ACTN` AS `FRC_ACTN`,`actn`.`PRIORITY_NBR` AS `PRIORITY_NBR` 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_role_rsp_t` `rr` on((`rr`.`RSP_ID` = `rsp`.`RSP_ID`))) left join `rice_2_0clean`.`krim_role_mbr_t` `rm` on((`rm`.`ROLE_ID` = `rr`.`ROLE_ID`))) left join `rice_2_0clean`.`krim_role_rsp_actn_t` `actn` on(((`actn`.`ROLE_RSP_ID` = `rr`.`ROLE_RSP_ID`) and ((`actn`.`ROLE_MBR_ID` = `rm`.`ROLE_MBR_ID`) or (`actn`.`ROLE_MBR_ID` = '*'))))) left join `rice_2_0clean`.`krim_role_t` `r` on((`rr`.`ROLE_ID` = `r`.`ROLE_ID`))) order by `rsp`.`NMSPC_CD`,`rsp`.`RSP_ID`,`rr`.`ROLE_ID`,`rm`.`ROLE_MBR_ID`
Possibly Referenced Tables/Views:
krim_role_mbr_t krim_role_rsp_actn_t krim_role_rsp_t krim_role_t krim_rsp_t krim_rsp_tmpl_t

Close relationships: