Tables


Documentation of the Moodle 4.0.2+ database structure

Generated on Sun Aug 07 13:38 BST 2022

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

XML Representation
Insertion Order Deletion Order
TABLES 469
VIEWS 0
COLUMNS 4327
Constraints 587
Anomalies 132
Routines 0

Database Properties

Database Type: MySQL - 8.0.20-0ubuntu0.20.04.1

Tables

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

Stores the overall grade for each user on the quiz, based on

groups 20 4 10 0 Table

Each record represents a group.

tool_policy_acceptances 0 12 9 0 Table

Tracks users accepting the policy versions

lesson_answers 4 8 13 0 Table

Defines lesson_answers

scorm_scoes_data 0 4 4 0 Table

Contains variable data get from packages

data_records 4 5 7 0 Table

every record introduced

h5p_library_dependencies 0 8 4 0 Table

Stores H5P library dependencies

upgrade_log 0 4 10 0 Table

Upgrade logging

stats_daily 0 5 7 0 Table

to accumulate daily stats

reportbuilder_schedule 0 4 19 0 Table

Table to represent a report schedule

stats_monthly 0 5 7 0 Table

To accumulate monthly stats

badge_issued 4 8 8 0 Table

Defines issued badges

assignment_submissions 0 3 14 0 Table

Info about submitted assignments

reportbuilder_filter 0 3 10 0 Table

Table to represent a report filter/condition

search_simpledb_index 0 3 14 0 Table

search_simpledb table containing the index data.

file_conversion 0 8 11 0 Table

Table to track file conversions.

competency_coursecomp 0 6 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 deplo

lesson_attempts 0 13 9 0 Table

Defines lesson_attempts

survey_questions 4 0 7 0 Table

the questions conforming one survey

adminpresets_plug 0 0 5 0 Table

Admin presets plugins status, to store information about whe

portfolio_instance 16 0 4 0 Table

base table (not including config data) for instances of port

badge 28 12 26 0 Table

Defines badge

question_bank_entries 2 2 4 0 Table

Each question bank entry. This table has one row for each qu

user_preferences 0 8 4 0 Table

Allows modules to store arbitrary user preferences

grade_outcomes 16 12 10 0 Table

This table describes the outcomes used in the system. An out

quiz_statistics 0 0 19 0 Table

table to cache results from analysis done in statistics repo

stats_user_daily 0 6 8 0 Table

To accumulate daily stats per course/user

role 69 0 6 0 Table

moodle roles

message 4 0 17 0 Table

Stores all unread messages

qtype_essay_options 0 4 15 0 Table

Extra options for essay questions.

message_contacts 0 12 4 0 Table

Maintains lists of contacts between users

oauth2_issuer 31 0 22 0 Table

Details for an oauth 2 connect identity issuer.

message_conversation_actions 0 8 5 0 Table

Stores all per-user actions on individual conversations

qtype_randomsamatch_options 0 4 11 0 Table

Info about a random short-answer matching question

editor_atto_autosave 0 2 9 0 Table

Draft text that is auto-saved every 5 seconds while an edito

qtype_ddmarker_drags 0 4 6 0 Table

Labels for markers to drag.

assignment_upgrade 0 0 6 0 Table

Info about upgraded assignments

tool_dataprivacy_ctxinstance 0 12 7 0 Table

Default comment for the table, please edit me

grade_categories_history 0 16 18 0 Table

History of grade_categories

analytics_models 24 0 13 0 Table

Analytic models.

imscp 0 4 9 0 Table

each record is one imscp resource

role_allow_view 0 8 3 0 Table

This table stores which which other roles a user is allowed

event_subscriptions 4 2 10 0 Table

Tracks subscriptions to remote calendars.

enrol_lti_lti2_share_key 0 4 5 0 Table

Resource link share key

course_completion_crit_compl 0 5 7 0 Table

Course completion user records

mnet_rpc 0 0 11 0 Table

Functions or methods that we may publish or subscribe to

enrol_lti_app_registration 1 0 13 0 Table

Details of each application that has been registered with th

tag_correlation 0 4 3 0 Table

The rationale for the ‘tag_correlation’ table is performance

scorm_seq_ruleconds 4 4 5 0 Table

