SchemaSpy - View rice-2.1.1.krim_role

Generated by
SchemaSpy

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

ROLE_NM

varchar

ROLE_ID

varchar

krim_role_t.ROLE_ID

Implied Constraint R

role_typ_nm

varchar

100

√

null

SRVC_NM

varchar

200

√

null

KIM_TYP_ID

varchar

krim_typ_t.KIM_TYP_ID

Implied Constraint R

Analyzed at Tue Sep 18 22:24 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.1.1`.`krim_role_t` `r` join `rice_2_1_1clean`.`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