Database Properties
Database Type: MySQL - 8.0.32-0ubuntu0.22.04.2
Schema mdl42_erd
The Moodle Database is complex. Normal installation discards Primary/Foreign Keys and field comments. These diagrams restore that data
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| quiz_grades | 0 | 5 | 5 | 0 | Table | Stores the overall grade for each user on the quiz, based on |
| groups | 25 | 5 | 12 | 0 | Table | Each record represents a group. |
| tool_policy_acceptances | 0 | 15 | 9 | 0 | Table | Tracks users accepting the policy versions |
| lesson_answers | 5 | 10 | 13 | 0 | Table | Defines lesson_answers |
| scorm_scoes_data | 0 | 5 | 4 | 0 | Table | Contains variable data get from packages |
| data_records | 5 | 10 | 7 | 0 | Table | every record introduced |
| h5p_library_dependencies | 0 | 10 | 4 | 0 | Table | Stores H5P library dependencies |
| upgrade_log | 0 | 5 | 10 | 0 | Table | Upgrade logging |
| stats_daily | 0 | 6 | 7 | 0 | Table | to accumulate daily stats |
| reportbuilder_schedule | 0 | 20 | 19 | 0 | Table | Table to represent a report schedule |
| stats_monthly | 0 | 6 | 7 | 0 | Table | To accumulate monthly stats |
| badge_issued | 5 | 10 | 8 | 0 | Table | Defines issued badges |
| reportbuilder_filter | 0 | 15 | 10 | 0 | Table | Table to represent a report filter/condition |
| search_simpledb_index | 0 | 2 | 14 | 0 | Table | search_simpledb table containing the index data. |
| file_conversion | 0 | 15 | 11 | 0 | Table | Table to track file conversions. |
| competency_coursecomp | 0 | 13 | 8 | 0 | Table | Link a competency to a course. |
| cache_filters | 0 | 0 | 6 | 0 | Table | For keeping information about cached data |
| enrol_lti_resource_link | 5 | 11 | 14 | 0 | Table | Each row represents a resource link for a platform and deplo |
| lesson_attempts | 0 | 15 | 9 | 0 | Table | Defines lesson_attempts |
| survey_questions | 5 | 0 | 7 | 0 | Table | the questions conforming one survey |
| adminpresets_plug | 0 | 0 | 5 | 0 | Table | Admin presets plugins status, to store information about whe |
| portfolio_instance | 20 | 0 | 4 | 0 | Table | base table (not including config data) for instances of port |
| badge | 35 | 15 | 26 | 0 | Table | Defines badge |
| question_bank_entries | 10 | 10 | 4 | 0 | Table | Each question bank entry. This table has one row for each qu |
| user_preferences | 0 | 10 | 4 | 0 | Table | Allows modules to store arbitrary user preferences |
| grade_outcomes | 20 | 15 | 10 | 0 | Table | This table describes the outcomes used in the system. An out |
| quiz_statistics | 0 | 0 | 19 | 0 | Table | table to cache results from analysis done in statistics repo |
| stats_user_daily | 0 | 6 | 8 | 0 | Table | To accumulate daily stats per course/user |
| role | 88 | 0 | 6 | 0 | Table | moodle roles |
| message | 5 | 0 | 17 | 0 | Table | Stores all unread messages |
| qtype_essay_options | 0 | 5 | 15 | 0 | Table | Extra options for essay questions. |
| message_contacts | 0 | 15 | 4 | 0 | Table | Maintains lists of contacts between users |
| oauth2_issuer | 40 | 0 | 22 | 0 | Table | Details for an oauth 2 connect identity issuer. |
| message_conversation_actions | 0 | 10 | 5 | 0 | Table | Stores all per-user actions on individual conversations |
| qtype_randomsamatch_options | 0 | 5 | 11 | 0 | Table | Info about a random short-answer matching question |
| editor_atto_autosave | 0 | 1 | 9 | 0 | Table | Draft text that is auto-saved every 5 seconds while an edito |
| qtype_ddmarker_drags | 0 | 5 | 6 | 0 | Table | Labels for markers to drag. |
| tool_dataprivacy_ctxinstance | 0 | 15 | 7 | 0 | Table | Default comment for the table, please edit me |
| grade_categories_history | 0 | 20 | 18 | 0 | Table | History of grade_categories |
| course_modules_viewed | 0 | 1 | 4 | 0 | Table | Tracks the completion viewed (viewed with cmid/userid and ot |
| analytics_models | 30 | 5 | 13 | 0 | Table | Analytic models. |
| imscp | 0 | 5 | 9 | 0 | Table | each record is one imscp resource |
| role_allow_view | 0 | 10 | 3 | 0 | Table | This table stores which which other roles a user is allowed |
| event_subscriptions | 5 | 10 | 10 | 0 | Table | Tracks subscriptions to remote calendars. |
| enrol_lti_lti2_share_key | 0 | 5 | 5 | 0 | Table | Resource link share key |
| course_completion_crit_compl | 0 | 5 | 7 | 0 | Table | Course completion user records |
| mnet_rpc | 0 | 0 | 11 | 0 | Table | Functions or methods that we may publish or subscribe to |
| enrol_lti_app_registration | 5 | 0 | 13 | 0 | Table | Details of each application that has been registered with th |
| tag_correlation | 0 | 5 | 3 | 0 | Table | The rationale for the ‘tag_correlation’ table is performance |
| scorm_seq_ruleconds | 5 | 5 | 5 | 0 | Table | SCORM2004 rule conditions |
| post | 5 | 15 | 19 | 0 | Table | Generic post table to hold data blog entries etc in differen |
| tool_dataprivacy_purpose | 15 | 0 | 11 | 0 | Table | Data purposes |
| assignfeedback_file | 0 | 10 | 4 | 0 | Table | Stores info about the number of files submitted by a student |
| question_gapselect | 0 | 5 | 10 | 0 | Table | Defines select missing words questions |
| quiz_overview_regrades | 0 | 10 | 7 | 0 | Table | This table records which question attempts need regrading an |
| qtype_shortanswer_options | 0 | 5 | 3 | 0 | Table | Options for short answer questions |
| user_password_resets | 0 | 5 | 5 | 0 | Table | table tracking password reset confirmation tokens |
| feedback_valuetmp | 0 | 4 | 6 | 0 | Table | values of the completedstmp |
| modules | 5 | 0 | 6 | 0 | Table | modules available in the site |
| feedback_sitecourse_map | 0 | 6 | 3 | 0 | Table | feedback sitecourse map |
| scorm_seq_mapinfo | 0 | 10 | 8 | 0 | Table | SCORM2004 objective mapinfo description |
| choice_options | 5 | 5 | 5 | 0 | Table | available options to choice |
| lesson | 35 | 0 | 42 | 0 | Table | Defines lesson for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Lesson_Activity |
| lti_types | 15 | 0 | 18 | 0 | Table | Basic LTI pre-configured activities |
| license | 0 | 0 | 8 | 0 | Table | store licenses used by moodle |
| lesson_branch | 0 | 10 | 8 | 0 | Table | branches for each lesson/user |
| bigbluebuttonbn_logs | 0 | 2 | 8 | 0 | Table | The bigbluebuttonbn table to store meeting activity events |
| reportbuilder_audience | 0 | 15 | 9 | 0 | Table | Defines report audience |
| cache_flags | 0 | 0 | 6 | 0 | Table | Cache of time-sensitive flags |
| analytics_indicator_calc | 0 | 5 | 9 | 0 | Table | Stored indicator calculations |
| message_popup_notifications | 0 | 5 | 2 | 0 | Table | List of notifications to display in the message output popup |
| customfield_data | 0 | 10 | 12 | 0 | Table | core_customfield data table |
| scorm_seq_rolluprule | 5 | 5 | 7 | 0 | Table | SCORM2004 sequencing rule |
| wiki_locks | 0 | 5 | 5 | 0 | Table | Manages page locks |
| oauth2_user_field_mapping | 0 | 10 | 7 | 0 | Table | Mapping of oauth user fields to moodle fields. |
| auth_oauth2_linked_login | 0 | 15 | 10 | 0 | Table | Accounts linked to a users Moodle account. |
| role_capabilities | 0 | 20 | 7 | 0 | Table | permission has to be signed, overriding a capability for a p |
| survey_analysis | 0 | 5 | 4 | 0 | Table | text about each survey submission |
| badge_criteria_met | 0 | 15 | 5 | 0 | Table | Defines criteria that were met for an issued badge |
| feedback | 19 | 0 | 17 | 0 | Table | all feedbacks |
| workshop_grades | 0 | 5 | 7 | 0 | Table | How the reviewers filled-up the grading forms, given grades |
| reportbuilder_column | 0 | 15 | 13 | 0 | Table | Table to represent a report column |
| qtype_ddmarker | 0 | 5 | 11 | 0 | Table | Defines drag and drop (text or images onto a background imag |
| mnet_remote_service2rpc | 0 | 0 | 3 | 0 | Table | Group functions or methods under a service |
| feedback_item | 9 | 10 | 13 | 0 | Table | feedback_items |
| infected_files | 0 | 5 | 6 | 0 | Table | Table to store infected file details. |
| competency_template | 15 | 10 | 10 | 0 | Table | Learning plan templates. |
| workshop_assessments | 5 | 15 | 15 | 0 | Table | Info about the made assessment and automatically calculated |
| grade_letters | 0 | 5 | 4 | 0 | Table | Repository for grade letters, for courses and other moodle e |
| paygw_paypal | 0 | 5 | 3 | 0 | Table | Stores PayPal related information |
| enrol_flatfile | 0 | 15 | 8 | 0 | Table | enrol_flatfile table retrofitted from MySQL |
| analytics_train_samples | 0 | 5 | 6 | 0 | Table | Samples used for training |
| assign_submission | 11 | 5 | 10 | 0 | Table | This table keeps information about student interactions with |
| adminpresets_it_a | 0 | 0 | 4 | 0 | Table | Admin presets items attributes. For settings with attributes |
| mnet_application | 5 | 0 | 6 | 0 | Table | Information about applications on remote hosts |
| tool_dataprivacy_category | 10 | 0 | 7 | 0 | Table | Data categories |
| survey_answers | 0 | 10 | 7 | 0 | Table | the answers to each questions filled by the users |
| forum_queue | 0 | 10 | 5 | 0 | Table | For keeping track of posts that will be mailed in digest for |
| tag_area | 0 | 5 | 9 | 0 | Table | Defines various tag areas, one area is identified by compone |
| backup_controllers | 5 | 5 | 17 | 0 | Table | To store the backup_controllers as they are used |
| analytics_predictions | 5 | 10 | 11 | 0 | Table | Predictions |
| ltiservice_gradebookservices | 0 | 2 | 11 | 0 | Table | This file records the grade items created by the LTI Gradebo |
| repository_onedrive_access | 0 | 5 | 6 | 0 | Table | List of temporary access grants. |
| tool_brickfield_checks | 5 | 0 | 6 | 0 | Table | Checks details |
| h5p | 5 | 5 | 9 | 0 | Table | Stores H5P content information |
| lti_tool_settings | 0 | 20 | 8 | 0 | Table | LTI tool setting values |
| assign_grades | 25 | 5 | 8 | 0 | Table | Grading information about a single assignment submission. |
| course_categories | 30 | 10 | 14 | 0 | Table | Course categories |
| quiz_reports | 0 | 0 | 4 | 0 | Table | Lists all the installed quiz reports and their display order |
| portfolio_instance_config | 0 | 5 | 4 | 0 | Table | config for portfolio plugin instances |
| resource_old | 0 | 1 | 16 | 0 | Table | backup of all old resource instances from 1.9 |
| scorm_scoes_track | 0 | 10 | 8 | 0 | Table | to track SCOes |
| forum_grades | 0 | 5 | 7 | 0 | Table | Grading data for forum instances |
| user_lastaccess | 0 | 11 | 4 | 0 | Table | To keep track of course page access times, used in online pa |
| badge_backpack_oauth2 | 0 | 20 | 11 | 0 | Table | Default comment for the table, please edit me |
| survey | 10 | 0 | 11 | 0 | Table | Defines badge for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Badges |
| workshopeval_best_settings | 0 | 5 | 3 | 0 | Table | Settings for the grading evaluation subplugin Comparison wit |
| quiz_attempts | 0 | 15 | 16 | 0 | Table | Stores users attempts at quizzes. |
| backup_courses | 0 | 5 | 6 | 0 | Table | To store every course backup status |
| tool_usertours_tours | 5 | 0 | 9 | 0 | Table | List of tours |
| oauth2_system_account | 0 | 10 | 9 | 0 | Table | Stored details used to get an access token as a system user |
| question_hints | 0 | 5 | 7 | 0 | Table | Stores the the part of the question definition that gives di |
| cohort | 11 | 5 | 11 | 0 | Table | Each record represents one cohort (aka site-wide group). |
| payment_accounts | 10 | 5 | 8 | 0 | Table | Payment accounts |
| workshop | 55 | 5 | 37 | 0 | Table | This table keeps information about the module instances and |
| question_statistics | 0 | 10 | 18 | 0 | Table | Statistics for individual questions used in an activity. |
| h5pactivity_attempts | 5 | 5 | 12 | 0 | Table | Users attempts inside H5P activities |
| groupings_groups | 0 | 10 | 4 | 0 | Table | Link a grouping to a group (note, groups can be in multiple |
| registration_hubs | 0 | 0 | 7 | 0 | Table | hub where the site is registered on with their associated to |
| glossary | 10 | 1 | 28 | 0 | Table | all glossaries |
| url | 0 | 5 | 10 | 0 | Table | each record is one url resource |
| mnet_session | 0 | 15 | 9 | 0 | Table | Store session data from users migrating to other sites |
| competency_templatecomp | 0 | 19 | 7 | 0 | Table | Link a competency to a learning plan template. |
| badge_external_identifier | 0 | 5 | 5 | 0 | Table | Setting for external badges mappings |
| glossary_entries_categories | 0 | 10 | 3 | 0 | Table | categories of each glossary entry |
| enrol_paypal | 0 | 20 | 21 | 0 | Table | Holds all known information about PayPal transactions |
| role_allow_switch | 0 | 10 | 3 | 0 | Table | This table stores which which other roles a user is allowed |
| badge_alignment | 0 | 5 | 7 | 0 | Table | Defines alignment for badges |
| qtype_ddimageortext_drops | 0 | 5 | 7 | 0 | Table | Drop boxes |
| notifications | 5 | 5 | 15 | 0 | Table | Stores all notifications |
| question_categories | 15 | 6 | 9 | 0 | Table | Categories are for grouping questions |
| assignsubmission_file | 0 | 9 | 4 | 0 | Table | Info about file submissions for assignments |
| message_conversation_members | 0 | 10 | 4 | 0 | Table | Stores all members in a conversations |
| task_adhoc | 0 | 5 | 12 | 0 | Table | List of adhoc tasks waiting to run. |
| contentbank_content | 0 | 15 | 11 | 0 | Table | This table stores content data in the content bank. |
| glossary_formats | 1 | 0 | 10 | 0 | Table | Setting of the display formats |
| grade_items | 20 | 20 | 31 | 0 | Table | This table keeps information about gradeable items (ie colum |
| book_chapters | 0 | 5 | 11 | 0 | Table | Defines book_chapters |
| adminpresets_app_it | 0 | 1 | 3 | 0 | Table | Admin presets applied items. To maintain the relation with c |
| block_instances | 5 | 10 | 12 | 0 | Table | This table stores block instances. The type of block this is |
| badge_external | 0 | 5 | 5 | 0 | Table | Setting for external badges display |
| question_response_count | 0 | 5 | 4 | 0 | Table | Count for each responses for each try at a question. |
| grade_grades_history | 0 | 30 | 24 | 0 | Table | History table |
| question_response_analysis | 5 | 5 | 10 | 0 | Table | Analysis of student responses given to questions. |
| mnet_service2rpc | 0 | 5 | 3 | 0 | Table | Group functions or methods under a service |
| tool_brickfield_cache_acts | 0 | 5 | 8 | 0 | Table | Contains accessibility summary information per activity. |
| lti_tool_proxies | 5 | 0 | 13 | 0 | Table | LTI tool proxy registrations |
| scorm_seq_rolluprulecond | 0 | 9 | 5 | 0 | Table | SCORM2004 sequencing rule |
| grade_import_values | 0 | 20 | 9 | 0 | Table | Temporary table for importing grades |
| grade_outcomes_courses | 0 | 10 | 3 | 0 | Table | stores what outcomes are used in what courses. |
| workshop_submissions | 5 | 15 | 19 | 0 | Table | Info about the submission and the aggregation of the grade f |
| enrol_lti_lti2_user_result | 0 | 5 | 6 | 0 | Table | Results for each user for each resource link |
| event | 0 | 11 | 24 | 0 | Table | For everything with a time associated to it |
| badge_endorsement | 0 | 5 | 8 | 0 | Table | Defines endorsement for badge |
| tool_dataprivacy_ctxexpired | 0 | 5 | 9 | 0 | Table | Default comment for the table, please edit me |
| config | 2 | 0 | 3 | 0 | Table | Moodle configuration variables |
| workshopform_comments | 0 | 5 | 5 | 0 | Table | The assessment dimensions definitions of Comments strategy f |
| mnet_sso_access_control | 0 | 1 | 4 | 0 | Table | Users by host permitted (or not) to login from a remote prov |
| question_dataset_definitions | 5 | 5 | 6 | 0 | Table | Organises and stores properties for dataset items |
| scale | 50 | 6 | 8 | 0 | Table | Defines grading scales |
| analytics_prediction_actions | 0 | 10 | 5 | 0 | Table | Register of user actions over predictions. |
| tool_policy | 5 | 5 | 3 | 0 | Table | Contains the list of policy documents defined on the site. |
| files | 15 | 15 | 20 | 0 | Table | description of files, content is stored in sha1 file pool |
| competency_usercompcourse | 0 | 10 | 9 | 0 | Table | User competencies in a course |
| feedback_template | 5 | 0 | 4 | 0 | Table | templates of feedbackstructures |
| tool_brickfield_cache_check | 0 | 5 | 6 | 0 | Table | Contains accessibility summary information per check. |
| enrol_lti_deployment | 15 | 5 | 7 | 0 | Table | Each row represents a deployment of a tool within a platform |
| wiki_subwikis | 15 | 5 | 4 | 0 | Table | Stores subwiki instances |
| mnetservice_enrol_courses | 0 | 1 | 14 | 0 | Table | Caches the information fetched via XML-RPC about courses on |
| question_datasets | 0 | 10 | 3 | 0 | Table | Many-many relation between questions and dataset definitions |
| assign_overrides | 0 | 15 | 9 | 0 | Table | The overrides to assign settings. |
| h5pactivity_attempts_results | 0 | 5 | 14 | 0 | Table | H5Pactivities_attempts tracking info |
| user_private_key | 0 | 5 | 8 | 0 | Table | access keys used in cookieless scripts - rss, etc. |
| feedback_completedtmp | 0 | 5 | 8 | 0 | Table | filled out feedback |
| h5pactivity | 5 | 5 | 12 | 0 | Table | Stores the h5pactivity activity module instances. |
| wiki_links | 0 | 10 | 5 | 0 | Table | Page wiki links |
| quizaccess_seb_quizsettings | 0 | 20 | 29 | 0 | Table | Stores the quiz level Safe Exam Browser configuration. |
| gradingform_guide_criteria | 5 | 5 | 9 | 0 | Table | Stores the rows of the criteria grid. |
| message_read | 0 | 5 | 17 | 0 | Table | Stores all messages that have been read |
| events_queue | 5 | 5 | 5 | 0 | Table | This table is for storing queued events. It stores only one |
| badge_criteria | 10 | 5 | 6 | 0 | Table | Defines criteria for issuing badges |
| quiz_sections | 0 | 5 | 5 | 0 | Table | Stores sections of a quiz with section name (heading), from |
| forum_digests | 0 | 10 | 4 | 0 | Table | Keeps track of user mail delivery preferences for each forum |
| enrol_lti_context | 5 | 5 | 6 | 0 | Table | Each row represents a context in the platform, where resourc |
| forum_subscriptions | 0 | 5 | 3 | 0 | Table | Keeps track of who is subscribed to what forum |
| assign_user_mapping | 0 | 10 | 3 | 0 | Table | Map an assignment specific id number to a user |
| wiki_pages | 20 | 5 | 10 | 0 | Table | Stores wiki pages |
| competency_coursecompsetting | 0 | 10 | 6 | 0 | Table | This table contains the course specific settings for compete |
| payment_gateways | 0 | 5 | 7 | 0 | Table | Configuration for one gateway for one payment account |
| tool_brickfield_errors | 0 | 5 | 5 | 0 | Table | Errors during the accessibility checks |
| message_popup | 0 | 5 | 3 | 0 | Table | Keep state of notifications for the popup message processor |
| repository_instance_config | 0 | 6 | 4 | 0 | Table | The config for intances |
| lti_types_config | 0 | 5 | 4 | 0 | Table | Basic LTI types configuration |
| data_content | 0 | 10 | 8 | 0 | Table | the content introduced in each record/fields |
| assignfeedback_editpdf_cmnt | 0 | 5 | 9 | 0 | Table | Stores comments added to pdfs |
| context | 208 | 0 | 6 | 0 | Table | one of these must be set |
| groupings | 10 | 4 | 9 | 0 | Table | A grouping is a collection of groups. WAS: groups_groupings |
| log_display | 0 | 0 | 6 | 0 | Table | For a particular module/action, specifies a moodle table/fie |
| role_names | 0 | 10 | 4 | 0 | Table | role names in native strings |
| question_references | 0 | 10 | 7 | 0 | Table | Records where a specific question is used. |
| competency_userevidence | 0 | 9 | 9 | 0 | Table | The evidence of prior learning |
| course_completions | 0 | 5 | 7 | 0 | Table | Course completion records |
| assignsubmission_onlinetext | 0 | 10 | 5 | 0 | Table | Info about onlinetext submission |
| tool_monitor_subscriptions | 5 | 6 | 8 | 0 | Table | Table to store user subscriptions to various rules |
| payments | 5 | 10 | 11 | 0 | Table | Stores information about payments |
| enrol_lti_users | 5 | 15 | 13 | 0 | Table | User access log and gradeback data |
| customfield_category | 5 | 5 | 11 | 0 | Table | core_customfield category table |
| gradingform_rubric_criteria | 10 | 5 | 5 | 0 | Table | Stores the rows of the rubric grid. |
| user_password_history | 0 | 5 | 4 | 0 | Table | A rotating log of hashes of previously used passwords for ea |
| feedback_value | 0 | 5 | 6 | 0 | Table | values of the completeds |
| config_log | 0 | 5 | 7 | 0 | Table | Changes done in server configuration through admin UI |
| competency_framework | 5 | 15 | 13 | 0 | Table | List of competency frameworks. |
| profiling | 0 | 0 | 11 | 0 | Table | Stores the results of all the profiling runs |
| scorm_seq_objective | 5 | 5 | 6 | 0 | Table | SCORM2004 objective description |
| rating | 0 | 15 | 10 | 0 | Table | moodle ratings |
| my_pages | 0 | 5 | 5 | 0 | Table | Extra user pages for the My Moodle system |
| competency_modulecomp | 0 | 20 | 9 | 0 | Table | Link a competency to a module. |
| grade_items_history | 0 | 30 | 34 | 0 | Table | History of grade_items |
| enrol_lti_tool_consumer_map | 0 | 10 | 3 | 0 | Table | Table that maps the published tool to tool consumers. |
| course_completion_criteria | 0 | 5 | 10 | 0 | Table | Course completion criteria |
| h5p_libraries_cachedassets | 0 | 5 | 3 | 0 | Table | H5P cached library assets |
| assignfeedback_editpdf_rot | 0 | 5 | 6 | 0 | Table | Stores rotation information of a page. |
| course_modules | 30 | 10 | 24 | 0 | Table | course_modules table retrofitted from MySQL |
| forum_posts | 15 | 10 | 18 | 0 | Table | All posts are stored in this table |
| tool_recyclebin_course | 0 | 5 | 6 | 0 | Table | A list of items in the course recycle bin |
| grade_grades | 5 | 20 | 23 | 0 | Table | grade_grades This table keeps individual grades for each us |
| glossary_alias | 0 | 5 | 3 | 0 | Table | entries alias |
| tool_brickfield_schedule | 0 | 1 | 7 | 0 | Table | Keeps the per course content analysis schedule. |
| scorm_scoes | 38 | 5 | 10 | 0 | Table | each SCO part of the SCORM module |
| stats_user_weekly | 0 | 6 | 8 | 0 | Table | To accumulate weekly stats per course/user |
| chat_messages_current | 0 | 5 | 7 | 0 | Table | Stores current session |
| enrol_lti_tools | 10 | 10 | 23 | 0 | Table | List of tools provided to the remote system |
| gradingform_rubric_levels | 0 | 5 | 5 | 0 | Table | Stores the columns of the rubric grid. |
| workshopform_accumulative | 0 | 5 | 7 | 0 | Table | The assessment dimensions definitions of Accumulative gradin |
| tool_monitor_history | 0 | 5 | 4 | 0 | Table | Table to store history of message notifications sent |
| competency_usercomp | 5 | 10 | 10 | 0 | Table | User competencies |
| tag_coll | 10 | 0 | 7 | 0 | Table | Defines different set of tags |
| tool_brickfield_content | 5 | 5 | 7 | 0 | Table | Content of an area at a particular time (recognised by a has |
| mnetservice_enrol_enrolments | 0 | 10 | 7 | 0 | Table | Caches the information about enrolments of our local users i |
| external_services_functions | 0 | 5 | 3 | 0 | Table | lists functions available in each service group |
| message_conversations | 20 | 5 | 11 | 0 | Table | Stores all message conversations |
| messages | 10 | 10 | 11 | 0 | Table | Stores all messages |
| h5p_contents_libraries | 0 | 10 | 6 | 0 | Table | Store which library is used in which content. |
| competency | 65 | 15 | 17 | 0 | Table | This table contains the master record of each competency in |
| resource | 1 | 5 | 13 | 0 | Table | Each record is one resource and its config data |
| tag_instance | 0 | 10 | 10 | 0 | Table | tag_instance table holds the information of associations bet |
| user_devices | 5 | 5 | 12 | 0 | Table | This table stores user’s mobile devices information in order |
| question_ddwtos | 0 | 5 | 10 | 0 | Table | Defines drag and drop (words into sentences) questions |
| grade_categories | 25 | 10 | 14 | 0 | Table | This table keeps information about categories, used for grou |
| question_set_references | 0 | 10 | 7 | 0 | Table | Records where groups of questions are used. |
| assign_plugin_config | 0 | 5 | 6 | 0 | Table | Config data for an instance of a plugin in an assignment. |
| quiz | 35 | 0 | 41 | 0 | Table | The settings for each quiz. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Quiz_Activity |
| tool_cohortroles | 0 | 6 | 7 | 0 | Table | Mapping of users to cohort role assignments. |
| question_attempt_steps | 5 | 10 | 7 | 0 | Table | Stores one step in in a question attempt. As well as the dat |
| auth_lti_linked_login | 0 | 5 | 8 | 0 | Table | Accounts linked to a users Moodle account. |
| repository | 0 | 0 | 4 | 0 | Table | This table contains one entry for every configured external |
| lesson_pages | 15 | 5 | 13 | 0 | Table | Defines lesson_pages |
| adminpresets_it | 0 | 0 | 5 | 0 | Table | Table to store settings |
| message_providers | 0 | 0 | 4 | 0 | Table | This table stores the message providers (modules and core sy |
| assignfeedback_editpdf_annot | 0 | 5 | 11 | 0 | Table | stores annotations added to pdfs submitted by students |
| bigbluebuttonbn | 6 | 0 | 44 | 0 | Table | The bigbluebuttonbn table to store information about a meeti |
| badge_related | 0 | 10 | 3 | 0 | Table | Defines badge related for badges |
| tool_dataprivacy_request | 0 | 20 | 15 | 0 | Table | Table for data requests |
| workshopform_numerrors | 0 | 5 | 9 | 0 | Table | The assessment dimensions definitions of Number of errors gr |
| block_positions | 0 | 10 | 8 | 0 | Table | Stores the position of a sticky block_instance on a another |
| tool_brickfield_areas | 5 | 20 | 13 | 0 | Table | Areas that have been checked for accessibility problems |
| tool_policy_versions | 10 | 10 | 16 | 0 | Table | Holds versions of the policy documents |
| config_plugins | 0 | 0 | 4 | 0 | Table | Moodle modules and plugins configuration variables |
| qtype_match_subquestions | 0 | 5 | 5 | 0 | Table | The subquestions that make up a matching question |
| customfield_field | 5 | 5 | 11 | 0 | Table | core_customfield field table |
| question_numerical | 0 | 5 | 4 | 0 | Table | Options for numerical questions. |
| messageinbound_handlers | 5 | 0 | 6 | 0 | Table | Inbound Message Handler definitions. |
| user_info_data | 0 | 10 | 5 | 0 | Table | Data for the customisable user fields |
| label | 0 | 5 | 6 | 0 | Table | Defines labels |
| mnet_service | 5 | 0 | 5 | 0 | Table | A service is a group of functions |
| analytics_used_analysables | 0 | 5 | 6 | 0 | Table | List of analysables used by each model |
| forum_read | 0 | 15 | 7 | 0 | Table | Tracks each users read posts |
| forum_discussions | 20 | 10 | 14 | 0 | Table | Forums are composed of discussions |
| user_info_field | 0 | 5 | 20 | 0 | Table | Customisable user profile fields |
| page | 0 | 5 | 13 | 0 | Table | Each record is one page and its config data |
| workshopform_rubric | 5 | 10 | 5 | 0 | Table | The assessment dimensions definitions of Rubric grading stra |
| enrol_lti_lti2_consumer | 25 | 0 | 19 | 0 | Table | LTI consumers interacting with moodle |
| scorm_seq_rulecond | 0 | 9 | 7 | 0 | Table | SCORM2004 rule condition |
| wiki_synonyms | 0 | 10 | 4 | 0 | Table | Stores wiki pages synonyms |
| question_usages | 10 | 5 | 4 | 0 | Table | This table’s main purpose it to assign a unique id to each a |
| tool_monitor_events | 0 | 15 | 8 | 0 | Table | A table that keeps a log of events related to subscriptions |
| chat_messages | 0 | 5 | 7 | 0 | Table | Stores all the actual chat messages |
| external_services | 15 | 0 | 11 | 0 | Table | built in and custom external services |
| grading_areas | 5 | 5 | 5 | 0 | Table | Identifies gradable areas where advanced grading can happen. |
| scale_history | 0 | 20 | 11 | 0 | Table | History table |
| role_context_levels | 0 | 5 | 3 | 0 | Table | Lists which roles can be assigned at which context levels. T |
| stats_user_monthly | 0 | 6 | 8 | 0 | Table | To accumulate monthly stats per course/user |
| user_enrolments | 0 | 15 | 9 | 0 | Table | Users participating in courses (aka enrolled users) - everyb |
| lesson_timer | 0 | 5 | 7 | 0 | Table | lesson timer for each lesson |
| qtype_ddimageortext_drags | 0 | 5 | 6 | 0 | Table | Images to drag. Actual file names are not stored here we use |
| role_assignments | 0 | 15 | 9 | 0 | Table | assigning roles in different context |
| portfolio_instance_user | 0 | 10 | 5 | 0 | Table | user data for portfolio instances. |
| assignfeedback_comments | 0 | 10 | 5 | 0 | Table | Text feedback for submitted assignments |
| capabilities | 5 | 0 | 6 | 0 | Table | this defines all capabilities |
| choice_answers | 0 | 10 | 5 | 0 | Table | choices performed by users |
| badge_external_backpack | 10 | 5 | 6 | 0 | Table | Defines settings for site level backpacks that a user can co |
| groups_members | 0 | 10 | 6 | 0 | Table | Link a user to a group. |
| enrol_lti_lti2_resource_link | 15 | 15 | 9 | 0 | Table | Link from the consumer to the tool |
| adminpresets_app_it_a | 0 | 1 | 4 | 0 | Table | Attributes of the applied items |
| scorm | 15 | 0 | 41 | 0 | Table | each table is one SCORM module and its configuration |
| course | 304 | 10 | 37 | 0 | Table | Central course table. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#COURSE_REPORTS |
| question | 150 | 15 | 16 | 0 | Table | This table stores the definition of one version of a questio |
| stats_weekly | 0 | 6 | 7 | 0 | Table | To accumulate weekly stats |
| qtype_ddmarker_drops | 0 | 5 | 6 | 0 | Table | drop regions |
| lesson_grades | 0 | 5 | 6 | 0 | Table | Defines lesson_grades |
| log_queries | 0 | 0 | 9 | 0 | Table | Logged database queries. |
| backup_logs | 0 | 5 | 5 | 0 | Table | To store all the logs from backup and restore operations (by |
| user_info_category | 5 | 0 | 3 | 0 | Table | Customisable fields categories |
| question_answers | 0 | 5 | 7 | 0 | Table | Answers, with a fractional grade (0-1) and feedback |
| question_dataset_items | 0 | 0 | 4 | 0 | Table | Individual dataset items |
| message_contact_requests | 0 | 10 | 4 | 0 | Table | Maintains list of contact requests between users |
| bigbluebuttonbn_recordings | 0 | 11 | 12 | 0 | Table | The bigbluebuttonbn table to store references to recordings |
| enrol_lti_lti2_context | 5 | 5 | 7 | 0 | Table | Information about a specific LTI contexts from the consumers |
| message_processors | 0 | 0 | 3 | 0 | Table | List of message output plugins |
| workshopform_rubric_levels | 0 | 5 | 5 | 0 | Table | The definition of rubric rating scales |
| lock_db | 0 | 0 | 4 | 0 | Table | Stores active and inactive lock types for db locking method. |
| assignfeedback_editpdf_queue | 0 | 1 | 1 | 0 | Table | |
| context_temp | 0 | 0 | 4 | 0 | Table | Used by build_context_path() in upgrade and cron to keep con |
| course_published | 0 | 10 | 8 | 0 | Table | Information about how and when an local courses were publish |
| grade_outcomes_history | 0 | 20 | 12 | 0 | Table | History table |
| book | 5 | 5 | 11 | 0 | Table | Defines book |
| lti_submission | 0 | 5 | 9 | 0 | Table | Keeps track of individual submissions for LTI activities. |
| portfolio_mahara_queue | 0 | 5 | 3 | 0 | Table | maps mahara tokens to transfer ids |
| oauth2_endpoint | 0 | 10 | 7 | 0 | Table | Describes the named endpoint for an oauth2 service. |
| analytics_models_log | 0 | 10 | 12 | 0 | Table | Analytic models changes during evaluation. |
| competency_userevidencecomp | 0 | 9 | 6 | 0 | Table | Relationship between user evidence and competencies |
| sessions | 0 | 5 | 9 | 0 | Table | Database based session storage - now recommended |
| question_calculated_options | 0 | 5 | 13 | 0 | Table | Options for questions of type calculated |
| repository_instances | 11 | 10 | 10 | 0 | Table | This table contains one entry for every configured external |
| forum | 36 | 0 | 29 | 0 | Table | Forum discussion system. For sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Forum_Activity |
| feedback_completed | 0 | 10 | 7 | 0 | Table | filled out feedback |
| assign_user_flags | 0 | 10 | 8 | 0 | Table | List of flags that can be set for a single user in a single |
| gradingform_guide_comments | 0 | 5 | 5 | 0 | Table | frequently used comments used in marking guide |
| grade_settings | 0 | 5 | 4 | 0 | Table | gradebook settings |
| course_format_options | 0 | 5 | 6 | 0 | Table | Stores format-specific options for the course or course sect |
| course_sections | 0 | 5 | 10 | 0 | Table | to define the sections for each course |
| logstore_standard_log | 0 | 26 | 21 | 0 | Table | Standard log table |
| enrol_lti_lti2_nonce | 0 | 5 | 4 | 0 | Table | Nonce used for authentication between moodle and a consumer |
| portfolio_tempdata | 10 | 10 | 6 | 0 | Table | stores temporary data for portfolio exports. the id of this |
| files_reference | 5 | 5 | 5 | 0 | Table | Store files references |
| tool_brickfield_results | 5 | 10 | 4 | 0 | Table | Results of the accessibility checks |
| adminpresets_app | 0 | 0 | 4 | 0 | Table | Applied presets |
| mnet_log | 0 | 5 | 13 | 0 | Table | Store session data from users migrating to other sites |
| course_completion_defaults | 0 | 10 | 9 | 0 | Table | Default settings for activities completion |
| log | 0 | 5 | 10 | 0 | Table | Every action is logged as far as possible |
| block_recentlyaccesseditems | 0 | 15 | 5 | 0 | Table | Most recently accessed items accessed by a user |
| qtype_multichoice_options | 0 | 5 | 14 | 0 | Table | Options for multiple choice questions |
| workshopform_numerrors_map | 0 | 5 | 4 | 0 | Table | This maps the number of errors to a percentual grade for sub |
| task_log | 0 | 5 | 13 | 0 | Table | The log table for all tasks |
| blog_external | 0 | 5 | 9 | 0 | Table | External blog links used for RSS copying of blog entries to |
| tool_usertours_steps | 0 | 5 | 9 | 0 | Table | Steps in an tour |
| quiz_feedback | 0 | 5 | 6 | 0 | Table | Feedback given to students based on which grade band their o |
| lesson_overrides | 0 | 15 | 11 | 0 | Table | The overrides to lesson settings. |
| tool_monitor_rules | 5 | 1 | 14 | 0 | Table | Table to store rules |
| task_scheduled | 0 | 0 | 17 | 0 | Table | List of scheduled tasks to be run by cron. |
| oauth2_refresh_token | 0 | 10 | 7 | 0 | Table | Stores refresh tokens which can be exchanged for access toke |
| events_queue_handlers | 0 | 10 | 6 | 0 | Table | This is the list of queued handlers for processing. The even |
| analytics_predict_samples | 0 | 5 | 8 | 0 | Table | Samples already used for predictions. |
| question_numerical_units | 0 | 5 | 4 | 0 | Table | Optional unit options for numerical questions. This table is |
| quiz_slots | 0 | 5 | 7 | 0 | Table | Stores the question used in a quiz, with the order, and for |
| cohort_members | 0 | 10 | 4 | 0 | Table | Link a user to a cohort. |
| chat | 15 | 0 | 10 | 0 | Table | Each of these is a chat room |
| question_attempts | 15 | 10 | 14 | 0 | Table | Each row here corresponds to an attempt at one question, as |
| comments | 0 | 6 | 9 | 0 | Table | moodle comments module |
| assign | 49 | 0 | 34 | 0 | Table | This table saves information about an instance of mod_assign in a course. For sample reports see https://docs.moodle.org/401/en/ad-hoc_contributed_reports#Assignment_Activity |
| portfolio_log | 0 | 15 | 11 | 0 | Table | log of portfolio transfers (used to later check for duplicat |
| course_modules_completion | 0 | 5 | 6 | 0 | Table | Stores the completion state (completed or not completed, etc |
| favourite | 0 | 10 | 9 | 0 | Table | Stores the relationship between an arbitrary item (itemtype, |
| qtype_ddimageortext | 0 | 5 | 10 | 0 | Table | Defines drag and drop (text or images onto a background imag |
| gradingform_rubric_fillings | 0 | 10 | 6 | 0 | Table | Stores the data of how the rubric is filled by a particular |
| glossary_categories | 5 | 5 | 4 | 0 | Table | all categories for glossary entries |
| question_versions | 0 | 10 | 5 | 0 | Table | A join table linking the different question version definiti |
| competency_plan | 0 | 10 | 13 | 0 | Table | Learning plans |
| chat_users | 0 | 10 | 12 | 0 | Table | Keeps track of which users are in which chat rooms |
| grading_definitions | 20 | 15 | 14 | 0 | Table | Contains the basic information about an advanced grading for |
| tool_brickfield_summary | 0 | 5 | 27 | 0 | Table | Contains accessibility check results summary information. |
| competency_usercompplan | 0 | 9 | 10 | 0 | Table | User competencies plans |
| gradingform_guide_fillings | 0 | 10 | 6 | 0 | Table | Stores the data of how the guide is filled by a particular r |
| mnet_host2service | 0 | 0 | 5 | 0 | Table | Information about the services for a given host |
| qtype_match_options | 0 | 5 | 10 | 0 | Table | Defines the question-type specific options for matching ques |
| badge_manual_award | 0 | 20 | 6 | 0 | Table | Track manual award criteria for badges |
| adminpresets_app_plug | 0 | 0 | 6 | 0 | Table | Admin presets plugins applied |
| question_multianswer | 0 | 5 | 3 | 0 | Table | Options for multianswer questions |
| tag | 10 | 10 | 10 | 0 | Table | Tag table - this generic table will replace the old “tags” t |
| tool_brickfield_process | 0 | 2 | 7 | 0 | Table | Queued records to initiate new processing of specific target |
| analytics_used_files | 0 | 10 | 5 | 0 | Table | Files that have already been used for training and predictio |
| forum_discussion_subs | 0 | 15 | 5 | 0 | Table | Users may choose to subscribe and unsubscribe from specific |
| mnet_host | 15 | 5 | 15 | 0 | Table | Information about the local and remote hosts for RPC |
| tool_recyclebin_category | 0 | 5 | 5 | 0 | Table | A list of items in the category recycle bin |
| forum_track_prefs | 0 | 6 | 3 | 0 | Table | Tracks each users untracked forums |
| message_airnotifier_devices | 0 | 5 | 3 | 0 | Table | Store information about the devices registered in Airnotifie |
| workshop_aggregations | 0 | 10 | 5 | 0 | Table | Aggregated grades for assessment are stored here. The aggreg |
| wiki_versions | 0 | 5 | 7 | 0 | Table | Stores wiki page history |
| question_calculated | 0 | 5 | 7 | 0 | Table | Options for questions of type calculated |
| role_allow_assign | 0 | 10 | 3 | 0 | Table | this defines what role can assign what role |
| filter_active | 0 | 5 | 5 | 0 | Table | Stores information about which filters are active in which c |
| messageinbound_messagelist | 0 | 5 | 5 | 0 | Table | A list of message IDs for existing replies |
| xapi_states | 0 | 0 | 9 | 0 | Table | The stored xAPI states |
| enrol | 15 | 10 | 35 | 0 | Table | Instances of enrolment plugins used in courses, fields marke |
| badge_criteria_param | 0 | 5 | 4 | 0 | Table | Defines parameters for badges criteria |
| wiki | 5 | 0 | 13 | 0 | Table | Stores Wiki activity configuration |
| competency_templatecohort | 0 | 10 | 6 | 0 | Table | Default comment for the table, please edit me |
| folder | 0 | 5 | 11 | 0 | Table | each record is one folder resource |
| competency_evidence | 0 | 20 | 14 | 0 | Table | The evidence linked to a user competency |
| competency_plancomp | 0 | 9 | 7 | 0 | Table | Plan competencies |
| external_functions | 0 | 0 | 8 | 0 | Table | list of all external functions |
| adminpresets | 0 | 0 | 11 | 0 | Table | named sets of site wide configurations e.g. enable/disable features https://www.youtube.com/watch?v=CyNOhbJ76fY |
| external_services_users | 0 | 10 | 6 | 0 | Table | users allowed to use services with restricted users flag |
| filter_config | 0 | 5 | 5 | 0 | Table | Stores per-context configuration settings for filters which |
| message_users_blocked | 0 | 10 | 4 | 0 | Table | Maintains lists of blocked users |
| block | 5 | 0 | 5 | 0 | Table | contains all installed blocks |
| competency_relatedcomp | 0 | 20 | 6 | 0 | Table | Related competencies |
| reportbuilder_report | 20 | 15 | 15 | 0 | Table | Table to represent a report |
| glossary_entries | 10 | 5 | 16 | 0 | Table | all glossary entries |
| data | 10 | 0 | 37 | 0 | Table | all database activities |
| enrol_lti_user_resource_link | 0 | 10 | 3 | 0 | Table | Join table mapping users to resource links as this is a many |
| block_rss_client | 0 | 5 | 9 | 0 | Table | Remote news feed information. Contains the news feed id, the |
| question_truefalse | 0 | 5 | 5 | 0 | Table | Options for True-False questions |
| tiny_autosave | 0 | 1 | 9 | 0 | Table | The content of the textarea saved during autosave operations |
| lti | 16 | 5 | 26 | 0 | Table | This table contains Basic LTI activities instances |
| quizaccess_seb_template | 5 | 5 | 9 | 0 | Table | Templates for Safe Exam Browser configuration. |
| mnet_remote_rpc | 0 | 0 | 6 | 0 | Table | This table describes functions that might be called remotely |
| course_completion_aggr_methd | 0 | 5 | 5 | 0 | Table | Course completion aggregation methods for criteria |
| assignfeedback_editpdf_quick | 0 | 5 | 5 | 0 | Table | Stores teacher specified quicklist comments |
| blog_association | 0 | 10 | 3 | 0 | Table | Associations of blog entries with courses and module instanc |
| tool_customlang | 0 | 5 | 11 | 0 | Table | Contains the working checkout of all strings and their custo |
| enrol_lti_lti2_tool_proxy | 0 | 5 | 6 | 0 | Table | A tool proxy between moodle and a consumer |
| choice | 10 | 0 | 19 | 0 | Table | Available choices are stored here |
| external_tokens | 0 | 20 | 13 | 0 | Table | Security tokens for accessing of external services |
| oauth2_access_token | 0 | 10 | 8 | 0 | Table | Stores access tokens for system accounts in order to be able |
| events_handlers | 5 | 0 | 8 | 0 | Table | This table is for storing which components requests what typ |
| messageinbound_datakeys | 0 | 5 | 6 | 0 | Table | Inbound Message data item secret keys. |
| question_attempt_step_data | 0 | 5 | 4 | 0 | Table | Each question_attempt_step has an associative array of the d |
| message_email_messages | 0 | 15 | 4 | 0 | Table | Keeps track of what emails to send in an email digest |
| search_index_requests | 0 | 5 | 7 | 0 | Table | Records requests for (re)indexing of specific contexts. Entr |
| block_recent_activity | 0 | 6 | 7 | 0 | Table | Recent activity block |
| h5p_libraries | 25 | 0 | 20 | 0 | Table | Stores information about libraries used by H5P content. |
| lti_access_tokens | 0 | 5 | 7 | 0 | Table | Security tokens for accessing of LTI services |
| data_fields | 5 | 5 | 16 | 0 | Table | every field available |
| badge_backpack | 10 | 10 | 7 | 0 | Table | Defines settings for connecting external backpack |
| scorm_aicc_session | 0 | 10 | 12 | 0 | Table | Used by AICC HACP to store session information |
| tool_dataprivacy_purposerole | 0 | 15 | 10 | 0 | Table | Data purpose overrides for a specific role |
| grading_instances | 10 | 10 | 9 | 0 | Table | Grading form instance is an assessment record for one gradab |
| course_request | 0 | 0 | 9 | 0 | Table | course requests |
| question_numerical_options | 0 | 5 | 6 | 0 | Table | Options for questions of type numerical This table is also u |
| role_allow_override | 0 | 10 | 3 | 0 | Table | this defines what role can override what role |
| user | 858 | 0 | 49 | 0 | Table | One record for each person, custom profile fields can be added via /user/profile/index.php for sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#USER_and_ENROLMENT_Reports |
| grade_import_newitem | 5 | 5 | 4 | 0 | Table | temporary table for storing new grade_item names from grade |
| tool_dataprivacy_ctxlevel | 0 | 10 | 7 | 0 | Table | Default comment for the table, please edit me |
| workshopform_rubric_config | 0 | 5 | 3 | 0 | Table | Configuration table for the Rubric grading strategy |
| tool_customlang_components | 5 | 0 | 3 | 0 | Table | Contains the list of all installed plugins that provide thei |
| message_user_actions | 0 | 10 | 5 | 0 | Table | Stores all per-user actions on individual messages |
| workshopallocation_scheduled | 0 | 5 | 9 | 0 | Table | Stores the allocation settings for the scheduled allocator |
| quiz_overrides | 0 | 15 | 9 | 0 | Table | The overrides to quiz settings on a per-user and per-group b |