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

View rice-2.0.krim_prncpl_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
--- | --- | --- | --- | --- | --- | --- | --- | ---
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 Mon May 07 20:18 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.0`.`krim_prncpl_t` `p` left join `rice_2_0clean`.`krim_entity_emp_info_t` `eei` on((`eei`.`ENTITY_ID` = `p`.`ENTITY_ID`))) left join `rice_2_0clean`.`krim_entity_afltn_t` `ea` on((`ea`.`ENTITY_ID` = `p`.`ENTITY_ID`))) left join `rice_2_0clean`.`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: