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
admin_mobile.[temp_user_id] session_types.[id]
educational_qualifications.[old_data_id] session_types.[id]
faq_categories.[old_data_id] session_types.[id]
faq_sub_categories.[old_data_id] session_types.[id]
mqops_activity_trackers.[learner_journey_id] activity_log_purge_progress.[id]
mqops_centrehead_interaction_tracker.[team_name_id] activity_log_purge_progress.[id]
mqops_educator_interaction_tracker.[team_name_id] activity_log_purge_progress.[id]
mqops_principal_interaction_tracker.[team_name_id] activity_log_purge_progress.[id]
mqops_session_trackers.[bootcamp_type_id] activity_log_purge_progress.[id]
mqops_session_trackers.[guest_type_id] activity_log_purge_progress.[id]
mqops_student_interaction_tracker.[team_name_id] activity_log_purge_progress.[id]
phase_subject.[phase_id] session_types.[id]
phase_subject.[subject_id] session_types.[id]
phase_users.[batch_id] session_types.[id]
phase_users.[centre_id] session_types.[id]
phase_users.[phase_id] session_types.[id]
phase_users.[user_id] session_types.[id]
placement_courses.[old_data_id] session_types.[id]

Tables without indexes

Table Rows
batches_non_ple 354
centre_subject_backup 462926
design 6
es_module_topic_completed 323
es_module_topic_studied 412
exclude_user_id 102
leader_designation_mqops_activity_tracker 232
log_stud_details 0
mqops_activity_company_sector 26
mqops_activity_employer_sector 0
mqops_activity_wfh_sector 23
mqops_education_interactions 13
mqops_external_meeing_user 29
mqops_internal_meeing_user 221
mqops_tot_objective_summary 492
mqops_tot_summary_centre_type 488
phase_subject 79
subject_ple_career_path 241
subject_trade 6177
subject_trade_old 8820
user_lesson_downloads 1479698
vacancy_district 2598
vacancy_trade 5481

Tables that contain a single column

Table Column
batches_non_ple batch_id
exclude_user_id user_id
telescope_monitoring tag

Tables with incrementing column names, potentially indicating denormalization

Table
model_has_roles
mqops_tot_summary

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

Table
Anomaly not detected