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
app_user.[name] permission.[name]
burden_outcome.[name] permission.[name]
country.[name] permission.[name]
coverage_set.[name] permission.[name]
demographic_source.[name] permission.[name]
demographic_statistic_type.[name] permission.[name]
demographic_value_unit.[name] permission.[name]
demographic_variant.[name] permission.[name]
disease.[name] permission.[name]
impact_estimate_ingredient.[name] permission.[name]
impact_estimate_recipe.[name] permission.[name]
impact_outcome.[name] permission.[name]
responsibility_set_status.[name] permission.[name]
role.[name] permission.[name]
support_type.[name] permission.[name]
touchstone_status.[name] permission.[name]
vaccine.[name] permission.[name]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
onetime_token
permission

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