SchemaSpy Analysis of rice-2.1.1 - Anomalies

Generated by SchemaSpy

Things that might not be 'quite right' about your schema:

• Columns whose name and type imply a relationship to another table's primary key:

  Child Column	Implied Parent Column
  acct_dd_attr_doc.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  bk_address_t.ADDR_TYP	bk_address_typ_t.ADDR_TYP
  bk_address_t.AUTHOR_ID	bk_author_account_t.AUTHOR_ID
  bk_author_t.AUTHOR_ID	bk_author_account_t.AUTHOR_ID
  bk_book_author_t.AUTHOR_ID	bk_author_account_t.AUTHOR_ID
  bk_book_author_t.BOOK_ID	bk_book_t.BOOK_ID
  bk_book_t.TYP_CD	bk_book_typ_t.TYP_CD
  kr_kim_test_bo.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krcr_drvd_cmpnt_t.CMPNT_SET_ID	krcr_cmpnt_set_t.CMPNT_SET_ID
  krcr_drvd_cmpnt_t.NMSPC_CD	krcr_nmspc_t.NMSPC_CD
  kren_chnl_subscrp_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  kren_recip_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  kren_rvwer_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krew_actn_itm_t.ACTN_RQST_ID	krew_actn_rqst_t.ACTN_RQST_ID
  krew_actn_itm_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_actn_itm_t.GRP_ID	krim_grp_t.GRP_ID
  krew_actn_itm_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krew_actn_itm_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_actn_rqst_t.ACTN_TKN_ID	krew_actn_tkn_t.ACTN_TKN_ID
  krew_actn_rqst_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_actn_rqst_t.GRP_ID	krim_grp_t.GRP_ID
  krew_actn_rqst_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krew_actn_rqst_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_actn_rqst_t.RTE_NODE_INSTN_ID	krew_rte_node_instn_t.RTE_NODE_INSTN_ID
  krew_actn_rqst_t.RULE_ID	krms_rule_t.RULE_ID
  krew_actn_tkn_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_actn_tkn_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krew_app_doc_stat_tran_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_dlgn_rsp_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_doc_hdr_ext_dt_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_hdr_ext_flt_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_hdr_ext_long_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_hdr_ext_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_hdr_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_hdr_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_doc_nte_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_typ_app_doc_stat_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_doc_typ_attr_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_doc_typ_attr_t.RULE_ATTR_ID	krms_rule_attr_t.RULE_ATTR_ID
  krew_doc_typ_plcy_reln_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_doc_typ_proc_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_doc_typ_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_doc_typ_t.GRP_ID	krim_grp_t.GRP_ID
  krew_edl_dmp_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_edl_fld_dmp_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_init_rte_node_instn_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_init_rte_node_instn_t.RTE_NODE_INSTN_ID	krew_rte_node_instn_t.RTE_NODE_INSTN_ID
  krew_out_box_itm_t.ACTN_ITM_ID	krew_actn_itm_t.ACTN_ITM_ID
  krew_out_box_itm_t.ACTN_RQST_ID	krew_actn_rqst_t.ACTN_RQST_ID
  krew_out_box_itm_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_out_box_itm_t.GRP_ID	krim_grp_t.GRP_ID
  krew_out_box_itm_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krew_out_box_itm_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_ppl_flw_dlgt_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_ppl_flw_mbr_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_rte_brch_st_t.RTE_BRCH_ID	krew_rte_brch_t.RTE_BRCH_ID
  krew_rte_node_cfg_parm_t.RTE_NODE_ID	krew_rte_node_t.RTE_NODE_ID
  krew_rte_node_instn_st_t.RTE_NODE_INSTN_ID	krew_rte_node_instn_t.RTE_NODE_INSTN_ID
  krew_rte_node_instn_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_rte_node_instn_t.RTE_NODE_ID	krew_rte_node_t.RTE_NODE_ID
  krew_rte_node_t.DOC_TYP_ID	krew_doc_typ_t.DOC_TYP_ID
  krew_rte_node_t.GRP_ID	krim_grp_t.GRP_ID
  krew_rule_attr_t.RULE_ATTR_ID	krms_rule_attr_t.RULE_ATTR_ID
  krew_rule_ext_t.RULE_ID	krms_rule_t.RULE_ID
  krew_rule_ext_t.RULE_TMPL_ATTR_ID	krew_rule_tmpl_attr_t.RULE_TMPL_ATTR_ID
  krew_rule_ext_val_t.RULE_EXT_ID	krew_rule_ext_t.RULE_EXT_ID
  krew_rule_rsp_t.RSP_ID	krim_rsp_t.RSP_ID
  krew_rule_rsp_t.RULE_ID	krms_rule_t.RULE_ID
  krew_rule_t.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  krew_rule_t.RULE_ID	krms_rule_t.RULE_ID
  krew_rule_t.RULE_TMPL_ID	krew_rule_tmpl_t.RULE_TMPL_ID
  krew_rule_tmpl_attr_t.RULE_ATTR_ID	krms_rule_attr_t.RULE_ATTR_ID
  krew_rule_tmpl_attr_t.RULE_TMPL_ID	krew_rule_tmpl_t.RULE_TMPL_ID
  krew_rule_tmpl_optn_t.RULE_TMPL_ID	krew_rule_tmpl_t.RULE_TMPL_ID
  krew_usr_optn_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krim_dlgn_mbr_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_dlgn_mbr_attr_data_t.DLGN_MBR_ID	krim_dlgn_mbr_t.DLGN_MBR_ID
  krim_dlgn_mbr_t.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_entity_addr_t.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_entity_afltn_t.CAMPUS_CD	krlc_cmp_t.CAMPUS_CD
  krim_entity_bio_t.ENTITY_ID	krim_entity_priv_pref_t.ENTITY_ID
  krim_entity_cache_t.ENTITY_ID	krim_entity_priv_pref_t.ENTITY_ID
  krim_entity_cache_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krim_entity_ctznshp_t.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_entity_email_t.EMAIL_TYP_CD	krim_email_typ_t.EMAIL_TYP_CD
  krim_entity_ethnic_t.ID	trv_acct_use_rt_t.ID
  krim_entity_phone_t.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_entity_residency_t.ID	trv_acct_use_rt_t.ID
  krim_entity_t.ENTITY_ID	krim_entity_priv_pref_t.ENTITY_ID
  krim_entity_visa_t.ID	trv_acct_use_rt_t.ID
  krim_grp_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_grp_document_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_grp_document_t.GRP_ID	krim_grp_t.GRP_ID
  krim_grp_document_t.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_perm_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_person_document_t.ENTITY_ID	krim_entity_priv_pref_t.ENTITY_ID
  krim_person_document_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_person_document_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krim_pnd_addr_mt.ADDR_TYP_CD	krim_addr_typ_t.ADDR_TYP_CD
  krim_pnd_addr_mt.ENTITY_ADDR_ID	krim_entity_addr_t.ENTITY_ADDR_ID
  krim_pnd_addr_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_addr_mt.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_pnd_afltn_mt.AFLTN_TYP_CD	krim_afltn_typ_t.AFLTN_TYP_CD
  krim_pnd_afltn_mt.CAMPUS_CD	krlc_cmp_t.CAMPUS_CD
  krim_pnd_afltn_mt.ENTITY_AFLTN_ID	krim_entity_afltn_t.ENTITY_AFLTN_ID
  krim_pnd_ctznshp_mt.CTZNSHP_STAT_CD	krim_ctznshp_stat_t.CTZNSHP_STAT_CD
  krim_pnd_ctznshp_mt.ENTITY_CTZNSHP_ID	krim_entity_ctznshp_t.ENTITY_CTZNSHP_ID
  krim_pnd_ctznshp_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_ctznshp_mt.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_pnd_dlgn_mbr_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_pnd_dlgn_mbr_attr_data_t.DLGN_MBR_ID	krim_dlgn_mbr_t.DLGN_MBR_ID
  krim_pnd_dlgn_mbr_attr_data_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_dlgn_mbr_attr_data_t.KIM_ATTR_DEFN_ID	krim_attr_defn_t.KIM_ATTR_DEFN_ID
  krim_pnd_dlgn_mbr_attr_data_t.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_dlgn_mbr_t.DLGN_ID	krim_dlgn_t.DLGN_ID
  krim_pnd_dlgn_mbr_t.DLGN_MBR_ID	krim_dlgn_mbr_t.DLGN_MBR_ID
  krim_pnd_dlgn_mbr_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_dlgn_mbr_t.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_pnd_dlgn_t.DLGN_ID	krim_dlgn_t.DLGN_ID
  krim_pnd_dlgn_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_dlgn_t.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_dlgn_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_pnd_email_mt.EMAIL_TYP_CD	krim_email_typ_t.EMAIL_TYP_CD
  krim_pnd_email_mt.ENT_TYP_CD	krim_ent_typ_t.ENT_TYP_CD
  krim_pnd_email_mt.ENTITY_EMAIL_ID	krim_entity_email_t.ENTITY_EMAIL_ID
  krim_pnd_email_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_emp_info_mt.EMP_STAT_CD	krim_emp_stat_t.EMP_STAT_CD
  krim_pnd_emp_info_mt.EMP_TYP_CD	krim_emp_typ_t.EMP_TYP_CD
  krim_pnd_emp_info_mt.ENTITY_AFLTN_ID	krim_entity_afltn_t.ENTITY_AFLTN_ID
  krim_pnd_emp_info_mt.ENTITY_EMP_ID	krim_entity_emp_info_t.ENTITY_EMP_ID
  krim_pnd_emp_info_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_grp_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_pnd_grp_attr_data_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_grp_attr_data_t.GRP_ID	krim_grp_t.GRP_ID
  krim_pnd_grp_attr_data_t.KIM_ATTR_DEFN_ID	krim_attr_defn_t.KIM_ATTR_DEFN_ID
  krim_pnd_grp_attr_data_t.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_grp_mbr_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_grp_mbr_t.GRP_ID	krim_grp_t.GRP_ID
  krim_pnd_grp_mbr_t.GRP_MBR_ID	krim_grp_mbr_t.GRP_MBR_ID
  krim_pnd_grp_prncpl_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_grp_prncpl_mt.GRP_ID	krim_grp_t.GRP_ID
  krim_pnd_grp_prncpl_mt.GRP_MBR_ID	krim_grp_mbr_t.GRP_MBR_ID
  krim_pnd_grp_prncpl_mt.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_grp_prncpl_mt.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krim_pnd_nm_mt.ENTITY_NM_ID	krim_entity_nm_t.ENTITY_NM_ID
  krim_pnd_nm_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_phone_mt.ENT_TYP_CD	krim_ent_typ_t.ENT_TYP_CD
  krim_pnd_phone_mt.ENTITY_PHONE_ID	krim_entity_phone_t.ENTITY_PHONE_ID
  krim_pnd_phone_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_phone_mt.PHONE_TYP_CD	krim_phone_typ_t.PHONE_TYP_CD
  krim_pnd_phone_mt.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krim_pnd_priv_pref_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_mbr_attr_data_mt.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krim_pnd_role_mbr_attr_data_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_mbr_attr_data_mt.KIM_ATTR_DEFN_ID	krim_attr_defn_t.KIM_ATTR_DEFN_ID
  krim_pnd_role_mbr_attr_data_mt.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_role_mbr_attr_data_mt.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_pnd_role_mbr_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_mbr_mt.ROLE_ID	krim_role_t.ROLE_ID
  krim_pnd_role_mbr_mt.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_pnd_role_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_mt.KIM_TYP_ID	krim_typ_t.KIM_TYP_ID
  krim_pnd_role_mt.ROLE_ID	krim_role_t.ROLE_ID
  krim_pnd_role_perm_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_perm_t.PERM_ID	krim_perm_t.PERM_ID
  krim_pnd_role_perm_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_pnd_role_perm_t.ROLE_PERM_ID	krim_role_perm_t.ROLE_PERM_ID
  krim_pnd_role_rsp_actn_mt.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_rsp_actn_mt.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_pnd_role_rsp_actn_mt.ROLE_RSP_ACTN_ID	krim_role_rsp_actn_t.ROLE_RSP_ACTN_ID
  krim_pnd_role_rsp_actn_mt.ROLE_RSP_ID	krim_role_rsp_t.ROLE_RSP_ID
  krim_pnd_role_rsp_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_pnd_role_rsp_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_pnd_role_rsp_t.ROLE_RSP_ID	krim_role_rsp_t.ROLE_RSP_ID
  krim_pnd_role_rsp_t.RSP_ID	krim_rsp_t.RSP_ID
  krim_role_document_t.FDOC_NBR	trv_doc_2.FDOC_NBR
  krim_role_document_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_role_mbr_attr_data_t.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_role_perm_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_role_rsp_actn_t.ROLE_MBR_ID	krim_role_mbr_t.ROLE_MBR_ID
  krim_role_rsp_actn_t.ROLE_RSP_ID	krim_role_rsp_t.ROLE_RSP_ID
  krim_role_rsp_t.ROLE_ID	krim_role_t.ROLE_ID
  krim_rsp_attr_data_t.ATTR_DATA_ID	krim_role_mbr_attr_data_t.ATTR_DATA_ID
  krlc_cnty_t.POSTAL_CNTRY_CD	krlc_cntry_t.POSTAL_CNTRY_CD
  krms_actn_t.TYP_ID	krew_typ_t.TYP_ID
  krms_agenda_t.TYP_ID	krew_typ_t.TYP_ID
  krms_cntxt_t.TYP_ID	krew_typ_t.TYP_ID
  krms_cntxt_vld_func_t.FUNC_ID	krms_func_t.FUNC_ID
  krms_prop_t.RULE_ID	krms_rule_t.RULE_ID
  krms_rule_t.TYP_ID	krew_typ_t.TYP_ID
  krms_typ_attr_t.TYP_ATTR_ID	krew_typ_attr_t.TYP_ATTR_ID
  krms_typ_t.TYP_ID	krew_typ_t.TYP_ID
  krns_adhoc_rte_actn_recip_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  krns_lookup_rslt_t.LOOKUP_RSLT_ID	krns_lookup_sel_t.LOOKUP_RSLT_ID
  krns_lookup_rslt_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krns_lookup_sel_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krns_maint_doc_att_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  krns_maint_lock_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  krns_pessimistic_lock_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  krns_pessimistic_lock_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krns_sesn_doc_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID
  krns_sesn_doc_t.PRNCPL_ID	krim_prncpl_t.PRNCPL_ID
  krsb_bam_parm_t.BAM_ID	krsb_bam_t.BAM_ID
  krsb_msg_que_t.MSG_QUE_ID	krsb_msg_pyld_t.MSG_QUE_ID
  krsb_qrtz_fired_triggers.INSTANCE_NAME	krsb_qrtz_scheduler_state.INSTANCE_NAME
  krsb_qrtz_fired_triggers.TRIGGER_GROUP	krsb_qrtz_paused_trigger_grps.TRIGGER_GROUP
  krsb_qrtz_triggers.CALENDAR_NAME	krsb_qrtz_calendars.CALENDAR_NAME
  krsb_qrtz_triggers.TRIGGER_GROUP	krsb_qrtz_paused_trigger_grps.TRIGGER_GROUP
  krsb_svc_def_t.TYP_CD	bk_book_typ_t.TYP_CD
  trav_doc_2_accounts.ACCT_NUM	trv_acct.ACCT_NUM
  trav_doc_2_accounts.FDOC_NBR	trv_doc_2.FDOC_NBR
  trv_acct_ext.ACCT_NUM	trv_acct.ACCT_NUM
  trv_acct_use_rt_t.ACCT_NUM	trv_acct.ACCT_NUM
  trv_doc_acct.ACCT_NUM	trv_acct.ACCT_NUM
  trv_doc_acct.DOC_HDR_ID	krew_doc_hdr_cntnt_t.DOC_HDR_ID
  tst_search_attr_indx_tst_doc_t.DOC_HDR_ID	krns_maint_doc_t.DOC_HDR_ID

  216 instances of anomaly detected

