Database Properties
Database Type: MySQL - 5.7.31
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| quiz_grades | 0 | 2 | 5 | -1 | Table | Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting. |
| groups | 5 | 1 | 11 | -1 | Table | Each record represents a group. |
| tool_policy_acceptances | 0 | 3 | 9 | -1 | Table | Tracks users accepting the policy versions |
| questionnaire_survey | 3 | 1 | 17 | -1 | Table | questionnaire_survey table retrofitted from MySQL |
| lesson_answers | 1 | 2 | 13 | -1 | Table | Defines lesson_answers |
| scorm_scoes_data | 0 | 1 | 4 | -1 | Table | Contains variable data get from packages |
| data_records | 1 | 2 | 7 | -1 | Table | every record introduced |
| h5p_library_dependencies | 0 | 2 | 4 | -1 | Table | Stores H5P library dependencies |
| upgrade_log | 0 | 1 | 10 | -1 | Table | Upgrade logging |
| stats_daily | 0 | 2 | 7 | -1 | Table | to accumulate daily stats |
| block_zoola_reports | 0 | 1 | 5 | -1 | Table | Reports configured in this block instance |
| stats_monthly | 0 | 2 | 7 | -1 | Table | To accumulate monthly stats |
| questionnaire_question | 2 | 1 | 12 | -1 | Table | questionnaire_question table retrofitted from MySQL |
| badge_issued | 1 | 2 | 8 | -1 | Table | Defines issued badges |
| assignment_submissions | 0 | 2 | 14 | -1 | Table | Info about submitted assignments |
| block_zoola_reports_user | 0 | 2 | 3 | -1 | Table | Users that can access this block instance |
| search_simpledb_index | 0 | 3 | 14 | -1 | Table | search_simpledb table containing the index data. |
| file_conversion | 0 | 2 | 11 | -1 | Table | Table to track file conversions. |
| competency_coursecomp | 0 | 2 | 8 | -1 | Table | Link a competency to a course. |
| cache_filters | 0 | 0 | 6 | -1 | Table | For keeping information about cached data |
| lesson_attempts | 0 | 4 | 9 | -1 | Table | Defines lesson_attempts |
| survey_questions | 1 | 0 | 7 | -1 | Table | the questions conforming one survey |
| portfolio_instance | 4 | 0 | 4 | -1 | Table | base table (not including config data) for instances of portfolio plugins. |
| badge | 7 | 3 | 26 | -1 | Table | Defines badge |
| user_preferences | 0 | 1 | 4 | -1 | Table | Allows modules to store arbitrary user preferences |
| grade_outcomes | 4 | 3 | 10 | -1 | Table | This table describes the outcomes used in the system. An outcome is a statement tied to a rubric scale from low to high, such as âNot met, Borderline, Metâ (stored as 0,1 or 2) |
| local_ld_course | 2 | 2 | 4 | -1 | Table | Total time spent within a course |
| quiz_statistics | 0 | 0 | 19 | -1 | Table | table to cache results from analysis done in statistics report for quizzes. |
| stats_user_daily | 0 | 3 | 8 | -1 | Table | To accumulate daily stats per course/user |
| role | 24 | 0 | 6 | -1 | Table | moodle roles |
| message | 1 | 0 | 17 | -1 | Table | Stores all unread messages |
| qtype_essay_options | 0 | 1 | 12 | -1 | Table | Extra options for essay questions. |
| message_contacts | 0 | 3 | 4 | -1 | Table | Maintains lists of contacts between users |
| oauth2_issuer | 5 | 0 | 20 | -1 | Table | Details for an oauth 2 connect identity issuer. |
| message_conversation_actions | 0 | 2 | 5 | -1 | Table | Stores all per-user actions on individual conversations |
| qtype_randomsamatch_options | 0 | 1 | 11 | -1 | Table | Info about a random short-answer matching question |
| block_zoola_reports_cohort | 0 | 2 | 3 | -1 | Table | Cohorts that can access this block instance |
| editor_atto_autosave | 0 | 2 | 9 | -1 | Table | Draft text that is auto-saved every 5 seconds while an editor is open. |
| local_ld_import_logs_status | 0 | 1 | 7 | -1 | Table | Current status of the import logs task |
| qtype_ddmarker_drags | 0 | 1 | 6 | -1 | Table | Labels for markers to drag. |
| assignment_upgrade | 0 | 0 | 6 | -1 | Table | Info about upgraded assignments |
| tool_dataprivacy_ctxinstance | 0 | 3 | 7 | -1 | Table | Default comment for the table, please edit me |
| grade_categories_history | 0 | 4 | 18 | -1 | Table | History of grade_categories |
| analytics_models | 6 | 0 | 13 | -1 | Table | Analytic models. |
| imscp | 0 | 0 | 9 | -1 | Table | each record is one imscp resource |
| role_allow_view | 0 | 2 | 3 | -1 | Table | This table stores which which other roles a user is allowed to view to if they have one role. |
| event_subscriptions | 1 | 2 | 10 | -1 | Table | Tracks subscriptions to remote calendars. |
| local_ld_course_day | 0 | 1 | 6 | -1 | Table | Time spent on a course at day level |
| enrol_lti_lti2_share_key | 0 | 1 | 5 | -1 | Table | Resource link share key |
| course_completion_crit_compl | 0 | 3 | 7 | -1 | Table | Course completion user records |
| mnet_rpc | 0 | 0 | 11 | -1 | Table | Functions or methods that we may publish or subscribe to |
| tag_correlation | 0 | 1 | 3 | -1 | Table | The rationale for the 'tag_correlation' table is performance. It works as a cache for a potentially heavy load query done at the 'tag_instance' table. So, the 'tag_correlation' table stores redundant information derived from the 'tag_instance' table |
| scorm_seq_ruleconds | 1 | 1 | 5 | -1 | Table | SCORM2004 rule conditions |
| post | 1 | 4 | 19 | -1 | Table | Generic post table to hold data blog entries etc in different modules |
| tool_dataprivacy_purpose | 3 | 0 | 11 | -1 | Table | Data purposes |
| assignfeedback_file | 0 | 2 | 4 | -1 | Table | Stores info about the number of files submitted by a student. |
| question_gapselect | 0 | 1 | 10 | -1 | Table | Defines select missing words questions |
| quiz_overview_regrades | 0 | 2 | 7 | -1 | Table | This table records which question attempts need regrading and the grade they will be regraded to. |
| qtype_shortanswer_options | 0 | 1 | 3 | -1 | Table | Options for short answer questions |
| user_password_resets | 0 | 1 | 5 | -1 | Table | table tracking password reset confirmation tokens |
| feedback_valuetmp | 0 | 1 | 6 | -1 | Table | values of the completedstmp |
| modules | 2 | 0 | 6 | -1 | Table | modules available in the site |
| feedback_sitecourse_map | 0 | 2 | 3 | -1 | Table | feedback sitecourse map |
| scorm_seq_mapinfo | 0 | 2 | 8 | -1 | Table | SCORM2004 objective mapinfo description |
| choice_options | 1 | 1 | 5 | -1 | Table | available options to choice |
| lesson | 7 | 0 | 42 | -1 | Table | Defines lesson |
| lti_types | 3 | 0 | 18 | -1 | Table | Basic LTI pre-configured activities |
| questionnaire | 1 | 2 | 20 | -1 | Table | Main questionnaire table. |
| license | 0 | 0 | 8 | -1 | Table | store licenses used by moodle |
| lesson_branch | 0 | 3 | 8 | -1 | Table | branches for each lesson/user |
| cache_flags | 0 | 0 | 6 | -1 | Table | Cache of time-sensitive flags |
| analytics_indicator_calc | 0 | 1 | 9 | -1 | Table | Stored indicator calculations |
| message_popup_notifications | 0 | 1 | 2 | -1 | Table | List of notifications to display in the message output popup |
| customfield_data | 0 | 2 | 12 | -1 | Table | core_customfield data table |
| scorm_seq_rolluprule | 1 | 1 | 7 | -1 | Table | SCORM2004 sequencing rule |
| wiki_locks | 0 | 2 | 5 | -1 | Table | Manages page locks |
| oauth2_user_field_mapping | 0 | 1 | 7 | -1 | Table | Mapping of oauth user fields to moodle fields. |
| auth_oauth2_linked_login | 0 | 3 | 10 | -1 | Table | Accounts linked to a users Moodle account. |
| role_capabilities | 0 | 4 | 7 | -1 | Table | permission has to be signed, overriding a capability for a particular role in a particular context |
| survey_analysis | 0 | 2 | 4 | -1 | Table | text about each survey submission |
| badge_criteria_met | 0 | 3 | 5 | -1 | Table | Defines criteria that were met for an issued badge |
| feedback | 4 | 0 | 17 | -1 | Table | all feedbacks |
| workshop_grades | 0 | 1 | 7 | -1 | Table | How the reviewers filled-up the grading forms, given grades and comments |
| qtype_ddmarker | 0 | 1 | 11 | -1 | Table | Defines drag and drop (text or images onto a background image) questions |
| mnet_remote_service2rpc | 0 | 0 | 3 | -1 | Table | Group functions or methods under a service |
| feedback_item | 2 | 2 | 13 | -1 | Table | feedback_items |
| competency_template | 3 | 1 | 10 | -1 | Table | Learning plan templates. |
| workshop_assessments | 1 | 3 | 15 | -1 | Table | Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher. |
| grade_letters | 0 | 1 | 4 | -1 | Table | Repository for grade letters, for courses and other moodle entities that use grades. |
| assignment | 1 | 0 | 19 | -1 | Table | Defines assignments |
| enrol_flatfile | 0 | 3 | 8 | -1 | Table | enrol_flatfile table retrofitted from MySQL |
| analytics_train_samples | 0 | 1 | 6 | -1 | Table | Samples used for training |
| assign_submission | 2 | 2 | 9 | -1 | Table | This table keeps information about student interactions with the mod/assign. This is limited to metadata about a student submission but does not include the submission itself which is stored by plugins. |
| mnet_application | 1 | 0 | 6 | -1 | Table | Information about applications on remote hosts |
| tool_dataprivacy_category | 2 | 0 | 7 | -1 | Table | Data categories |
| survey_answers | 0 | 3 | 7 | -1 | Table | the answers to each questions filled by the users |
| forum_queue | 0 | 3 | 5 | -1 | Table | For keeping track of posts that will be mailed in digest form |
| tag_area | 0 | 1 | 9 | -1 | Table | Defines various tag areas, one area is identified by component and itemtype |
| backup_controllers | 1 | 1 | 17 | -1 | Table | To store the backup_controllers as they are used |
| analytics_predictions | 1 | 2 | 11 | -1 | Table | Predictions |
| block_zoola_module_name | 0 | 1 | 5 | -1 | Table | Module names |
| ltiservice_gradebookservices | 0 | 2 | 9 | -1 | Table | This file records the grade items created by the LTI Gradebook Services service |
| repository_onedrive_access | 0 | 1 | 6 | -1 | Table | List of temporary access grants. |
| questionnaire_dependency | 0 | 2 | 7 | -1 | Table | Holds the combined dependencies per question to navigate in the test |
| h5p | 1 | 1 | 9 | -1 | Table | Stores H5P content information |
| lti_tool_settings | 0 | 4 | 8 | -1 | Table | LTI tool setting values |
| assign_grades | 5 | 2 | 8 | -1 | Table | Grading information about a single assignment submission. |
| course_categories | 4 | 1 | 14 | -1 | Table | Course categories |
| quiz_reports | 0 | 0 | 4 | -1 | Table | Lists all the installed quiz reports and their display order and so on. No need to worry about deleting old records. Only records with an equivalent directory are displayed. |
| questionnaire_response_other | 0 | 0 | 5 | -1 | Table | questionnaire_response_other table retrofitted from MySQL |
| portfolio_instance_config | 0 | 1 | 4 | -1 | Table | config for portfolio plugin instances |
| questionnaire_fb_sections | 1 | 1 | 7 | -1 | Table | questionnaire_fb_sections table retrofitted from MySQL |
| resource_old | 0 | 0 | 16 | -1 | Table | backup of all old resource instances from 1.9 |
| scorm_scoes_track | 0 | 3 | 8 | -1 | Table | to track SCOes |
| forum_grades | 0 | 2 | 7 | -1 | Table | Grading data for forum instances |
| user_lastaccess | 0 | 2 | 4 | -1 | Table | To keep track of course page access times, used in online participants block, and participants list |
| questionnaire_resp_multiple | 0 | 0 | 4 | -1 | Table | questionnaire_resp_multiple table retrofitted from MySQL |
| badge_backpack_oauth2 | 0 | 4 | 11 | -1 | Table | Default comment for the table, please edit me |
| block_zoola_reports_schreps | 1 | 2 | 23 | -1 | Table | Manually scheduled reports |
| survey | 3 | 0 | 11 | -1 | Table | Each record is one SURVEY module with its configuration |
| workshopeval_best_settings | 0 | 1 | 3 | -1 | Table | Settings for the grading evaluation subplugin Comparison with the best assessment. |
| quiz_attempts | 0 | 2 | 15 | -1 | Table | Stores users attempts at quizzes. |
| backup_courses | 0 | 1 | 6 | -1 | Table | To store every course backup status |
| tool_usertours_tours | 1 | 0 | 7 | -1 | Table | List of tours |
| oauth2_system_account | 0 | 0 | 9 | -1 | Table | Stored details used to get an access token as a system user for this oauth2 service. |
| question_hints | 0 | 1 | 7 | -1 | Table | Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours. |
| cohort | 4 | 1 | 11 | -1 | Table | Each record represents one cohort (aka site-wide group). |
| workshop | 10 | 1 | 37 | -1 | Table | This table keeps information about the module instances and their settings |
| question_statistics | 0 | 1 | 18 | -1 | Table | Statistics for individual questions used in an activity. |
| h5pactivity_attempts | 1 | 2 | 12 | -1 | Table | Users attempts inside H5P activities |
| groupings_groups | 0 | 2 | 4 | -1 | Table | Link a grouping to a group (note, groups can be in multiple groupings ONLY in a course). WAS: groups_groupings_groups |
| registration_hubs | 0 | 0 | 7 | -1 | Table | hub where the site is registered on with their associated token |
| glossary | 2 | 0 | 28 | -1 | Table | all glossaries |
| url | 0 | 0 | 10 | -1 | Table | each record is one url resource |
| mnet_session | 0 | 1 | 9 | -1 | Table | Store session data from users migrating to other sites |
| competency_templatecomp | 0 | 2 | 7 | -1 | Table | Link a competency to a learning plan template. |
| badge_external_identifier | 0 | 1 | 5 | -1 | Table | Setting for external badges mappings |
| glossary_entries_categories | 0 | 2 | 3 | -1 | Table | categories of each glossary entry |
| enrol_paypal | 0 | 3 | 21 | -1 | Table | Holds all known information about PayPal transactions |
| role_allow_switch | 0 | 2 | 3 | -1 | Table | This table stores which which other roles a user is allowed to switch to if they have one role. |
| badge_alignment | 0 | 1 | 7 | -1 | Table | Defines alignment for badges |
| qtype_ddimageortext_drops | 0 | 1 | 7 | -1 | Table | Drop boxes |
| notifications | 1 | 1 | 15 | -1 | Table | Stores all notifications |
| question_categories | 4 | 2 | 9 | -1 | Table | Categories are for grouping questions |
| assignsubmission_file | 0 | 2 | 4 | -1 | Table | Info about file submissions for assignments |
| message_conversation_members | 0 | 2 | 4 | -1 | Table | Stores all members in a conversations |
| task_adhoc | 1 | 1 | 8 | -1 | Table | List of adhoc tasks waiting to run. |
| contentbank_content | 0 | 3 | 10 | -1 | Table | This table stores content data in the content bank. |
| glossary_formats | 0 | 0 | 10 | -1 | Table | Setting of the display formats |
| grade_items | 4 | 4 | 31 | -1 | Table | This table keeps information about gradeable items (ie columns). If an activity (eg an assignment or quiz) has multiple grade_items associated with it (eg several outcomes or numerical grades), then there will be a corresponding multiple number of rows in this table. |
| book_chapters | 0 | 1 | 11 | -1 | Table | Defines book_chapters |
| badge_external | 0 | 1 | 5 | -1 | Table | Setting for external badges display |
| block_instances | 5 | 2 | 12 | -1 | Table | This table stores block instances. The type of block this is is given by the blockname column. The places this block instance appears is controlled by the parentcontexid, showinsubcontexts, pagetypepattern and subpagepattern fields. Where the block appears on the page (by default) is controlled by the defaultposition and defaultweight columns. The block's own configuration is stored serialized in configdata. |
| question_response_count | 0 | 1 | 4 | -1 | Table | Count for each responses for each try at a question. |
| grade_grades_history | 0 | 6 | 24 | -1 | Table | History table |
| question_response_analysis | 1 | 1 | 10 | -1 | Table | Analysis of student responses given to questions. |
| mnet_service2rpc | 0 | 0 | 3 | -1 | Table | Group functions or methods under a service |
| lti_tool_proxies | 1 | 0 | 13 | -1 | Table | LTI tool proxy registrations |
| scorm_seq_rolluprulecond | 0 | 2 | 5 | -1 | Table | SCORM2004 sequencing rule |
| grade_import_values | 0 | 4 | 9 | -1 | Table | Temporary table for importing grades |
| questionnaire_resp_single | 0 | 0 | 4 | -1 | Table | questionnaire_resp_single table retrofitted from MySQL |
| grade_outcomes_courses | 0 | 2 | 3 | -1 | Table | stores what outcomes are used in what courses. |
| workshop_submissions | 1 | 3 | 19 | -1 | Table | Info about the submission and the aggregation of the grade for submission, grade for assessment and final grade. Both grade for submission and grade for assessment can be overridden by teacher. Final grade is always the sum of them. All grades are stored as of 0-100. |
| enrol_lti_lti2_user_result | 0 | 1 | 6 | -1 | Table | Results for each user for each resource link |
| event | 0 | 4 | 24 | -1 | Table | For everything with a time associated to it |
| badge_endorsement | 0 | 1 | 8 | -1 | Table | Defines endorsement for badge |
| tool_dataprivacy_ctxexpired | 0 | 1 | 9 | -1 | Table | Default comment for the table, please edit me |
| config | 0 | 0 | 3 | -1 | Table | Moodle configuration variables |
| workshopform_comments | 0 | 1 | 5 | -1 | Table | The assessment dimensions definitions of Comments strategy forms |
| mnet_sso_access_control | 0 | 0 | 4 | -1 | Table | Users by host permitted (or not) to login from a remote provider |
| question_dataset_definitions | 1 | 1 | 6 | -1 | Table | Organises and stores properties for dataset items |
| scale | 10 | 2 | 8 | -1 | Table | Defines grading scales |
| analytics_prediction_actions | 0 | 2 | 5 | -1 | Table | Register of user actions over predictions. |
| block_zoola_reports_eventcfg | 1 | 0 | 14 | -1 | Table | Event schedules configuration |
| questionnaire_quest_choice | 0 | 1 | 4 | -1 | Table | questionnaire_quest_choice table retrofitted from MySQL |
| tool_policy | 1 | 1 | 3 | -1 | Table | Contains the list of policy documents defined on the site. |
| files | 3 | 3 | 20 | -1 | Table | description of files, content is stored in sha1 file pool |
| competency_usercompcourse | 0 | 3 | 9 | -1 | Table | User competencies in a course |
| feedback_template | 1 | 0 | 4 | -1 | Table | templates of feedbackstructures |
| wiki_subwikis | 2 | 2 | 4 | -1 | Table | Stores subwiki instances |
| mnetservice_enrol_courses | 0 | 1 | 14 | -1 | Table | Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users |
| question_datasets | 0 | 2 | 3 | -1 | Table | Many-many relation between questions and dataset definitions |
| assign_overrides | 0 | 3 | 8 | -1 | Table | The overrides to assign settings. |
| h5pactivity_attempts_results | 0 | 1 | 14 | -1 | Table | H5Pactivities_attempts tracking info |
| user_private_key | 0 | 1 | 8 | -1 | Table | access keys used in cookieless scripts - rss, etc. |
| feedback_completedtmp | 0 | 3 | 8 | -1 | Table | filled out feedback |
| h5pactivity | 1 | 1 | 12 | -1 | Table | Stores the h5pactivity activity module instances. |
| wiki_links | 0 | 2 | 5 | -1 | Table | Page wiki links |
| questionnaire_question_type | 0 | 0 | 5 | -1 | Table | questionnaire_question_type table retrofitted from MySQL |
| quizaccess_seb_quizsettings | 0 | 2 | 29 | -1 | Table | Stores the quiz level Safe Exam Browser configuration. |
| gradingform_guide_criteria | 1 | 1 | 9 | -1 | Table | Stores the rows of the criteria grid. |
| message_read | 0 | 2 | 17 | -1 | Table | Stores all messages that have been read |
| events_queue | 1 | 1 | 5 | -1 | Table | This table is for storing queued events. It stores only one copy of the eventdata here, and entries from this table are being references by the event_queue_handlers table. |
| badge_criteria | 2 | 1 | 6 | -1 | Table | Defines criteria for issuing badges |
| quiz_sections | 0 | 1 | 5 | -1 | Table | Stores sections of a quiz with section name (heading), from slot-number N and whether the question order should be shuffled. |
| forum_digests | 0 | 2 | 4 | -1 | Table | Keeps track of user mail delivery preferences for each forum |
| forum_subscriptions | 0 | 2 | 3 | -1 | Table | Keeps track of who is subscribed to what forum |
| assign_user_mapping | 0 | 2 | 3 | -1 | Table | Map an assignment specific id number to a user |
| questionnaire_response_text | 0 | 0 | 4 | -1 | Table | questionnaire_response_text table retrofitted from MySQL |
| wiki_pages | 2 | 2 | 10 | -1 | Table | Stores wiki pages |
| competency_coursecompsetting | 0 | 1 | 6 | -1 | Table | This table contains the course specific settings for competencies. |
| message_popup | 0 | 1 | 3 | -1 | Table | Keep state of notifications for the popup message processor |
| repository_instance_config | 0 | 0 | 4 | -1 | Table | The config for intances |
| lti_types_config | 0 | 0 | 4 | -1 | Table | Basic LTI types configuration |
| data_content | 0 | 2 | 8 | -1 | Table | the content introduced in each record/fields |
| questionnaire_response_date | 0 | 0 | 4 | -1 | Table | questionnaire_response_date table retrofitted from MySQL |
| assignfeedback_editpdf_cmnt | 0 | 1 | 9 | -1 | Table | Stores comments added to pdfs |
| context | 39 | 0 | 6 | -1 | Table | one of these must be set |
| groupings | 2 | 1 | 9 | -1 | Table | A grouping is a collection of groups. WAS: groups_groupings |
| log_display | 0 | 0 | 6 | -1 | Table | For a particular module/action, specifies a moodle table/field |
| role_names | 0 | 2 | 4 | -1 | Table | role names in native strings |
| competency_userevidence | 0 | 1 | 9 | -1 | Table | The evidence of prior learning |
| course_completions | 0 | 2 | 7 | -1 | Table | Course completion records |
| assignsubmission_onlinetext | 0 | 2 | 5 | -1 | Table | Info about onlinetext submission |
| tool_monitor_subscriptions | 1 | 3 | 8 | -1 | Table | Table to store user subscriptions to various rules |
| enrol_lti_users | 0 | 2 | 12 | -1 | Table | User access log and gradeback data |
| local_ld_lastactivity | 0 | 3 | 5 | -1 | Table | Last activity that user has performed |
| customfield_category | 1 | 1 | 11 | -1 | Table | core_customfield category table |
| gradingform_rubric_criteria | 2 | 1 | 5 | -1 | Table | Stores the rows of the rubric grid. |
| user_password_history | 0 | 1 | 4 | -1 | Table | A rotating log of hashes of previously used passwords for each user. |
| feedback_value | 0 | 1 | 6 | -1 | Table | values of the completeds |
| config_log | 0 | 1 | 7 | -1 | Table | Changes done in server configuration through admin UI |
| competency_framework | 1 | 2 | 13 | -1 | Table | List of competency frameworks. |
| profiling | 0 | 0 | 11 | -1 | Table | Stores the results of all the profiling runs |
| scorm_seq_objective | 1 | 1 | 6 | -1 | Table | SCORM2004 objective description |
| rating | 0 | 3 | 10 | -1 | Table | moodle ratings |
| my_pages | 0 | 1 | 5 | -1 | Table | Extra user pages for the My Moodle system |
| competency_modulecomp | 0 | 2 | 8 | -1 | Table | Link a competency to a module. |
| grade_items_history | 0 | 6 | 34 | -1 | Table | History of grade_items |
| enrol_lti_tool_consumer_map | 0 | 2 | 3 | -1 | Table | Table that maps the published tool to tool consumers. |
| course_completion_criteria | 1 | 3 | 10 | -1 | Table | Course completion criteria |
| h5p_libraries_cachedassets | 0 | 1 | 3 | -1 | Table | H5P cached library assets |
| assignfeedback_editpdf_rot | 0 | 1 | 6 | -1 | Table | Stores rotation information of a page. |
| course_modules | 5 | 3 | 21 | -1 | Table | course_modules table retrofitted from MySQL |
| forum_posts | 3 | 3 | 18 | -1 | Table | All posts are stored in this table |
| tool_recyclebin_course | 0 | 1 | 6 | -1 | Table | A list of items in the course recycle bin |
| glossary_alias | 0 | 1 | 3 | -1 | Table | entries alias |
| grade_grades | 1 | 4 | 23 | -1 | Table | grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers might change this for an activity! All the results are normalised/resampled for the final grade value. |
| scorm_scoes | 8 | 1 | 10 | -1 | Table | each SCO part of the SCORM module |
| stats_user_weekly | 0 | 3 | 8 | -1 | Table | To accumulate weekly stats per course/user |
| chat_messages_current | 0 | 2 | 7 | -1 | Table | Stores current session |
| enrol_lti_tools | 2 | 2 | 19 | -1 | Table | List of tools provided to the remote system |
| gradingform_rubric_levels | 0 | 1 | 5 | -1 | Table | Stores the columns of the rubric grid. |
| workshopform_accumulative | 0 | 1 | 7 | -1 | Table | The assessment dimensions definitions of Accumulative grading strategy forms |
| tool_monitor_history | 0 | 2 | 4 | -1 | Table | Table to store history of message notifications sent |
| competency_usercomp | 1 | 2 | 10 | -1 | Table | User competencies |
| tag_coll | 2 | 0 | 7 | -1 | Table | Defines different set of tags |
| mnetservice_enrol_enrolments | 0 | 2 | 7 | -1 | Table | Caches the information about enrolments of our local users in courses on remote hosts |
| external_services_functions | 0 | 1 | 3 | -1 | Table | lists functions available in each service group |
| message_conversations | 4 | 1 | 11 | -1 | Table | Stores all message conversations |
| messages | 2 | 2 | 11 | -1 | Table | Stores all messages |
| h5p_contents_libraries | 0 | 2 | 6 | -1 | Table | Store which library is used in which content. |
| competency | 9 | 2 | 17 | -1 | Table | This table contains the master record of each competency in a framework |
| resource | 1 | 0 | 13 | -1 | Table | Each record is one resource and its config data |
| tag_instance | 0 | 2 | 10 | -1 | Table | tag_instance table holds the information of associations between tags and other items |
| user_devices | 0 | 1 | 11 | -1 | Table | This table stores user's mobile devices information in order to send PUSH notifications |
| question_ddwtos | 0 | 1 | 10 | -1 | Table | Defines drag and drop (words into sentences) questions |
| block_zoola_schedule_rcp | 0 | 2 | 3 | -1 | Table | Scheduled reports recipients |
| grade_categories | 5 | 2 | 14 | -1 | Table | This table keeps information about categories, used for grouping items. |
| assign_plugin_config | 0 | 1 | 6 | -1 | Table | Config data for an instance of a plugin in an assignment. |
| quiz | 7 | 0 | 41 | -1 | Table | The settings for each quiz. |
| tool_cohortroles | 0 | 3 | 7 | -1 | Table | Mapping of users to cohort role assignments. |
| question_attempt_steps | 1 | 2 | 7 | -1 | Table | Stores one step in in a question attempt. As well as the data here, the step will have some data in the question_attempt_step_data table. |
| repository | 0 | 0 | 4 | -1 | Table | This table contains one entry for every configured external repository instance. |
| lesson_pages | 3 | 1 | 13 | -1 | Table | Defines lesson_pages |
| message_providers | 0 | 0 | 4 | -1 | Table | This table stores the message providers (modules and core systems) |
| assignfeedback_editpdf_annot | 0 | 1 | 11 | -1 | Table | stores annotations added to pdfs submitted by students |
| badge_related | 0 | 2 | 3 | -1 | Table | Defines badge related for badges |
| tool_dataprivacy_request | 0 | 4 | 15 | -1 | Table | Table for data requests |
| workshopform_numerrors | 0 | 1 | 9 | -1 | Table | The assessment dimensions definitions of Number of errors grading strategy forms |
| block_positions | 0 | 2 | 8 | -1 | Table | Stores the position of a sticky block_instance on a another page than the one where it was added. |
| tool_policy_versions | 2 | 2 | 16 | -1 | Table | Holds versions of the policy documents |
| local_ld_module | 1 | 2 | 4 | -1 | Table | Time spent on a module |
| config_plugins | 0 | 0 | 4 | -1 | Table | Moodle modules and plugins configuration variables |
| qtype_match_subquestions | 0 | 1 | 5 | -1 | Table | The subquestions that make up a matching question |
| customfield_field | 1 | 1 | 11 | -1 | Table | core_customfield field table |
| question_numerical | 0 | 1 | 4 | -1 | Table | Options for numerical questions. |
| messageinbound_handlers | 1 | 0 | 6 | -1 | Table | Inbound Message Handler definitions. |
| user_info_data | 0 | 2 | 5 | -1 | Table | Data for the customisable user fields |
| label | 0 | 0 | 6 | -1 | Table | Defines labels |
| mnet_service | 0 | 0 | 5 | -1 | Table | A service is a group of functions |
| analytics_used_analysables | 0 | 1 | 6 | -1 | Table | List of analysables used by each model |
| quiz_slot_tags | 0 | 2 | 4 | -1 | Table | Stores data about the tags that a question must have so that it can be selected for a quiz slot (when having a random question by tags on that slot). |
| forum_read | 0 | 4 | 7 | -1 | Table | Tracks each users read posts |
| forum_discussions | 4 | 2 | 14 | -1 | Table | Forums are composed of discussions |
| user_info_field | 1 | 1 | 20 | -1 | Table | Customisable user profile fields |
| page | 2 | 0 | 13 | -1 | Table | Each record is one page and its config data |
| workshopform_rubric | 1 | 1 | 5 | -1 | Table | The assessment dimensions definitions of Rubric grading strategy forms |
| enrol_lti_lti2_consumer | 5 | 0 | 19 | -1 | Table | LTI consumers interacting with moodle |
| scorm_seq_rulecond | 0 | 2 | 7 | -1 | Table | SCORM2004 rule condition |
| wiki_synonyms | 0 | 1 | 4 | -1 | Table | Stores wiki pages synonyms |
| question_usages | 1 | 1 | 4 | -1 | Table | This table's main purpose it to assign a unique id to each attempt at a set of questions by some part of Moodle. A question usage is made up of a number of question_attempts. |
| tool_monitor_events | 0 | 3 | 8 | -1 | Table | A table that keeps a log of events related to subscriptions |
| chat_messages | 0 | 2 | 7 | -1 | Table | Stores all the actual chat messages |
| external_services | 3 | 0 | 11 | -1 | Table | built in and custom external services |
| grading_areas | 1 | 1 | 5 | -1 | Table | Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set. |
| scale_history | 0 | 4 | 11 | -1 | Table | History table |
| role_context_levels | 0 | 1 | 3 | -1 | Table | Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table. |
| stats_user_monthly | 0 | 3 | 8 | -1 | Table | To accumulate monthly stats per course/user |
| user_enrolments | 0 | 3 | 9 | -1 | Table | Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students |
| lesson_timer | 0 | 2 | 7 | -1 | Table | lesson timer for each lesson |
| qtype_ddimageortext_drags | 0 | 1 | 6 | -1 | Table | Images to drag. Actual file names are not stored here we use the file names as found in the file storage area. |
| local_ld_module_day | 0 | 1 | 5 | -1 | Table | Time spent on a module at day level |
| role_assignments | 0 | 3 | 9 | -1 | Table | assigning roles in different context |
| portfolio_instance_user | 0 | 2 | 5 | -1 | Table | user data for portfolio instances. |
| assignfeedback_comments | 0 | 2 | 5 | -1 | Table | Text feedback for submitted assignments |
| capabilities | 1 | 0 | 6 | -1 | Table | this defines all capabilities |
| choice_answers | 0 | 3 | 5 | -1 | Table | choices performed by users |
| badge_external_backpack | 2 | 1 | 7 | -1 | Table | Defines settings for site level backpacks that a user can connect to. |
| groups_members | 0 | 2 | 6 | -1 | Table | Link a user to a group. |
| enrol_lti_lti2_resource_link | 2 | 3 | 9 | -1 | Table | Link from the consumer to the tool |
| scorm | 3 | 0 | 42 | -1 | Table | each table is one SCORM module and its configuration |
| course | 66 | 1 | 32 | -1 | Table | Central course table |
| question | 29 | 4 | 20 | -1 | Table | The questions themselves |
| stats_weekly | 0 | 2 | 7 | -1 | Table | To accumulate weekly stats |
| qtype_ddmarker_drops | 0 | 1 | 6 | -1 | Table | drop regions |
| lesson_grades | 0 | 2 | 6 | -1 | Table | Defines lesson_grades |
| log_queries | 0 | 0 | 9 | -1 | Table | Logged database queries. |
| backup_logs | 0 | 1 | 5 | -1 | Table | To store all the logs from backup and restore operations (by db logger) |
| user_info_category | 1 | 0 | 3 | -1 | Table | Customisable fields categories |
| question_answers | 0 | 1 | 7 | -1 | Table | Answers, with a fractional grade (0-1) and feedback |
| question_dataset_items | 0 | 0 | 4 | -1 | Table | Individual dataset items |
| message_contact_requests | 0 | 2 | 4 | -1 | Table | Maintains list of contact requests between users |
| enrol_lti_lti2_context | 1 | 1 | 7 | -1 | Table | Information about a specific LTI contexts from the consumers |
| message_processors | 0 | 0 | 3 | -1 | Table | List of message output plugins |
| workshopform_rubric_levels | 0 | 1 | 5 | -1 | Table | The definition of rubric rating scales |
| lock_db | 0 | 0 | 4 | -1 | Table | Stores active and inactive lock types for db locking method. |
| assignfeedback_editpdf_queue | 0 | 0 | 4 | -1 | Table | Queue for processing. |
| questionnaire_response_rank | 0 | 0 | 5 | -1 | Table | questionnaire_response_rank table retrofitted from MySQL |
| context_temp | 0 | 0 | 4 | -1 | Table | Used by build_context_path() in upgrade and cron to keep context depths and paths in sync. |
| course_published | 0 | 1 | 8 | -1 | Table | Information about how and when an local courses were published to hubs |
| grade_outcomes_history | 0 | 4 | 12 | -1 | Table | History table |
| book | 1 | 0 | 11 | -1 | Table | Defines book |
| lti_submission | 0 | 2 | 9 | -1 | Table | Keeps track of individual submissions for LTI activities. |
| portfolio_mahara_queue | 0 | 1 | 3 | -1 | Table | maps mahara tokens to transfer ids |
| oauth2_endpoint | 0 | 1 | 7 | -1 | Table | Describes the named endpoint for an oauth2 service. |
| analytics_models_log | 0 | 1 | 12 | -1 | Table | Analytic models changes during evaluation. |
| competency_userevidencecomp | 0 | 2 | 6 | -1 | Table | Relationship between user evidence and competencies |
| sessions | 0 | 1 | 9 | -1 | Table | Database based session storage - now recommended |
| question_calculated_options | 0 | 1 | 13 | -1 | Table | Options for questions of type calculated |
| block_zoola_reports_schedule | 0 | 3 | 5 | -1 | Table | Reports scheduled from an event |
| repository_instances | 1 | 2 | 10 | -1 | Table | This table contains one entry for every configured external repository instance. |
| forum | 8 | 0 | 29 | -1 | Table | Forums contain and structure discussion |
| feedback_completed | 0 | 3 | 7 | -1 | Table | filled out feedback |
| assign_user_flags | 0 | 2 | 8 | -1 | Table | List of flags that can be set for a single user in a single assignment. |
| grade_settings | 0 | 1 | 4 | -1 | Table | gradebook settings |
| gradingform_guide_comments | 0 | 1 | 5 | -1 | Table | frequently used comments used in marking guide |
| questionnaire_response | 0 | 2 | 6 | -1 | Table | questionnaire_response table retrofitted from MySQL |
| course_format_options | 0 | 1 | 6 | -1 | Table | Stores format-specific options for the course or course section |
| course_sections | 0 | 1 | 10 | -1 | Table | to define the sections for each course |
| logstore_standard_log | 0 | 4 | 21 | -1 | Table | Standard log table |
| enrol_lti_lti2_nonce | 0 | 1 | 4 | -1 | Table | Nonce used for authentication between moodle and a consumer |
| portfolio_tempdata | 1 | 2 | 6 | -1 | Table | stores temporary data for portfolio exports. the id of this table is used for the itemid for the temporary files area. cron can clean up stale records (and associated file data) after expirytime. |
| files_reference | 1 | 1 | 5 | -1 | Table | Store files references |
| mnet_log | 0 | 1 | 13 | -1 | Table | Store session data from users migrating to other sites |
| course_completion_defaults | 0 | 2 | 8 | -1 | Table | Default settings for activities completion |
| log | 0 | 1 | 10 | -1 | Table | Every action is logged as far as possible |
| block_recentlyaccesseditems | 0 | 3 | 5 | -1 | Table | Most recently accessed items accessed by a user |
| qtype_multichoice_options | 0 | 1 | 14 | -1 | Table | Options for multiple choice questions |
| workshopform_numerrors_map | 0 | 1 | 4 | -1 | Table | This maps the number of errors to a percentual grade for submission |
| task_log | 0 | 1 | 11 | -1 | Table | The log table for all tasks |
| blog_external | 0 | 1 | 9 | -1 | Table | External blog links used for RSS copying of blog entries to Moodle user blogs |
| tool_usertours_steps | 0 | 1 | 8 | -1 | Table | Steps in an tour |
| block_zoola_notifications | 0 | 1 | 2 | -1 | Table | Zoola notifications |
| quiz_feedback | 0 | 1 | 6 | -1 | Table | Feedback given to students based on which grade band their overall score lies. |
| lesson_overrides | 0 | 3 | 11 | -1 | Table | The overrides to lesson settings. |
| tool_monitor_rules | 1 | 2 | 14 | -1 | Table | Table to store rules |
| task_scheduled | 0 | 0 | 14 | -1 | Table | List of scheduled tasks to be run by cron. |
| events_queue_handlers | 0 | 2 | 6 | -1 | Table | This is the list of queued handlers for processing. The event object is retrieved from the events_queue table. When no further reference is made to the event_queues table, the corresponding entry in the events_queue table should be deleted. Entry should get deleted after a successful event processing by the specified handler. |
| analytics_predict_samples | 0 | 1 | 8 | -1 | Table | Samples already used for predictions. |
| question_numerical_units | 0 | 1 | 4 | -1 | Table | Optional unit options for numerical questions. This table is also used by the calculated question type. |
| quiz_slots | 1 | 3 | 9 | -1 | Table | Stores the question used in a quiz, with the order, and for each question, which page it appears on, and the maximum mark (weight). |
| cohort_members | 0 | 2 | 4 | -1 | Table | Link a user to a cohort. |
| chat | 3 | 0 | 10 | -1 | Table | Each of these is a chat room |
| question_attempts | 3 | 2 | 14 | -1 | Table | Each row here corresponds to an attempt at one question, as part of a question_usage. A question_attempt will have some question_attempt_steps |
| comments | 0 | 2 | 9 | -1 | Table | moodle comments module |
| assign | 10 | 0 | 30 | -1 | Table | This table saves information about an instance of mod_assign in a course. |
| portfolio_log | 0 | 2 | 11 | -1 | Table | log of portfolio transfers (used to later check for duplicates) |
| course_modules_completion | 0 | 2 | 7 | -1 | Table | Stores the completion state (completed or not completed, etc) of each user on each activity. |
| favourite | 0 | 2 | 9 | -1 | Table | Stores the relationship between an arbitrary item (itemtype, itemid), and a context area (component, contextid) for a specific user. Used by the favourites subsystem. |
| local_activityvisibility_que | 0 | 2 | 4 | -1 | Table | The update queue |
| qtype_ddimageortext | 0 | 1 | 10 | -1 | Table | Defines drag and drop (text or images onto a background image) questions |
| questionnaire_response_bool | 0 | 0 | 4 | -1 | Table | questionnaire_response_bool table retrofitted from MySQL |
| gradingform_rubric_fillings | 0 | 2 | 6 | -1 | Table | Stores the data of how the rubric is filled by a particular rater |
| glossary_categories | 1 | 1 | 4 | -1 | Table | all categories for glossary entries |
| competency_plan | 0 | 2 | 13 | -1 | Table | Learning plans |
| chat_users | 0 | 2 | 12 | -1 | Table | Keeps track of which users are in which chat rooms |
| grading_definitions | 4 | 3 | 14 | -1 | Table | Contains the basic information about an advanced grading form defined in the given gradable area |
| competency_usercompplan | 0 | 2 | 10 | -1 | Table | User competencies plans |
| gradingform_guide_fillings | 0 | 2 | 6 | -1 | Table | Stores the data of how the guide is filled by a particular rater |
| mnet_host2service | 0 | 0 | 5 | -1 | Table | Information about the services for a given host |
| qtype_match_options | 0 | 1 | 10 | -1 | Table | Defines the question-type specific options for matching questions |
| badge_manual_award | 0 | 4 | 6 | -1 | Table | Track manual award criteria for badges |
| question_multianswer | 0 | 1 | 3 | -1 | Table | Options for multianswer questions |
| tag | 3 | 2 | 10 | -1 | Table | Tag table - this generic table will replace the old "tags" table. |
| analytics_used_files | 0 | 2 | 5 | -1 | Table | Files that have already been used for training and prediction. |
| forum_discussion_subs | 0 | 3 | 5 | -1 | Table | Users may choose to subscribe and unsubscribe from specific discussions. |
| mnet_host | 1 | 1 | 15 | -1 | Table | Information about the local and remote hosts for RPC |
| tool_recyclebin_category | 0 | 1 | 5 | -1 | Table | A list of items in the category recycle bin |
| forum_track_prefs | 0 | 2 | 3 | -1 | Table | Tracks each users untracked forums |
| message_airnotifier_devices | 0 | 1 | 3 | -1 | Table | Store information about the devices registered in Airnotifier for PUSH notifications |
| workshop_aggregations | 0 | 2 | 5 | -1 | Table | Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions |
| wiki_versions | 0 | 2 | 7 | -1 | Table | Stores wiki page history |
| questionnaire_feedback | 0 | 1 | 7 | -1 | Table | questionnaire_feedback table retrofitted from MySQL |
| question_calculated | 0 | 1 | 7 | -1 | Table | Options for questions of type calculated |
| role_allow_assign | 0 | 2 | 3 | -1 | Table | this defines what role can assign what role |
| filter_active | 0 | 1 | 5 | -1 | Table | Stores information about which filters are active in which contexts. Also the filter sort order. See get_active_filters in lib/filterlib.php for how this data is used. |
| messageinbound_messagelist | 0 | 1 | 5 | -1 | Table | A list of message IDs for existing replies |
| enrol | 3 | 2 | 35 | -1 | Table | Instances of enrolment plugins used in courses, fields marked as custom have a plugin defined meaning, core does not touch them. Create a new linked table if you need even more custom fields. |
| badge_criteria_param | 0 | 1 | 4 | -1 | Table | Defines parameters for badges criteria |
| wiki | 1 | 0 | 13 | -1 | Table | Stores Wiki activity configuration |
| competency_templatecohort | 0 | 2 | 6 | -1 | Table | Default comment for the table, please edit me |
| folder | 0 | 0 | 10 | -1 | Table | each record is one folder resource |
| competency_evidence | 0 | 2 | 14 | -1 | Table | The evidence linked to a user competency |
| competency_plancomp | 0 | 1 | 7 | -1 | Table | Plan competencies |
| external_functions | 0 | 0 | 8 | -1 | Table | list of all external functions |
| external_services_users | 0 | 2 | 6 | -1 | Table | users allowed to use services with restricted users flag |
| filter_config | 0 | 1 | 5 | -1 | Table | Stores per-context configuration settings for filters which have them. |
| message_users_blocked | 0 | 2 | 4 | -1 | Table | Maintains lists of blocked users |
| block | 1 | 0 | 5 | -1 | Table | contains all installed blocks |
| competency_relatedcomp | 0 | 1 | 6 | -1 | Table | Related competencies |
| glossary_entries | 2 | 2 | 16 | -1 | Table | all glossary entries |
| data | 2 | 0 | 37 | -1 | Table | all database activities |
| block_rss_client | 0 | 1 | 9 | -1 | Table | Remote news feed information. Contains the news feed id, the userid of the user who added the feed, the title of the feed itself and a description of the feed contents along with the url used to access the remote feed. Preferredtitle is a field for future use - intended to allow for custom titles rather than those found in the feed |
| question_truefalse | 0 | 1 | 4 | -1 | Table | Options for True-False questions |
| lti | 3 | 1 | 26 | -1 | Table | This table contains Basic LTI activities instances |
| quizaccess_seb_template | 0 | 1 | 9 | -1 | Table | Templates for Safe Exam Browser configuration. |
| mnet_remote_rpc | 0 | 0 | 6 | -1 | Table | This table describes functions that might be called remotely (we have less information about them than local functions) |
| course_completion_aggr_methd | 0 | 1 | 5 | -1 | Table | Course completion aggregation methods for criteria |
| assignfeedback_editpdf_quick | 0 | 1 | 5 | -1 | Table | Stores teacher specified quicklist comments |
| blog_association | 0 | 2 | 3 | -1 | Table | Associations of blog entries with courses and module instances |
| local_activityvisibility | 0 | 3 | 7 | -1 | Table | Default comment for local_activityvisibility, please edit me |
| tool_customlang | 0 | 1 | 11 | -1 | Table | Contains the working checkout of all strings and their customization |
| enrol_lti_lti2_tool_proxy | 0 | 1 | 6 | -1 | Table | A tool proxy between moodle and a consumer |
| choice | 2 | 0 | 18 | -1 | Table | Available choices are stored here |
| external_tokens | 0 | 4 | 13 | -1 | Table | Security tokens for accessing of external services |
| oauth2_access_token | 0 | 0 | 8 | -1 | Table | Stores access tokens for system accounts in order to be able to use a single token across multiple sessions |
| events_handlers | 1 | 0 | 8 | -1 | Table | This table is for storing which components requests what type of event, and the location of the responsible handlers. For example, the assignment registers 'grade_updated' event with a function assignment_grade_handler() that should be called event time an 'grade_updated' event is triggered by grade_update() function. |
| messageinbound_datakeys | 0 | 1 | 6 | -1 | Table | Inbound Message data item secret keys. |
| question_attempt_step_data | 0 | 1 | 4 | -1 | Table | Each question_attempt_step has an associative array of the data that was submitted by the user in the POST request. It can also contain extra data from the question type or behaviour to avoid re-computation. The convention is that names belonging to the behaviour start with -, and cached values added to the submitted data start with _, or _- |
| message_email_messages | 0 | 3 | 4 | -1 | Table | Keeps track of what emails to send in an email digest |
| search_index_requests | 0 | 1 | 7 | -1 | Table | Records requests for (re)indexing of specific contexts. Entries will be removed from this table when indexing of that context is complete. (This table is not used for normal time-based indexing of new content.) |
| block_recent_activity | 0 | 2 | 7 | -1 | Table | Recent activity block |
| h5p_libraries | 5 | 0 | 16 | -1 | Table | Stores information about libraries used by H5P content. |
| lti_access_tokens | 0 | 1 | 7 | -1 | Table | Security tokens for accessing of LTI services |
| data_fields | 1 | 1 | 16 | -1 | Table | every field available |
| badge_backpack | 2 | 2 | 7 | -1 | Table | Defines settings for connecting external backpack |
| scorm_aicc_session | 0 | 2 | 12 | -1 | Table | Used by AICC HACP to store session information |
| tool_dataprivacy_purposerole | 0 | 2 | 10 | -1 | Table | Data purpose overrides for a specific role |
| grading_instances | 2 | 2 | 9 | -1 | Table | Grading form instance is an assessment record for one gradable item assessed by one rater |
| course_request | 0 | 0 | 9 | -1 | Table | course requests |
| question_numerical_options | 0 | 1 | 6 | -1 | Table | Options for questions of type numerical This table is also used by the calculated question type |
| role_allow_override | 0 | 2 | 3 | -1 | Table | this defines what role can override what role |
| user | 185 | 0 | 54 | -1 | Table | One record for each person |
| grade_import_newitem | 1 | 1 | 4 | -1 | Table | temporary table for storing new grade_item names from grade import |
| tool_dataprivacy_ctxlevel | 0 | 2 | 7 | -1 | Table | Default comment for the table, please edit me |
| workshopform_rubric_config | 0 | 1 | 3 | -1 | Table | Configuration table for the Rubric grading strategy |
| tool_customlang_components | 1 | 0 | 3 | -1 | Table | Contains the list of all installed plugins that provide their own language pack |
| message_user_actions | 0 | 2 | 5 | -1 | Table | Stores all per-user actions on individual messages |
| workshopallocation_scheduled | 0 | 1 | 9 | -1 | Table | Stores the allocation settings for the scheduled allocator |
| quiz_overrides | 0 | 3 | 9 | -1 | Table | The overrides to quiz settings on a per-user and per-group basis. |