Tables


SchemaSpy Analysis of moodle3.10

Generated on Sat Apr 03 13:28 BST 2021

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

XML Representation
Insertion Order Deletion Order
TABLES 419
VIEWS 0
COLUMNS 3843
Constraints 529
Anomalies 57
Routines 0

Database Properties

Database Type: MySQL - 8.0.20-0ubuntu0.20.04.1

Schema moodle3.10

The Moodle Database is Complex

Tables

Table / View Children Parents Columns Rows Type Comments
quiz_grades 0 2 5 0 Table

Stores the overall grade for each user on the quiz, based on
groups 10 2 11 0 Table

Each record represents a group.
tool_policy_acceptances 0 6 9 0 Table

Tracks users accepting the policy versions
lesson_answers 2 4 13 0 Table

Defines lesson_answers
scorm_scoes_data 0 2 4 0 Table

Contains variable data get from packages
data_records 2 2 7 0 Table

every record introduced
h5p_library_dependencies 0 4 4 0 Table

Stores H5P library dependencies
upgrade_log 0 2 10 0 Table

Upgrade logging
stats_daily 0 3 7 0 Table

to accumulate daily stats
stats_monthly 0 3 7 0 Table

To accumulate monthly stats
badge_issued 2 4 8 0 Table

Defines issued badges
assignment_submissions 0 1 14 0 Table

Info about submitted assignments
search_simpledb_index 0 2 14 0 Table

search_simpledb table containing the index data.
file_conversion 0 4 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
lesson_attempts 0 6 9 0 Table

Defines lesson_attempts
survey_questions 2 0 7 0 Table

the questions conforming one survey
portfolio_instance 8 0 4 0 Table

base table (not including config data) for instances of port
badge 14 6 26 0 Table

Defines badge
user_preferences 0 4 4 0 Table

Allows modules to store arbitrary user preferences
grade_outcomes 8 6 10 0 Table

This table describes the outcomes used in the system. An out
stats_user_daily 0 3 8 0 Table

To accumulate daily stats per course/user
role 39 0 6 0 Table

moodle roles
message 2 0 17 0 Table

Stores all unread messages
qtype_essay_options 0 2 13 0 Table

Extra options for essay questions.
message_contacts 0 6 4 0 Table

Maintains lists of contacts between users
oauth2_issuer 15 0 20 0 Table

Details for an oauth 2 connect identity issuer.
message_conversation_actions 0 4 5 0 Table

Stores all per-user actions on individual conversations
qtype_randomsamatch_options 0 2 11 0 Table

Info about a random short-answer matching question
editor_atto_autosave 0 1 9 0 Table

Draft text that is auto-saved every 5 seconds while an edito
qtype_ddmarker_drags 0 2 6 0 Table

Labels for markers to drag.
assignment_upgrade 0 0 6 0 Table

Info about upgraded assignments
tool_dataprivacy_ctxinstance 0 6 7 0 Table

Default comment for the table, please edit me
grade_categories_history 0 8 18 0 Table

History of grade_categories
analytics_models 12 0 13 0 Table

Analytic models.
imscp 0 2 9 0 Table

each record is one imscp resource
role_allow_view 0 4 3 0 Table

This table stores which which other roles a user is allowed
event_subscriptions 2 1 10 0 Table

Tracks subscriptions to remote calendars.
enrol_lti_lti2_share_key 0 2 5 0 Table

Resource link share key
course_completion_crit_compl 0 2 7 0 Table

Course completion user records
mnet_rpc 0 0 11 0 Table

Functions or methods that we may publish or subscribe to
tag_correlation 0 2 3 0 Table

The rationale for the ‘tag_correlation’ table is performance
scorm_seq_ruleconds 2 2 5 0 Table

SCORM2004 rule conditions
post 2 4 19 0 Table

Generic post table to hold data blog entries etc in differen
tool_dataprivacy_purpose 6 0 11 0 Table

Data purposes
assignfeedback_file 0 4 4 0 Table

Stores info about the number of files submitted by a student
question_gapselect 0 2 10 0 Table

