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
cat_ayuda_marc.[campo] pref_estructura_campo_marc.[campo]
cat_estructura_catalogacion.[campo] pref_estructura_campo_marc.[campo]
cat_estructura_catalogacion.[idinforef] pref_informacion_referencia.[idinforef]
cat_visualizacion_intra.[campo] pref_estructura_campo_marc.[campo]
cat_visualizacion_opac.[campo] pref_estructura_campo_marc.[campo]
circ_prestamo.[nro_socio] usr_login_attempts.[nro_socio]
circ_prestamo_vencido_temp.[id_prestamo] circ_prestamo.[id_prestamo]
circ_reserva.[nro_socio] usr_login_attempts.[nro_socio]
circ_sancion.[id_reserva] circ_reserva.[id_reserva]
circ_sancion.[nro_socio] usr_login_attempts.[nro_socio]
circ_sancion.[tipo_sancion] circ_tipo_sancion.[tipo_sancion]
perm_catalogo.[id_persona] usr_persona.[id_persona]
perm_catalogo.[nro_socio] usr_login_attempts.[nro_socio]
rep_busqueda.[nro_socio] usr_login_attempts.[nro_socio]
rep_historial_busqueda.[idBusqueda] rep_busqueda.[idBusqueda]
rep_historial_circulacion.[nro_socio] usr_login_attempts.[nro_socio]
rep_historial_prestamo.[nro_socio] usr_login_attempts.[nro_socio]
rep_historial_sancion.[nro_socio] usr_login_attempts.[nro_socio]
rep_historial_sancion.[tipo_sancion] circ_tipo_sancion.[tipo_sancion]
usr_socio.[id_estado] usr_estado.[id_estado]
usr_socio.[id_persona] usr_persona.[id_persona]
usr_socio.[nro_socio] usr_login_attempts.[nro_socio]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
cat_rating
cat_registro_marc_n2_cover
cat_registro_marc_n3
circ_reserva
e_document
io_importacion_iso
io_importacion_iso_registro
perm_catalogo
rep_historial_circulacion

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

Table
Anomaly not detected