SCORM2004 rule conditions

post 4 7 19 0 Table

Generic post table to hold data blog entries etc in differen

tool_dataprivacy_purpose 12 0 11 0 Table

Data purposes

assignfeedback_file 0 8 4 0 Table

Stores info about the number of files submitted by a student

question_gapselect 0 4 10 0 Table

Defines select missing words questions

quiz_overview_regrades 0 2 7 0 Table

This table records which question attempts need regrading an

qtype_shortanswer_options 0 4 3 0 Table

Options for short answer questions

user_password_resets 0 4 5 0 Table

table tracking password reset confirmation tokens

feedback_valuetmp 0 2 6 0 Table

values of the completedstmp

modules 4 0 6 0 Table

modules available in the site

feedback_sitecourse_map 0 5 3 0 Table

feedback sitecourse map

scorm_seq_mapinfo 0 8 8 0 Table

SCORM2004 objective mapinfo description

choice_options 4 4 5 0 Table

available options to choice

lesson 28 0 42 0 Table

Defines lesson

lti_types 12 0 18 0 Table

Basic LTI pre-configured activities

license 0 0 8 0 Table

store licenses used by moodle

lesson_branch 0 9 8 0 Table

branches for each lesson/user

bigbluebuttonbn_logs 0 3 8 0 Table

The bigbluebuttonbn table to store meeting activity events

reportbuilder_audience 0 3 9 0 Table

Defines report audience

cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

analytics_indicator_calc 0 4 9 0 Table

Stored indicator calculations

message_popup_notifications 0 4 2 0 Table

List of notifications to display in the message output popup

customfield_data 0 8 12 0 Table

core_customfield data table

scorm_seq_rolluprule 4 4 7 0 Table

SCORM2004 sequencing rule

wiki_locks 0 5 5 0 Table

Manages page locks

oauth2_user_field_mapping 0 4 7 0 Table

Mapping of oauth user fields to moodle fields.

auth_oauth2_linked_login 0 12 10 0 Table

Accounts linked to a users Moodle account.

role_capabilities 0 16 7 0 Table

permission has to be signed, overriding a capability for a p

survey_analysis 0 5 4 0 Table

text about each survey submission

badge_criteria_met 0 12 5 0 Table

Defines criteria that were met for an issued badge

feedback 14 0 17 0 Table

all feedbacks

workshop_grades 0 4 7 0 Table

How the reviewers filled-up the grading forms, given grades

reportbuilder_column 0 3 13 0 Table

Table to represent a report column

qtype_ddmarker 0 4 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 6 8 13 0 Table

feedback_items

infected_files 0 3 6 0 Table

Table to store infected file details.

competency_template 12 1 10 0 Table

Learning plan templates.

workshop_assessments 4 12 15 0 Table

Info about the made assessment and automatically calculated

grade_letters 0 4 4 0 Table

Repository for grade letters, for courses and other moodle e

paygw_paypal 0 3 3 0 Table

Stores PayPal related information

assignment 2 0 19 0 Table

Defines assignments

enrol_flatfile 0 12 8 0 Table

enrol_flatfile table retrofitted from MySQL

analytics_train_samples 0 4 6 0 Table

Samples used for training

assign_submission 8 5 10 0 Table

This table keeps information about student interactions with

adminpresets_it_a 0 0 4 0 Table

Admin presets items attributes. For settings with attributes

mnet_application 4 0 6 0 Table

Information about applications on remote hosts

tool_dataprivacy_category 8 0 7 0 Table

Data categories

survey_answers 0 9 7 0 Table

the answers to each questions filled by the users

forum_queue 0 9 5 0 Table

For keeping track of posts that will be mailed in digest for

tag_area 0 4 9 0 Table

Defines various tag areas, one area is identified by compone

backup_controllers 4 4 17 0 Table

To store the backup_controllers as they are used

analytics_predictions 4 8 11 0 Table

Predictions

ltiservice_gradebookservices 0 2 9 0 Table

This file records the grade items created by the LTI Gradebo

repository_onedrive_access 0 4 6 0 Table

List of temporary access grants.

tool_brickfield_checks 2 0 6 0 Table

Checks details

