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
block_recent_activity.[courseid] course.[id]
comments.[contextid] context.[id]
competency.[scaleid] scale.[id]
competency_evidence.[contextid] context.[id]
competency_framework.[contextid] context.[id]
competency_framework.[scaleid] scale.[id]
competency_template.[contextid] context.[id]
competency_templatecohort.[cohortid] cohort.[id]
competency_usercompcourse.[courseid] course.[id]
editor_atto_autosave.[contextid] context.[id]
enrol.[roleid] role.[id]
event.[courseid] course.[id]
event_subscriptions.[courseid] course.[id]
feedback_completed.[courseid] course.[id]
feedback_completedtmp.[courseid] course.[id]
feedback_sitecourse_map.[courseid] course.[id]
forum_track_prefs.[forumid] forum.[id]
mnetservice_enrol_courses.[roleid] role.[id]
payment_accounts.[contextid] context.[id]
post.[courseid] course.[id]
post.[coursemoduleid] course.[id]
question_categories.[contextid] context.[id]
question_response_analysis.[questionid] question.[id]
rating.[scaleid] scale.[id]
repository_instances.[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]
tool_brickfield_process.[contextid] context.[id]
tool_brickfield_process.[courseid] course.[id]
tool_brickfield_schedule.[contextid] context.[id]
tool_cohortroles.[roleid] role.[id]
tool_monitor_events.[contextid] context.[id]
tool_monitor_events.[contextinstanceid] context.[id]
tool_monitor_events.[courseid] course.[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
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
assignment
assignment_submissions
data_content
data_fields
enrol
enrol_paypal
grade_items
grade_items_history
quiz
search_simpledb_index
stats_daily
stats_monthly
stats_weekly
survey_answers
tool_brickfield_summary
user
user_info_field

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

Table
Anomaly not detected