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
mod_version.[version] terms_of_service.[version]
updates_balancetesting.[id] leaderboard.[id]
updates_blackops.[id] leaderboard.[id]
updates_civilians.[id] leaderboard.[id]
updates_claustrophobia.[id] leaderboard.[id]
updates_coop.[id] leaderboard.[id]
updates_diamond.[id] leaderboard.[id]
updates_equilibrium.[id] leaderboard.[id]
updates_faf.[id] leaderboard.[id]
updates_fafbeta.[id] leaderboard.[id]
updates_fafdevelop.[id] leaderboard.[id]
updates_gw.[id] leaderboard.[id]
updates_koth.[id] leaderboard.[id]
updates_labwars.[id] leaderboard.[id]
updates_murderparty.[id] leaderboard.[id]
updates_nomads.[id] leaderboard.[id]
updates_phantomx.[id] leaderboard.[id]
updates_tutorials.[id] leaderboard.[id]
updates_vanilla.[id] leaderboard.[id]
updates_xtremewars.[id] leaderboard.[id]

Tables without indexes

Table Rows
faction 4

Tables that contain a single column

Table Column
email_domain_blacklist domain

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