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
appraisal_review_data.[appraisalscalevalueid] appraisal.[id]
appraisal_role_changes.[userassignmentid] user.[id]
assign_grades.[userid] user.[id]
assign_submission.[userid] user.[id]
assignment_submissions.[userid] user.[id]
auth_approved_request_snapshots.[organisationid] org.[id]
auth_approved_request_snapshots.[positionid] pos.[id]
auth_approved_request_snapshots.[userid] user.[id]
block_quicklinks.[userid] user.[id]
block_recent_activity.[courseid] course.[id]
block_totara_stats.[userid] user.[id]
block_zoola_module_name.[coursemoduleid] course.[id]
block_zoola_notifications.[userid] user.[id]
block_zoola_reports_schedule.[courseid] course.[id]
block_zoola_reports_schedule.[userid] user.[id]
catalog.[contextid] context.[id]
certificate_issues.[userid] user.[id]
chat_messages.[userid] user.[id]
chat_messages_current.[userid] user.[id]
chat_users.[userid] user.[id]
choice_answers.[userid] user.[id]
cohort_role.[contextid] context.[id]
comments.[contextid] context.[id]
comments.[userid] user.[id]
competency.[scaleid] scale.[id]
competency_coursecompsetting.[courseid] course.[id]
competency_evidence.[contextid] context.[id]
competency_framework.[contextid] context.[id]
competency_framework.[scaleid] scale.[id]
competency_plan.[userid] user.[id]
competency_template.[contextid] context.[id]
competency_templatecohort.[cohortid] cohort.[id]
competency_usercomp.[userid] user.[id]
competency_usercompcourse.[courseid] course.[id]
competency_usercompcourse.[userid] user.[id]
competency_usercompplan.[userid] user.[id]
competency_userevidence.[userid] user.[id]
competency_userevidencecomp.[userevidenceid] user.[id]
course_completions.[organisationid] org.[id]
course_completions.[positionid] pos.[id]
course_published.[courseid] course.[id]
data_records.[userid] user.[id]
editor_atto_autosave.[contextid] context.[id]
editor_atto_autosave.[userid] user.[id]
enrol.[roleid] role.[id]
enrol_lti_lti2_share_key.[resourcelinkid] resource.[id]
enrol_paypal.[courseid] course.[id]
enrol_paypal.[userid] user.[id]
enrol_totara_f2f_pending.[enrolid] enrol.[id]
enrol_totara_f2f_pending.[userid] user.[id]
event.[courseid] course.[id]
event.[userid] user.[id]
event_subscriptions.[courseid] course.[id]
event_subscriptions.[userid] user.[id]
facetoface_interest.[userid] user.[id]
facetoface_session_roles.[roleid] role.[id]
feedback_completed.[courseid] course.[id]
feedback_completed.[userid] user.[id]
feedback_completedtmp.[courseid] course.[id]
feedback_completedtmp.[userid] user.[id]
feedback_sitecourse_map.[courseid] course.[id]
forum_discussions.[userid] user.[id]
forum_posts.[userid] user.[id]
forum_queue.[userid] user.[id]
forum_read.[userid] user.[id]
forum_subscriptions.[userid] user.[id]
forum_track_prefs.[forumid] forum.[id]
glossary_entries.[userid] user.[id]
grade_import_values.[userid] user.[id]
grade_letters.[contextid] context.[id]
lesson_attempts.[userid] user.[id]
lesson_branch.[userid] user.[id]
lesson_grades.[userid] user.[id]
lesson_timer.[userid] user.[id]
local_activityvisibility.[courseid] course.[id]
local_activityvisibility.[coursemoduleid] course.[id]
local_activityvisibility.[userid] user.[id]
local_activityvisibility_que.[courseid] course.[id]
local_activityvisibility_que.[userid] user.[id]
local_ld_lastactivity.[courseid] course.[id]
local_ld_lastactivity.[coursemoduleid] course.[id]
local_ld_lastactivity.[userid] user.[id]
log.[userid] user.[id]
logstore_standard_log.[contextinstanceid] context.[id]
logstore_standard_log.[courseid] course.[id]
logstore_standard_log.[userid] user.[id]
lti_submission.[userid] user.[id]
message_airnotifier_devices.[userdeviceid] user.[id]
message_metadata.[messageid] message.[id]
message_metadata.[messagereadid] message.[id]
message_popup.[messageid] message.[id]
mnet_log.[userid] user.[id]
mnet_session.[userid] user.[id]
mnetservice_enrol_courses.[roleid] role.[id]
my_pages.[userid] user.[id]
post.[courseid] course.[id]
post.[coursemoduleid] course.[id]
post.[userid] user.[id]
prog_completion.[organisationid] org.[id]
prog_completion.[positionid] pos.[id]
prog_completion_history.[organisationid] org.[id]
prog_completion_history.[positionid] pos.[id]
prog_future_user_assignment.[programid] prog.[id]
prog_future_user_assignment.[userid] user.[id]
prog_user_assignment.[programid] prog.[id]
prog_user_assignment.[userid] user.[id]
qtype_essay_options.[questionid] question.[id]
qtype_match_options.[questionid] question.[id]
qtype_multichoice_options.[questionid] question.[id]
qtype_randomsamatch_options.[questionid] question.[id]
qtype_shortanswer_options.[questionid] question.[id]
question_categories.[contextid] context.[id]
question_response_analysis.[questionid] question.[id]
questionnaire_attempts.[userid] user.[id]
questionnaire_response.[userid] user.[id]
questionnaire_survey.[courseid] course.[id]
quickaccess_preferences.[userid] user.[id]
quiz_grades.[userid] user.[id]
quiz_overview_regrades.[questionusageid] question.[id]
rating.[scaleid] scale.[id]
reminder.[courseid] course.[id]
reminder_message.[reminderid] reminder.[id]
reminder_sent.[messageid] message.[id]
reminder_sent.[reminderid] reminder.[id]
reminder_sent.[userid] user.[id]
repository_instances.[contextid] context.[id]
repository_instances.[userid] user.[id]
scale.[courseid] course.[id]
scale.[userid] user.[id]
scale_history.[userid] user.[id]
scorm_scoes_track.[userid] user.[id]
stats_daily.[courseid] course.[id]
stats_daily.[roleid] role.[id]
stats_monthly.[courseid] course.[id]
stats_monthly.[roleid] role.[id]
stats_user_daily.[courseid] course.[id]
stats_user_daily.[roleid] role.[id]
stats_user_daily.[userid] user.[id]
stats_user_monthly.[courseid] course.[id]
stats_user_monthly.[roleid] role.[id]
stats_user_monthly.[userid] user.[id]
stats_user_weekly.[courseid] course.[id]
stats_user_weekly.[roleid] role.[id]
stats_user_weekly.[userid] user.[id]
stats_weekly.[courseid] course.[id]
stats_weekly.[roleid] role.[id]
survey_analysis.[userid] user.[id]
survey_answers.[userid] user.[id]
tool_monitor_events.[contextid] context.[id]
tool_monitor_events.[contextinstanceid] context.[id]
tool_monitor_events.[courseid] course.[id]
tool_monitor_history.[userid] user.[id]
tool_monitor_rules.[courseid] course.[id]
tool_monitor_rules.[userid] user.[id]
tool_monitor_subscriptions.[courseid] course.[id]
tool_monitor_subscriptions.[userid] user.[id]
totara_compl_import_cert.[certificationid] certif.[id]
totara_compl_import_course.[courseid] course.[id]
totara_userdata_export.[contextid] context.[id]
totara_userdata_purge.[contextid] context.[id]
totara_userdata_purge.[usercontextid] user.[id]
totara_userdata_user.[usercontextid] user.[id]
user_lastaccess.[courseid] course.[id]
wiki_locks.[pageid] page.[id]
wiki_locks.[userid] user.[id]
wiki_pages.[userid] user.[id]
wiki_subwikis.[userid] user.[id]
wiki_synonyms.[pageid] page.[id]
wiki_versions.[userid] user.[id]
workshopallocation_scheduled.[workshopid] workshop.[id]
workshopeval_best_settings.[workshopid] workshop.[id]
workshopform_rubric_config.[workshopid] workshop.[id]

Tables without indexes

Table
Anomaly not detected

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
appraisal_quest_field
assignment
assignment_submissions
block_totara_stats
comp_relations
comp_type_info_field
course_info_field
data_content
data_fields
dp_plan_component_relation
dp_plan_evidence_info_field
enrol
enrol_paypal
facetoface_asset_info_field
facetoface_cancellation_info_field
facetoface_room_info_field
facetoface_session_info_field
facetoface_sessioncancel_info_field
facetoface_signup_info_field
feedback360_quest_field
goal_type_info_field
goal_user_info_field
grade_items
grade_items_history
org_relations
org_type_info_field
pos_relations
pos_type_info_field
prog_info_field
quiz
stats_daily
stats_monthly
stats_weekly
survey_answers
user
user_info_field
workshopform_numerrors

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

Table
Anomaly not detected