View rice-2.1.1.krim_perm_v Generated by
SchemaSpy
Legend: SourceForge.net
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
tmpl_nmspc_cd varchar 40
tmpl_nm varchar 100
PERM_TMPL_ID varchar 40
krim_perm_tmpl_t.PERM_TMPL_ID Implied Constraint R
perm_nmspc_cd varchar 40
perm_nm varchar 100
PERM_ID varchar 40
krim_perm_t.PERM_ID Implied Constraint R
perm_typ_nm varchar 100  √  null
SRVC_NM varchar 200  √  null

Analyzed at Tue Sep 18 22:24 PDT 2012

View Definition:
select `t`.`NMSPC_CD` AS `tmpl_nmspc_cd`,`t`.`NM` AS `tmpl_nm`,`t`.`PERM_TMPL_ID` AS `PERM_TMPL_ID`,`p`.`NMSPC_CD` AS `perm_nmspc_cd`,`p`.`NM` AS `perm_nm`,`p`.`PERM_ID` AS `PERM_ID`,`typ`.`NM` AS `perm_typ_nm`,`typ`.`SRVC_NM` AS `SRVC_NM` from ((`rice-2.1.1`.`krim_perm_t` `p` join `rice_2_1_1clean`.`krim_perm_tmpl_t` `t` on((`p`.`PERM_TMPL_ID` = `t`.`PERM_TMPL_ID`))) left join `rice_2_1_1clean`.`krim_typ_t` `typ` on((`t`.`KIM_TYP_ID` = `typ`.`KIM_TYP_ID`)))
 
Possibly Referenced Tables/Views:
krim_perm_t krim_perm_tmpl_t krim_typ_t 


Close relationships: