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] |
| subject.[fk_vb_lnd_code_iso] | land.[code_iso] |
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 | ||