• Tables without indexes:

  Table	Rows
  kr_kim_test_bo	0

  1 instance of anomaly detected

• Columns that are flagged as both 'nullable' and 'must be unique':

  Column
  kren_msg_t.ORGN_ID
  krew_doc_typ_t.DOC_TYP_NM
  krew_doc_typ_t.DOC_TYP_VER_NBR
  krim_addr_typ_t.NM
  krim_afltn_typ_t.NM
  krim_ctznshp_stat_t.NM
  krim_email_typ_t.NM
  krim_emp_stat_t.NM
  krim_emp_typ_t.NM
  krim_ent_nm_typ_t.NM
  krim_ent_typ_t.NM
  krim_ext_id_typ_t.NM
  krim_phone_typ_t.PHONE_TYP_NM
  krim_role_rsp_actn_t.ROLE_MBR_ID
  krim_role_rsp_actn_t.ROLE_RSP_ID

  15 instances of anomaly detected

• Tables that contain a single column:

  Table	Column
  krsb_qrtz_locks	LOCK_NAME
  krsb_qrtz_paused_trigger_grps	TRIGGER_GROUP

  2 instances of anomaly detected

• Tables with incrementing column names, potentially indicating denormalization:

  Table
  bk_address_t
  krim_entity_addr_t
  krim_pnd_addr_mt

  3 instances of anomaly detected

• Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:

  Column
  krms_attr_defn_t.DESC_TXT
  krms_cntxt_t.DESC_TXT
  krms_term_spec_t.DESC_TXT
  krms_term_t.DESC_TXT

  4 instances of anomaly detected