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
activities.[name] shedlock.[name]
ai_generation_templates.[template_name] shedlock.[name]
ai_prompt_profiles.[name] shedlock.[name]
ai_rule_sets.[name] shedlock.[name]
announcement_recipients.[recipient_name] shedlock.[name]
antecedent_interventions.[name] shedlock.[name]
antecedents.[name] shedlock.[name]
assessment_templates.[name] shedlock.[name]
assessment_tools.[name] shedlock.[name]
assistance_levels.[name] shedlock.[name]
availity_payer_capability.[payer_name] shedlock.[name]
boilerplate_templates.[name] shedlock.[name]
boilerplate_variables.[name] shedlock.[name]
business_entities.[name] shedlock.[name]
business_lines.[name] shedlock.[name]
business_lines.[trade_name] shedlock.[name]
caregiver_training_topics.[name] shedlock.[name]
caregivers.[status_changed_by_name] shedlock.[name]
cases.[insurance_name] shedlock.[name]
cases.[name] shedlock.[name]
catalog_activities.[name] shedlock.[name]
catalog_antecedent_interventions.[name] shedlock.[name]
catalog_antecedents.[name] shedlock.[name]
catalog_assessment_tools.[name] shedlock.[name]
catalog_assistance_levels.[name] shedlock.[name]
catalog_caregiver_training_topics.[name] shedlock.[name]
catalog_clearinghouses.[name] shedlock.[name]
catalog_clinical_documents.[name] shedlock.[name]
catalog_competency_options.[name] shedlock.[name]
catalog_consequence_interventions.[name] shedlock.[name]
catalog_consequences.[name] shedlock.[name]
catalog_credentials.[name] shedlock.[name]
catalog_credentials.[organization_name] shedlock.[name]
catalog_discriminative_stimuli.[name] shedlock.[name]
catalog_environmental_changes.[name] shedlock.[name]
catalog_focus_interventions.[name] shedlock.[name]
catalog_hr_documents.[name] shedlock.[name]
catalog_hypothesized_functions.[name] shedlock.[name]
catalog_interventions.[name] shedlock.[name]
catalog_maladaptive_behaviors.[name] shedlock.[name]
catalog_medical_concerns.[name] shedlock.[name]
catalog_participation_justifications.[name] shedlock.[name]
catalog_payers.[name] shedlock.[name]
catalog_prompts.[name] shedlock.[name]
catalog_protocol_modification_categories.[name] shedlock.[name]
catalog_protocols.[name] shedlock.[name]
catalog_reinforcers.[name] shedlock.[name]
catalog_replacement_behaviors.[name] shedlock.[name]
catalog_scheduled_reinforcements.[name] shedlock.[name]
catalog_teaching_materials.[name] shedlock.[name]
catalog_teaching_objectives.[name] shedlock.[name]
catalog_teaching_procedures.[name] shedlock.[name]
catalog_treatment_targets.[name] shedlock.[name]
clearinghouses.[name] shedlock.[name]
client_files.[original_file_name] shedlock.[name]
client_files.[uploaded_by_name] shedlock.[name]
client_pharmacies.[name] shedlock.[name]
client_status_change_history.[changed_by_name] shedlock.[name]
clients.[emergency_contact_name] shedlock.[name]
clinical_documents.[name] shedlock.[name]
competency_options.[name] shedlock.[name]
consequence_interventions.[name] shedlock.[name]
consequences.[name] shedlock.[name]
contact_organizations.[name] shedlock.[name]
credentials.[name] shedlock.[name]
credentials.[organization_name] shedlock.[name]
daily_operation_logs.[related_entity_name] shedlock.[name]
datasheet_initials_audit_log.[changed_by_user_name] shedlock.[name]
datasheet_initials_audit_log.[new_user_name] shedlock.[name]
datasheet_initials_audit_log.[old_user_name] shedlock.[name]
datasheets.[ioa_observer_name] shedlock.[name]
datasheets.[locked_by_user_name] shedlock.[name]
datasheets.[signed_by_user_name] shedlock.[name]
discriminative_stimuli.[name] shedlock.[name]
documents.[name] shedlock.[name]
documents.[uploaded_by_name] shedlock.[name]
eligibility_check.[plan_name] shedlock.[name]
encounter_note_narratives.[custom_section_name] shedlock.[name]
flyway_schema_history_bak_20260705_canon.[installed_rank] flyway_schema_history.[installed_rank]
flyway_schema_history_bak_20260706.[installed_rank] flyway_schema_history.[installed_rank]
focus_interventions.[name] shedlock.[name]
hr_documents.[name] shedlock.[name]
hypothesized_functions.[name] shedlock.[name]
insurances.[insurance_name] shedlock.[name]
insurances.[plan_name] shedlock.[name]
location_business_lines.[name] shedlock.[name]
location_business_lines.[trade_name] shedlock.[name]
locations.[name] shedlock.[name]
maladaptive_behaviors.[name] shedlock.[name]
medical_concerns.[name] shedlock.[name]
medications.[name] shedlock.[name]
note_templates.[template_name] shedlock.[name]
participation_justifications.[name] shedlock.[name]
payers.[name] shedlock.[name]
physicians.[first_name] shedlock.[name]
physicians.[last_name] shedlock.[name]
prior_authorization_documents.[file_name] shedlock.[name]
prompts.[name] shedlock.[name]
protocol_modification_categories.[name] shedlock.[name]
protocols.[name] shedlock.[name]
provider_master_list.[dba_name] shedlock.[name]
provider_master_list.[provider_name] shedlock.[name]
reinforcers.[name] shedlock.[name]
replacement_behaviors.[name] shedlock.[name]
report_definitions.[name] shedlock.[name]
required_documents.[name] shedlock.[name]
scheduled_job.[name] shedlock.[name]
scheduled_reinforcements.[name] shedlock.[name]
service_plan_caregiver_competencies.[name] shedlock.[name]
service_plan_categories.[name] shedlock.[name]
service_plan_category_definitions.[name] shedlock.[name]
service_plan_custom_categories.[name] shedlock.[name]
service_plan_maladaptive_behaviors.[name] shedlock.[name]
service_plan_rbt_competencies.[name] shedlock.[name]
service_plan_replacement_behaviors.[name] shedlock.[name]
service_plans.[name] shedlock.[name]
signature_recipients.[name] shedlock.[name]
sp_maladaptive_behavior_measure_history.[created_by_user_name] shedlock.[name]
sp_maladaptive_behavior_protocol_modifications.[protocol_name] shedlock.[name]
sp_measure_version_audit_log.[user_name] shedlock.[name]
sp_replacement_behavior_field_history.[changed_by_name] shedlock.[name]
sp_replacement_behavior_protocol_modifications.[protocol_name] shedlock.[name]
teaching_materials.[name] shedlock.[name]
teaching_objectives.[name] shedlock.[name]
teaching_procedures.[name] shedlock.[name]
treatment_targets.[name] shedlock.[name]
user_credentials.[document_name] shedlock.[name]
users.[company_name] shedlock.[name]

Tables without indexes

Table
flyway_schema_history_bak_20260705_canon
flyway_schema_history_bak_20260706

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
addresses
business_lines
catalog_clearinghouses
catalog_payers
clearinghouses
payers
provider_master_list

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

Table
Anomaly not detected