h5p 4 4 9 0 Table

Stores H5P content information

lti_tool_settings 0 16 8 0 Table

LTI tool setting values

assign_grades 20 5 8 0 Table

Grading information about a single assignment submission.

course_categories 22 8 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 4 4 0 Table

config for portfolio plugin instances

resource_old 0 0 16 0 Table

backup of all old resource instances from 1.9

scorm_scoes_track 0 9 8 0 Table

to track SCOes

forum_grades 0 5 7 0 Table

Grading data for forum instances

user_lastaccess 0 9 4 0 Table

To keep track of course page access times, used in online pa

badge_backpack_oauth2 0 16 11 0 Table

Default comment for the table, please edit me

survey 8 0 11 0 Table

Each record is one SURVEY module with its configuration

workshopeval_best_settings 0 1 3 0 Table

Settings for the grading evaluation subplugin Comparison wit

quiz_attempts 0 12 16 0 Table

Stores users attempts at quizzes.

backup_courses 0 4 6 0 Table

To store every course backup status

tool_usertours_tours 4 0 9 0 Table

List of tours

oauth2_system_account 0 4 9 0 Table

Stored details used to get an access token as a system user

question_hints 0 4 7 0 Table

Stores the the part of the question definition that gives di

cohort 9 4 11 0 Table

Each record represents one cohort (aka site-wide group).

payment_accounts 6 1 8 0 Table

Payment accounts

workshop 17 4 37 0 Table

This table keeps information about the module instances and

question_statistics 0 4 18 0 Table

Statistics for individual questions used in an activity.

h5pactivity_attempts 4 5 12 0 Table

Users attempts inside H5P activities

groupings_groups 0 8 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 8 0 28 0 Table

all glossaries

url 0 4 10 0 Table

each record is one url resource

mnet_session 0 4 9 0 Table

Store session data from users migrating to other sites

competency_templatecomp 0 12 7 0 Table

Link a competency to a learning plan template.

badge_external_identifier 0 4 5 0 Table

Setting for external badges mappings

glossary_entries_categories 0 8 3 0 Table

categories of each glossary entry

enrol_paypal 0 16 21 0 Table

Holds all known information about PayPal transactions

role_allow_switch 0 8 3 0 Table

This table stores which which other roles a user is allowed

badge_alignment 0 4 7 0 Table

Defines alignment for badges

qtype_ddimageortext_drops 0 4 7 0 Table

Drop boxes

notifications 4 4 15 0 Table

Stores all notifications

question_categories 9 5 9 0 Table

Categories are for grouping questions

assignsubmission_file 0 6 4 0 Table

Info about file submissions for assignments

message_conversation_members 0 8 4 0 Table

Stores all members in a conversations

task_adhoc 0 4 12 0 Table

List of adhoc tasks waiting to run.

contentbank_content 0 12 11 0 Table

This table stores content data in the content bank.

grade_items 16 16 31 0 Table

