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

View rice-2.0.krim_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
--- | --- | --- | --- | --- | --- | --- | --- | ---
NMSPC_CD | varchar | 40 |  |  |  |  |  |
ROLE_NM | varchar | 80 |  |  |  |  |  |
ROLE_ID | varchar | 40 |  |  |  |  |
krim_role_t.ROLE_ID | Implied Constraint R
role_typ_nm | varchar | 100 | √ |  | null |  |  |
SRVC_NM | varchar | 200 | √ |  | null |  |  |
KIM_TYP_ID | varchar | 40 |  |  |  |  |
krim_typ_t.KIM_TYP_ID | Implied Constraint R
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`,`t`.`NM` AS `role_typ_nm`,`t`.`SRVC_NM` AS `SRVC_NM`,`t`.`KIM_TYP_ID` AS `KIM_TYP_ID` from `rice-2.0`.`krim_role_t` `r` join `rice_2_0clean`.`krim_typ_t` `t` where ((`t`.`KIM_TYP_ID` = `r`.`KIM_TYP_ID`) and (`r`.`ACTV_IND` = 'Y')) order by `r`.`NMSPC_CD`,`r`.`ROLE_NM`
Possibly Referenced Tables/Views:
krim_role_t krim_typ_t

Close relationships: