Tables


SchemaSpy Analysis of moodle_3.11

Generated on Sun Mar 13 12:28 GMT 2022

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

XML Representation
Insertion Order Deletion Order
TABLES 429
VIEWS 0
COLUMNS 3934
Constraints 540
Anomalies 61
Routines 0

Database Properties

Database Type: MySQL - 8.0.20-0ubuntu0.20.04.1

Schema moodle_3.11

Moodle Logo 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 3 5 0 Table

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

groups 15 3 10 0 Table

Each record represents a group.

tool_policy_acceptances 0 9 9 0 Table

Tracks users accepting the policy versions

lesson_answers 3 6 13 0 Table

Defines lesson_answers

scorm_scoes_data 0 3 4 0 Table

Contains variable data get from packages

data_records 3 3 7 0 Table

every record introduced

h5p_library_dependencies 0 6 4 0 Table

Stores H5P library dependencies

upgrade_log 0 3 10 0 Table

Upgrade logging

stats_daily 0 4 7 0 Table

to accumulate daily stats

stats_monthly 0 4 7 0 Table

To accumulate monthly stats

badge_issued 3 6 8 0 Table

Defines issued badges

assignment_submissions 0 2 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 6 11 0 Table

Table to track file conversions.

competency_coursecomp 0 5 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 9 9 0 Table

Defines lesson_attempts

survey_questions 3 0 7 0 Table

the questions conforming one survey

portfolio_instance 12 0 4 0 Table

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

badge 21 9 26 0 Table

Defines badge

user_preferences 0 6 4 0 Table

Allows modules to store arbitrary user preferences

grade_outcomes 12 9 10 0 Table

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

stats_user_daily 0 4 8 0 Table

To accumulate daily stats per course/user

role 54 0 6 0 Table

moodle roles

message 3 0 17 0 Table

Stores all unread messages

qtype_essay_options 0 3 15 0 Table

Extra options for essay questions.

message_contacts 0 9 4 0 Table

Maintains lists of contacts between users

oauth2_issuer 23 0 22 0 Table

Details for an oauth 2 connect identity issuer.

message_conversation_actions 0 6 5 0 Table

Stores all per-user actions on individual conversations

qtype_randomsamatch_options 0 3 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 3 6 0 Table

Labels for markers to drag.

assignment_upgrade 0 0 6 0 Table

Info about upgraded assignments

tool_dataprivacy_ctxinstance 0 9 7 0 Table

Default comment for the table, please edit me

grade_categories_history 0 12 18 0 Table

History of grade_categories

analytics_models 18 0 13 0 Table

Analytic models.

imscp 0 3 9 0 Table

each record is one imscp resource

role_allow_view 0 6 3 0 Table

This table stores which which other roles a user is allowed

event_subscriptions 3 1 10 0 Table

Tracks subscriptions to remote calendars.

enrol_lti_lti2_share_key 0 3 5 0 Table

Resource link share key

course_completion_crit_compl 0 3 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 3 3 0 Table

The rationale for the ‘tag_correlation’ table is performance

scorm_seq_ruleconds 3 3 5 0 Table

SCORM2004 rule conditions

post 3 5 19 0 Table

Generic post table to hold data blog entries etc in differen

tool_dataprivacy_purpose 9 0 11 0 Table

Data purposes

assignfeedback_file 0 6 4 0 Table

Stores info about the number of files submitted by a student

question_gapselect 0 3 10 0 Table

Defines select missing words questions

qtype_shortanswer_options 0 3 3 0 Table

Options for short answer questions

user_password_resets 0 3 5 0 Table

table tracking password reset confirmation tokens

feedback_valuetmp 0 2 6 0 Table

values of the completedstmp

modules 3 0 6 0 Table

modules available in the site

feedback_sitecourse_map 0 4 3 0 Table

feedback sitecourse map

scorm_seq_mapinfo 0 6 8 0 Table

SCORM2004 objective mapinfo description

choice_options 3 3 5 0 Table

available options to choice

lesson 21 0 42 0 Table

Defines lesson

