# 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
--- | ---
adminpresets_app_it.[configlogid] | config.[id]
adminpresets_app_it_a.[configlogid] | config.[id]
ai_action_register.[contextid] | context.[id]
ai_policy_register.[contextid] | context.[id]
bigbluebuttonbn_logs.[bigbluebuttonbnid] | bigbluebuttonbn.[id]
bigbluebuttonbn_logs.[courseid] | course.[id]
bigbluebuttonbn_recordings.[courseid] | course.[id]
block_recent_activity.[courseid] | course.[id]
comments.[contextid] | context.[id]
competency_templatecohort.[cohortid] | cohort.[id]
competency_usercompcourse.[courseid] | course.[id]
course_modules_viewed.[coursemoduleid] | course.[id]
enrol_lti_resource_link.[resourceid] | resource.[id]
event.[courseid] | course.[id]
feedback_completedtmp.[courseid] | course.[id]
feedback_sitecourse_map.[courseid] | course.[id]
forum_track_prefs.[forumid] | forum.[id]
gradepenalty_duedate_rule.[contextid] | context.[id]
logstore_standard_log.[contextinstanceid] | context.[id]
lti_coursevisible.[courseid] | course.[id]
ltiservice_gradebookservices.[courseid] | course.[id]
ltiservice_gradebookservices.[ltilinkid] | lti.[id]
moodlenet_share_progress.[courseid] | course.[id]
question_categories.[contextid] | context.[id]
scale.[courseid] | course.[id]
search_simpledb_index.[contextid] | context.[id]
search_simpledb_index.[courseid] | course.[id]
stats_daily.[roleid] | role.[id]
stats_monthly.[roleid] | role.[id]
stats_user_daily.[roleid] | role.[id]
stats_user_monthly.[roleid] | role.[id]
stats_user_weekly.[roleid] | role.[id]
stats_weekly.[roleid] | role.[id]
tiny_autosave.[contextid] | context.[id]
tool_brickfield_process.[contextid] | context.[id]
tool_brickfield_process.[courseid] | course.[id]
tool_brickfield_schedule.[contextid] | context.[id]
tool_cohortroles.[roleid] | role.[id]
tool_dataprivacy_ctxlst_ctx.[contextid] | context.[id]
tool_monitor_rules.[courseid] | course.[id]
tool_monitor_subscriptions.[courseid] | course.[id]
user_lastaccess.[courseid] | course.[id]

### Tables without indexes

Table | Rows
--- | ---
Anomaly not detected

### Tables that contain a single column

Table | Column
--- | ---
bbbext_complex |
assignfeedback_editpdf_queue |

### Tables with incrementing column names, potentially indicating denormalization

Table
data_content
data_fields
enrol
enrol_paypal
grade_items
grade_items_history
quiz
search_simpledb_index
stats_daily
stats_monthly
stats_weekly
tool_brickfield_summary
user
user_info_field
workshopform_numerrors

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

Table
Anomaly not detected