Columns whose name and type imply a relationship to another table's primary key
| Child Column | Implied Parent Column |
|---|---|
| casserviceticket.[name] | scheduler.[name] |
| casserviceticket.[username] | oppilaitos_ip_osoite.[username] |
| suoritusjako.[secret] | suoritusjako_v2.[secret] |
Tables without indexes
| Table | Rows |
|---|---|
| opiskeluoikeus_fixture | 174 |
| opiskeluoikeus_valpas_fixture | 247 |
| opiskeluoikeushistoria_fixture | 177 |
| opiskeluoikeushistoria_valpas_fixture | 247 |
Tables that contain a single column
| Table | Column | |
|---|---|---|
| Anomaly not detected | ||
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 | ||