Defines select missing words questions
qtype_shortanswer_options 0 2 3 0 Table

Options for short answer questions
user_password_resets 0 2 5 0 Table

table tracking password reset confirmation tokens
feedback_valuetmp 0 1 6 0 Table

values of the completedstmp
modules 2 0 6 0 Table

modules available in the site
feedback_sitecourse_map 0 3 3 0 Table

feedback sitecourse map
scorm_seq_mapinfo 0 4 8 0 Table

SCORM2004 objective mapinfo description
choice_options 2 2 5 0 Table

available options to choice
lesson 14 0 42 0 Table

Defines lesson
lti_types 6 0 18 0 Table

Basic LTI pre-configured activities
license 0 0 8 0 Table

store licenses used by moodle
lesson_branch 0 4 8 0 Table

branches for each lesson/user
cache_flags 0 0 6 0 Table

Cache of time-sensitive flags
analytics_indicator_calc 0 2 9 0 Table

Stored indicator calculations
message_popup_notifications 0 2 2 0 Table

List of notifications to display in the message output popup
customfield_data 0 4 12 0 Table

core_customfield data table
scorm_seq_rolluprule 2 2 7 0 Table

SCORM2004 sequencing rule
wiki_locks 0 2 5 0 Table

Manages page locks
oauth2_user_field_mapping 0 2 7 0 Table

Mapping of oauth user fields to moodle fields.
auth_oauth2_linked_login 0 6 10 0 Table

Accounts linked to a users Moodle account.
role_capabilities 0 8 7 0 Table

permission has to be signed, overriding a capability for a p
survey_analysis 0 2 4 0 Table

text about each survey submission
badge_criteria_met 0 6 5 0 Table

Defines criteria that were met for an issued badge
feedback 7 0 17 0 Table

all feedbacks
workshop_grades 0 2 7 0 Table

How the reviewers filled-up the grading forms, given grades
qtype_ddmarker 0 2 11 0 Table

