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
CERT_ENDORSEMENT_DOCUMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
COUNTRY.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
COUNTRY_EXTERNAL_LINK.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
DISPENSATION.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
FRAUDULENT_CERTIFICATE.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
FRAUDULENT_CERTIFICATE_DOC.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
INSPECTION_TEAM.[TEAM_ID] TEAM.[TEAM_ID]
LEGAL_ENTITY.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
LEGAL_ENTITY_DOCUMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
LEGAL_REQUIREMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
MET_PROGRAMM_DOCUMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
METC_SYSTEM.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
PROCESS_COLLECTION.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
PROCESS_ENUM_LEGAL_ENTITY.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
QUALITY_SYSTEM_DOCUMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
RECOGNISED_COUNTRY.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]
TRAINING_FACILITY_DOCUMENT.[ENUM_STATUS_ID] ENUM_STATUS.[ENUM_STATUS_ID]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

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

Table
Anomaly not detected