Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| lahtokoulut.[henkilo_oid] | henkilot.[oid] |
| lahtokoulut.[oppilaitos_oid] | henkilot.[oid] |
| yliajot.[haku_oid] | henkilot.[oid] |
| yliajot.[henkilo_oid] | henkilot.[oid] |
| yliajot.[virkailija_oid] | henkilot.[oid] |
Tables without indexes
| Table | ||
|---|---|---|
| Anomaly not detected | ||
Tables that contain a single column
| Table | Column |
|---|---|
| henkilot | oid |
Tables with incrementing column names, potentially indicating denormalization
| Table | ||
|---|---|---|
| Anomaly not detected | ||
Columns whose default value is the word 'NULL' or 'null'
| Table | ||
|---|---|---|
| Anomaly not detected | ||