Defines drag and drop (text or images onto a background imag
mnet_remote_service2rpc 0 0 3 0 Table

Group functions or methods under a service
feedback_item 3 4 13 0 Table

feedback_items
infected_files 0 1 6 0 Table

Table to store infected file details.
competency_template 6 1 10 0 Table

Learning plan templates.
workshop_assessments 2 6 15 0 Table

Info about the made assessment and automatically calculated
grade_letters 0 2 4 0 Table

Repository for grade letters, for courses and other moodle e
paygw_paypal 0 1 3 0 Table

Stores PayPal related information
assignment 1 0 19 0 Table

Defines assignments
enrol_flatfile 0 6 8 0 Table

enrol_flatfile table retrofitted from MySQL
analytics_train_samples 0 2 6 0 Table

Samples used for training
assign_submission 5 2 9 0 Table

This table keeps information about student interactions with
mnet_application 2 0 6 0 Table

Information about applications on remote hosts
tool_dataprivacy_category 4 0 7 0 Table

Data categories
survey_answers 0 4 7 0 Table

the answers to each questions filled by the users
forum_queue 0 4 5 0 Table

For keeping track of posts that will be mailed in digest for
tag_area 0 2 9 0 Table

Defines various tag areas, one area is identified by compone
backup_controllers 2 2 17 0 Table

To store the backup_controllers as they are used
analytics_predictions 2 4 11 0 Table

Predictions
repository_onedrive_access 0 2 6 0 Table

List of temporary access grants.
h5p 2 2 9 0 Table

Stores H5P content information
lti_tool_settings 0 8 8 0 Table

LTI tool setting values
assign_grades 10 2 8 0 Table

Grading information about a single assignment submission.
course_categories 10 4 14 0 Table

Course categories
quiz_reports 0 0 4 0 Table

Lists all the installed quiz reports and their display order
portfolio_instance_config 0 2 4 0 Table

config for portfolio plugin instances
resource_old 0 1 16 0 Table

backup of all old resource instances from 1.9
scorm_scoes_track 0 4 8 0 Table

to track SCOes
forum_grades 0 2 7 0 Table

Grading data for forum instances
user_lastaccess 0 5 4 0 Table

To keep track of course page access times, used in online pa
badge_backpack_oauth2 0 8 11 0 Table

Default comment for the table, please edit me
survey 4 0 11 0 Table

Each record is one SURVEY module with its configuration
quiz_attempts 0 6 15 0 Table

Stores users attempts at quizzes.
backup_courses 0 2 6 0 Table

To store every course backup status
tool_usertours_tours 2 0 7 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
question_hints 0 2 7 0 Table

Stores the the part of the question definition that gives di
cohort 5 2 11 0 Table

Each record represents one cohort (aka site-wide group).
payment_accounts 2 1 8 0 Table

Payment accounts
workshop 4 2 37 0 Table

This table keeps information about the module instances and
question_statistics 0 2 18 0 Table

Statistics for individual questions used in an activity.
h5pactivity_attempts 2 2 12 0 Table

Users attempts inside H5P activities
groupings_groups 0 4 4 0 Table

Link a grouping to a group (note, groups can be in multiple
registration_hubs 0 0 7 0 Table

hub where the site is registered on with their associated to
glossary 4 1 28 0 Table

all glossaries
url 0 2 10 0 Table

each record is one url resource
mnet_session 0 2 9 0 Table

Store session data from users migrating to other sites
competency_templatecomp 0 6 7 0 Table

Link a competency to a learning plan template.
badge_external_identifier 0 2 5 0 Table

Setting for external badges mappings
glossary_entries_categories 0 4 3 0 Table

categories of each glossary entry
enrol_paypal 0 8 21 0 Table

Holds all known information about PayPal transactions
role_allow_switch 0 4 3 0 Table

This table stores which which other roles a user is allowed
badge_alignment 0 2 7 0 Table

Defines alignment for badges
qtype_ddimageortext_drops 0 2 7 0 Table

Drop boxes
notifications 2 2 15 0 Table

Stores all notifications
question_categories 8 3 9 0 Table

Categories are for grouping questions
assignsubmission_file 0 3 4 0 Table

Info about file submissions for assignments
message_conversation_members 0 4 4 0 Table

Stores all members in a conversations
task_adhoc 0 2 12 0 Table

List of adhoc tasks waiting to run.
contentbank_content 0 6 10 0 Table

This table stores content data in the content bank.
glossary_formats 1 0 10 0 Table

Setting of the display formats
grade_items 8 8 31 0 Table

This table keeps information about gradeable items (ie colum
book_chapters 0 2 11 0 Table

Defines book_chapters
badge_external 0 2 5 0 Table

Setting for external badges display
block_instances 2 4 12 0 Table

This table stores block instances. The type of block this is
question_response_count 0 2 4 0 Table

Count for each responses for each try at a question.
grade_grades_history 0 12 24 0 Table

History table
question_response_analysis 2 1 10 0 Table

Analysis of student responses given to questions.
mnet_service2rpc 0 2 3 0 Table

Group functions or methods under a service
lti_tool_proxies 2 0 13 0 Table

LTI tool proxy registrations
scorm_seq_rolluprulecond 0 3 5 0 Table

SCORM2004 sequencing rule
grade_import_values 0 6 9 0 Table

Temporary table for importing grades
grade_outcomes_courses 0 4 3 0 Table

stores what outcomes are used in what courses.
workshop_submissions 2 6 19 0 Table

Info about the submission and the aggregation of the grade f
enrol_lti_lti2_user_result 0 2 6 0 Table

Results for each user for each resource link
event 0 5 24 0 Table

For everything with a time associated to it
badge_endorsement 0 2 8 0 Table

Defines endorsement for badge
tool_dataprivacy_ctxexpired 0 2 9 0 Table

Default comment for the table, please edit me
config 0 0 3 0 Table

Moodle configuration variables
mnet_sso_access_control 0 1 4 0 Table

Users by host permitted (or not) to login from a remote prov
question_dataset_definitions 2 2 6 0 Table

Organises and stores properties for dataset items
scale 17 1 8 0 Table

Defines grading scales
analytics_prediction_actions 0 4 5 0 Table

Register of user actions over predictions.
tool_policy 2 2 3 0 Table

Contains the list of policy documents defined on the site.
files 6 6 20 0 Table

description of files, content is stored in sha1 file pool
competency_usercompcourse 0 3 9 0 Table

User competencies in a course
feedback_template 2 0 4 0 Table

templates of feedbackstructures
wiki_subwikis 6 2 4 0 Table

Stores subwiki instances
mnetservice_enrol_courses 0 1 14 0 Table

Caches the information fetched via XML-RPC about courses on
question_datasets 0 4 3 0 Table

Many-many relation between questions and dataset definitions
assign_overrides 0 6 8 0 Table

The overrides to assign settings.
h5pactivity_attempts_results 0 2 14 0 Table

H5Pactivities_attempts tracking info
user_private_key 0 2 8 0 Table

access keys used in cookieless scripts - rss, etc.
feedback_completedtmp 0 2 8 0 Table

filled out feedback
h5pactivity 2 2 12 0 Table

Stores the h5pactivity activity module instances.
wiki_links 0 4 5 0 Table

Page wiki links
gradingform_guide_criteria 2 2 9 0 Table

Stores the rows of the criteria grid.
message_read 0 2 17 0 Table

Stores all messages that have been read
events_queue 2 2 5 0 Table

This table is for storing queued events. It stores only one
badge_criteria 4 2 6 0 Table

Defines criteria for issuing badges
quiz_sections 0 2 5 0 Table

Stores sections of a quiz with section name (heading), from
forum_digests 0 4 4 0 Table

Keeps track of user mail delivery preferences for each forum
forum_subscriptions 0 2 3 0 Table

Keeps track of who is subscribed to what forum
assign_user_mapping 0 4 3 0 Table

Map an assignment specific id number to a user
wiki_pages 8 2 10 0 Table

Stores wiki pages
competency_coursecompsetting 0 2 6 0 Table

This table contains the course specific settings for compete
payment_gateways 0 1 7 0 Table

Configuration for one gateway for one payment account
message_popup 0 2 3 0 Table

Keep state of notifications for the popup message processor
repository_instance_config 0 3 4 0 Table

The config for intances
lti_types_config 0 2 4 0 Table

Basic LTI types configuration
data_content 0 4 8 0 Table

the content introduced in each record/fields
assignfeedback_editpdf_cmnt 0 2 9 0 Table

Stores comments added to pdfs
context 65 0 6 0 Table

one of these must be set
groupings 4 1 9 0 Table

A grouping is a collection of groups. WAS: groups_groupings
log_display 0 0 6 0 Table

For a particular module/action, specifies a moodle table/fie
role_names 0 4 4 0 Table

role names in native strings
competency_userevidence 0 2 9 0 Table

The evidence of prior learning
course_completions 0 2 7 0 Table

Course completion records
assignsubmission_onlinetext 0 4 5 0 Table

Info about onlinetext submission
tool_monitor_subscriptions 2 3 8 0 Table

Table to store user subscriptions to various rules
payments 1 2 11 0 Table

Stores information about payments
enrol_lti_users 0 4 12 0 Table

User access log and gradeback data
customfield_category 2 2 11 0 Table

core_customfield category table
gradingform_rubric_criteria 4 2 5 0 Table

Stores the rows of the rubric grid.
user_password_history 0 2 4 0 Table

A rotating log of hashes of previously used passwords for ea
feedback_value 0 2 6 0 Table

values of the completeds
config_log 0 2 7 0 Table

Changes done in server configuration through admin UI
competency_framework 2 2 13 0 Table

List of competency frameworks.
profiling 0 0 11 0 Table

Stores the results of all the profiling runs
scorm_seq_objective 2 2 6 0 Table

SCORM2004 objective description
rating 0 5 10 0 Table

moodle ratings
my_pages 0 2 5 0 Table

Extra user pages for the My Moodle system
competency_modulecomp 0 6 8 0 Table

Link a competency to a module.
grade_items_history 0 12 34 0 Table

History of grade_items
enrol_lti_tool_consumer_map 0 4 3 0 Table

Table that maps the published tool to tool consumers.
course_completion_criteria 0 2 10 0 Table

Course completion criteria
h5p_libraries_cachedassets 0 2 3 0 Table

H5P cached library assets
assignfeedback_editpdf_rot 0 2 6 0 Table

Stores rotation information of a page.
course_modules 6 4 21 0 Table

course_modules table retrofitted from MySQL
forum_posts 6 4 18 0 Table

All posts are stored in this table
tool_recyclebin_course 0 2 6 0 Table

A list of items in the course recycle bin
grade_grades 2 8 23 0 Table

grade_grades This table keeps individual grades for each us
glossary_alias 0 2 3 0 Table

entries alias
scorm_scoes 14 2 10 0 Table

each SCO part of the SCORM module
stats_user_weekly 0 3 8 0 Table

To accumulate weekly stats per course/user
chat_messages_current 0 2 7 0 Table

Stores current session
enrol_lti_tools 4 4 19 0 Table

List of tools provided to the remote system
gradingform_rubric_levels 0 2 5 0 Table

Stores the columns of the rubric grid.
tool_monitor_history 0 2 4 0 Table

Table to store history of message notifications sent
competency_usercomp 2 2 10 0 Table

User competencies
tag_coll 4 0 7 0 Table

Defines different set of tags
mnetservice_enrol_enrolments 0 4 7 0 Table

Caches the information about enrolments of our local users i
external_services_functions 0 2 3 0 Table

lists functions available in each service group
message_conversations 8 2 11 0 Table

Stores all message conversations
messages 4 4 11 0 Table

Stores all messages
h5p_contents_libraries 0 4 6 0 Table

Store which library is used in which content.
competency 22 3 17 0 Table

This table contains the master record of each competency in
resource 0 2 13 0 Table

Each record is one resource and its config data
tag_instance 0 4 10 0 Table

tag_instance table holds the information of associations bet
user_devices 2 2 11 0 Table

This table stores user’s mobile devices information in order
question_ddwtos 0 2 10 0 Table

Defines drag and drop (words into sentences) questions
grade_categories 10 4 14 0 Table

This table keeps information about categories, used for grou
assign_plugin_config 0 2 6 0 Table

Config data for an instance of a plugin in an assignment.
quiz 12 0 42 0 Table

The settings for each quiz.
tool_cohortroles 0 3 7 0 Table

Mapping of users to cohort role assignments.
question_attempt_steps 2 4 7 0 Table

Stores one step in in a question attempt. As well as the dat
repository 0 0 4 0 Table

This table contains one entry for every configured external
lesson_pages 6 2 13 0 Table

Defines lesson_pages
message_providers 0 0 4 0 Table

This table stores the message providers (modules and core sy
assignfeedback_editpdf_annot 0 2 11 0 Table

stores annotations added to pdfs submitted by students
badge_related 0 4 3 0 Table

Defines badge related for badges
tool_dataprivacy_request 0 8 15 0 Table

Table for data requests
block_positions 0 4 8 0 Table

Stores the position of a sticky block_instance on a another
tool_policy_versions 4 4 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 2 5 0 Table

The subquestions that make up a matching question
customfield_field 2 2 11 0 Table

core_customfield field table
question_numerical 0 2 4 0 Table

Options for numerical questions.
messageinbound_handlers 2 0 6 0 Table

Inbound Message Handler definitions.
user_info_data 0 4 5 0 Table

Data for the customisable user fields
label 0 2 6 0 Table

Defines labels
mnet_service 2 0 5 0 Table

A service is a group of functions
analytics_used_analysables 0 2 6 0 Table

List of analysables used by each model
quiz_slot_tags 0 4 4 0 Table

Stores data about the tags that a question must have so that
forum_read 0 6 7 0 Table

Tracks each users read posts
forum_discussions 8 2 14 0 Table

Forums are composed of discussions
user_info_field 0 2 20 0 Table

Customisable user profile fields
page 0 2 13 0 Table

Each record is one page and its config data
enrol_lti_lti2_consumer 10 0 19 0 Table

LTI consumers interacting with moodle
scorm_seq_rulecond 0 3 7 0 Table

SCORM2004 rule condition
wiki_synonyms 0 4 4 0 Table

Stores wiki pages synonyms
question_usages 4 2 4 0 Table

This table’s main purpose it to assign a unique id to each a
tool_monitor_events 0 3 8 0 Table

A table that keeps a log of events related to subscriptions
chat_messages 0 2 7 0 Table

Stores all the actual chat messages
external_services 6 0 11 0 Table

built in and custom external services
grading_areas 2 2 5 0 Table

Identifies gradable areas where advanced grading can happen.
role_context_levels 0 2 3 0 Table

Lists which roles can be assigned at which context levels. T
scale_history 0 6 11 0 Table

History table
stats_user_monthly 0 3 8 0 Table

To accumulate monthly stats per course/user
user_enrolments 0 6 9 0 Table

Users participating in courses (aka enrolled users) - everyb
lesson_timer 0 2 7 0 Table

lesson timer for each lesson
qtype_ddimageortext_drags 0 2 6 0 Table

Images to drag. Actual file names are not stored here we use
role_assignments 0 6 9 0 Table

assigning roles in different context
portfolio_instance_user 0 4 5 0 Table

user data for portfolio instances.
assignfeedback_comments 0 4 5 0 Table

Text feedback for submitted assignments
choice_answers 0 4 5 0 Table

choices performed by users
capabilities 2 0 6 0 Table

this defines all capabilities
badge_external_backpack 4 2 6 0 Table

Defines settings for site level backpacks that a user can co
groups_members 0 4 6 0 Table

Link a user to a group.
enrol_lti_lti2_resource_link 6 6 9 0 Table

Link from the consumer to the tool
scorm 6 0 42 0 Table

each table is one SCORM module and its configuration
course 104 2 34 0 Table

Central course table
question 57 8 20 0 Table

The questions themselves
stats_weekly 0 3 7 0 Table

To accumulate weekly stats
qtype_ddmarker_drops 0 2 6 0 Table

drop regions
lesson_grades 0 2 6 0 Table

Defines lesson_grades
log_queries 0 0 9 0 Table

Logged database queries.
backup_logs 0 2 5 0 Table

To store all the logs from backup and restore operations (by
user_info_category 2 0 3 0 Table

Customisable fields categories
question_answers 0 2 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 4 4 0 Table

Maintains list of contact requests between users
enrol_lti_lti2_context 2 2 7 0 Table

Information about a specific LTI contexts from the consumers
message_processors 0 0 3 0 Table

List of message output plugins
lock_db 0 0 4 0 Table

Stores active and inactive lock types for db locking method.
assignfeedback_editpdf_queue 0 1 4 0 Table

Queue for processing.
context_temp 0 0 4 0 Table

Used by build_context_path() in upgrade and cron to keep con
course_published 0 2 8 0 Table

Information about how and when an local courses were publish
grade_outcomes_history 0 8 12 0 Table

History table
book 2 0 11 0 Table

Defines book
lti_submission 0 2 9 0 Table

Keeps track of individual submissions for LTI activities.
portfolio_mahara_queue 0 2 3 0 Table

maps mahara tokens to transfer ids
oauth2_endpoint 0 2 7 0 Table

Describes the named endpoint for an oauth2 service.
analytics_models_log 0 2 12 0 Table

Analytic models changes during evaluation.
competency_userevidencecomp 0 2 6 0 Table

Relationship between user evidence and competencies
sessions 0 2 9 0 Table

Database based session storage - now recommended
question_calculated_options 0 2 13 0 Table

Options for questions of type calculated
repository_instances 5 1 10 0 Table

This table contains one entry for every configured external
forum 15 0 29 0 Table

Forums contain and structure discussion
feedback_completed 0 3 7 0 Table

filled out feedback
assign_user_flags 0 4 8 0 Table

List of flags that can be set for a single user in a single
gradingform_guide_comments 0 2 5 0 Table

frequently used comments used in marking guide
grade_settings 0 2 4 0 Table

gradebook settings
course_format_options 0 2 6 0 Table

Stores format-specific options for the course or course sect
course_sections 0 2 10 0 Table

to define the sections for each course
enrol_lti_lti2_nonce 0 2 4 0 Table

Nonce used for authentication between moodle and a consumer
portfolio_tempdata 2 4 6 0 Table

stores temporary data for portfolio exports. the id of this
files_reference 2 2 5 0 Table

Store files references
mnet_log 0 2 13 0 Table

Store session data from users migrating to other sites
course_completion_defaults 0 4 8 0 Table

Default settings for activities completion
log 0 2 10 0 Table

Every action is logged as far as possible
block_recentlyaccesseditems 0 6 5 0 Table

Most recently accessed items accessed by a user
qtype_multichoice_options 0 2 14 0 Table

Options for multiple choice questions
task_log 0 0 13 0 Table

The log table for all tasks
blog_external 0 2 9 0 Table

External blog links used for RSS copying of blog entries to
tool_usertours_steps 0 2 8 0 Table

Steps in an tour
quiz_feedback 0 2 6 0 Table

Feedback given to students based on which grade band their o
lesson_overrides 0 6 11 0 Table

The overrides to lesson settings.
tool_monitor_rules 2 1 14 0 Table

Table to store rules
task_scheduled 0 0 17 0 Table

List of scheduled tasks to be run by cron.
oauth2_refresh_token 0 2 7 0 Table

Stores refresh tokens which can be exchanged for access toke
events_queue_handlers 0 4 6 0 Table

This is the list of queued handlers for processing. The even
analytics_predict_samples 0 2 8 0 Table

Samples already used for predictions.
question_numerical_units 0 2 4 0 Table

Optional unit options for numerical questions. This table is
quiz_slots 2 6 9 0 Table

Stores the question used in a quiz, with the order, and for
cohort_members 0 4 4 0 Table

Link a user to a cohort.
chat 6 0 10 0 Table

Each of these is a chat room
question_attempts 2 4 14 0 Table

Each row here corresponds to an attempt at one question, as
comments 0 3 9 0 Table

moodle comments module
assign 19 0 30 0 Table

This table saves information about an instance of mod_assign
portfolio_log 0 4 11 0 Table

log of portfolio transfers (used to later check for duplicat
course_modules_completion 0 2 7 0 Table

Stores the completion state (completed or not completed, etc
favourite 0 4 9 0 Table

Stores the relationship between an arbitrary item (itemtype,
qtype_ddimageortext 0 2 10 0 Table

Defines drag and drop (text or images onto a background imag
gradingform_rubric_fillings 0 4 6 0 Table

Stores the data of how the rubric is filled by a particular
glossary_categories 2 2 4 0 Table

all categories for glossary entries
competency_plan 0 2 13 0 Table

Learning plans
chat_users 0 2 12 0 Table

Keeps track of which users are in which chat rooms
grading_definitions 8 6 14 0 Table

Contains the basic information about an advanced grading for
competency_usercompplan 0 2 10 0 Table

User competencies plans
gradingform_guide_fillings 0 4 6 0 Table

Stores the data of how the guide is filled by a particular r
mnet_host2service 0 0 5 0 Table

Information about the services for a given host
qtype_match_options 0 2 10 0 Table

Defines the question-type specific options for matching ques
badge_manual_award 0 8 6 0 Table

Track manual award criteria for badges
question_multianswer 0 2 3 0 Table

Options for multianswer questions
tag 6 4 10 0 Table

Tag table - this generic table will replace the old “tags” t
analytics_used_files 0 4 5 0 Table

Files that have already been used for training and predictio
forum_discussion_subs 0 6 5 0 Table

Users may choose to subscribe and unsubscribe from specific
mnet_host 4 2 15 0 Table

Information about the local and remote hosts for RPC
tool_recyclebin_category 0 2 5 0 Table

A list of items in the category recycle bin
forum_track_prefs 0 3 3 0 Table

Tracks each users untracked forums
message_airnotifier_devices 0 2 3 0 Table

Store information about the devices registered in Airnotifie
workshop_aggregations 0 4 5 0 Table

Aggregated grades for assessment are stored here. The aggreg
wiki_versions 0 2 7 0 Table

Stores wiki page history
question_calculated 0 2 7 0 Table

Options for questions of type calculated
role_allow_assign 0 4 3 0 Table

this defines what role can assign what role
filter_active 0 2 5 0 Table

Stores information about which filters are active in which c
messageinbound_messagelist 0 2 5 0 Table

A list of message IDs for existing replies
enrol 6 3 35 0 Table

Instances of enrolment plugins used in courses, fields marke
badge_criteria_param 0 2 4 0 Table

Defines parameters for badges criteria
wiki 2 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 2 11 0 Table

each record is one folder resource
competency_evidence 0 3 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 4 6 0 Table

users allowed to use services with restricted users flag
filter_config 0 2 5 0 Table

Stores per-context configuration settings for filters which
message_users_blocked 0 4 4 0 Table

Maintains lists of blocked users
block 2 0 5 0 Table

contains all installed blocks
competency_relatedcomp 0 2 6 0 Table

Related competencies
glossary_entries 4 2 16 0 Table

all glossary entries
data 4 0 37 0 Table

all database activities
block_rss_client 0 2 9 0 Table

Remote news feed information. Contains the news feed id, the
question_truefalse 0 2 4 0 Table

Options for True-False questions
lti 6 2 26 0 Table

This table contains Basic LTI activities instances
mnet_remote_rpc 0 0 6 0 Table

This table describes functions that might be called remotely
course_completion_aggr_methd 0 2 5 0 Table

Course completion aggregation methods for criteria
assignfeedback_editpdf_quick 0 2 5 0 Table

Stores teacher specified quicklist comments
blog_association 0 4 3 0 Table

Associations of blog entries with courses and module instanc
tool_customlang 0 2 11 0 Table

Contains the working checkout of all strings and their custo
enrol_lti_lti2_tool_proxy 0 2 6 0 Table

A tool proxy between moodle and a consumer
choice 4 0 19 0 Table

Available choices are stored here
external_tokens 0 8 13 0 Table

Security tokens for accessing of external services
oauth2_access_token 0 2 8 0 Table

Stores access tokens for system accounts in order to be able
events_handlers 2 0 8 0 Table

This table is for storing which components requests what typ
messageinbound_datakeys 0 2 6 0 Table

Inbound Message data item secret keys.
question_attempt_step_data 0 2 4 0 Table

Each question_attempt_step has an associative array of the d
message_email_messages 0 6 4 0 Table

Keeps track of what emails to send in an email digest
search_index_requests 0 2 7 0 Table

Records requests for (re)indexing of specific contexts. Entr
block_recent_activity 0 3 7 0 Table

Recent activity block
h5p_libraries 10 0 19 0 Table

Stores information about libraries used by H5P content.
lti_access_tokens 0 2 7 0 Table

Security tokens for accessing of LTI services
data_fields 2 2 16 0 Table

every field available
badge_backpack 4 4 7 0 Table

Defines settings for connecting external backpack
scorm_aicc_session 0 4 12 0 Table

Used by AICC HACP to store session information
tool_dataprivacy_purposerole 0 4 10 0 Table

Data purpose overrides for a specific role
grading_instances 4 4 9 0 Table

Grading form instance is an assessment record for one gradab
course_request 0 0 9 0 Table

course requests
question_numerical_options 0 2 6 0 Table

Options for questions of type numerical This table is also u
role_allow_override 0 4 3 0 Table

this defines what role can override what role
user 236 0 55 0 Table

One record for each person, custom profile fields can be added via /user/profile/index.php
grade_import_newitem 2 2 4 0 Table

temporary table for storing new grade_item names from grade
tool_dataprivacy_ctxlevel 0 4 7 0 Table

Default comment for the table, please edit me
tool_customlang_components 2 0 3 0 Table

Contains the list of all installed plugins that provide thei
message_user_actions 0 4 5 0 Table

Stores all per-user actions on individual messages
quiz_overrides 0 6 9 0 Table

The overrides to quiz settings on a per-user and per-group b