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

View rice-2.0.krim_grp_mbr_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 | √ |  | null |  |  |
grp_nm | varchar | 80 | √ |  | null |  |  |
GRP_ID | varchar | 40 | √ |  |  |  |
krim_grp_t.GRP_ID | Implied Constraint R
PRNCPL_NM | varchar | 100 | √ |  | null |  |  |
PRNCPL_ID | varchar | 40 | √ |  |  |  |
krim_prncpl_t.PRNCPL_ID | Implied Constraint R
mbr_grp_nm | varchar | 80 | √ |  | null |  |  |
mbr_grp_id | varchar | 40 | √ |  |  |  |  |
Analyzed at Mon May 07 20:18 PDT 2012

View Definition:
select `g`.`NMSPC_CD` AS `NMSPC_CD`,`g`.`GRP_NM` AS `grp_nm`,`g`.`GRP_ID` AS `GRP_ID`,`p`.`PRNCPL_NM` AS `PRNCPL_NM`,`p`.`PRNCPL_ID` AS `PRNCPL_ID`,`mg`.`GRP_NM` AS `mbr_grp_nm`,`mg`.`GRP_ID` AS `mbr_grp_id` from ((((`rice-2.0`.`krim_grp_mbr_t` `gm` left join `rice_2_0clean`.`krim_grp_t` `g` on((`g`.`GRP_ID` = `gm`.`GRP_ID`))) left join `rice_2_0clean`.`krim_grp_t` `mg` on(((`mg`.`GRP_ID` = `gm`.`MBR_ID`) and (`gm`.`MBR_TYP_CD` = 'G')))) left join `rice_2_0clean`.`krim_prncpl_t` `p` on(((`p`.`PRNCPL_ID` = `gm`.`MBR_ID`) and (`gm`.`MBR_TYP_CD` = 'P')))) left join `rice_2_0clean`.`krim_entity_nm_t` `en` on(((`en`.`ENTITY_ID` = `p`.`ENTITY_ID`) and (`en`.`DFLT_IND` = 'Y') and (`en`.`ACTV_IND` = 'Y')))) order by `g`.`NMSPC_CD`,`g`.`GRP_NM`,`p`.`PRNCPL_NM`
Possibly Referenced Tables/Views:
krim_entity_nm_t krim_grp_mbr_t krim_grp_t krim_prncpl_t

Close relationships: