Anomalies


Things that might not be 'quite right' about your database and schema

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

Child Column Implied Parent Column
ss_objeto_esp_gasto_hist.[obj_clasificador] ss_objeto_esp_gasto.[obj_clasificador]
ss_rel_acta_categoria_hist.[rel_id] ss_rel_acta_categoria.[rel_id]

Tables without indexes

Table Rows
databasechangelog 0
ss_act_asignacion_np_hist 0
ss_actividad_po_pory_hist 0
ss_anio_fiscal_hist 14
ss_anio_indicador_hist 10454
ss_archivo_hist 0
ss_areas_inversion_hist 0
ss_beneficiarios 0
ss_beneficiarios_hist 0
ss_cat_conv_proyecto_hist 0
ss_categoper_hist 0
ss_categoria_convenio_hist 2
ss_categoria_hist 11
ss_categoria_presupuesto_escolar_hist 0
ss_cert_disp_pres_hist 0
ss_clasificador_funcional_hist 0
ss_cmp_re_exp_pagos_hist 0
ss_cod_ins_articulo_hist 0
ss_cod_ins_clase_hist 0
ss_cod_ins_familia_hist 0
ss_cod_ins_segmento_hist 0
ss_comen_cert_disp_hist 0
ss_compromisos_prestario_hist 0
ss_con_monto_por_anio_hist 0
ss_configuraciones_hist 11
ss_contrato_oc_hist 0
ss_convenio_hist 2
ss_cuentas_hist 0
ss_desembolso_transferencia_componente_hist 0
ss_errores_hist 0
ss_factura_hist 0
ss_flujo_caja_anio_hist 0
ss_fuente_aporte_proy_hist 0
ss_fuente_financiamiento_hist 0
ss_fuente_proyecto_hist 0
ss_fuente_recursos_hist 0
ss_gantt_hist 0
ss_gantt_task_hist 0
ss_ges_pres_es_hist 0
ss_idiomas_hist 0
ss_impuestos_hist 0
ss_ind_form_med_hist 0
ss_indicador_hist 2116
ss_inf_comprometido_hist 0
ss_inf_compromiso_hist 0
ss_inf_devengado_hist 0
ss_inf_pagado_hist 0
ss_insumo_hist 0
ss_linea_estrategica_hist 25
ss_lock_hist 19
ss_log_auditoria_hist 0
ss_macro_actividad_hist 5
ss_meta_indicador_hist 0
ss_metodo_adq_hist 0
ss_metodo_adq_rango_hist 0
ss_metodo_adq_tarea_hist 0
ss_modificativa_contrato_hist 0
ss_normativa_hist 0
ss_notificaciones_hist 66260
ss_nros_comp_recep_pago_hist 0
ss_objeto_esp_gasto_hist 0
ss_oficina_hist 0
ss_operacion_hist 0
ss_pac_grupo_hist 0
ss_pac_hist 0
ss_pago_contrato_hist 0
ss_pago_insumo_hist 0
ss_periodo_seg_ind_hist 0
ss_pla_de_ins_nodo_hist 0
ss_pla_estrategica_hist 6
ss_plantillas_correo_hist 0
ss_po_act_hist 0
ss_po_com_val_seg_hist 0
ss_po_fluj_caj_hist 0
ss_po_ind_lin_hist 0
ss_po_insumo_anio_hist 0
ss_po_insumo_hist 0
ss_po_linea_actividad_hist 0
ss_po_linea_colabora_hist 0
ss_po_linea_hist 0
ss_po_mont_fuent_i_fcm_hist 0
ss_po_mont_fuent_i_hist 0
ss_po_val_seg_hist 0
ss_po_valor_c_producto_hist 0
ss_po_valores_c_indicador_hist 0
ss_poa_actividades_metas_hist 17017
ss_poa_general_hist 0
ss_poa_hist 4637
ss_poa_metas_anuales_hist 16413
ss_poa_programacion_trimestral_hist 86
ss_poa_rel_poa_linea_hist 0
ss_poa_rel_poa_riesgo_hist 0
ss_poa_riesgo_hist 0
ss_poa_riesgos_poa_hist 3651
ss_pog_mont_fuent_i_hist 0
ss_pog_proyecto_hist 0
ss_pog_rel_pog_linea_hist 0
ss_pol_contrasenia_hist 2
ss_polizas_de_concen_hist 0
ss_pro_adq_insumo_hist 0
ss_pro_adq_item_ofer_ins_hist 0
ss_pro_adq_item_prov_ofer_hist 0
ss_proceso_adq_hist 0
ss_proceso_adq_item_hist 0
ss_proceso_adq_lote_hist 0
ss_proceso_adq_prov_hist 0
ss_prog_fin_acc_central_hist 0
ss_prog_fin_asig_np_hist 0
ss_prog_ind_hist 1802
ss_progp_tech_anio_hist 39
ss_programa_hist 394
ss_proveedor_hist 0
ss_proy_aportramo_tramo_hist 0
ss_proy_categoria_hist 0
ss_proy_co_eje_hist 0
ss_proy_desembolso_hist 0
ss_proy_documento_hist 0
ss_proy_enmienda_hist 0
ss_proy_est_por_fuente_hist 0
ss_proy_est_producto_hist 0
ss_proy_paripassu_tramo_hist 0
ss_proy_prorroga_hist 0
ss_proy_tech_pre_apor_hist 0
ss_proy_tech_presup_hist 0
ss_proyecto_est_hist 0
ss_proyecto_hist 6
ss_proyecto_indic_hist 0
ss_quedan_emitidos_hist 0
ss_quedan_val_imp_hist 0
ss_rangos_de_matricula_hist 0
ss_rel_acta_categoria_hist 0
ss_rel_acta_item_hist 0
ss_rel_asig_activnp_hist 0
ss_rel_cert_disp_pres_f 0
ss_rel_cert_disp_pres_f_hist 0
ss_rel_componentepresupescolar_areainv_hist 0
ss_rel_con_linea_hist 0
ss_rel_cont_fluj_caj_anio_hist 0
ss_rel_convenio_categ_hist 2
ss_rel_fc_anio_g_pac_hist 0
ss_rel_fc_anio_po_insumo_hist 0
ss_rel_fluj_anio_fluj_mes_hist 0
ss_rel_gantt_task_hist 0
ss_rel_ges_pres_es_anio_fiscal_hist 0
ss_rel_ges_pres_es_tipo_organismo_escolar 0
ss_rel_ges_pres_es_tipo_organismo_escolar_hist 0
ss_rel_gespresanio_clasificacion_hist 0
ss_rel_impuesto_cont_hist 0
ss_rel_insumo_cert_val_hist 0
ss_rel_modi_fluj_caj_anio_hist 0
ss_rel_pac_poa_hist 0
ss_rel_padqitem_padqins_hist 0
ss_rel_pla_linea_hist 13
ss_rel_poa_con_act_act_hist 0
ss_rel_poa_riesgos_hist 1382
ss_rel_pol_impuesto_hist 0
ss_rel_pres_anio_financiamiento_hist 0
ss_rel_pro_fluj_caj_anio_hist 0
ss_rel_pro_linea_hist 174
ss_rel_prog_p_prog_i_hist 16
ss_rel_proyecto_indicador_hist 5
ss_rel_reprog_fuentes_hist 0
ss_rel_rol_operacion_hist 0
ss_rel_techo_pres_fr_hist 0
ss_rel_techo_pres_ut_hist 0
ss_rel_usu_rol_hist 16
ss_reporte_pac_hist 0
ss_reporte_pep_hist 0
ss_reprog_detalle_hist 0
ss_reprogramaciones_hist 0
ss_rol_hist 3
ss_rubro_hist 0
ss_secuencias_hist 0
ss_seq_contrato_orden_hist 0
ss_seq_p_adq_hist 0
ss_sub_rubro_hist 0
ss_supuesto_hist 3
ss_tdr_hist 0
ss_techo_act_accc_hist 0
ss_techo_asig_np_hist 0
ss_techo_pla_accc_hist 0
ss_techo_pres_goes_hist 0
ss_techo_prog_pres_anio_hist 0
ss_techo_prog_pres_f_hist 0
ss_texto_ayuda_hist 167
ss_textos_hist 33
ss_tipo_documento_hist 0
ss_tipos_transferencia 0
ss_tipos_transferencia_hist 0
ss_token_password_hist 0
ss_tope_detalle_matriculas_hist 0
ss_tope_presupestal_hist 0
ss_transferencias_componente_hist 0
ss_transferencias_hist 0
ss_unidad_de_medida_hist 0
ss_unidad_tecnica_hist 340
ss_usu_ofi_roles_hist 0
ss_usuario_hist 909
ss_valor_de_indicador_hist 0
ss_valor_indicador_hist 0

Tables that contain a single column

Table Column
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected