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
ingeschr_nat_prs.[fk_17lnd_code_iso] land.[code_iso]
ingeschr_nat_prs.[fk_18lnd_code_iso] land.[code_iso]
ingeschr_nat_prs.[fk_gb_lnd_code_iso] land.[code_iso]
ingeschr_nat_prs.[fk_ol_lnd_code_iso] land.[code_iso]
kad_onrrnd_zk_aantek_archief.[fk_4koz_kad_identif] kad_onrrnd_zk.[kad_identif]
kad_onrrnd_zk_archief.[fk_7kdg_code] kad_gemeente.[code]
ouder_kind_rel.[ouder_aand] aard_verkregen_recht.[aand]
subject.[fk_vb_lnd_code_iso] land.[code_iso]
zak_recht.[fk_3avr_aand] aard_verkregen_recht.[aand]
zak_recht_archief.[fk_2aard_recht_verkort_aand] aard_recht_verkort.[aand]
zak_recht_archief.[fk_3avr_aand] aard_verkregen_recht.[aand]
zak_recht_archief.[fk_7koz_kad_identif] kad_onrrnd_zk.[kad_identif]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
ander_btnlnds_niet_nat_prs sc_identif
niet_ingezetene sc_identif

Tables with incrementing column names, potentially indicating denormalization

Table
subject

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

Table
Anomaly not detected