This table keeps information about gradeable items (ie colum

glossary_formats 0 0 10 0 Table

Setting of the display formats

book_chapters 0 4 11 0 Table

Defines book_chapters

adminpresets_app_it 0 1 3 0 Table

Admin presets applied items. To maintain the relation with c

badge_external 0 4 5 0 Table

Setting for external badges display

block_instances 4 8 12 0 Table

This table stores block instances. The type of block this is

question_response_count 0 4 4 0 Table

Count for each responses for each try at a question.

grade_grades_history 0 24 24 0 Table

History table

question_response_analysis 4 1 10 0 Table

Analysis of student responses given to questions.

mnet_service2rpc 0 4 3 0 Table

Group functions or methods under a service

tool_brickfield_cache_acts 0 2 8 0 Table

Contains accessibility summary information per activity.

lti_tool_proxies 4 0 13 0 Table

LTI tool proxy registrations

scorm_seq_rolluprulecond 0 6 5 0 Table

SCORM2004 sequencing rule

grade_import_values 0 13 9 0 Table

Temporary table for importing grades

grade_outcomes_courses 0 8 3 0 Table

stores what outcomes are used in what courses.

workshop_submissions 4 12 19 0 Table

Info about the submission and the aggregation of the grade f

enrol_lti_lti2_user_result 0 4 6 0 Table

Results for each user for each resource link

event 0 10 24 0 Table

For everything with a time associated to it

badge_endorsement 0 4 8 0 Table

Defines endorsement for badge

tool_dataprivacy_ctxexpired 0 4 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 f

mnet_sso_access_control 0 0 4 0 Table

Users by host permitted (or not) to login from a remote prov

question_dataset_definitions 4 4 6 0 Table

Organises and stores properties for dataset items

scale 31 2 8 0 Table

Defines grading scales

analytics_prediction_actions 0 8 5 0 Table

Register of user actions over predictions.

tool_policy 4 4 3 0 Table

Contains the list of policy documents defined on the site.

files 12 12 20 0 Table

description of files, content is stored in sha1 file pool

competency_usercompcourse 0 6 9 0 Table

User competencies in a course

feedback_template 4 0 4 0 Table

templates of feedbackstructures

tool_brickfield_cache_check 0 2 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 12 5 4 0 Table

Stores subwiki instances

mnetservice_enrol_courses 0 1 14 0 Table

Caches the information fetched via XML-RPC about courses on

question_datasets 0 8 3 0 Table

Many-many relation between questions and dataset definitions

assign_overrides 0 12 9 0 Table

The overrides to assign settings.

h5pactivity_attempts_results 0 4 14 0 Table

H5Pactivities_attempts tracking info

user_private_key 0 4 8 0 Table

access keys used in cookieless scripts - rss, etc.

feedback_completedtmp 0 4 8 0 Table

filled out feedback

h5pactivity 4 4 12 0 Table

Stores the h5pactivity activity module instances.

wiki_links 0 8 5 0 Table

Page wiki links

quizaccess_seb_quizsettings 0 4 29 0 Table

Stores the quiz level Safe Exam Browser configuration.

gradingform_guide_criteria 4 4 9 0 Table

Stores the rows of the criteria grid.

message_read 0 4 17 0 Table

Stores all messages that have been read

events_queue 4 4 5 0 Table

This table is for storing queued events. It stores only one

badge_criteria 8 4 6 0 Table

Defines criteria for issuing badges

quiz_sections 0 4 5 0 Table

Stores sections of a quiz with section name (heading), from

forum_digests 0 8 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 resourc

forum_subscriptions 0 5 3 0 Table

Keeps track of who is subscribed to what forum

assign_user_mapping 0 8 3 0 Table

Map an assignment specific id number to a user

wiki_pages 16 5 10 0 Table

Stores wiki pages

competency_coursecompsetting 0 4 6 0 Table

This table contains the course specific settings for compete

payment_gateways 0 3 7 0 Table

Configuration for one gateway for one payment account

tool_brickfield_errors 0 2 5 0 Table

Errors during the accessibility checks

message_popup 0 4 3 0 Table

Keep state of notifications for the popup message processor

repository_instance_config 0 4 4 0 Table

The config for intances

lti_types_config 0 4 4 0 Table

Basic LTI types configuration

data_content 0 8 8 0 Table

the content introduced in each record/fields

assignfeedback_editpdf_cmnt 0 4 9 0 Table

Stores comments added to pdfs

context 129 0 6 0 Table

one of these must be set

groupings 8 2 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 8 4 0 Table

role names in native strings

question_references 0 2 7 0 Table

Records where a specific question is used.

competency_userevidence 0 4 9 0 Table

The evidence of prior learning

course_completions 0 5 7 0 Table

Course completion records

assignsubmission_onlinetext 0 8 5 0 Table

Info about onlinetext submission

tool_monitor_subscriptions 4 6 8 0 Table

Table to store user subscriptions to various rules

payments 3 6 11 0 Table

Stores information about payments

enrol_lti_users 1 9 13 0 Table

User access log and gradeback data

customfield_category 4 4 11 0 Table

core_customfield category table

gradingform_rubric_criteria 8 4 5 0 Table

Stores the rows of the rubric grid.

user_password_history 0 4 4 0 Table

A rotating log of hashes of previously used passwords for ea

feedback_value 0 4 6 0 Table

values of the completeds

config_log 0 4 7 0 Table

Changes done in server configuration through admin UI

competency_framework 4 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 4 4 6 0 Table

SCORM2004 objective description

rating 0 9 10 0 Table

moodle ratings

my_pages 0 4 5 0 Table

Extra user pages for the My Moodle system

competency_modulecomp 0 12 8 0 Table

Link a competency to a module.

grade_items_history 0 24 34 0 Table

History of grade_items

enrol_lti_tool_consumer_map 0 8 3 0 Table

Table that maps the published tool to tool consumers.

course_completion_criteria 0 4 10 0 Table

Course completion criteria

h5p_libraries_cachedassets 0 4 3 0 Table

H5P cached library assets

assignfeedback_editpdf_rot 0 4 6 0 Table

Stores rotation information of a page.

course_modules 15 8 23 0 Table

course_modules table retrofitted from MySQL

forum_posts 12 9 18 0 Table

All posts are stored in this table

tool_recyclebin_course 0 4 6 0 Table

A list of items in the course recycle bin

glossary_alias 0 4 3 0 Table

entries alias

grade_grades 4 16 23 0 Table

grade_grades This table keeps individual grades for each us

tool_brickfield_schedule 0 1 7 0 Table

Keeps the per course content analysis schedule.

scorm_scoes 28 4 10 0 Table

each SCO part of the SCORM module

stats_user_weekly 0 6 8 0 Table

To accumulate weekly stats per course/user

chat_messages_current 0 5 7 0 Table

Stores current session

enrol_lti_tools 8 8 23 0 Table

List of tools provided to the remote system

gradingform_rubric_levels 0 4 5 0 Table

Stores the columns of the rubric grid.

workshopform_accumulative 0 1 7 0 Table

The assessment dimensions definitions of Accumulative gradin

tool_monitor_history 0 5 4 0 Table

Table to store history of message notifications sent

competency_usercomp 4 5 10 0 Table

User competencies

tag_coll 8 0 7 0 Table

Defines different set of tags

tool_brickfield_content 2 2 7 0 Table

Content of an area at a particular time (recognised by a has

mnetservice_enrol_enrolments 0 8 7 0 Table

Caches the information about enrolments of our local users i

external_services_functions 0 4 3 0 Table

lists functions available in each service group

message_conversations 16 4 11 0 Table

Stores all message conversations

messages 8 8 11 0 Table

Stores all messages

h5p_contents_libraries 0 8 6 0 Table

Store which library is used in which content.

competency 44 5 17 0 Table

This table contains the master record of each competency in

resource 1 4 13 0 Table

Each record is one resource and its config data

tag_instance 0 8 10 0 Table

tag_instance table holds the information of associations bet

user_devices 4 4 11 0 Table

This table stores user’s mobile devices information in order

question_ddwtos 0 4 10 0 Table

Defines drag and drop (words into sentences) questions

grade_categories 20 8 14 0 Table

This table keeps information about categories, used for grou

question_set_references 0 2 7 0 Table

Records where groups of questions are used.

assign_plugin_config 0 4 6 0 Table

Config data for an instance of a plugin in an assignment.

quiz 25 0 41 0 Table

The settings for each quiz.

tool_cohortroles 0 6 7 0 Table

Mapping of users to cohort role assignments.

question_attempt_steps 4 8 7 0 Table

Stores one step in in a question attempt. As well as the dat

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

lesson_pages 12 4 13 0 Table

Defines lesson_pages

adminpresets_it 0 0 5 0 Table

Table to store settings

message_providers 0 0 4 0 Table

This table stores the message providers (modules and core sy

assignfeedback_editpdf_annot 0 4 11 0 Table

stores annotations added to pdfs submitted by students

bigbluebuttonbn 2 0 43 0 Table

The bigbluebuttonbn table to store information about a meeti

badge_related 0 8 3 0 Table

Defines badge related for badges

tool_dataprivacy_request 0 16 15 0 Table

Table for data requests

workshopform_numerrors 0 1 9 0 Table

The assessment dimensions definitions of Number of errors gr

block_positions 0 8 8 0 Table

Stores the position of a sticky block_instance on a another

tool_brickfield_areas 2 8 13 0 Table

Areas that have been checked for accessibility problems

tool_policy_versions 8 8 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 4 5 0 Table

The subquestions that make up a matching question

customfield_field 4 4 11 0 Table

core_customfield field table

question_numerical 0 4 4 0 Table

Options for numerical questions.

messageinbound_handlers 4 0 6 0 Table

Inbound Message Handler definitions.

user_info_data 0 8 5 0 Table

Data for the customisable user fields

label 0 4 6 0 Table

Defines labels

mnet_service 4 0 5 0 Table

A service is a group of functions

analytics_used_analysables 0 4 6 0 Table

List of analysables used by each model

forum_read 0 13 7 0 Table

Tracks each users read posts

forum_discussions 16 5 14 0 Table

Forums are composed of discussions

user_info_field 0 4 20 0 Table

Customisable user profile fields

page 0 4 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 stra

enrol_lti_lti2_consumer 20 0 19 0 Table

LTI consumers interacting with moodle

scorm_seq_rulecond 0 6 7 0 Table

SCORM2004 rule condition

wiki_synonyms 0 8 4 0 Table

Stores wiki pages synonyms

question_usages 8 4 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 5 7 0 Table

Stores all the actual chat messages

external_services 12 0 11 0 Table

built in and custom external services

grading_areas 4 4 5 0 Table

Identifies gradable areas where advanced grading can happen.

scale_history 0 13 11 0 Table

History table

role_context_levels 0 4 3 0 Table

Lists which roles can be assigned at which context levels. T

stats_user_monthly 0 6 8 0 Table

To accumulate monthly stats per course/user

user_enrolments 0 12 9 0 Table

Users participating in courses (aka enrolled users) - everyb

lesson_timer 0 5 7 0 Table

lesson timer for each lesson

qtype_ddimageortext_drags 0 4 6 0 Table

Images to drag. Actual file names are not stored here we use

role_assignments 0 12 9 0 Table

assigning roles in different context

portfolio_instance_user 0 8 5 0 Table

user data for portfolio instances.

assignfeedback_comments 0 8 5 0 Table

Text feedback for submitted assignments

capabilities 4 0 6 0 Table

this defines all capabilities

choice_answers 0 9 5 0 Table

choices performed by users

badge_external_backpack 8 4 6 0 Table

Defines settings for site level backpacks that a user can co

groups_members 0 8 6 0 Table

Link a user to a group.

enrol_lti_lti2_resource_link 12 12 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 12 0 41 0 Table

each table is one SCORM module and its configuration

course 204 4 36 0 Table

Central course table

question 110 12 16 0 Table

This table stores the definition of one version of a questio

stats_weekly 0 5 7 0 Table

To accumulate weekly stats

qtype_ddmarker_drops 0 4 6 0 Table

drop regions

lesson_grades 0 5 6 0 Table

Defines lesson_grades

log_queries 0 0 9 0 Table

Logged database queries.

backup_logs 0 4 5 0 Table

To store all the logs from backup and restore operations (by

user_info_category 4 0 3 0 Table

Customisable fields categories

question_answers 0 4 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 8 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 4 4 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 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 4 8 0 Table

Information about how and when an local courses were publish

grade_outcomes_history 0 16 12 0 Table

History table

book 4 0 11 0 Table

Defines book

lti_submission 0 5 9 0 Table

Keeps track of individual submissions for LTI activities.

portfolio_mahara_queue 0 4 3 0 Table

maps mahara tokens to transfer ids

oauth2_endpoint 0 4 7 0 Table

Describes the named endpoint for an oauth2 service.

analytics_models_log 0 4 12 0 Table

Analytic models changes during evaluation.

competency_userevidencecomp 0 5 6 0 Table

Relationship between user evidence and competencies

sessions 0 4 9 0 Table

Database based session storage - now recommended

question_calculated_options 0 4 13 0 Table

Options for questions of type calculated

repository_instances 8 2 10 0 Table

This table contains one entry for every configured external

forum 29 0 29 0 Table

Forums contain and structure discussion

feedback_completed 0 6 7 0 Table

filled out feedback

assign_user_flags 0 8 8 0 Table

List of flags that can be set for a single user in a single

gradingform_guide_comments 0 4 5 0 Table

frequently used comments used in marking guide

grade_settings 0 4 4 0 Table

gradebook settings

course_format_options 0 4 6 0 Table

Stores format-specific options for the course or course sect

course_sections 0 4 10 0 Table

to define the sections for each course

logstore_standard_log 0 4 21 0 Table

Standard log table

enrol_lti_lti2_nonce 0 4 4 0 Table

Nonce used for authentication between moodle and a consumer

portfolio_tempdata 4 8 6 0 Table

stores temporary data for portfolio exports. the id of this

files_reference 4 4 5 0 Table

Store files references

tool_brickfield_results 2 4 4 0 Table

Results of the accessibility checks

adminpresets_app 0 1 4 0 Table

Applied presets

mnet_log 0 5 13 0 Table

Store session data from users migrating to other sites

course_completion_defaults 0 8 9 0 Table

Default settings for activities completion

log 0 4 10 0 Table

Every action is logged as far as possible

block_recentlyaccesseditems 0 12 5 0 Table

Most recently accessed items accessed by a user

qtype_multichoice_options 0 4 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 sub

task_log 0 1 13 0 Table

The log table for all tasks

blog_external 0 4 9 0 Table

External blog links used for RSS copying of blog entries to

tool_usertours_steps 0 4 9 0 Table

Steps in an tour

quiz_feedback 0 4 6 0 Table

Feedback given to students based on which grade band their o

lesson_overrides 0 12 11 0 Table

The overrides to lesson settings.

tool_monitor_rules 4 2 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 6 7 0 Table

Stores refresh tokens which can be exchanged for access toke

events_queue_handlers 0 8 6 0 Table

This is the list of queued handlers for processing. The even

analytics_predict_samples 0 4 8 0 Table

Samples already used for predictions.

question_numerical_units 0 4 4 0 Table

Optional unit options for numerical questions. This table is

quiz_slots 0 4 6 0 Table

Stores the question used in a quiz, with the order, and for

cohort_members 0 8 4 0 Table

Link a user to a cohort.

chat 12 0 10 0 Table

Each of these is a chat room

question_attempts 6 8 14 0 Table

Each row here corresponds to an attempt at one question, as

comments 0 5 9 0 Table

moodle comments module

assign 38 0 34 0 Table

This table saves information about an instance of mod_assign

portfolio_log 0 8 11 0 Table

log of portfolio transfers (used to later check for duplicat

course_modules_completion 0 5 7 0 Table

Stores the completion state (completed or not completed, etc

favourite 0 8 9 0 Table

Stores the relationship between an arbitrary item (itemtype,

qtype_ddimageortext 0 4 10 0 Table

Defines drag and drop (text or images onto a background imag

gradingform_rubric_fillings 0 8 6 0 Table

Stores the data of how the rubric is filled by a particular

glossary_categories 4 4 4 0 Table

all categories for glossary entries

question_versions 0 2 5 0 Table

A join table linking the different question version definiti

competency_plan 0 5 13 0 Table

Learning plans

chat_users 0 5 12 0 Table

Keeps track of which users are in which chat rooms

grading_definitions 16 12 14 0 Table

Contains the basic information about an advanced grading for

tool_brickfield_summary 0 2 27 0 Table

Contains accessibility check results summary information.

competency_usercompplan 0 5 10 0 Table

User competencies plans

gradingform_guide_fillings 0 8 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 4 10 0 Table

Defines the question-type specific options for matching ques

badge_manual_award 0 16 6 0 Table

Track manual award criteria for badges

adminpresets_app_plug 0 0 6 0 Table

Admin presets plugins applied

question_multianswer 0 4 3 0 Table

Options for multianswer questions

tag 8 8 10 0 Table

Tag table - this generic table will replace the old “tags” t

tool_brickfield_process 0 2 7 0 Table

Queued records to initiate new processing of specific target

analytics_used_files 0 8 5 0 Table

Files that have already been used for training and predictio

forum_discussion_subs 0 12 5 0 Table

Users may choose to subscribe and unsubscribe from specific

mnet_host 8 4 15 0 Table

Information about the local and remote hosts for RPC

tool_recyclebin_category 0 4 5 0 Table

A list of items in the category recycle bin

forum_track_prefs 0 5 3 0 Table

Tracks each users untracked forums

message_airnotifier_devices 0 4 3 0 Table

Store information about the devices registered in Airnotifie

workshop_aggregations 0 8 5 0 Table

Aggregated grades for assessment are stored here. The aggreg

wiki_versions 0 5 7 0 Table

Stores wiki page history

question_calculated 0 4 7 0 Table

Options for questions of type calculated

role_allow_assign 0 8 3 0 Table

this defines what role can assign what role

filter_active 0 4 5 0 Table

Stores information about which filters are active in which c

messageinbound_messagelist 0 4 5 0 Table

A list of message IDs for existing replies

enrol 12 5 35 0 Table

Instances of enrolment plugins used in courses, fields marke

badge_criteria_param 0 4 4 0 Table

Defines parameters for badges criteria

wiki 4 0 13 0 Table

Stores Wiki activity configuration

competency_templatecohort 0 5 6 0 Table

Default comment for the table, please edit me

folder 0 4 11 0 Table

each record is one folder resource

competency_evidence 0 5 14 0 Table

The evidence linked to a user competency

competency_plancomp 0 4 7 0 Table

Plan competencies

external_functions 0 0 8 0 Table

list of all external functions

adminpresets 0 1 11 0 Table

Table to store presets data

external_services_users 0 8 6 0 Table

users allowed to use services with restricted users flag

filter_config 0 4 5 0 Table

Stores per-context configuration settings for filters which

message_users_blocked 0 8 4 0 Table

Maintains lists of blocked users

block 4 0 5 0 Table

contains all installed blocks

competency_relatedcomp 0 4 6 0 Table

Related competencies

reportbuilder_report 4 3 15 0 Table

Table to represent a report

glossary_entries 8 5 16 0 Table

all glossary entries

data 8 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

block_rss_client 0 4 9 0 Table

Remote news feed information. Contains the news feed id, the

question_truefalse 0 4 4 0 Table

Options for True-False questions

lti 13 4 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

course_completion_aggr_methd 0 4 5 0 Table

Course completion aggregation methods for criteria

assignfeedback_editpdf_quick 0 4 5 0 Table

Stores teacher specified quicklist comments

blog_association 0 8 3 0 Table

Associations of blog entries with courses and module instanc

tool_customlang 0 4 11 0 Table

Contains the working checkout of all strings and their custo

enrol_lti_lti2_tool_proxy 0 4 6 0 Table

A tool proxy between moodle and a consumer

choice 8 0 19 0 Table

Available choices are stored here

external_tokens 0 16 13 0 Table

Security tokens for accessing of external services

oauth2_access_token 0 4 8 0 Table

Stores access tokens for system accounts in order to be able

events_handlers 4 0 8 0 Table

This table is for storing which components requests what typ

messageinbound_datakeys 0 4 6 0 Table

Inbound Message data item secret keys.

question_attempt_step_data 0 4 4 0 Table

Each question_attempt_step has an associative array of the d

message_email_messages 0 12 4 0 Table

Keeps track of what emails to send in an email digest

search_index_requests 0 4 7 0 Table

Records requests for (re)indexing of specific contexts. Entr

block_recent_activity 0 5 7 0 Table

Recent activity block

h5p_libraries 20 0 20 0 Table

Stores information about libraries used by H5P content.

lti_access_tokens 0 4 7 0 Table

Security tokens for accessing of LTI services

data_fields 4 4 16 0 Table

every field available

badge_backpack 8 8 7 0 Table

Defines settings for connecting external backpack

scorm_aicc_session 0 8 12 0 Table

Used by AICC HACP to store session information

tool_dataprivacy_purposerole 0 8 10 0 Table

Data purpose overrides for a specific role

grading_instances 8 8 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 4 6 0 Table

Options for questions of type numerical This table is also u

role_allow_override 0 8 3 0 Table

this defines what role can override what role

user 550 0 48 0 Table

One record for each person

grade_import_newitem 4 4 4 0 Table

temporary table for storing new grade_item names from grade

tool_dataprivacy_ctxlevel 0 8 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 4 0 3 0 Table

Contains the list of all installed plugins that provide thei

message_user_actions 0 8 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 12 9 0 Table

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