View rice-2.1.1.krim_prncpl_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
PRNCPL_ID varchar 40
krim_prncpl_t.PRNCPL_ID Implied Constraint R
PRNCPL_NM varchar 100
FIRST_NM varchar 40  √  null
LAST_NM varchar 80  √  null
AFLTN_TYP_CD varchar 40  √  null
krim_afltn_typ_t.AFLTN_TYP_CD Implied Constraint R
CAMPUS_CD varchar 2  √  null
krlc_cmp_t.CAMPUS_CD Implied Constraint R
EMP_STAT_CD varchar 40  √  null
krim_emp_stat_t.EMP_STAT_CD Implied Constraint R
EMP_TYP_CD varchar 40  √  null
krim_emp_typ_t.EMP_TYP_CD Implied Constraint R

Analyzed at Tue Sep 18 22:24 PDT 2012

View Definition:
select `p`.`PRNCPL_ID` AS `PRNCPL_ID`,`p`.`PRNCPL_NM` AS `PRNCPL_NM`,`en`.`FIRST_NM` AS `FIRST_NM`,`en`.`LAST_NM` AS `LAST_NM`,`ea`.`AFLTN_TYP_CD` AS `AFLTN_TYP_CD`,`ea`.`CAMPUS_CD` AS `CAMPUS_CD`,`eei`.`EMP_STAT_CD` AS `EMP_STAT_CD`,`eei`.`EMP_TYP_CD` AS `EMP_TYP_CD` from (((`rice-2.1.1`.`krim_prncpl_t` `p` left join `rice_2_1_1clean`.`krim_entity_emp_info_t` `eei` on((`eei`.`ENTITY_ID` = `p`.`ENTITY_ID`))) left join `rice_2_1_1clean`.`krim_entity_afltn_t` `ea` on((`ea`.`ENTITY_ID` = `p`.`ENTITY_ID`))) left join `rice_2_1_1clean`.`krim_entity_nm_t` `en` on(((`p`.`ENTITY_ID` = `en`.`ENTITY_ID`) and ('Y' = `en`.`DFLT_IND`))))
 
Possibly Referenced Tables/Views:
krim_entity_afltn_t krim_entity_emp_info_t krim_entity_nm_t krim_prncpl_t 


Close relationships: