Anomalies

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
edi_sequences
fee_sheet_options
form_functional_cognitive_status
gacl_acl_seq
gacl_aco_sections_seq
gacl_aco_seq
gacl_aro_groups_id_seq
gacl_aro_sections_seq
gacl_aro_seq
lang_custom
module_acl_sections
modules_settings
sequences
version

Tables that contain a single column

Table	Column
categories_seq	id
edi_sequences	id
gacl_acl_seq	id
gacl_aco_sections_seq	id
gacl_aco_seq	id
gacl_aro_groups_id_seq	id
gacl_aro_sections_seq	id
gacl_aro_seq	id
form_clinic_note	id
sequences	id

Tables with incrementing column names, potentially indicating denormalization

Table
addresses
clinical_rules
facility
form_eye_antseg
form_eye_biometrics
form_eye_hpi
form_eye_vitals
form_history_sdoh
gprelations
history_data
icd10_reimbr_dx_9_10
icd10_reimbr_pcs_9_10
list_options
login_mfa_registrations
form_ankleinjury
form_bronchitis
patient_data
payments
users
users_secure
voids
x12_partners

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

Table
Anomaly not detected