# Tables

#### SchemaSpy Analysis of mdl52er_erd

Generated on Mon May 18 21:40 BST 2026

Moodle 5.2 database schema with additional foreign key relationships see http://www.examulator.com/er

XML Representation
Insertion Order Deletion Order
TABLES 494
VIEWS 0
COLUMNS 4469
Constraints 679
Anomalies 56
Routines 0

### Database Properties

Database Type: MySQL - 5.5.5-10.11.10-MariaDB-ubu2204

### Schema mdl52er_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 | 1 | 5 | 0 | Table | Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting.
groups | 5 | 1 | 12 | 0 | Table | Each record represents a group.
tool_policy_acceptances | 0 | 3 | 9 | 0 | Table | Tracks users accepting the policy versions
lesson_answers | 1 | 2 | 13 | 0 | Table | Defines lesson_answers
scorm_scoes_data | 0 | 1 | 4 | 0 | Table | Contains variable data get from packages
data_records | 1 | 2 | 7 | 0 | Table | every record introduced
h5p_library_dependencies | 0 | 2 | 4 | 0 | Table | Stores H5P library dependencies
upgrade_log | 0 | 1 | 10 | 0 | Table | Upgrade logging
stats_daily | 0 | 2 | 7 | 0 | Table | to accumulate daily stats
reportbuilder_schedule | 0 | 4 | 17 | 0 | Table | Table to represent a report schedule
communication_customlink | 0 | 1 | 3 | 0 | Table | Stores the link associated with a custom link communication instance.
stats_monthly | 0 | 2 | 7 | 0 | Table | To accumulate monthly stats
badge_issued | 1 | 2 | 8 | 0 | Table | Defines issued badges
tool_dataprivacy_contextlist | 2 | 0 | 4 | 0 | Table | List of contexts for a component
reportbuilder_filter | 0 | 3 | 10 | 0 | Table | Table to represent a report filter/condition
scorm_attempt | 1 | 2 | 4 | 0 | Table | List of SCORM attempts made by user.
search_simpledb_index | 0 | 2 | 14 | 0 | Table | search_simpledb table containing the index data.
file_conversion | 0 | 3 | 11 | 0 | Table | Table to track file conversions.
competency_coursecomp | 0 | 3 | 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 | 1 | 3 | 14 | 0 | Table | Each row represents a resource link for a platform and deployment
lesson_attempts | 0 | 3 | 9 | 0 | Table | Defines lesson_attempts
adminpresets_plug | 0 | 0 | 5 | 0 | Table | Admin presets plugins status, to store information about whether they are enabled or not
portfolio_instance | 4 | 0 | 4 | 0 | Table | base table (not including config data) for instances of portfolio plugins.
badge | 7 | 3 | 23 | 0 | Table | Defines badge
question_bank_entries | 2 | 2 | 5 | 0 | Table | Each question bank entry. This table has one row for each question that appears in the question bank.
user_preferences | 0 | 2 | 4 | 0 | Table | Allows modules to store arbitrary user preferences
grade_outcomes | 4 | 3 | 10 | 0 | 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)
quiz_statistics | 0 | 0 | 19 | 0 | Table | table to cache results from analysis done in statistics report for quizzes.
stats_user_daily | 0 | 2 | 8 | 0 | Table | To accumulate daily stats per course/user
role | 23 | 0 | 6 | 0 | Table | moodle roles
message | 1 | 0 | 17 | 0 | Table | Stores all unread messages
qtype_essay_options | 0 | 1 | 15 | 0 | Table | Extra options for essay questions.
message_contacts | 0 | 3 | 4 | 0 | Table | Maintains lists of contacts between users
oauth2_issuer | 8 | 0 | 23 | 0 | Table | Details for an oauth 2 connect identity issuer.
message_conversation_actions | 0 | 2 | 5 | 0 | Table | Stores all per-user actions on individual conversations
qtype_randomsamatch_options | 0 | 1 | 11 | 0 | Table | Info about a random short-answer matching question
qtype_ddmarker_drags | 0 | 1 | 6 | 0 | Table | Labels for markers to drag.
tool_dataprivacy_ctxinstance | 0 | 3 | 7 | 0 | Table | Default comment for the table, please edit me
grade_categories_history | 0 | 4 | 18 | 0 | Table | History of grade_categories
course_modules_viewed | 0 | 1 | 4 | 0 | Table | Tracks the completion viewed (viewed with cmid/userid and otherwise no row) of each user on each activity.
analytics_models | 6 | 1 | 13 | 0 | Table | Analytic models.
imscp | 0 | 1 | 9 | 0 | Table | each record is one imscp resource
role_allow_view | 0 | 2 | 3 | 0 | 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 | 0 | Table | Tracks subscriptions to remote calendars.
enrol_lti_lti2_share_key | 0 | 1 | 5 | 0 | Table | Resource link share key
course_completion_crit_compl | 0 | 1 | 7 | 0 | Table | Course completion user records
mnet_rpc | 0 | 0 | 11 | 0 | Table | Functions or methods that we may publish or subscribe to
assign_allocated_marker | 0 | 3 | 4 | 0 | Table | One or more teachers allocated to mark individual submissions
enrol_lti_app_registration | 1 | 0 | 13 | 0 | Table | Details of each application that has been registered with the tool
tag_correlation | 0 | 1 | 3 | 0 | 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
lti_types_categories | 0 | 2 | 3 | 0 | Table | Link LTI types to course categories
scorm_seq_ruleconds | 1 | 1 | 5 | 0 | Table | SCORM2004 rule conditions
post | 1 | 3 | 19 | 0 | Table | Generic post table to hold data blog entries etc in different modules
tool_dataprivacy_purpose | 3 | 0 | 11 | 0 | Table | Data purposes
question_gapselect | 0 | 1 | 10 | 0 | Table | Defines select missing words questions
assignfeedback_file | 0 | 2 | 4 | 0 | Table | Stores info about the number of files submitted by a student.
quiz_overview_regrades | 0 | 1 | 7 | 0 | Table | This table records which question attempts need regrading and the grade they will be regraded to.
user_password_resets | 0 | 1 | 5 | 0 | Table | table tracking password reset confirmation tokens
qtype_shortanswer_options | 0 | 1 | 3 | 0 | Table | Options for short answer questions
feedback_valuetmp | 0 | 1 | 6 | 0 | Table | values of the completedstmp
modules | 1 | 0 | 6 | 0 | Table | modules available in the site
feedback_sitecourse_map | 0 | 2 | 3 | 0 | Table | feedback sitecourse map
scorm_seq_mapinfo | 0 | 2 | 8 | 0 | Table | SCORM2004 objective mapinfo description
quiz_grade_items | 1 | 1 | 4 | 0 | Table | Where a quiz supports mulitple grades, this table stores what those grade items are.
choice_options | 1 | 1 | 5 | 0 | Table | available options to choice
lesson | 7 | 0 | 42 | 0 | Table | Defines lesson for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Lesson_Activity
lti_types | 4 | 0 | 18 | 0 | Table | Basic LTI pre-configured activities
license | 0 | 0 | 8 | 0 | Table | store licenses used by moodle
lesson_branch | 0 | 2 | 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 | 3 | 9 | 0 | Table | Defines report audience
ai_action_register | 0 | 2 | 12 | 0 | Table | Stores information about processed ai actions.
cache_flags | 0 | 0 | 6 | 0 | Table | Cache of time-sensitive flags
analytics_indicator_calc | 0 | 1 | 9 | 0 | Table | Stored indicator calculations
message_popup_notifications | 0 | 1 | 2 | 0 | Table | List of notifications to display in the message output popup
scorm_seq_rolluprule | 1 | 1 | 7 | 0 | Table | SCORM2004 sequencing rule
customfield_data | 0 | 2 | 16 | 0 | Table | core_customfield data table
wiki_locks | 0 | 1 | 5 | 0 | Table | Manages page locks
oauth2_user_field_mapping | 0 | 2 | 7 | 0 | Table | Mapping of oauth user fields to moodle fields.
role_capabilities | 0 | 4 | 7 | 0 | Table | permission has to be signed, overriding a capability for a particular role in a particular context
auth_oauth2_linked_login | 0 | 3 | 10 | 0 | Table | Accounts linked to a users Moodle account.
badge_criteria_met | 0 | 3 | 5 | 0 | Table | Defines criteria that were met for an issued badge
feedback | 4 | 0 | 17 | 0 | Table | all feedbacks
workshop_grades | 0 | 1 | 7 | 0 | Table | How the reviewers filled-up the grading forms, given grades and comments
reportbuilder_column | 0 | 3 | 13 | 0 | Table | Table to represent a report column
qtype_ddmarker | 0 | 1 | 11 | 0 | Table | Defines drag and drop (text or images onto a background image) questions
mnet_remote_service2rpc | 0 | 0 | 3 | 0 | Table | Group functions or methods under a service
feedback_item | 2 | 2 | 13 | 0 | Table | feedback_items
infected_files | 0 | 1 | 6 | 0 | Table | Table to store infected file details.
competency_template | 3 | 2 | 10 | 0 | Table | Learning plan templates.
workshop_assessments | 1 | 3 | 15 | 0 | 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 | 0 | Table | Repository for grade letters, for courses and other moodle entities that use grades.
paygw_paypal | 0 | 1 | 3 | 0 | Table | Stores PayPal related information
enrol_flatfile | 0 | 3 | 8 | 0 | Table | enrol_flatfile table retrofitted from MySQL
analytics_train_samples | 0 | 1 | 6 | 0 | Table | Samples used for training
assign_submission | 2 | 1 | 10 | 0 | 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.
adminpresets_it_a | 0 | 0 | 4 | 0 | Table | Admin presets items attributes. For settings with attributes (extra values like ‘advanced’)
tool_dataprivacy_category | 2 | 0 | 7 | 0 | Table | Data categories
mnet_application | 1 | 0 | 6 | 0 | Table | Information about applications on remote hosts
lti_coursevisible | 0 | 1 | 4 | 0 | Table | Table to store coursevisible setting for site tool on course level
forum_queue | 0 | 2 | 5 | 0 | Table | For keeping track of posts that will be mailed in digest form
tag_area | 0 | 1 | 9 | 0 | Table | Defines various tag areas, one area is identified by component and itemtype
backup_controllers | 1 | 1 | 17 | 0 | Table | To store the backup_controllers as they are used
analytics_predictions | 1 | 2 | 11 | 0 | Table | Predictions
scorm_element | 1 | 0 | 2 | 0 | Table | List of scorm elements.
ltiservice_gradebookservices | 0 | 3 | 11 | 0 | Table | This file records the grade items created by the LTI Gradebook Services service
tool_dataprivacy_ctxlst_ctx | 0 | 2 | 6 | 0 | Table | A contextlist context item
repository_onedrive_access | 0 | 1 | 6 | 0 | Table | List of temporary access grants.
tool_brickfield_checks | 1 | 0 | 6 | 0 | Table | Checks details
h5p | 1 | 1 | 9 | 0 | Table | Stores H5P content information
lti_tool_settings | 0 | 4 | 8 | 0 | Table | LTI tool setting values
ai_action_explain_text | 0 | 0 | 8 | 0 | Table | Stores specific data about explain text actions.
assign_grades | 6 | 1 | 9 | 0 | Table | Grading information about a single assignment submission.
course_categories | 7 | 2 | 14 | 0 | Table | Course categories
quiz_reports | 0 | 0 | 4 | 0 | 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.
bbbext_complex | 0 | 0 | 1 | 0 | Table | Default comment for bbbext_complex, please edit me
portfolio_instance_config | 0 | 1 | 4 | 0 | Table | config for portfolio plugin instances
resource_old | 0 | 1 | 16 | 0 | Table | backup of all old resource instances from 1.9
user_lastaccess | 0 | 3 | 4 | 0 | Table | To keep track of course page access times, used in online participants block, and participants list
forum_grades | 0 | 1 | 7 | 0 | Table | Grading data for forum instances
scorm_scoes_value | 0 | 3 | 6 | 0 | Table | Values passed from SCORM package
badge_backpack_oauth2 | 0 | 4 | 11 | 0 | Table | Default comment for the table, please edit me
workshopeval_best_settings | 0 | 1 | 3 | 0 | Table | Settings for the grading evaluation subplugin Comparison with the best assessment.
survey | 0 | 0 | 0 | 0 | Table | Defines badge for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Badges
quiz_attempts | 0 | 3 | 16 | 0 | Table | Stores users attempts at quizzes.
backup_courses | 0 | 1 | 6 | 0 | Table | To store every course backup status
tool_usertours_tours | 1 | 0 | 9 | 0 | Table | List of tours
oauth2_system_account | 0 | 2 | 9 | 0 | Table | Stored details used to get an access token as a system user for this oauth2 service.
question_hints | 0 | 1 | 7 | 0 | Table | Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours.
cohort | 3 | 1 | 11 | 0 | Table | Each record represents one cohort (aka site-wide group).
payment_accounts | 2 | 1 | 8 | 0 | Table | Payment accounts
workshop | 11 | 1 | 37 | 0 | Table | This table keeps information about the module instances and their settings
question_statistics | 0 | 2 | 18 | 0 | Table | Statistics for individual questions used in an activity.
ai_action_summarise_text | 0 | 0 | 8 | 0 | Table | Stores specific data about summarise text actions.
h5pactivity_attempts | 1 | 1 | 12 | 0 | Table | Users attempts inside H5P activities
groupings_groups | 0 | 2 | 4 | 0 | 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 | 0 | Table | hub where the site is registered on with their associated token
glossary | 2 | 0 | 28 | 0 | Table | all glossaries
url | 0 | 1 | 10 | 0 | Table | each record is one url resource
mnet_session | 0 | 3 | 9 | 0 | Table | Store session data from users migrating to other sites
competency_templatecomp | 0 | 4 | 7 | 0 | Table | Link a competency to a learning plan template.
glossary_entries_categories | 0 | 2 | 3 | 0 | Table | categories of each glossary entry
badge_external_identifier | 0 | 1 | 5 | 0 | Table | Setting for external badges mappings
enrol_paypal | 0 | 4 | 21 | 0 | Table | Holds all known information about PayPal transactions
role_allow_switch | 0 | 2 | 3 | 0 | 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 | 0 | Table | Defines alignment for badges
qtype_ddimageortext_drops | 0 | 1 | 7 | 0 | Table | Drop boxes
notifications | 1 | 1 | 15 | 0 | Table | Stores all notifications
question_categories | 3 | 2 | 9 | 0 | Table | Categories are for grouping questions
tool_dataprivacy_rqst_ctxlst | 0 | 2 | 3 | 0 | Table | Association table joining requests and contextlists
assignsubmission_file | 0 | 2 | 4 | 0 | Table | Info about file submissions for assignments
task_adhoc | 0 | 1 | 13 | 0 | Table | List of adhoc tasks waiting to run.
message_conversation_members | 0 | 2 | 4 | 0 | Table | Stores all members in a conversations
grade_items | 5 | 4 | 31 | 0 | 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.
contentbank_content | 0 | 3 | 11 | 0 | Table | This table stores content data in the content bank.
glossary_formats | 0 | 0 | 10 | 0 | Table | Setting of the display formats
book_chapters | 0 | 1 | 11 | 0 | Table | Defines book_chapters
adminpresets_app_it | 0 | 1 | 3 | 0 | Table | Admin presets applied items. To maintain the relation with config_log
block_instances | 1 | 2 | 12 | 0 | 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.
badge_external | 0 | 1 | 5 | 0 | Table | Setting for external badges display
question_response_count | 0 | 1 | 4 | 0 | Table | Count for each responses for each try at a question.
grade_grades_history | 0 | 6 | 24 | 0 | Table | History table
question_response_analysis | 1 | 1 | 10 | 0 | Table | Analysis of student responses given to questions.
mnet_service2rpc | 0 | 1 | 3 | 0 | Table | Group functions or methods under a service
tool_brickfield_cache_acts | 0 | 1 | 8 | 0 | Table | Contains accessibility summary information per activity.
lti_tool_proxies | 1 | 0 | 13 | 0 | Table | LTI tool proxy registrations
scorm_seq_rolluprulecond | 0 | 2 | 5 | 0 | Table | SCORM2004 sequencing rule
grade_import_values | 0 | 4 | 9 | 0 | Table | Temporary table for importing grades
grade_outcomes_courses | 0 | 2 | 3 | 0 | Table | stores what outcomes are used in what courses.
assign_mark | 0 | 3 | 8 | 0 | Table | Marks from multiple markers for a single submission
workshop_submissions | 1 | 3 | 19 | 0 | 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 | 0 | Table | Results for each user for each resource link
event | 0 | 3 | 24 | 0 | Table | For everything with a time associated to it
badge_endorsement | 0 | 1 | 8 | 0 | Table | Defines endorsement for badge
tool_dataprivacy_ctxexpired | 0 | 1 | 9 | 0 | Table | Default comment for the table, please edit me
config | 2 | 0 | 3 | 0 | Table | Moodle configuration variables
workshopform_comments | 0 | 1 | 5 | 0 | Table | The assessment dimensions definitions of Comments strategy forms
mnet_sso_access_control | 0 | 1 | 4 | 0 | Table | Users by host permitted (or not) to login from a remote provider
question_dataset_definitions | 1 | 1 | 6 | 0 | Table | Organises and stores properties for dataset items
scale | 10 | 2 | 8 | 0 | Table | Defines grading scales
analytics_prediction_actions | 0 | 2 | 5 | 0 | Table | Register of user actions over predictions.
gradepenalty_duedate_rule | 0 | 2 | 8 | 0 | Table | Penalty rules
tool_policy | 1 | 1 | 3 | 0 | Table | Contains the list of policy documents defined on the site.
files | 3 | 3 | 20 | 0 | Table | description of files, content is stored in sha1 file pool meaning no duplicate storage https://docs.moodle.org/en/ad-hoc_contributed_reports#List_course_resources_accumulative_file_size_and_count
feedback_template | 1 | 0 | 4 | 0 | Table | templates of feedbackstructures
competency_usercompcourse | 0 | 3 | 9 | 0 | Table | User competencies in a course
tool_brickfield_cache_check | 0 | 1 | 6 | 0 | Table | Contains accessibility summary information per check.
enrol_lti_deployment | 3 | 1 | 7 | 0 | Table | Each row represents a deployment of a tool within a platform.
wiki_subwikis | 3 | 1 | 4 | 0 | Table | Stores subwiki instances
question_datasets | 0 | 2 | 3 | 0 | Table | Many-many relation between questions and dataset definitions
assign_overrides | 0 | 3 | 11 | 0 | Table | The overrides to assign settings.
h5pactivity_attempts_results | 0 | 1 | 14 | 0 | Table | H5Pactivities_attempts tracking info
user_private_key | 0 | 1 | 8 | 0 | Table | access keys used in cookieless scripts - rss, etc.
h5pactivity | 1 | 1 | 12 | 0 | Table | Stores the h5pactivity activity module instances.
feedback_completedtmp | 0 | 2 | 8 | 0 | Table | filled out feedback
customfield_shared | 0 | 2 | 8 | 0 | Table | core_customfield shared category table
wiki_links | 0 | 2 | 5 | 0 | Table | Page wiki links
quizaccess_seb_quizsettings | 0 | 4 | 31 | 0 | Table | Stores the quiz level Safe Exam Browser configuration.
gradingform_guide_criteria | 1 | 1 | 9 | 0 | Table | Stores the rows of the criteria grid.
message_read | 0 | 1 | 17 | 0 | Table | Stores all messages that have been read
events_queue | 1 | 1 | 5 | 0 | 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.
reportbuilder_user_filter | 0 | 3 | 7 | 0 | Table | Defines user report filter
badge_criteria | 2 | 1 | 6 | 0 | Table | Defines criteria for issuing badges
quiz_sections | 0 | 1 | 5 | 0 | 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 | 0 | Table | Keeps track of user mail delivery preferences for each forum
enrol_lti_context | 1 | 1 | 6 | 0 | Table | Each row represents a context in the platform, where resource links are added within a deployment.
forum_subscriptions | 0 | 1 | 3 | 0 | Table | Keeps track of who is subscribed to what forum
assign_user_mapping | 0 | 2 | 3 | 0 | Table | Map an assignment specific id number to a user
wiki_pages | 4 | 1 | 10 | 0 | Table | Stores wiki pages
competency_coursecompsetting | 0 | 2 | 6 | 0 | Table | This table contains the course specific settings for competencies.
qtype_ordering_options | 0 | 1 | 15 | 0 | Table | Options for ordering questions
payment_gateways | 0 | 1 | 7 | 0 | Table | Configuration for one gateway for one payment account
tool_brickfield_errors | 0 | 1 | 5 | 0 | Table | Errors during the accessibility checks
message_popup | 0 | 1 | 3 | 0 | Table | Keep state of notifications for the popup message processor
repository_instance_config | 0 | 1 | 4 | 0 | Table | The config for intances
lti_types_config | 0 | 1 | 4 | 0 | Table | Basic LTI types configuration
data_content | 0 | 2 | 8 | 0 | Table | the content introduced in each record/fields
assignfeedback_editpdf_cmnt | 0 | 1 | 9 | 0 | Table | Stores comments added to pdfs
context | 52 | 0 | 6 | 0 | Table | one of these must be set
groupings | 2 | 1 | 9 | 0 | Table | A grouping is a collection of groups. WAS: groups_groupings
role_names | 0 | 2 | 4 | 0 | Table | role names in native strings
log_display | 0 | 0 | 6 | 0 | Table | For a particular module/action, specifies a moodle table/field
question_references | 0 | 2 | 7 | 0 | Table | Records where a specific question is used.
tool_mfa_auth | 0 | 1 | 3 | 0 | Table | Stores the last time a successful MFA auth was registered for a userid
competency_userevidence | 0 | 2 | 9 | 0 | Table | The evidence of prior learning
course_completions | 0 | 1 | 7 | 0 | Table | Course completion records
sms_messages | 0 | 1 | 10 | 0 | Table | SMS Messages sent via the SMS subsystem
assignsubmission_onlinetext | 0 | 2 | 5 | 0 | Table | Info about onlinetext submission
tool_monitor_subscriptions | 1 | 2 | 8 | 0 | Table | Table to store user subscriptions to various rules
payments | 1 | 2 | 11 | 0 | Table | Stores information about payments
enrol_lti_users | 1 | 3 | 13 | 0 | Table | User access log and gradeback data
customfield_category | 2 | 1 | 12 | 0 | Table | core_customfield category table
user_password_history | 0 | 1 | 4 | 0 | Table | A rotating log of hashes of previously used passwords for each user.
gradingform_rubric_criteria | 2 | 1 | 5 | 0 | Table | Stores the rows of the rubric grid.
feedback_value | 0 | 1 | 6 | 0 | Table | values of the completeds
config_log | 0 | 1 | 7 | 0 | Table | Changes done in server configuration through admin UI
profiling | 0 | 0 | 11 | 0 | Table | Stores the results of all the profiling runs
competency_framework | 1 | 3 | 13 | 0 | Table | List of competency frameworks.
scorm_seq_objective | 1 | 1 | 6 | 0 | Table | SCORM2004 objective description
rating | 0 | 3 | 10 | 0 | Table | moodle ratings
my_pages | 0 | 1 | 5 | 0 | Table | Extra user pages for the My Moodle system
competency_modulecomp | 0 | 4 | 9 | 0 | Table | Link a competency to a module.
grade_items_history | 0 | 6 | 34 | 0 | Table | History of grade_items
enrol_lti_tool_consumer_map | 0 | 2 | 3 | 0 | Table | Table that maps the published tool to tool consumers.
course_completion_criteria | 0 | 1 | 10 | 0 | Table | Course completion criteria
ai_action_generate_text | 0 | 0 | 8 | 0 | Table | Stores specific data about generate text actions.
h5p_libraries_cachedassets | 0 | 1 | 3 | 0 | Table | H5P cached library assets
assignfeedback_editpdf_rot | 0 | 1 | 6 | 0 | Table | Stores rotation information of a page.
course_modules | 6 | 2 | 26 | 0 | Table | course_modules table retrofitted from MySQL
forum_posts | 3 | 2 | 18 | 0 | Table | All posts are stored in this table
tool_recyclebin_course | 0 | 1 | 6 | 0 | Table | A list of items in the course recycle bin
tool_brickfield_schedule | 0 | 1 | 7 | 0 | Table | Keeps the per course content analysis schedule.
grade_grades | 1 | 4 | 24 | 0 | 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.
glossary_alias | 0 | 1 | 3 | 0 | Table | entries alias
stats_user_weekly | 0 | 2 | 8 | 0 | Table | To accumulate weekly stats per course/user
scorm_scoes | 8 | 1 | 10 | 0 | Table | each SCO part of the SCORM module
enrol_lti_tools | 2 | 2 | 23 | 0 | Table | List of tools provided to the remote system
workshopform_accumulative | 0 | 1 | 7 | 0 | Table | The assessment dimensions definitions of Accumulative grading strategy forms
gradingform_rubric_levels | 0 | 1 | 5 | 0 | Table | Stores the columns of the rubric grid.
tool_monitor_history | 0 | 1 | 4 | 0 | Table | Table to store history of message notifications sent
tag_coll | 2 | 0 | 7 | 0 | Table | Defines different set of tags
competency_usercomp | 1 | 2 | 10 | 0 | Table | User competencies
tool_brickfield_content | 1 | 1 | 7 | 0 | Table | Content of an area at a particular time (recognised by a hash)
external_services_functions | 0 | 1 | 3 | 0 | Table | lists functions available in each service group
message_conversations | 4 | 1 | 11 | 0 | Table | Stores all message conversations
messages | 2 | 2 | 11 | 0 | Table | Stores all messages
h5p_contents_libraries | 0 | 2 | 6 | 0 | Table | Store which library is used in which content.
competency | 13 | 3 | 17 | 0 | Table | This table contains the master record of each competency in a framework
resource | 1 | 1 | 13 | 0 | Table | Each record is one resource and its config data
tag_instance | 0 | 2 | 10 | 0 | Table | tag_instance table holds the information of associations between tags and other items
user_devices | 1 | 1 | 12 | 0 | Table | This table stores user’s mobile devices information in order to send PUSH notifications
question_ddwtos | 0 | 1 | 10 | 0 | Table | Defines drag and drop (words into sentences) questions
grade_categories | 5 | 2 | 14 | 0 | Table | This table keeps information about categories, used for grouping items.
question_set_references | 0 | 2 | 7 | 0 | Table | Records where groups of questions are used.
assign_plugin_config | 0 | 1 | 6 | 0 | Table | Config data for an instance of a plugin in an assignment.
quiz | 8 | 0 | 43 | 0 | Table | The settings for each quiz. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Quiz_Activity
tool_cohortroles | 0 | 2 | 7 | 0 | Table | Mapping of users to cohort role assignments.
subsection | 0 | 1 | 4 | 0 | Table | Stores the delegated subsection instances.
question_attempt_steps | 1 | 2 | 7 | 0 | 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.
auth_lti_linked_login | 0 | 1 | 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 repository instance.
lesson_pages | 3 | 1 | 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 systems)
bigbluebuttonbn | 3 | 0 | 46 | 0 | Table | The bigbluebuttonbn table to store information about a meeting activities.
assignfeedback_editpdf_annot | 0 | 1 | 11 | 0 | Table | stores annotations added to pdfs submitted by students
badge_related | 0 | 2 | 3 | 0 | Table | Defines badge related for badges
tool_dataprivacy_request | 1 | 4 | 15 | 0 | Table | Table for data requests
workshopform_numerrors | 0 | 1 | 9 | 0 | Table | The assessment dimensions definitions of Number of errors grading strategy forms
block_positions | 0 | 2 | 8 | 0 | Table | Stores the position of a sticky block_instance on a another page than the one where it was added.
stored_progress | 0 | 0 | 7 | 0 | Table | Records for any long running tasks we want to poll for progress
tool_brickfield_areas | 1 | 4 | 13 | 0 | Table | Areas that have been checked for accessibility problems
tool_policy_versions | 2 | 2 | 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 | 1 | 5 | 0 | Table | The subquestions that make up a matching question
customfield_field | 1 | 1 | 11 | 0 | Table | core_customfield field table
question_numerical | 0 | 1 | 4 | 0 | Table | Options for numerical questions.
messageinbound_handlers | 1 | 0 | 6 | 0 | Table | Inbound Message Handler definitions.
user_info_data | 0 | 2 | 5 | 0 | Table | Data for the customisable user fields
qbank | 0 | 1 | 8 | 0 | Table | Stores the qbank activity module instances.
label | 0 | 1 | 6 | 0 | Table | Defines labels
mnet_service | 1 | 0 | 5 | 0 | Table | A service is a group of functions
analytics_used_analysables | 0 | 1 | 6 | 0 | Table | List of analysables used by each model
forum_read | 0 | 3 | 7 | 0 | Table | Tracks each users read posts
forum_discussions | 4 | 2 | 14 | 0 | Table | Forums are composed of discussions
user_info_field | 0 | 1 | 20 | 0 | Table | Customisable user profile fields
page | 0 | 1 | 13 | 0 | Table | Each record is one page and its config data
workshopform_rubric | 1 | 2 | 5 | 0 | Table | The assessment dimensions definitions of Rubric grading strategy forms
enrol_lti_lti2_consumer | 5 | 0 | 19 | 0 | Table | LTI consumers interacting with moodle
scorm_seq_rulecond | 0 | 2 | 7 | 0 | Table | SCORM2004 rule condition
wiki_synonyms | 0 | 2 | 4 | 0 | Table | Stores wiki pages synonyms
question_usages | 2 | 1 | 4 | 0 | 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 | 0 | Table | A table that keeps a log of events related to subscriptions
tool_mfa | 0 | 0 | 11 | 0 | Table | Table to store factor configurations for users
external_services | 3 | 0 | 11 | 0 | Table | built in and custom external services
scale_history | 0 | 4 | 11 | 0 | Table | History table
role_context_levels | 0 | 1 | 3 | 0 | Table | Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table.
grading_areas | 1 | 1 | 5 | 0 | Table | Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set.
user_enrolments | 0 | 3 | 9 | 0 | Table | Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students
stats_user_monthly | 0 | 2 | 8 | 0 | Table | To accumulate monthly stats per course/user
lesson_timer | 0 | 1 | 7 | 0 | Table | lesson timer for each lesson
qtype_ddimageortext_drags | 0 | 1 | 6 | 0 | Table | Images to drag. Actual file names are not stored here we use the file names as found in the file storage area.
role_assignments | 0 | 3 | 9 | 0 | Table | assigning roles in different context
portfolio_instance_user | 0 | 2 | 5 | 0 | Table | user data for portfolio instances.
choice_answers | 0 | 2 | 5 | 0 | Table | choices performed by users
capabilities | 1 | 0 | 6 | 0 | Table | this defines all capabilities
assignfeedback_comments | 0 | 2 | 5 | 0 | Table | Text feedback for submitted assignments
badge_external_backpack | 2 | 1 | 6 | 0 | Table | Defines settings for site level backpacks that a user can connect to.
groups_members | 0 | 2 | 6 | 0 | Table | Link a user to a group.
enrol_lti_lti2_resource_link | 3 | 3 | 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 | 3 | 0 | 41 | 0 | Table | each table is one SCORM module and its configuration
course | 76 | 2 | 38 | 0 | Table | Central course table. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#COURSE_REPORTS
question | 31 | 3 | 16 | 0 | Table | This table stores the definition of one version of a question.
communication_user | 0 | 2 | 5 | 0 | Table | Communication user records mapping
stats_weekly | 0 | 2 | 7 | 0 | Table | To accumulate weekly stats
qtype_ddmarker_drops | 0 | 1 | 6 | 0 | Table | drop regions
lesson_grades | 0 | 1 | 6 | 0 | Table | Defines lesson_grades
tool_mfa_secrets | 0 | 1 | 8 | 0 | Table | Table to store factor secrets
log_queries | 0 | 0 | 9 | 0 | Table | Logged database queries.
backup_logs | 0 | 1 | 5 | 0 | Table | To store all the logs from backup and restore operations (by db logger)
user_info_category | 1 | 0 | 3 | 0 | Table | Customisable fields categories
question_answers | 0 | 1 | 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 | 2 | 4 | 0 | Table | Maintains list of contact requests between users
bigbluebuttonbn_recordings | 0 | 3 | 12 | 0 | Table | The bigbluebuttonbn table to store references to recordings
enrol_lti_lti2_context | 1 | 1 | 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 | 1 | 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 | 0 | 0 | 0 | Table |
course_published | 0 | 2 | 8 | 0 | Table | Information about how and when an local courses were published to hubs
context_temp | 0 | 0 | 4 | 0 | Table | Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.
grade_outcomes_history | 0 | 4 | 12 | 0 | Table | History table
lti_submission | 0 | 1 | 9 | 0 | Table | Keeps track of individual submissions for LTI activities.
book | 1 | 1 | 11 | 0 | Table | Defines book
oauth2_endpoint | 0 | 2 | 7 | 0 | Table | Describes the named endpoint for an oauth2 service.
competency_userevidencecomp | 0 | 2 | 6 | 0 | Table | Relationship between user evidence and competencies
analytics_models_log | 0 | 2 | 12 | 0 | Table | Analytic models changes during evaluation.
sessions | 0 | 1 | 9 | 0 | Table | Database based session storage - now recommended
question_calculated_options | 0 | 1 | 13 | 0 | Table | Options for questions of type calculated
repository_instances | 2 | 2 | 10 | 0 | Table | This table contains one entry for every configured external repository instance.
forum | 8 | 0 | 30 | 0 | Table | Forum discussion system. For sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Forum_Activity
feedback_completed | 0 | 2 | 7 | 0 | Table | filled out feedback
assign_user_flags | 0 | 2 | 7 | 0 | Table | List of flags that can be set for a single user in a single assignment.
grade_settings | 0 | 1 | 4 | 0 | Table | gradebook settings
gradingform_guide_comments | 0 | 1 | 5 | 0 | Table | frequently used comments used in marking guide
course_format_options | 0 | 1 | 6 | 0 | Table | Stores format-specific options for the course or course section
course_sections | 0 | 1 | 12 | 0 | Table | to define the sections for each course
logstore_standard_log | 0 | 6 | 21 | 0 | Table | Standard log table
shortlink | 0 | 1 | 6 | 0 | Table | Short codes for user short links
enrol_lti_lti2_nonce | 0 | 1 | 4 | 0 | Table | Nonce used for authentication between moodle and a consumer
portfolio_tempdata | 1 | 2 | 6 | 0 | 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 | 0 | Table | Store files references
tool_brickfield_results | 1 | 2 | 4 | 0 | Table | Results of the accessibility checks
adminpresets_app | 0 | 0 | 4 | 0 | Table | Applied presets
mnet_log | 0 | 1 | 13 | 0 | Table | Store session data from users migrating to other sites
course_completion_defaults | 0 | 2 | 9 | 0 | Table | Default settings for activities completion
log | 0 | 1 | 10 | 0 | Table | Every action is logged as far as possible
block_recentlyaccesseditems | 0 | 3 | 5 | 0 | Table | Most recently accessed items accessed by a user
qtype_multichoice_options | 0 | 1 | 14 | 0 | Table | Options for multiple choice questions
workshopform_numerrors_map | 0 | 1 | 4 | 0 | Table | This maps the number of errors to a percentual grade for submission
ai_providers | 0 | 0 | 6 | 0 | Table | AI provider instances
task_log | 0 | 1 | 13 | 0 | Table | The log table for all tasks
blog_external | 0 | 1 | 9 | 0 | Table | External blog links used for RSS copying of blog entries to Moodle user blogs
tool_usertours_steps | 0 | 1 | 9 | 0 | Table | Steps in an tour
quiz_feedback | 0 | 1 | 6 | 0 | Table | Feedback given to students based on which grade band their overall score lies.
tool_monitor_rules | 1 | 1 | 14 | 0 | Table | Table to store rules
lesson_overrides | 0 | 3 | 13 | 0 | Table | The overrides to lesson settings.
task_scheduled | 0 | 0 | 16 | 0 | Table | List of scheduled tasks to be run by cron.
oauth2_refresh_token | 0 | 2 | 7 | 0 | Table | Stores refresh tokens which can be exchanged for access tokens
events_queue_handlers | 0 | 2 | 6 | 0 | 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.
sms_gateways | 1 | 0 | 5 | 0 | Table | Instances of SMS gateways
analytics_predict_samples | 0 | 1 | 8 | 0 | Table | Samples already used for predictions.
question_numerical_units | 0 | 1 | 4 | 0 | Table | Optional unit options for numerical questions. This table is also used by the calculated question type.
quiz_slots | 0 | 2 | 8 | 0 | 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 | 0 | Table | Link a user to a cohort.
question_attempts | 2 | 2 | 14 | 0 | 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 For documentation https://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine
comments | 0 | 2 | 9 | 0 | Table | moodle comments module
assign | 12 | 0 | 39 | 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 | 3 | 11 | 0 | Table | log of portfolio transfers (used to later check for duplicates)
course_modules_completion | 0 | 1 | 6 | 0 | Table | Stores the completion state (completed or not completed, etc) of each user on each activity.
favourite | 0 | 2 | 9 | 0 | 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.
qtype_ddimageortext | 0 | 1 | 11 | 0 | Table | Defines drag and drop (text or images onto a background image) questions
gradingform_rubric_fillings | 0 | 2 | 6 | 0 | Table | Stores the data of how the rubric is filled by a particular rater
question_versions | 0 | 2 | 5 | 0 | Table | A join table linking the different question version definitions in the question table to the question_bank_entires.
glossary_categories | 1 | 1 | 4 | 0 | Table | all categories for glossary entries
competency_plan | 0 | 2 | 13 | 0 | Table | Learning plans
grading_definitions | 4 | 3 | 14 | 0 | Table | Contains the basic information about an advanced grading form defined in the given gradable area
tool_brickfield_summary | 0 | 1 | 27 | 0 | Table | Contains accessibility check results summary information.
competency_usercompplan | 0 | 2 | 10 | 0 | Table | User competencies plans
gradingform_guide_fillings | 0 | 2 | 6 | 0 | Table | Stores the data of how the guide is filled by a particular rater
mnet_host2service | 0 | 0 | 5 | 0 | Table | Information about the services for a given host
qtype_match_options | 0 | 1 | 10 | 0 | Table | Defines the question-type specific options for matching questions
badge_manual_award | 0 | 4 | 6 | 0 | Table | Track manual award criteria for badges
adminpresets_app_plug | 0 | 0 | 6 | 0 | Table | Admin presets plugins applied
question_multianswer | 0 | 1 | 3 | 0 | Table | Options for multianswer questions
tag | 2 | 2 | 10 | 0 | Table | Tag table - this generic table will replace the old “tags” table.
tool_brickfield_process | 0 | 2 | 7 | 0 | Table | Queued records to initiate new processing of specific targets
analytics_used_files | 0 | 2 | 5 | 0 | Table | Files that have already been used for training and prediction.
forum_discussion_subs | 0 | 3 | 5 | 0 | Table | Users may choose to subscribe and unsubscribe from specific discussions.
mnet_host | 2 | 1 | 15 | 0 | Table | Information about the local and remote hosts for RPC
tool_recyclebin_category | 0 | 1 | 5 | 0 | Table | A list of items in the category recycle bin
message_airnotifier_devices | 0 | 1 | 3 | 0 | Table | Store information about the devices registered in Airnotifier for PUSH notifications
forum_track_prefs | 0 | 2 | 3 | 0 | Table | Tracks each users untracked forums
workshop_aggregations | 0 | 2 | 5 | 0 | Table | Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions
ai_policy_register | 0 | 2 | 4 | 0 | Table | Register of users who have accepted this sites AI usage policy
wiki_versions | 0 | 1 | 7 | 0 | Table | Stores wiki page history
role_allow_assign | 0 | 2 | 3 | 0 | Table | this defines what role can assign what role
question_calculated | 0 | 1 | 7 | 0 | Table | Options for questions of type calculated
messageinbound_messagelist | 0 | 1 | 5 | 0 | Table | A list of message IDs for existing replies
filter_active | 0 | 1 | 5 | 0 | 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.
xapi_states | 0 | 0 | 9 | 0 | Table | The stored xAPI states
enrol | 3 | 2 | 35 | 0 | 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.
ai_action_generate_image | 0 | 0 | 8 | 0 | Table | Stores specific data about generate image actions
badge_criteria_param | 0 | 1 | 4 | 0 | Table | Defines parameters for badges criteria
wiki | 1 | 0 | 13 | 0 | Table | Stores Wiki activity configuration
competency_templatecohort | 0 | 3 | 6 | 0 | Table | Default comment for the table, please edit me
folder | 0 | 1 | 11 | 0 | Table | each record is one folder resource
competency_evidence | 0 | 4 | 14 | 0 | Table | The evidence linked to a user competency
competency_plancomp | 0 | 2 | 7 | 0 | Table | Plan competencies
external_functions | 0 | 0 | 8 | 0 | Table | list of all external functions
external_services_users | 0 | 2 | 6 | 0 | Table | users allowed to use services with restricted users flag
adminpresets | 0 | 0 | 11 | 0 | Table | named sets of site wide configurations e.g. enable/disable features https://www.youtube.com/watch?v=CyNOhbJ76fY
filter_config | 0 | 1 | 5 | 0 | Table | Stores per-context configuration settings for filters which have them.
message_users_blocked | 0 | 2 | 4 | 0 | Table | Maintains lists of blocked users
competency_relatedcomp | 0 | 4 | 6 | 0 | Table | Related competencies
block | 1 | 0 | 5 | 0 | Table | contains all installed blocks
matrix_room | 0 | 1 | 4 | 0 | Table | Stores the matrix room information associated with the communication instance.
reportbuilder_report | 5 | 3 | 15 | 0 | Table | Table to represent a report
glossary_entries | 2 | 1 | 16 | 0 | Table | all glossary entries
data | 2 | 0 | 37 | 0 | Table | all database activities
enrol_lti_user_resource_link | 0 | 2 | 3 | 0 | Table | Join table mapping users to resource links as this is a many:many relationship
block_rss_client | 0 | 1 | 9 | 0 | 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 | 5 | 0 | Table | Options for True-False questions
tiny_autosave | 0 | 1 | 9 | 0 | Table | The content of the textarea saved during autosave operations
communication | 3 | 1 | 10 | 0 | Table | Communication records
lti | 4 | 1 | 26 | 0 | Table | This table contains Basic LTI activities instances
quizaccess_seb_template | 1 | 1 | 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 (we have less information about them than local functions)
course_completion_aggr_methd | 0 | 1 | 5 | 0 | Table | Course completion aggregation methods for criteria
blog_association | 0 | 2 | 3 | 0 | Table | Associations of blog entries with courses and module instances
assignfeedback_editpdf_quick | 0 | 1 | 5 | 0 | Table | Stores teacher specified quicklist comments
bbbext_simple | 0 | 1 | 5 | 0 | Table | Default comment for bbbext_simple, please edit me
tool_customlang | 0 | 1 | 11 | 0 | Table | Contains the working checkout of all strings and their customization
enrol_lti_lti2_tool_proxy | 0 | 1 | 6 | 0 | Table | A tool proxy between moodle and a consumer
external_tokens | 0 | 4 | 14 | 0 | Table | Security tokens for accessing of external services
choice | 2 | 0 | 19 | 0 | Table | Available choices are stored here
oauth2_access_token | 0 | 2 | 8 | 0 | 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 | 0 | 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 | 0 | Table | Inbound Message data item secret keys.
question_attempt_step_data | 0 | 1 | 4 | 0 | 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 | 0 | Table | Keeps track of what emails to send in an email digest
search_index_requests | 0 | 1 | 7 | 0 | 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 | 0 | Table | Recent activity block
h5p_libraries | 5 | 0 | 20 | 0 | Table | Stores information about libraries used by H5P content.
lti_access_tokens | 0 | 1 | 7 | 0 | Table | Security tokens for accessing of LTI services
data_fields | 1 | 1 | 16 | 0 | Table | every field available
badge_backpack | 2 | 2 | 7 | 0 | Table | Defines settings for connecting external backpack
tool_dataprivacy_purposerole | 0 | 3 | 10 | 0 | Table | Data purpose overrides for a specific role
scorm_aicc_session | 0 | 2 | 12 | 0 | Table | Used by AICC HACP to store session information
grading_instances | 2 | 2 | 9 | 0 | Table | Grading form instance is an assessment record for one gradable item assessed by one rater
course_request | 0 | 0 | 9 | 0 | Table | course requests
question_numerical_options | 0 | 1 | 6 | 0 | Table | Options for questions of type numerical This table is also used by the calculated question type
role_allow_override | 0 | 2 | 3 | 0 | Table | this defines what role can override what role
user | 187 | 0 | 48 | 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 | 1 | 1 | 4 | 0 | Table | temporary table for storing new grade_item names from grade import
tool_dataprivacy_ctxlevel | 0 | 2 | 7 | 0 | Table | Default comment for the table, please edit me
workshopform_rubric_config | 0 | 1 | 3 | 0 | Table | Configuration table for the Rubric grading strategy
tool_customlang_components | 1 | 0 | 3 | 0 | Table | Contains the list of all installed plugins that provide their own language pack
message_user_actions | 0 | 2 | 5 | 0 | Table | Stores all per-user actions on individual messages
workshopallocation_scheduled | 0 | 1 | 9 | 0 | Table | Stores the allocation settings for the scheduled allocator
quiz_overrides | 0 | 3 | 11 | 0 | Table | The overrides to quiz settings on a per-user and per-group basis.