SchemaSpy Analysis of rice-2.1.1 - Constraints Generated by
SchemaSpy
138 Foreign Key Constraints:
SourceForge.net

Constraint Name Child Column Parent Column Delete Rule
BK_ORDER_ENTRY_T_BK_BOOK_T bk_order_entry_t.BOOK_ID bk_book_t.BOOK_ID Restrict delete 
BK_ORDER_ENTRY_T_KRNS_DO_ADV1 bk_order_entry_t.DOC_HDR_ID krns_doc_hdr_t.DOC_HDR_ID Restrict delete 
KR_POSTAL_CODE_TR1 krlc_pstl_cd_t.POSTAL_CNTRY_CD krlc_cntry_t.POSTAL_CNTRY_CD Restrict delete 
KR_POSTAL_CODE_TR2 krlc_pstl_cd_t.POSTAL_STATE_CD
krlc_pstl_cd_t.POSTAL_CNTRY_CD
krlc_st_t.POSTAL_STATE_CD
krlc_st_t.POSTAL_CNTRY_CD
Restrict delete 
KR_POSTAL_CODE_TR3 krlc_pstl_cd_t.COUNTY_CD
krlc_pstl_cd_t.POSTAL_STATE_CD
krlc_pstl_cd_t.POSTAL_CNTRY_CD
krlc_cnty_t.COUNTY_CD
krlc_cnty_t.STATE_CD
krlc_cnty_t.POSTAL_CNTRY_CD
Restrict delete 
KR_STATE_TR1 krlc_st_t.POSTAL_CNTRY_CD krlc_cntry_t.POSTAL_CNTRY_CD Restrict delete 
KREN_CHAN_SUBSCRP_FK1 kren_chnl_subscrp_t.CHNL_ID kren_chnl_t.CHNL_ID Restrict delete 
KREN_CHNL_PRODCR_FK1 kren_chnl_prodcr_t.CHNL_ID kren_chnl_t.CHNL_ID Restrict delete 
KREN_CHNL_PRODCR_FK2 kren_chnl_prodcr_t.PRODCR_ID kren_prodcr_t.PRODCR_ID Restrict delete 
KREN_MSG_DELIV_FK1 kren_msg_deliv_t.MSG_ID kren_msg_t.MSG_ID Restrict delete 
KREN_NTFCTN_FK1 kren_ntfctn_t.CHNL_ID kren_chnl_t.CHNL_ID Restrict delete 
KREN_NTFCTN_FK2 kren_ntfctn_t.CNTNT_TYP_ID kren_cntnt_typ_t.CNTNT_TYP_ID Restrict delete 
KREN_NTFCTN_FK3 kren_ntfctn_t.PRIO_ID kren_prio_t.PRIO_ID Restrict delete 
KREN_NTFCTN_FK4 kren_ntfctn_t.PRODCR_ID kren_prodcr_t.PRODCR_ID Restrict delete 
KREN_NTFCTN_MSG_DELIV_FK1 kren_ntfctn_msg_deliv_t.NTFCTN_ID kren_ntfctn_t.NTFCTN_ID Restrict delete 
KREN_RECIP_FK1 kren_recip_t.NTFCTN_ID kren_ntfctn_t.NTFCTN_ID Restrict delete 
KREN_RECIP_LIST_FK1 kren_recip_list_t.CHNL_ID kren_chnl_t.CHNL_ID Restrict delete 
KREN_SNDR_FK1 kren_sndr_t.NTFCTN_ID kren_ntfctn_t.NTFCTN_ID Restrict delete 
KREW_PPL_FLW_ATTR_FK1 krew_ppl_flw_attr_t.PPL_FLW_ID krew_ppl_flw_t.PPL_FLW_ID Restrict delete 
KREW_PPL_FLW_ATTR_FK2 krew_ppl_flw_attr_t.ATTR_DEFN_ID krew_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KREW_PPL_FLW_DLGT_FK1 krew_ppl_flw_dlgt_t.PPL_FLW_MBR_ID krew_ppl_flw_mbr_t.PPL_FLW_MBR_ID Restrict delete 
KREW_PPL_FLW_FK1 krew_ppl_flw_t.TYP_ID krew_typ_t.TYP_ID Restrict delete 
KREW_PPL_FLW_MBR_FK1 krew_ppl_flw_mbr_t.PPL_FLW_ID krew_ppl_flw_t.PPL_FLW_ID Restrict delete 
KREW_RULE_TR1 krew_rule_t.RULE_EXPR_ID krew_rule_expr_t.RULE_EXPR_ID Restrict delete 
KREW_TYP_ATTR_FK1 krew_typ_attr_t.ATTR_DEFN_ID krew_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KREW_TYP_ATTR_FK2 krew_typ_attr_t.TYP_ID krew_typ_t.TYP_ID Restrict delete 
KRIM_DLGN_MBR_ATTR_DATA_TR1 krim_dlgn_mbr_attr_data_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_DLGN_MBR_ATTR_DATA_TR2 krim_dlgn_mbr_attr_data_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Restrict delete 
KRIM_DLGN_MBR_TR2 krim_dlgn_mbr_t.DLGN_ID krim_dlgn_t.DLGN_ID Restrict delete 
KRIM_DLGN_TR1 krim_dlgn_t.ROLE_ID krim_role_t.ROLE_ID Restrict delete 
KRIM_DLGN_TR2 krim_dlgn_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_ENTITY_ADDR_TR1 krim_entity_addr_t.ENT_TYP_CD
krim_entity_addr_t.ENTITY_ID
krim_entity_ent_typ_t.ENT_TYP_CD
krim_entity_ent_typ_t.ENTITY_ID
Cascade on delete 
KRIM_ENTITY_ADDR_TR2 krim_entity_addr_t.ADDR_TYP_CD krim_addr_typ_t.ADDR_TYP_CD Restrict delete 
KRIM_ENTITY_AFLTN_TR1 krim_entity_afltn_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_AFLTN_TR2 krim_entity_afltn_t.AFLTN_TYP_CD krim_afltn_typ_t.AFLTN_TYP_CD Restrict delete 
KRIM_ENTITY_CTZNSHP_TR1 krim_entity_ctznshp_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_CTZNSHP_TR2 krim_entity_ctznshp_t.CTZNSHP_STAT_CD krim_ctznshp_stat_t.CTZNSHP_STAT_CD Restrict delete 
KRIM_ENTITY_EMAIL_TR1 krim_entity_email_t.ENT_TYP_CD
krim_entity_email_t.ENTITY_ID
krim_entity_ent_typ_t.ENT_TYP_CD
krim_entity_ent_typ_t.ENTITY_ID
Cascade on delete 
KRIM_ENTITY_EMP_INFO_TR1 krim_entity_emp_info_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_EMP_INFO_TR2 krim_entity_emp_info_t.EMP_STAT_CD krim_emp_stat_t.EMP_STAT_CD Restrict delete 
KRIM_ENTITY_EMP_INFO_TR3 krim_entity_emp_info_t.EMP_TYP_CD krim_emp_typ_t.EMP_TYP_CD Restrict delete 
KRIM_ENTITY_EMP_INFO_TR4 krim_entity_emp_info_t.ENTITY_AFLTN_ID krim_entity_afltn_t.ENTITY_AFLTN_ID Restrict delete 
KRIM_ENTITY_ENT_TYP_TR1 krim_entity_ent_typ_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_ENT_TYP_TR2 krim_entity_ent_typ_t.ENT_TYP_CD krim_ent_typ_t.ENT_TYP_CD Restrict delete 
KRIM_ENTITY_ETHNIC_TR1 krim_entity_ethnic_t.ENTITY_ID krim_entity_t.ENTITY_ID Restrict delete 
KRIM_ENTITY_EXT_ID_TR1 krim_entity_ext_id_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_EXT_ID_TR2 krim_entity_ext_id_t.EXT_ID_TYP_CD krim_ext_id_typ_t.EXT_ID_TYP_CD Restrict delete 
KRIM_ENTITY_NM_TR1 krim_entity_nm_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ENTITY_PHONE_TR1 krim_entity_phone_t.ENT_TYP_CD
krim_entity_phone_t.ENTITY_ID
krim_entity_ent_typ_t.ENT_TYP_CD
krim_entity_ent_typ_t.ENTITY_ID
Cascade on delete 
KRIM_ENTITY_PHONE_TR2 krim_entity_phone_t.PHONE_TYP_CD krim_phone_typ_t.PHONE_TYP_CD Restrict delete 
KRIM_ENTITY_RESIDENCY_TR1 krim_entity_residency_t.ENTITY_ID krim_entity_t.ENTITY_ID Restrict delete 
KRIM_ENTITY_VISA_TR1 krim_entity_visa_t.ENTITY_ID krim_entity_t.ENTITY_ID Restrict delete 
KRIM_GRP_ATTR_DATA_TR1 krim_grp_attr_data_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_GRP_ATTR_DATA_TR2 krim_grp_attr_data_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Restrict delete 
KRIM_GRP_ATTR_DATA_TR3 krim_grp_attr_data_t.GRP_ID krim_grp_t.GRP_ID Cascade on delete 
KRIM_GRP_MBR_TR1 krim_grp_mbr_t.GRP_ID krim_grp_t.GRP_ID Cascade on delete 
KRIM_GRP_TR1 krim_grp_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_PERM_ATTR_DATA_TR1 krim_perm_attr_data_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_PERM_ATTR_DATA_TR2 krim_perm_attr_data_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Restrict delete 
KRIM_PERM_ATTR_DATA_TR3 krim_perm_attr_data_t.PERM_ID krim_perm_t.PERM_ID Cascade on delete 
KRIM_PERM_TMPL_TR1 krim_perm_tmpl_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_PERM_TR1 krim_perm_t.PERM_TMPL_ID krim_perm_tmpl_t.PERM_TMPL_ID Restrict delete 
KRIM_PND_AFLTN_MT_FK1 krim_pnd_afltn_mt.FDOC_NBR krim_person_document_t.FDOC_NBR Restrict delete 
KRIM_PRNCPL_TR1 krim_prncpl_t.ENTITY_ID krim_entity_t.ENTITY_ID Cascade on delete 
KRIM_ROLE_MBR_ATTR_DATA_TR1 krim_role_mbr_attr_data_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_ROLE_MBR_ATTR_DATA_TR2 krim_role_mbr_attr_data_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Restrict delete 
KRIM_ROLE_MBR_TR1 krim_role_mbr_t.ROLE_ID krim_role_t.ROLE_ID Cascade on delete 
KRIM_ROLE_PERM_TR1 krim_role_perm_t.PERM_ID krim_perm_t.PERM_ID Restrict delete 
KRIM_ROLE_RSP_TR1 krim_role_rsp_t.RSP_ID krim_rsp_t.RSP_ID Restrict delete 
KRIM_ROLE_TR1 krim_role_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_RSP_ATTR_DATA_TR1 krim_rsp_attr_data_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_RSP_ATTR_DATA_TR2 krim_rsp_attr_data_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Restrict delete 
KRIM_RSP_ATTR_DATA_TR3 krim_rsp_attr_data_t.RSP_ID krim_rsp_t.RSP_ID Cascade on delete 
KRIM_RSP_TMPL_TR1 krim_rsp_tmpl_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Restrict delete 
KRIM_RSP_TR1 krim_rsp_t.RSP_TMPL_ID krim_rsp_tmpl_t.RSP_TMPL_ID Restrict delete 
KRIM_TYP_ATTR_TR2 krim_typ_attr_t.KIM_ATTR_DEFN_ID krim_attr_defn_t.KIM_ATTR_DEFN_ID Cascade on delete 
KRIM_TYP_ATTRIBUTE_TR1 krim_typ_attr_t.KIM_TYP_ID krim_typ_t.KIM_TYP_ID Cascade on delete 
KRMS_ACTN_ATTR_FK1 krms_actn_attr_t.ACTN_ID krms_actn_t.ACTN_ID Restrict delete 
KRMS_ACTN_ATTR_FK2 krms_actn_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_ACTN_FK1 krms_actn_t.RULE_ID krms_rule_t.RULE_ID Restrict delete 
KRMS_AGENDA_ATTR_FK1 krms_agenda_attr_t.AGENDA_ID krms_agenda_t.AGENDA_ID Restrict delete 
KRMS_AGENDA_ATTR_FK2 krms_agenda_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_AGENDA_FK1 krms_agenda_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_AGENDA_ITM_FK1 krms_agenda_itm_t.RULE_ID krms_rule_t.RULE_ID Restrict delete 
KRMS_AGENDA_ITM_FK2 krms_agenda_itm_t.AGENDA_ID krms_agenda_t.AGENDA_ID Restrict delete 
KRMS_AGENDA_ITM_FK3 krms_agenda_itm_t.SUB_AGENDA_ID krms_agenda_t.AGENDA_ID Restrict delete 
KRMS_AGENDA_ITM_FK4 krms_agenda_itm_t.WHEN_TRUE krms_agenda_itm_t.AGENDA_ITM_ID Restrict delete 
KRMS_AGENDA_ITM_FK5 krms_agenda_itm_t.WHEN_FALSE krms_agenda_itm_t.AGENDA_ITM_ID Restrict delete 
KRMS_AGENDA_ITM_FK6 krms_agenda_itm_t.ALWAYS krms_agenda_itm_t.AGENDA_ITM_ID Restrict delete 
KRMS_CMPND_PROP_PROPS_FK1 krms_cmpnd_prop_props_t.PROP_ID krms_prop_t.PROP_ID Restrict delete 
KRMS_CMPND_PROP_PROPS_FK2 krms_cmpnd_prop_props_t.CMPND_PROP_ID krms_prop_t.PROP_ID Restrict delete 
KRMS_CNTXT_ATTR_FK1 krms_cntxt_attr_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_ATTR_FK2 krms_cntxt_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_CNTXT_VLD_ACTN_TYP_FK1 krms_cntxt_vld_actn_typ_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_VLD_AGENDA_TYP_FK1 krms_cntxt_vld_agenda_typ_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_VLD_FUNC_FK1 krms_cntxt_vld_func_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_VLD_RULE_TYP_FK1 krms_cntxt_vld_rule_typ_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_VLD_TERM_SPEC_TI1 krms_cntxt_vld_term_spec_t.CNTXT_ID krms_cntxt_t.CNTXT_ID Restrict delete 
KRMS_CNTXT_VLD_TERM_SPEC_TI2 krms_cntxt_vld_term_spec_t.TERM_SPEC_ID krms_term_spec_t.TERM_SPEC_ID Restrict delete 
KRMS_FUNC_CTGRY_FK1 krms_func_ctgry_t.FUNC_ID krms_func_t.FUNC_ID Restrict delete 
KRMS_FUNC_CTGRY_FK2 krms_func_ctgry_t.CTGRY_ID krms_ctgry_t.CTGRY_ID Restrict delete 
KRMS_FUNC_FK1 krms_func_t.TYP_ID krms_typ_t.TYP_ID Restrict delete 
KRMS_FUNC_PARM_FK1 krms_func_parm_t.FUNC_ID krms_func_t.FUNC_ID Restrict delete 
KRMS_INPUT_ASSET_FK1 krms_term_rslvr_input_spec_t.TERM_RSLVR_ID krms_term_rslvr_t.TERM_RSLVR_ID Restrict delete 
KRMS_INPUT_ASSET_FK2 krms_term_rslvr_input_spec_t.TERM_SPEC_ID krms_term_spec_t.TERM_SPEC_ID Restrict delete 
KRMS_PROP_FK2 krms_prop_t.TYP_ID krms_typ_t.TYP_ID Restrict delete 
KRMS_PROP_PARM_FK1 krms_prop_parm_t.PROP_ID krms_prop_t.PROP_ID Restrict delete 
KRMS_RULE_ATTR_FK1 krms_rule_attr_t.RULE_ID krms_rule_t.RULE_ID Restrict delete 
KRMS_RULE_ATTR_FK2 krms_rule_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_RULE_FK1 krms_rule_t.PROP_ID krms_prop_t.PROP_ID Restrict delete 
KRMS_TERM_PARM_FK1 krms_term_parm_t.TERM_ID krms_term_t.TERM_ID Restrict delete 
KRMS_TERM_RESLV_PARM_FK1 krms_term_rslvr_parm_spec_t.TERM_RSLVR_ID krms_term_rslvr_t.TERM_RSLVR_ID Restrict delete 
KRMS_TERM_RSLVR_ATTR_FK1 krms_term_rslvr_attr_t.TERM_RSLVR_ID krms_term_rslvr_t.TERM_RSLVR_ID Restrict delete 
KRMS_TERM_RSLVR_ATTR_FK2 krms_term_rslvr_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_TERM_RSLVR_FK1 krms_term_rslvr_t.OUTPUT_TERM_SPEC_ID krms_term_spec_t.TERM_SPEC_ID Restrict delete 
KRMS_TERM_RSLVR_FK3 krms_term_rslvr_t.TYP_ID krms_typ_t.TYP_ID Restrict delete 
KRMS_TERM_SPEC_CTGRY_FK1 krms_term_spec_ctgry_t.TERM_SPEC_ID krms_term_spec_t.TERM_SPEC_ID Restrict delete 
KRMS_TERM_SPEC_CTGRY_FK2 krms_term_spec_ctgry_t.CTGRY_ID krms_ctgry_t.CTGRY_ID Restrict delete 
KRMS_TERM_T__FK1 krms_term_t.TERM_SPEC_ID krms_term_spec_t.TERM_SPEC_ID Restrict delete 
KRMS_TYP_ATTR_FK1 krms_typ_attr_t.ATTR_DEFN_ID krms_attr_defn_t.ATTR_DEFN_ID Restrict delete 
KRMS_TYP_ATTR_FK2 krms_typ_attr_t.TYP_ID krms_typ_t.TYP_ID Restrict delete 
KRNS_ATT_TR1 krns_att_t.NTE_ID krns_nte_t.NTE_ID Restrict delete 
KRNS_MAINT_DOC_ATT_LST_FK1 krns_maint_doc_att_lst_t.DOC_HDR_ID krns_maint_doc_t.DOC_HDR_ID Restrict delete 
KRNS_MAINT_DOC_TR1 krns_maint_doc_t.DOC_HDR_ID krns_doc_hdr_t.DOC_HDR_ID Restrict delete 
KRNS_NTE_TR1 krns_nte_t.NTE_TYP_CD krns_nte_typ_t.NTE_TYP_CD Restrict delete 
KRNS_PARM_DTL_TYP_TR1 krcr_cmpnt_t.NMSPC_CD krcr_nmspc_t.NMSPC_CD Restrict delete 
KRNS_PARM_TR1 krcr_parm_t.NMSPC_CD krcr_nmspc_t.NMSPC_CD Restrict delete 
KRNS_PARM_TR2 krcr_parm_t.PARM_TYP_CD krcr_parm_typ_t.PARM_TYP_CD Restrict delete 
KRSB_QRTZ_BLOB_TRIGGERS_TR1 krsb_qrtz_blob_triggers.TRIGGER_NAME
krsb_qrtz_blob_triggers.TRIGGER_GROUP
krsb_qrtz_triggers.TRIGGER_NAME
krsb_qrtz_triggers.TRIGGER_GROUP
Restrict delete 
KRSB_QRTZ_CRON_TRIGGERS_TR1 krsb_qrtz_cron_triggers.TRIGGER_NAME
krsb_qrtz_cron_triggers.TRIGGER_GROUP
krsb_qrtz_triggers.TRIGGER_NAME
krsb_qrtz_triggers.TRIGGER_GROUP
Restrict delete 
KRSB_QRTZ_SIMPLE_TRIGGERS_TR1 krsb_qrtz_simple_triggers.TRIGGER_NAME
krsb_qrtz_simple_triggers.TRIGGER_GROUP
krsb_qrtz_triggers.TRIGGER_NAME
krsb_qrtz_triggers.TRIGGER_GROUP
Restrict delete 
KRSB_QRTZ_TRIGGER_LISTENE_TR1 krsb_qrtz_trigger_listeners.TRIGGER_NAME
krsb_qrtz_trigger_listeners.TRIGGER_GROUP
krsb_qrtz_triggers.TRIGGER_NAME
krsb_qrtz_triggers.TRIGGER_GROUP
Restrict delete 
KRSB_QUARTZ_JOB_LISTENERS_TR1 krsb_qrtz_job_listeners.JOB_NAME
krsb_qrtz_job_listeners.JOB_GROUP
krsb_qrtz_job_details.JOB_NAME
krsb_qrtz_job_details.JOB_GROUP
Restrict delete 
KRSB_SVC_DEF_FK1 krsb_svc_def_t.SVC_DSCRPTR_ID krsb_svc_dscrptr_t.SVC_DSCRPTR_ID Cascade on delete 
NOTIFICATION_REVIEWERS_N_FK1 kren_rvwer_t.CHNL_ID kren_chnl_t.CHNL_ID Restrict delete 
SH_CAMPUS_TR1 krlc_cmp_t.CAMPUS_TYP_CD krlc_cmp_typ_t.CAMPUS_TYP_CD Restrict delete 
SYS_C003453453 trv_multi_att_sample.ATTACHMENT_ID trv_att_sample.ATTACHMENT_ID Restrict delete 
TRV_ACCT_FK1 trv_acct.ACCT_FO_ID trv_acct_fo.ACCT_FO_ID Restrict delete 

Check Constraints:

Table Constraint Name Constraint
None detected