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
api_key.[key] setting.[key]
notification.[internal_id] core_session.[id]
parameter_card.[parameter_id] metabot_conversation.[id]
user_key_value.[key] setting.[key]
user_parameter_value.[parameter_id] metabot_conversation.[id]

Tables without indexes

Table
Anomaly not detected

Tables that contain a single column

Table Column
metabase_cluster_lock lock_name

Tables with incrementing column names, potentially indicating denormalization

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

Table
Anomaly not detected