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

SchemaSpy Analysis of rice-2.0 - 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_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.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

  214 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