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
badmailfrom.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
Configurations.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
dns_recs_t.[uid] dns_refs.[uid]
dom_level_usrs.[uid] dns_refs.[uid]
dsn.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
IisAppPools.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
IP_Addresses.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
ServiceInstallations.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
SharedSslDomains.[domainId] IisAppPoolDomains.[domainId]
SharedSslDomains.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
smtp_poplocks.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
spamfilter.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
sys_users.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]
Webmails.[serviceNodeId] IisAppPoolsPolicy.[serviceNodeId]

Tables without indexes

Table Rows
migration_version 1
suspend_handler_history 0

Tables that contain a single column

Table Column
IpCollections
migration_version
WebServerSettings

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