lti_types 9 0 18 0 Table

Basic LTI pre-configured activities

license 0 0 8 0 Table

store licenses used by moodle

lesson_branch 0 6 8 0 Table

branches for each lesson/user

cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

analytics_indicator_calc 0 3 9 0 Table

Stored indicator calculations

message_popup_notifications 0 3 2 0 Table

List of notifications to display in the message output popup

customfield_data 0 6 12 0 Table

core_customfield data table

scorm_seq_rolluprule 3 3 7 0 Table

SCORM2004 sequencing rule

wiki_locks 0 3 5 0 Table

Manages page locks

oauth2_user_field_mapping 0 3 7 0 Table

Mapping of oauth user fields to moodle fields.

auth_oauth2_linked_login 0 9 10 0 Table

Accounts linked to a users Moodle account.

role_capabilities 0 12 7 0 Table

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

survey_analysis 0 3 4 0 Table

text about each survey submission

badge_criteria_met 0 9 5 0 Table

Defines criteria that were met for an issued badge

feedback 11 0 17 0 Table

all feedbacks

workshop_grades 0 3 7 0 Table

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

qtype_ddmarker 0 3 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 5 6 13 0 Table

feedback_items

infected_files 0 2 6 0 Table

Table to store infected file details.

competency_template 9 1 10 0 Table

Learning plan templates.

workshop_assessments 3 9 15 0 Table

Info about the made assessment and automatically calculated

grade_letters 0 3 4 0 Table

Repository for grade letters, for courses and other moodle e

paygw_paypal 0 2 3 0 Table

Stores PayPal related information

assignment 2 0 19 0 Table

Defines assignments

enrol_flatfile 0 9 8 0 Table

enrol_flatfile table retrofitted from MySQL

analytics_train_samples 0 3 6 0 Table

Samples used for training

assign_submission 7 3 9 0 Table

This table keeps information about student interactions with

mnet_application 3 0 6 0 Table

Information about applications on remote hosts

tool_dataprivacy_category 6 0 7 0 Table

Data categories

survey_answers 0 6 7 0 Table

the answers to each questions filled by the users

forum_queue 0 6 5 0 Table

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

tag_area 0 3 9 0 Table

Defines various tag areas, one area is identified by compone

backup_controllers 3 3 17 0 Table

To store the backup_controllers as they are used

analytics_predictions 3 6 11 0 Table

Predictions

repository_onedrive_access 0 3 6 0 Table

List of temporary access grants.

tool_brickfield_checks 1 0 6 0 Table

Checks details

h5p 3 3 9 0 Table

Stores H5P content information

lti_tool_settings 0 12 8 0 Table

LTI tool setting values

assign_grades 15 3 8 0 Table

Grading information about a single assignment submission.

course_categories 16 6 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 3 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 6 8 0 Table

to track SCOes

forum_grades 0 3 7 0 Table

Grading data for forum instances

user_lastaccess 0 7 4 0 Table

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

badge_backpack_oauth2 0 12 11 0 Table

Default comment for the table, please edit me

survey 6 0 11 0 Table

Each record is one SURVEY module with its configuration, https://docs.moodle.org/en/Survey_activity

quiz_attempts 0 9 15 0 Table

Stores users attempts at quizzes.

backup_courses 0 3 6 0 Table

To store every course backup status

tool_usertours_tours 3 0 7 0 Table

List of tours

oauth2_system_account 0 3 9 0 Table

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

question_hints 0 3 7 0 Table

Stores the the part of the question definition that gives di

cohort 7 3 11 0 Table

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

payment_accounts 4 1 8 0 Table

Payment accounts

workshop 6 3 37 0 Table

This table keeps information about the module instances and

question_statistics 0 3 18 0 Table

Statistics for individual questions used in an activity.

h5pactivity_attempts 3 3 12 0 Table

Users attempts inside H5P activities

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

all glossaries

url 0 3 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 9 7 0 Table

Link a competency to a learning plan template.

badge_external_identifier 0 3 5 0 Table

Setting for external badges mappings

