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
Anomaly not detected

Tables without indexes

Table
benefit_eligibility
form_care_plan
form_functional_cognitive_status
form_observation

Tables that contain a single column

Table Column
form_clinic_note id

Tables with incrementing column names, potentially indicating denormalization

Table
facility
form_eye_antseg
form_eye_biometrics
form_eye_hpi
form_eye_vitals
history_data
list_options
form_ankleinjury
form_bronchitis
patient_data
users
voids

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

Table
Anomaly not detected