glossary_entries_categories 0 6 3 0 Table

categories of each glossary entry

enrol_paypal 0 12 21 0 Table

Holds all known information about PayPal transactions

role_allow_switch 0 6 3 0 Table

This table stores which which other roles a user is allowed

badge_alignment 0 3 7 0 Table

Defines alignment for badges

qtype_ddimageortext_drops 0 3 7 0 Table

Drop boxes

notifications 3 3 15 0 Table

Stores all notifications

question_categories 12 4 9 0 Table

Categories are for grouping questions

assignsubmission_file 0 5 4 0 Table

Info about file submissions for assignments

message_conversation_members 0 6 4 0 Table

Stores all members in a conversations

task_adhoc 0 3 12 0 Table

List of adhoc tasks waiting to run.

contentbank_content 0 9 11 0 Table

This table stores content data in the content bank.

grade_items 12 12 31 0 Table

This table keeps information about gradeable items (ie colum

glossary_formats 1 0 10 0 Table

Setting of the display formats

book_chapters 0 3 11 0 Table

Defines book_chapters

badge_external 0 3 5 0 Table

Setting for external badges display

block_instances 3 6 12 0 Table

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

question_response_count 0 3 4 0 Table

Count for each responses for each try at a question.

grade_grades_history 0 18 24 0 Table

History table

question_response_analysis 3 1 10 0 Table

Analysis of student responses given to questions.

mnet_service2rpc 0 3 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 3 0 13 0 Table

LTI tool proxy registrations

scorm_seq_rolluprulecond 0 5 5 0 Table

SCORM2004 sequencing rule

grade_import_values 0 9 9 0 Table

Temporary table for importing grades

grade_outcomes_courses 0 6 3 0 Table

stores what outcomes are used in what courses.

workshop_submissions 3 9 19 0 Table

Info about the submission and the aggregation of the grade f

enrol_lti_lti2_user_result 0 3 6 0 Table

Results for each user for each resource link

event 0 7 24 0 Table

For everything with a time associated to it

badge_endorsement 0 3 8 0 Table

Defines endorsement for badge

tool_dataprivacy_ctxexpired 0 3 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 3 3 6 0 Table

Organises and stores properties for dataset items

scale 24 1 8 0 Table

Defines grading scales

analytics_prediction_actions 0 6 5 0 Table

Register of user actions over predictions.

tool_policy 3 3 3 0 Table

Contains the list of policy documents defined on the site.

files 9 9 20 0 Table

description of files, content is stored in sha1 file pool

competency_usercompcourse 0 4 9 0 Table

User competencies in a course

feedback_template 3 0 4 0 Table

templates of feedbackstructures

tool_brickfield_cache_check 0 1 6 0 Table

Contains accessibility summary information per check.

wiki_subwikis 9 3 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 6 3 0 Table

Many-many relation between questions and dataset definitions

assign_overrides 0 9 8 0 Table

The overrides to assign settings.

h5pactivity_attempts_results 0 3 14 0 Table

H5Pactivities_attempts tracking info

user_private_key 0 3 8 0 Table

access keys used in cookieless scripts - rss, etc.

feedback_completedtmp 0 3 8 0 Table

filled out feedback

h5pactivity 3 3 12 0 Table

Stores the h5pactivity activity module instances.

wiki_links 0 6 5 0 Table

Page wiki links

gradingform_guide_criteria 3 3 9 0 Table

Stores the rows of the criteria grid.

message_read 0 3 17 0 Table

Stores all messages that have been read

events_queue 3 3 5 0 Table

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

badge_criteria 6 3 6 0 Table

Defines criteria for issuing badges

quiz_sections 0 3 5 0 Table

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

forum_digests 0 6 4 0 Table

Keeps track of user mail delivery preferences for each forum

forum_subscriptions 0 3 3 0 Table

Keeps track of who is subscribed to what forum

assign_user_mapping 0 6 3 0 Table

Map an assignment specific id number to a user

wiki_pages 12 3 10 0 Table

Stores wiki pages

competency_coursecompsetting 0 3 6 0 Table

This table contains the course specific settings for compete

payment_gateways 0 2 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 3 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 3 4 0 Table

Basic LTI types configuration

data_content 0 6 8 0 Table

the content introduced in each record/fields

assignfeedback_editpdf_cmnt 0 3 9 0 Table

Stores comments added to pdfs

context 95 0 6 0 Table

one of these must be set

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

role names in native strings

competency_userevidence 0 3 9 0 Table

The evidence of prior learning

course_completions 0 3 7 0 Table

Course completion records

assignsubmission_onlinetext 0 6 5 0 Table

Info about onlinetext submission

tool_monitor_subscriptions 3 4 8 0 Table

Table to store user subscriptions to various rules

payments 2 4 11 0 Table

Stores information about payments

enrol_lti_users 0 6 12 0 Table

User access log and gradeback data

customfield_category 3 3 11 0 Table

core_customfield category table

gradingform_rubric_criteria 6 3 5 0 Table

Stores the rows of the rubric grid.

user_password_history 0 3 4 0 Table

A rotating log of hashes of previously used passwords for ea

feedback_value 0 3 6 0 Table

values of the completeds

config_log 0 3 7 0 Table

Changes done in server configuration through admin UI

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

SCORM2004 objective description

rating 0 7 10 0 Table

moodle ratings

my_pages 0 3 5 0 Table

Extra user pages for the My Moodle system

competency_modulecomp 0 9 8 0 Table

Link a competency to a module.

grade_items_history 0 18 34 0 Table

History of grade_items

enrol_lti_tool_consumer_map 0 6 3 0 Table

Table that maps the published tool to tool consumers.

course_completion_criteria 0 3 10 0 Table

Course completion criteria

h5p_libraries_cachedassets 0 3 3 0 Table

H5P cached library assets

assignfeedback_editpdf_rot 0 3 6 0 Table

Stores rotation information of a page.

course_modules 10 6 21 0 Table

course_modules table retrofitted from MySQL

forum_posts 9 6 18 0 Table

All posts are stored in this table

tool_recyclebin_course 0 3 6 0 Table

A list of items in the course recycle bin

grade_grades 3 12 23 0 Table

grade_grades This table keeps individual grades for each us

glossary_alias 0 3 3 0 Table

entries alias

tool_brickfield_schedule 0 1 7 0 Table

Keeps the per course content analysis schedule.

scorm_scoes 22 3 10 0 Table

each SCO part of the SCORM module

stats_user_weekly 0 4 8 0 Table

To accumulate weekly stats per course/user

chat_messages_current 0 3 7 0 Table

Stores current session

enrol_lti_tools 6 6 19 0 Table

List of tools provided to the remote system

gradingform_rubric_levels 0 3 5 0 Table

Stores the columns of the rubric grid.

tool_monitor_history 0 3 4 0 Table

Table to store history of message notifications sent

competency_usercomp 3 3 10 0 Table

User competencies

tag_coll 6 0 7 0 Table

Defines different set of tags

tool_brickfield_content 1 1 7 0 Table

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

mnetservice_enrol_enrolments 0 6 7 0 Table

Caches the information about enrolments of our local users i

external_services_functions 0 3 3 0 Table

lists functions available in each service group

message_conversations 12 3 11 0 Table

Stores all message conversations

messages 6 6 11 0 Table

Stores all messages

h5p_contents_libraries 0 6 6 0 Table

Store which library is used in which content.

competency 33 4 17 0 Table

This table contains the master record of each competency in

resource 0 3 13 0 Table

Each record is one resource and its config data

tag_instance 0 6 10 0 Table

tag_instance table holds the information of associations bet

user_devices 3 3 11 0 Table

This table stores user’s mobile devices information in order

question_ddwtos 0 3 10 0 Table

Defines drag and drop (words into sentences) questions

grade_categories 15 6 14 0 Table

This table keeps information about categories, used for grou

assign_plugin_config 0 3 6 0 Table

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

quiz 18 0 42 0 Table

The settings for each quiz.

tool_cohortroles 0 4 7 0 Table

Mapping of users to cohort role assignments.

question_attempt_steps 3 6 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 9 3 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 3 11 0 Table

stores annotations added to pdfs submitted by students

badge_related 0 6 3 0 Table

Defines badge related for badges

tool_dataprivacy_request 0 12 15 0 Table

Table for data requests

block_positions 0 6 8 0 Table

Stores the position of a sticky block_instance on a another

tool_brickfield_areas 1 4 13 0 Table

Areas that have been checked for accessibility problems

tool_policy_versions 6 6 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 3 5 0 Table

The subquestions that make up a matching question

customfield_field 3 3 11 0 Table

core_customfield field table

question_numerical 0 3 4 0 Table

Options for numerical questions.

messageinbound_handlers 3 0 6 0 Table

Inbound Message Handler definitions.

user_info_data 0 6 5 0 Table

Data for the customisable user fields

label 0 3 6 0 Table

Defines labels

mnet_service 3 0 5 0 Table

A service is a group of functions

analytics_used_analysables 0 3 6 0 Table

List of analysables used by each model

quiz_slot_tags 0 6 4 0 Table

Stores data about the tags that a question must have so that

forum_read 0 9 7 0 Table

Tracks each users read posts

forum_discussions 12 3 14 0 Table

Forums are composed of discussions

user_info_field 0 3 20 0 Table

Customisable user profile fields

page 0 3 13 0 Table

Each record is one page and its config data

enrol_lti_lti2_consumer 15 0 19 0 Table

LTI consumers interacting with moodle

scorm_seq_rulecond 0 5 7 0 Table

SCORM2004 rule condition

wiki_synonyms 0 6 4 0 Table

Stores wiki pages synonyms

question_usages 6 3 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 3 7 0 Table

Stores all the actual chat messages

external_services 9 0 11 0 Table

built in and custom external services

grading_areas 3 3 5 0 Table

Identifies gradable areas where advanced grading can happen.

scale_history 0 9 11 0 Table

History table

role_context_levels 0 3 3 0 Table

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

stats_user_monthly 0 4 8 0 Table

To accumulate monthly stats per course/user

user_enrolments 0 9 9 0 Table

Users participating in courses (aka enrolled users) - everyb

lesson_timer 0 3 7 0 Table

lesson timer for each lesson

qtype_ddimageortext_drags 0 3 6 0 Table

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

role_assignments 0 9 9 0 Table

assigning roles in different context

portfolio_instance_user 0 6 5 0 Table

user data for portfolio instances.

assignfeedback_comments 0 6 5 0 Table

Text feedback for submitted assignments

choice_answers 0 6 5 0 Table

choices performed by users

capabilities 3 0 6 0 Table

this defines all capabilities

badge_external_backpack 6 3 6 0 Table

Defines settings for site level backpacks that a user can co

groups_members 0 6 6 0 Table

Link a user to a group.

enrol_lti_lti2_resource_link 9 9 9 0 Table

Link from the consumer to the tool

scorm 9 0 42 0 Table

each table is one SCORM module and its configuration

course 154 3 36 0 Table

Central course table

question 85 12 20 0 Table

The questions themselves

stats_weekly 0 4 7 0 Table

To accumulate weekly stats

qtype_ddmarker_drops 0 3 6 0 Table

drop regions

lesson_grades 0 3 6 0 Table

Defines lesson_grades

log_queries 0 0 9 0 Table

Logged database queries.

backup_logs 0 3 5 0 Table

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

user_info_category 3 0 3 0 Table

Customisable fields categories

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

Maintains list of contact requests between users

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

Information about how and when an local courses were publish

grade_outcomes_history 0 12 12 0 Table

History table

book 3 0 11 0 Table

Defines book

lti_submission 0 3 9 0 Table

Keeps track of individual submissions for LTI activities.

portfolio_mahara_queue 0 3 3 0 Table

maps mahara tokens to transfer ids

oauth2_endpoint 0 3 7 0 Table

Describes the named endpoint for an oauth2 service.

analytics_models_log 0 3 12 0 Table

Analytic models changes during evaluation.

competency_userevidencecomp 0 3 6 0 Table

Relationship between user evidence and competencies

sessions 0 3 9 0 Table

Database based session storage - now recommended

question_calculated_options 0 3 13 0 Table

Options for questions of type calculated

repository_instances 7 1 10 0 Table

This table contains one entry for every configured external

forum 22 0 29 0 Table

Forums contain and structure discussion

feedback_completed 0 4 7 0 Table

filled out feedback

assign_user_flags 0 6 8 0 Table

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

gradingform_guide_comments 0 3 5 0 Table

frequently used comments used in marking guide

grade_settings 0 3 4 0 Table

gradebook settings

course_format_options 0 3 6 0 Table

Stores format-specific options for the course or course sect

course_sections 0 3 10 0 Table

to define the sections for each course

enrol_lti_lti2_nonce 0 3 4 0 Table

Nonce used for authentication between moodle and a consumer

portfolio_tempdata 3 6 6 0 Table

stores temporary data for portfolio exports. the id of this

files_reference 3 3 5 0 Table

Store files references

tool_brickfield_results 1 2 4 0 Table

Results of the accessibility checks

mnet_log 0 3 13 0 Table

Store session data from users migrating to other sites

course_completion_defaults 0 6 8 0 Table

Default settings for activities completion

log 0 3 10 0 Table

Every action is logged as far as possible

block_recentlyaccesseditems 0 9 5 0 Table

Most recently accessed items accessed by a user

qtype_multichoice_options 0 3 14 0 Table

Options for multiple choice questions

task_log 0 0 13 0 Table

The log table for all tasks

blog_external 0 3 9 0 Table

External blog links used for RSS copying of blog entries to

tool_usertours_steps 0 3 8 0 Table

Steps in an tour

quiz_feedback 0 3 6 0 Table

Feedback given to students based on which grade band their o

lesson_overrides 0 9 11 0 Table

The overrides to lesson settings.

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

Stores refresh tokens which can be exchanged for access toke

events_queue_handlers 0 6 6 0 Table

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

analytics_predict_samples 0 3 8 0 Table

Samples already used for predictions.

question_numerical_units 0 3 4 0 Table

Optional unit options for numerical questions. This table is

quiz_slots 3 9 9 0 Table

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

cohort_members 0 6 4 0 Table

Link a user to a cohort.

chat 9 0 10 0 Table

Each of these is a chat room

question_attempts 3 6 14 0 Table

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

comments 0 4 9 0 Table

moodle comments module

assign 29 0 30 0 Table

This table saves information about an instance of mod_assign

portfolio_log 0 6 11 0 Table

log of portfolio transfers (used to later check for duplicat

course_modules_completion 0 3 7 0 Table

Stores the completion state (completed or not completed, etc

favourite 0 6 9 0 Table

Stores the relationship between an arbitrary item (itemtype,

qtype_ddimageortext 0 3 10 0 Table

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

gradingform_rubric_fillings 0 6 6 0 Table

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

glossary_categories 3 3 4 0 Table

all categories for glossary entries

competency_plan 0 3 13 0 Table

Learning plans

chat_users 0 3 12 0 Table

Keeps track of which users are in which chat rooms

grading_definitions 12 9 14 0 Table

Contains the basic information about an advanced grading for

tool_brickfield_summary 0 1 27 0 Table

Contains accessibility check results summary information.

competency_usercompplan 0 3 10 0 Table

User competencies plans

gradingform_guide_fillings 0 6 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 3 10 0 Table

Defines the question-type specific options for matching ques

badge_manual_award 0 12 6 0 Table

Track manual award criteria for badges

question_multianswer 0 3 3 0 Table

Options for multianswer questions

tag 9 6 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 6 5 0 Table

Files that have already been used for training and predictio

forum_discussion_subs 0 9 5 0 Table

Users may choose to subscribe and unsubscribe from specific

mnet_host 6 3 15 0 Table

Information about the local and remote hosts for RPC

tool_recyclebin_category 0 3 5 0 Table

A list of items in the category recycle bin

forum_track_prefs 0 4 3 0 Table

Tracks each users untracked forums

message_airnotifier_devices 0 3 3 0 Table

Store information about the devices registered in Airnotifie

workshop_aggregations 0 6 5 0 Table

Aggregated grades for assessment are stored here. The aggreg

wiki_versions 0 3 7 0 Table

Stores wiki page history

question_calculated 0 3 7 0 Table

Options for questions of type calculated

role_allow_assign 0 6 3 0 Table

this defines what role can assign what role

filter_active 0 3 5 0 Table

Stores information about which filters are active in which c

messageinbound_messagelist 0 3 5 0 Table

A list of message IDs for existing replies

enrol 9 4 35 0 Table

Instances of enrolment plugins used in courses, fields marke

badge_criteria_param 0 3 4 0 Table

Defines parameters for badges criteria

wiki 3 0 13 0 Table

Stores Wiki activity configuration

competency_templatecohort 0 4 6 0 Table

Default comment for the table, please edit me

folder 0 3 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 3 7 0 Table

Plan competencies

external_functions 0 0 8 0 Table

list of all external functions

external_services_users 0 6 6 0 Table

users allowed to use services with restricted users flag

filter_config 0 3 5 0 Table

Stores per-context configuration settings for filters which

message_users_blocked 0 6 4 0 Table

Maintains lists of blocked users

block 3 0 5 0 Table

contains all installed blocks

competency_relatedcomp 0 3 6 0 Table

Related competencies

glossary_entries 6 3 16 0 Table

all glossary entries

data 6 0 37 0 Table

all database activities

block_rss_client 0 3 9 0 Table

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

question_truefalse 0 3 4 0 Table

Options for True-False questions

lti 9 3 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 3 5 0 Table

Course completion aggregation methods for criteria

assignfeedback_editpdf_quick 0 3 5 0 Table

Stores teacher specified quicklist comments

blog_association 0 6 3 0 Table

Associations of blog entries with courses and module instanc

tool_customlang 0 3 11 0 Table

Contains the working checkout of all strings and their custo

enrol_lti_lti2_tool_proxy 0 3 6 0 Table

A tool proxy between moodle and a consumer

choice 6 0 19 0 Table

Available choices are stored here

external_tokens 0 12 13 0 Table

Security tokens for accessing of external services

oauth2_access_token 0 3 8 0 Table

Stores access tokens for system accounts in order to be able

events_handlers 3 0 8 0 Table

This table is for storing which components requests what typ

messageinbound_datakeys 0 3 6 0 Table

Inbound Message data item secret keys.

question_attempt_step_data 0 3 4 0 Table

Each question_attempt_step has an associative array of the d

message_email_messages 0 9 4 0 Table

Keeps track of what emails to send in an email digest

search_index_requests 0 3 7 0 Table

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

block_recent_activity 0 4 7 0 Table

Recent activity block

h5p_libraries 15 0 20 0 Table

Stores information about libraries used by H5P content.

lti_access_tokens 0 3 7 0 Table

Security tokens for accessing of LTI services

data_fields 3 3 16 0 Table

every field available

badge_backpack 6 6 7 0 Table

Defines settings for connecting external backpack

scorm_aicc_session 0 6 12 0 Table

Used by AICC HACP to store session information

tool_dataprivacy_purposerole 0 6 10 0 Table

Data purpose overrides for a specific role

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

Options for questions of type numerical This table is also u

role_allow_override 0 6 3 0 Table

this defines what role can override what role

user 355 0 49 0 Table

One record for each person, custom profile fields can be added via /user/profile/index.php

grade_import_newitem 3 3 4 0 Table

temporary table for storing new grade_item names from grade

tool_dataprivacy_ctxlevel 0 6 7 0 Table

Default comment for the table, please edit me

tool_customlang_components 3 0 3 0 Table

Contains the list of all installed plugins that provide thei

message_user_actions 0 6 5 0 Table

Stores all per-user actions on individual messages

quiz_overrides 0 9 9 0 Table

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