Tables


SchemaSpy Analysis of Moodle 4.3 database structure

Generated on Sat Oct 21 22:21 BST 2023

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

XML Representation
Insertion Order Deletion Order
TABLES 485
VIEWS 0
COLUMNS 4399
Constraints 667
Anomalies 57
Routines 0

Database Properties

Database Type: MySQL - 8.0.34-0ubuntu0.22.04.1

Schema mdl43_er

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

Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting.

groups 30 6 12 0 Table

Each record represents a group.

tool_policy_acceptances 0 18 9 0 Table

Tracks users accepting the policy versions

lesson_answers 6 12 13 0 Table

Defines lesson_answers

scorm_scoes_data 0 6 4 0 Table

Contains variable data get from packages

data_records 6 12 7 0 Table

every record introduced

h5p_library_dependencies 0 12 4 0 Table

Stores H5P library dependencies

upgrade_log 0 6 10 0 Table

Upgrade logging

stats_daily 0 7 7 0 Table

to accumulate daily stats

reportbuilder_schedule 0 24 19 0 Table

Table to represent a report schedule

communication_customlink 0 1 3 0 Table

Stores the link associated with a custom link communication instance.

stats_monthly 0 7 7 0 Table

To accumulate monthly stats

badge_issued 6 12 8 0 Table

Defines issued badges

tool_dataprivacy_contextlist 2 0 4 0 Table

List of contexts for a component

reportbuilder_filter 0 18 10 0 Table

Table to represent a report filter/condition

scorm_attempt 1 2 4 0 Table

List of SCORM attempts made by user.

moodlenet_share_progress 0 1 8 0 Table

Records MoodleNet share progress

search_simpledb_index 0 2 14 0 Table

search_simpledb table containing the index data.

file_conversion 0 18 11 0 Table

Table to track file conversions.

competency_coursecomp 0 16 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 6 13 14 0 Table

Each row represents a resource link for a platform and deployment

lesson_attempts 0 18 9 0 Table

Defines lesson_attempts

survey_questions 6 0 7 0 Table

the questions conforming one survey

adminpresets_plug 0 0 5 0 Table

Admin presets plugins status, to store information about whether they are enabled or not

portfolio_instance 24 0 4 0 Table

base table (not including config data) for instances of portfolio plugins.

badge 42 18 26 0 Table

Defines badge

question_bank_entries 12 12 4 0 Table

Each question bank entry. This table has one row for each question that appears in the question bank.

user_preferences 0 12 4 0 Table

Allows modules to store arbitrary user preferences

grade_outcomes 24 18 10 0 Table

This table describes the outcomes used in the system. An outcome is a statement tied to a rubric scale from low to high, such as “Not met, Borderline, Met” (stored as 0,1 or 2)

quiz_statistics 0 0 19 0 Table

table to cache results from analysis done in statistics report for quizzes.

stats_user_daily 0 7 8 0 Table

To accumulate daily stats per course/user

role 104 0 6 0 Table

moodle roles

message 6 0 17 0 Table

Stores all unread messages

qtype_essay_options 0 6 15 0 Table

Extra options for essay questions.

message_contacts 0 18 4 0 Table

Maintains lists of contacts between users

oauth2_issuer 48 0 22 0 Table

Details for an oauth 2 connect identity issuer.

message_conversation_actions 0 12 5 0 Table

Stores all per-user actions on individual conversations

qtype_randomsamatch_options 0 6 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 editor is open.

qtype_ddmarker_drags 0 6 6 0 Table

Labels for markers to drag.

tool_dataprivacy_ctxinstance 0 18 7 0 Table

Default comment for the table, please edit me

grade_categories_history 0 24 18 0 Table

History of grade_categories

course_modules_viewed 0 1 4 0 Table

Tracks the completion viewed (viewed with cmid/userid and otherwise no row) of each user on each activity.

analytics_models 36 6 13 0 Table

Analytic models.

imscp 0 6 9 0 Table

each record is one imscp resource

role_allow_view 0 12 3 0 Table

This table stores which which other roles a user is allowed to view to if they have one role.

event_subscriptions 6 12 10 0 Table

Tracks subscriptions to remote calendars.

enrol_lti_lti2_share_key 0 6 5 0 Table

Resource link share key

course_completion_crit_compl 0 6 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 6 0 13 0 Table

Details of each application that has been registered with the tool

tag_correlation 0 6 3 0 Table

The rationale for the ‘tag_correlation’ table is performance. It works as a cache for a potentially heavy load query done at the ‘tag_instance’ table. So, the ‘tag_correlation’ table stores redundant information derived from the ‘tag_instance’ table

lti_types_categories 0 2 3 0 Table

Link LTI types to course categories

scorm_seq_ruleconds 6 6 5 0 Table

SCORM2004 rule conditions

post 6 18 19 0 Table

Generic post table to hold data blog entries etc in different modules

tool_dataprivacy_purpose 18 0 11 0 Table

Data purposes

assignfeedback_file 0 12 4 0 Table

Stores info about the number of files submitted by a student.

question_gapselect 0 6 10 0 Table

Defines select missing words questions

quiz_overview_regrades 0 12 7 0 Table

This table records which question attempts need regrading and the grade they will be regraded to.

qtype_shortanswer_options 0 6 3 0 Table

Options for short answer questions

user_password_resets 0 6 5 0 Table

table tracking password reset confirmation tokens

feedback_valuetmp 0 5 6 0 Table

values of the completedstmp

modules 6 0 6 0 Table

modules available in the site

feedback_sitecourse_map 0 7 3 0 Table

feedback sitecourse map

scorm_seq_mapinfo 0 12 8 0 Table

SCORM2004 objective mapinfo description

choice_options 6 6 5 0 Table

available options to choice

lesson 42 0 42 0 Table

Defines lesson for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Lesson_Activity

lti_types 19 0 18 0 Table

Basic LTI pre-configured activities

license 0 0 8 0 Table

store licenses used by moodle

lesson_branch 0 12 8 0 Table

branches for each lesson/user

bigbluebuttonbn_logs 0 2 8 0 Table

The bigbluebuttonbn table to store meeting activity events

reportbuilder_audience 0 18 9 0 Table

Defines report audience

cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

analytics_indicator_calc 0 6 9 0 Table

Stored indicator calculations

message_popup_notifications 0 6 2 0 Table

List of notifications to display in the message output popup

customfield_data 0 12 12 0 Table

core_customfield data table

scorm_seq_rolluprule 6 6 7 0 Table

SCORM2004 sequencing rule

wiki_locks 0 6 5 0 Table

Manages page locks

oauth2_user_field_mapping 0 12 7 0 Table

Mapping of oauth user fields to moodle fields.

auth_oauth2_linked_login 0 18 10 0 Table

Accounts linked to a users Moodle account.

role_capabilities 0 24 7 0 Table

permission has to be signed, overriding a capability for a particular role in a particular context

survey_analysis 0 6 4 0 Table

text about each survey submission

badge_criteria_met 0 18 5 0 Table

Defines criteria that were met for an issued badge

feedback 23 0 17 0 Table

all feedbacks

workshop_grades 0 6 7 0 Table

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

reportbuilder_column 0 18 13 0 Table

Table to represent a report column

qtype_ddmarker 0 6 11 0 Table

Defines drag and drop (text or images onto a background image) questions

mnet_remote_service2rpc 0 0 3 0 Table

Group functions or methods under a service

feedback_item 11 12 13 0 Table

feedback_items

infected_files 0 6 6 0 Table

Table to store infected file details.

competency_template 18 12 10 0 Table

Learning plan templates.

workshop_assessments 6 18 15 0 Table

Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher.

grade_letters 0 6 4 0 Table

Repository for grade letters, for courses and other moodle entities that use grades.

paygw_paypal 0 6 3 0 Table

Stores PayPal related information

enrol_flatfile 0 18 8 0 Table

enrol_flatfile table retrofitted from MySQL

analytics_train_samples 0 6 6 0 Table

Samples used for training

assign_submission 13 6 10 0 Table

This table keeps information about student interactions with the mod/assign. This is limited to metadata about a student submission but does not include the submission itself which is stored by plugins.

adminpresets_it_a 0 0 4 0 Table

Admin presets items attributes. For settings with attributes (extra values like ‘advanced’)

mnet_application 6 0 6 0 Table

Information about applications on remote hosts

tool_dataprivacy_category 12 0 7 0 Table

Data categories

lti_coursevisible 0 1 4 0 Table

Table to store coursevisible setting for site tool on course level

survey_answers 0 12 7 0 Table

the answers to each questions filled by the users

forum_queue 0 12 5 0 Table

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

tag_area 0 6 9 0 Table

Defines various tag areas, one area is identified by component and itemtype

backup_controllers 6 6 17 0 Table

To store the backup_controllers as they are used

analytics_predictions 6 12 11 0 Table

Predictions

scorm_element 1 0 2 0 Table

List of scorm elements.

ltiservice_gradebookservices 0 3 11 0 Table

This file records the grade items created by the LTI Gradebook Services service

tool_dataprivacy_ctxlst_ctx 0 2 6 0 Table

A contextlist context item

repository_onedrive_access 0 6 6 0 Table

List of temporary access grants.

tool_brickfield_checks 6 0 6 0 Table

Checks details

h5p 6 6 9 0 Table

Stores H5P content information

lti_tool_settings 0 24 8 0 Table

LTI tool setting values

assign_grades 30 6 8 0 Table

Grading information about a single assignment submission.

course_categories 37 12 14 0 Table

Course categories

quiz_reports 0 0 4 0 Table

Lists all the installed quiz reports and their display order and so on. No need to worry about deleting old records. Only records with an equivalent directory are displayed.

portfolio_instance_config 0 6 4 0 Table

config for portfolio plugin instances

resource_old 0 1 16 0 Table

backup of all old resource instances from 1.9

forum_grades 0 6 7 0 Table

Grading data for forum instances

user_lastaccess 0 13 4 0 Table

To keep track of course page access times, used in online participants block, and participants list

scorm_scoes_value 0 3 6 0 Table

Values passed from SCORM package

badge_backpack_oauth2 0 24 11 0 Table

Default comment for the table, please edit me

survey 12 0 11 0 Table

Defines badge for reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Badges

workshopeval_best_settings 0 6 3 0 Table

Settings for the grading evaluation subplugin Comparison with the best assessment.

quiz_attempts 0 18 16 0 Table

Stores users attempts at quizzes.

backup_courses 0 6 6 0 Table

To store every course backup status

tool_usertours_tours 6 0 9 0 Table

List of tours

oauth2_system_account 0 12 9 0 Table

Stored details used to get an access token as a system user for this oauth2 service.

question_hints 0 6 7 0 Table

Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours.

cohort 13 6 11 0 Table

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

payment_accounts 12 6 8 0 Table

Payment accounts

workshop 66 6 37 0 Table

This table keeps information about the module instances and their settings

question_statistics 0 12 18 0 Table

Statistics for individual questions used in an activity.

h5pactivity_attempts 6 6 12 0 Table

Users attempts inside H5P activities

groupings_groups 0 12 4 0 Table

Link a grouping to a group (note, groups can be in multiple groupings ONLY in a course). WAS: groups_groupings_groups

registration_hubs 0 0 7 0 Table

hub where the site is registered on with their associated token

glossary 12 1 28 0 Table

all glossaries

url 0 6 10 0 Table

each record is one url resource

mnet_session 0 18 9 0 Table

Store session data from users migrating to other sites

competency_templatecomp 0 23 7 0 Table

Link a competency to a learning plan template.

badge_external_identifier 0 6 5 0 Table

Setting for external badges mappings

glossary_entries_categories 0 12 3 0 Table

categories of each glossary entry

enrol_paypal 0 24 21 0 Table

Holds all known information about PayPal transactions

role_allow_switch 0 12 3 0 Table

This table stores which which other roles a user is allowed to switch to if they have one role.

badge_alignment 0 6 7 0 Table

Defines alignment for badges

qtype_ddimageortext_drops 0 6 7 0 Table

Drop boxes

notifications 6 6 15 0 Table

Stores all notifications

question_categories 18 7 9 0 Table

Categories are for grouping questions

tool_dataprivacy_rqst_ctxlst 0 2 3 0 Table

Association table joining requests and contextlists

assignsubmission_file 0 11 4 0 Table

Info about file submissions for assignments

message_conversation_members 0 12 4 0 Table

Stores all members in a conversations

task_adhoc 0 6 12 0 Table

List of adhoc tasks waiting to run.

contentbank_content 0 18 11 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 24 24 31 0 Table

This table keeps information about gradeable items (ie columns). If an activity (eg an assignment or quiz) has multiple grade_items associated with it (eg several outcomes or numerical grades), then there will be a corresponding multiple number of rows in this table.

book_chapters 0 6 11 0 Table

Defines book_chapters

adminpresets_app_it 0 1 3 0 Table

Admin presets applied items. To maintain the relation with config_log

block_instances 6 12 12 0 Table

This table stores block instances. The type of block this is is given by the blockname column. The places this block instance appears is controlled by the parentcontexid, showinsubcontexts, pagetypepattern and subpagepattern fields. Where the block appears on the page (by default) is controlled by the defaultposition and defaultweight columns. The block’s own configuration is stored serialized in configdata.

badge_external 0 6 5 0 Table

Setting for external badges display

question_response_count 0 6 4 0 Table

Count for each responses for each try at a question.

grade_grades_history 0 36 24 0 Table

History table

question_response_analysis 6 6 10 0 Table

Analysis of student responses given to questions.

mnet_service2rpc 0 6 3 0 Table

Group functions or methods under a service

tool_brickfield_cache_acts 0 6 8 0 Table

Contains accessibility summary information per activity.

lti_tool_proxies 6 0 13 0 Table

LTI tool proxy registrations

scorm_seq_rolluprulecond 0 11 5 0 Table

SCORM2004 sequencing rule

grade_import_values 0 24 9 0 Table

Temporary table for importing grades

grade_outcomes_courses 0 12 3 0 Table

stores what outcomes are used in what courses.

workshop_submissions 6 18 19 0 Table

Info about the submission and the aggregation of the grade for submission, grade for assessment and final grade. Both grade for submission and grade for assessment can be overridden by teacher. Final grade is always the sum of them. All grades are stored as of 0-100.

enrol_lti_lti2_user_result 0 6 6 0 Table

Results for each user for each resource link

event 0 13 24 0 Table

For everything with a time associated to it

badge_endorsement 0 6 8 0 Table

Defines endorsement for badge

tool_dataprivacy_ctxexpired 0 6 9 0 Table

Default comment for the table, please edit me

config 2 0 3 0 Table

Moodle configuration variables

workshopform_comments 0 6 5 0 Table

The assessment dimensions definitions of Comments strategy forms

mnet_sso_access_control 0 1 4 0 Table

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

question_dataset_definitions 6 6 6 0 Table

Organises and stores properties for dataset items

scale 60 7 8 0 Table

Defines grading scales

analytics_prediction_actions 0 12 5 0 Table

Register of user actions over predictions.

tool_policy 6 6 3 0 Table

Contains the list of policy documents defined on the site.

files 18 18 20 0 Table

description of files, content is stored in sha1 file pool meaning no duplicate storage https://docs.moodle.org/en/ad-hoc_contributed_reports#List_course_resources_accumulative_file_size_and_count

competency_usercompcourse 0 12 9 0 Table

User competencies in a course

feedback_template 6 0 4 0 Table

templates of feedbackstructures

tool_brickfield_cache_check 0 6 6 0 Table

Contains accessibility summary information per check.

enrol_lti_deployment 18 6 7 0 Table

Each row represents a deployment of a tool within a platform.

wiki_subwikis 18 6 4 0 Table

Stores subwiki instances

mnetservice_enrol_courses 0 1 14 0 Table

Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users

question_datasets 0 12 3 0 Table

Many-many relation between questions and dataset definitions

assign_overrides 0 18 9 0 Table

The overrides to assign settings.

h5pactivity_attempts_results 0 6 14 0 Table

H5Pactivities_attempts tracking info

user_private_key 0 6 8 0 Table

access keys used in cookieless scripts - rss, etc.

feedback_completedtmp 0 6 8 0 Table

filled out feedback

h5pactivity 6 6 12 0 Table

Stores the h5pactivity activity module instances.

wiki_links 0 12 5 0 Table

Page wiki links

quizaccess_seb_quizsettings 0 24 29 0 Table

Stores the quiz level Safe Exam Browser configuration.

gradingform_guide_criteria 6 6 9 0 Table

Stores the rows of the criteria grid.

message_read 0 6 17 0 Table

Stores all messages that have been read

events_queue 6 6 5 0 Table

This table is for storing queued events. It stores only one copy of the eventdata here, and entries from this table are being references by the event_queue_handlers table.

badge_criteria 12 6 6 0 Table

Defines criteria for issuing badges

quiz_sections 0 6 5 0 Table

Stores sections of a quiz with section name (heading), from slot-number N and whether the question order should be shuffled.

forum_digests 0 12 4 0 Table

Keeps track of user mail delivery preferences for each forum

enrol_lti_context 6 6 6 0 Table

Each row represents a context in the platform, where resource links are added within a deployment.

forum_subscriptions 0 6 3 0 Table

Keeps track of who is subscribed to what forum

assign_user_mapping 0 12 3 0 Table

Map an assignment specific id number to a user

wiki_pages 24 6 10 0 Table

Stores wiki pages

competency_coursecompsetting 0 12 6 0 Table

This table contains the course specific settings for competencies.

payment_gateways 0 6 7 0 Table

Configuration for one gateway for one payment account

tool_brickfield_errors 0 6 5 0 Table

Errors during the accessibility checks

message_popup 0 6 3 0 Table

Keep state of notifications for the popup message processor

repository_instance_config 0 7 4 0 Table

The config for intances

lti_types_config 0 6 4 0 Table

Basic LTI types configuration

data_content 0 12 8 0 Table

the content introduced in each record/fields

assignfeedback_editpdf_cmnt 0 6 9 0 Table

Stores comments added to pdfs

context 250 0 6 0 Table

one of these must be set

groupings 12 5 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/field

role_names 0 12 4 0 Table

role names in native strings

question_references 0 12 7 0 Table

Records where a specific question is used.

tool_mfa_auth 0 1 3 0 Table

Stores the last time a successful MFA auth was registered for a userid

competency_userevidence 0 11 9 0 Table

The evidence of prior learning

course_completions 0 6 7 0 Table

Course completion records

assignsubmission_onlinetext 0 12 5 0 Table

Info about onlinetext submission

tool_monitor_subscriptions 6 7 8 0 Table

Table to store user subscriptions to various rules

payments 6 12 11 0 Table

Stores information about payments

enrol_lti_users 6 18 13 0 Table

User access log and gradeback data

customfield_category 6 6 11 0 Table

core_customfield category table

gradingform_rubric_criteria 12 6 5 0 Table

Stores the rows of the rubric grid.

user_password_history 0 6 4 0 Table

A rotating log of hashes of previously used passwords for each user.

feedback_value 0 6 6 0 Table

values of the completeds

config_log 0 6 7 0 Table

Changes done in server configuration through admin UI

competency_framework 6 18 13 0 Table

List of competency frameworks.

profiling 0 0 11 0 Table

Stores the results of all the profiling runs

scorm_seq_objective 6 6 6 0 Table

SCORM2004 objective description

rating 0 18 10 0 Table

moodle ratings

my_pages 0 6 5 0 Table

Extra user pages for the My Moodle system

competency_modulecomp 0 24 9 0 Table

Link a competency to a module.

grade_items_history 0 36 34 0 Table

History of grade_items

enrol_lti_tool_consumer_map 0 12 3 0 Table

Table that maps the published tool to tool consumers.

course_completion_criteria 0 6 10 0 Table

Course completion criteria

h5p_libraries_cachedassets 0 6 3 0 Table

H5P cached library assets

assignfeedback_editpdf_rot 0 6 6 0 Table

Stores rotation information of a page.

course_modules 36 12 24 0 Table

course_modules table retrofitted from MySQL

forum_posts 18 12 18 0 Table

All posts are stored in this table

tool_recyclebin_course 0 6 6 0 Table

A list of items in the course recycle bin

glossary_alias 0 6 3 0 Table

entries alias

grade_grades 6 24 23 0 Table

grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers might change this for an activity! All the results are normalised/resampled for the final grade value.

tool_brickfield_schedule 0 1 7 0 Table

Keeps the per course content analysis schedule.

scorm_scoes 41 6 10 0 Table

each SCO part of the SCORM module

stats_user_weekly 0 7 8 0 Table

To accumulate weekly stats per course/user

chat_messages_current 0 6 7 0 Table

Stores current session

enrol_lti_tools 12 12 23 0 Table

List of tools provided to the remote system

gradingform_rubric_levels 0 6 5 0 Table

Stores the columns of the rubric grid.

workshopform_accumulative 0 6 7 0 Table

The assessment dimensions definitions of Accumulative grading strategy forms

tool_monitor_history 0 6 4 0 Table

Table to store history of message notifications sent

competency_usercomp 6 12 10 0 Table

User competencies

tag_coll 12 0 7 0 Table

Defines different set of tags

tool_brickfield_content 6 6 7 0 Table

Content of an area at a particular time (recognised by a hash)

mnetservice_enrol_enrolments 0 12 7 0 Table

Caches the information about enrolments of our local users in courses on remote hosts

external_services_functions 0 6 3 0 Table

lists functions available in each service group

message_conversations 24 6 11 0 Table

Stores all message conversations

messages 12 12 11 0 Table

Stores all messages

h5p_contents_libraries 0 12 6 0 Table

Store which library is used in which content.

competency 78 18 17 0 Table

This table contains the master record of each competency in a framework

resource 1 6 13 0 Table

Each record is one resource and its config data

tag_instance 0 12 10 0 Table

tag_instance table holds the information of associations between tags and other items

user_devices 6 6 12 0 Table

This table stores user’s mobile devices information in order to send PUSH notifications

question_ddwtos 0 6 10 0 Table

Defines drag and drop (words into sentences) questions

grade_categories 30 12 14 0 Table

This table keeps information about categories, used for grouping items.

question_set_references 0 12 7 0 Table

Records where groups of questions are used.

assign_plugin_config 0 6 6 0 Table

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

quiz 42 0 42 0 Table

The settings for each quiz. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Quiz_Activity

tool_cohortroles 0 7 7 0 Table

Mapping of users to cohort role assignments.

question_attempt_steps 6 12 7 0 Table

Stores one step in in a question attempt. As well as the data here, the step will have some data in the question_attempt_step_data table.

auth_lti_linked_login 0 6 8 0 Table

Accounts linked to a users Moodle account.

repository 0 0 4 0 Table

This table contains one entry for every configured external repository instance.

lesson_pages 18 6 13 0 Table

Defines lesson_pages

adminpresets_it 0 0 5 0 Table

Table to store settings

message_providers 0 0 4 0 Table

This table stores the message providers (modules and core systems)

assignfeedback_editpdf_annot 0 6 11 0 Table

stores annotations added to pdfs submitted by students

bigbluebuttonbn 8 0 44 0 Table

The bigbluebuttonbn table to store information about a meeting activities.

badge_related 0 12 3 0 Table

Defines badge related for badges

tool_dataprivacy_request 1 24 15 0 Table

Table for data requests

workshopform_numerrors 0 6 9 0 Table

The assessment dimensions definitions of Number of errors grading strategy forms

block_positions 0 12 8 0 Table

Stores the position of a sticky block_instance on a another page than the one where it was added.

tool_brickfield_areas 6 24 13 0 Table

Areas that have been checked for accessibility problems

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

The subquestions that make up a matching question

customfield_field 6 6 11 0 Table

core_customfield field table

question_numerical 0 6 4 0 Table

Options for numerical questions.

messageinbound_handlers 6 0 6 0 Table

Inbound Message Handler definitions.

user_info_data 0 12 5 0 Table

Data for the customisable user fields

label 0 6 6 0 Table

Defines labels

mnet_service 6 0 5 0 Table

A service is a group of functions

analytics_used_analysables 0 6 6 0 Table

List of analysables used by each model

forum_read 0 18 7 0 Table

Tracks each users read posts

forum_discussions 24 12 14 0 Table

Forums are composed of discussions

user_info_field 0 6 20 0 Table

Customisable user profile fields

page 0 6 13 0 Table

Each record is one page and its config data

workshopform_rubric 6 12 5 0 Table

The assessment dimensions definitions of Rubric grading strategy forms

enrol_lti_lti2_consumer 30 0 19 0 Table

LTI consumers interacting with moodle

scorm_seq_rulecond 0 11 7 0 Table

SCORM2004 rule condition

wiki_synonyms 0 12 4 0 Table

Stores wiki pages synonyms

question_usages 12 6 4 0 Table

This table’s main purpose it to assign a unique id to each attempt at a set of questions by some part of Moodle. A question usage is made up of a number of question_attempts.

tool_monitor_events 0 18 8 0 Table

A table that keeps a log of events related to subscriptions

chat_messages 0 6 7 0 Table

Stores all the actual chat messages

external_services 18 0 11 0 Table

built in and custom external services

tool_mfa 0 0 11 0 Table

Table to store factor configurations for users

grading_areas 6 6 5 0 Table

Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set.

role_context_levels 0 6 3 0 Table

Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table.

scale_history 0 24 11 0 Table

History table

stats_user_monthly 0 7 8 0 Table

To accumulate monthly stats per course/user

user_enrolments 0 18 9 0 Table

Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students

lesson_timer 0 6 7 0 Table

lesson timer for each lesson

qtype_ddimageortext_drags 0 6 6 0 Table

Images to drag. Actual file names are not stored here we use the file names as found in the file storage area.

role_assignments 0 18 9 0 Table

assigning roles in different context

portfolio_instance_user 0 12 5 0 Table

user data for portfolio instances.

assignfeedback_comments 0 12 5 0 Table

Text feedback for submitted assignments

capabilities 6 0 6 0 Table

this defines all capabilities

choice_answers 0 12 5 0 Table

choices performed by users

badge_external_backpack 12 6 6 0 Table

Defines settings for site level backpacks that a user can connect to.

groups_members 0 12 6 0 Table

Link a user to a group.

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

each table is one SCORM module and its configuration

course 364 12 37 0 Table

Central course table. For reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#COURSE_REPORTS

question 180 18 16 0 Table

This table stores the definition of one version of a question.

communication_user 0 2 5 0 Table

Communication user records mapping

stats_weekly 0 7 7 0 Table

To accumulate weekly stats

qtype_ddmarker_drops 0 6 6 0 Table

drop regions

lesson_grades 0 6 6 0 Table

Defines lesson_grades

log_queries 0 0 9 0 Table

Logged database queries.

tool_mfa_secrets 0 1 8 0 Table

Table to store factor secrets

backup_logs 0 6 5 0 Table

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

user_info_category 6 0 3 0 Table

Customisable fields categories

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

Maintains list of contact requests between users

bigbluebuttonbn_recordings 0 13 12 0 Table

The bigbluebuttonbn table to store references to recordings

enrol_lti_lti2_context 6 6 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 6 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 1 1 0 Table
context_temp 0 0 4 0 Table

Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.

course_published 0 12 8 0 Table

Information about how and when an local courses were published to hubs

grade_outcomes_history 0 24 12 0 Table

History table

book 6 6 11 0 Table

Defines book

lti_submission 0 6 9 0 Table

Keeps track of individual submissions for LTI activities.

portfolio_mahara_queue 0 6 3 0 Table

maps mahara tokens to transfer ids

oauth2_endpoint 0 12 7 0 Table

Describes the named endpoint for an oauth2 service.

analytics_models_log 0 12 12 0 Table

Analytic models changes during evaluation.

competency_userevidencecomp 0 11 6 0 Table

Relationship between user evidence and competencies

sessions 0 6 9 0 Table

Database based session storage - now recommended

question_calculated_options 0 6 13 0 Table

Options for questions of type calculated

repository_instances 13 12 10 0 Table

This table contains one entry for every configured external repository instance.

forum 43 0 29 0 Table

Forum discussion system. For sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#Forum_Activity

feedback_completed 0 12 7 0 Table

filled out feedback

assign_user_flags 0 12 8 0 Table

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

grade_settings 0 6 4 0 Table

gradebook settings

gradingform_guide_comments 0 6 5 0 Table

frequently used comments used in marking guide

course_format_options 0 6 6 0 Table

Stores format-specific options for the course or course section

course_sections 0 6 10 0 Table

to define the sections for each course

logstore_standard_log 0 31 21 0 Table

Standard log table

enrol_lti_lti2_nonce 0 6 4 0 Table

Nonce used for authentication between moodle and a consumer

portfolio_tempdata 12 12 6 0 Table

stores temporary data for portfolio exports. the id of this table is used for the itemid for the temporary files area. cron can clean up stale records (and associated file data) after expirytime.

files_reference 6 6 5 0 Table

Store files references

tool_brickfield_results 6 12 4 0 Table

Results of the accessibility checks

adminpresets_app 0 0 4 0 Table

Applied presets

mnet_log 0 6 13 0 Table

Store session data from users migrating to other sites

course_completion_defaults 0 12 9 0 Table

Default settings for activities completion

log 0 6 10 0 Table

Every action is logged as far as possible

block_recentlyaccesseditems 0 18 5 0 Table

Most recently accessed items accessed by a user

qtype_multichoice_options 0 6 14 0 Table

Options for multiple choice questions

workshopform_numerrors_map 0 6 4 0 Table

This maps the number of errors to a percentual grade for submission

task_log 0 6 13 0 Table

The log table for all tasks

blog_external 0 6 9 0 Table

External blog links used for RSS copying of blog entries to Moodle user blogs

tool_usertours_steps 0 6 9 0 Table

Steps in an tour

quiz_feedback 0 6 6 0 Table

Feedback given to students based on which grade band their overall score lies.

lesson_overrides 0 18 11 0 Table

The overrides to lesson settings.

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

Stores refresh tokens which can be exchanged for access tokens

events_queue_handlers 0 12 6 0 Table

This is the list of queued handlers for processing. The event object is retrieved from the events_queue table. When no further reference is made to the event_queues table, the corresponding entry in the events_queue table should be deleted. Entry should get deleted after a successful event processing by the specified handler.

analytics_predict_samples 0 6 8 0 Table

Samples already used for predictions.

question_numerical_units 0 6 4 0 Table

Optional unit options for numerical questions. This table is also used by the calculated question type.

quiz_slots 0 6 7 0 Table

Stores the question used in a quiz, with the order, and for each question, which page it appears on, and the maximum mark (weight).

cohort_members 0 12 4 0 Table

Link a user to a cohort.

chat 18 0 10 0 Table

Each of these is a chat room

question_attempts 18 12 14 0 Table

Each row here corresponds to an attempt at one question, as part of a question_usage. A question_attempt will have some question_attempt_steps

comments 0 7 9 0 Table

moodle comments module

assign 59 0 34 0 Table

This table saves information about an instance of mod_assign in a course. For sample reports see https://docs.moodle.org/401/en/ad-hoc_contributed_reports#Assignment_Activity

portfolio_log 0 18 11 0 Table

log of portfolio transfers (used to later check for duplicates)

course_modules_completion 0 6 6 0 Table

Stores the completion state (completed or not completed, etc) of each user on each activity.

favourite 0 12 9 0 Table

Stores the relationship between an arbitrary item (itemtype, itemid), and a context area (component, contextid) for a specific user. Used by the favourites subsystem.

qtype_ddimageortext 0 6 10 0 Table

Defines drag and drop (text or images onto a background image) questions

gradingform_rubric_fillings 0 12 6 0 Table

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

glossary_categories 6 6 4 0 Table

all categories for glossary entries

question_versions 0 12 5 0 Table

A join table linking the different question version definitions in the question table to the question_bank_entires.

competency_plan 0 12 13 0 Table

Learning plans

chat_users 0 12 12 0 Table

Keeps track of which users are in which chat rooms

grading_definitions 24 18 14 0 Table

Contains the basic information about an advanced grading form defined in the given gradable area

tool_brickfield_summary 0 6 27 0 Table

Contains accessibility check results summary information.

competency_usercompplan 0 11 10 0 Table

User competencies plans

gradingform_guide_fillings 0 12 6 0 Table

Stores the data of how the guide is filled by a particular rater

mnet_host2service 0 0 5 0 Table

Information about the services for a given host

qtype_match_options 0 6 10 0 Table

Defines the question-type specific options for matching questions

badge_manual_award 0 24 6 0 Table

Track manual award criteria for badges

adminpresets_app_plug 0 0 6 0 Table

Admin presets plugins applied

question_multianswer 0 6 3 0 Table

Options for multianswer questions

tag 12 12 10 0 Table

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

tool_brickfield_process 0 2 7 0 Table

Queued records to initiate new processing of specific targets

analytics_used_files 0 12 5 0 Table

Files that have already been used for training and prediction.

forum_discussion_subs 0 18 5 0 Table

Users may choose to subscribe and unsubscribe from specific discussions.

mnet_host 18 6 15 0 Table

Information about the local and remote hosts for RPC

tool_recyclebin_category 0 6 5 0 Table

A list of items in the category recycle bin

forum_track_prefs 0 7 3 0 Table

Tracks each users untracked forums

message_airnotifier_devices 0 6 3 0 Table

Store information about the devices registered in Airnotifier for PUSH notifications

workshop_aggregations 0 12 5 0 Table

Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions

wiki_versions 0 6 7 0 Table

Stores wiki page history

question_calculated 0 6 7 0 Table

Options for questions of type calculated

role_allow_assign 0 12 3 0 Table

this defines what role can assign what role

filter_active 0 6 5 0 Table

Stores information about which filters are active in which contexts. Also the filter sort order. See get_active_filters in lib/filterlib.php for how this data is used.

messageinbound_messagelist 0 6 5 0 Table

A list of message IDs for existing replies

xapi_states 0 0 9 0 Table

The stored xAPI states

enrol 18 12 35 0 Table

Instances of enrolment plugins used in courses, fields marked as custom have a plugin defined meaning, core does not touch them. Create a new linked table if you need even more custom fields.

badge_criteria_param 0 6 4 0 Table

Defines parameters for badges criteria

wiki 6 0 13 0 Table

Stores Wiki activity configuration

competency_templatecohort 0 12 6 0 Table

Default comment for the table, please edit me

folder 0 6 11 0 Table

each record is one folder resource

competency_evidence 0 24 14 0 Table

The evidence linked to a user competency

competency_plancomp 0 11 7 0 Table

Plan competencies

external_functions 0 0 8 0 Table

list of all external functions

adminpresets 0 0 11 0 Table

named sets of site wide configurations e.g. enable/disable features https://www.youtube.com/watch?v=CyNOhbJ76fY

external_services_users 0 12 6 0 Table

users allowed to use services with restricted users flag

filter_config 0 6 5 0 Table

Stores per-context configuration settings for filters which have them.

message_users_blocked 0 12 4 0 Table

Maintains lists of blocked users

block 6 0 5 0 Table

contains all installed blocks

competency_relatedcomp 0 24 6 0 Table

Related competencies

matrix_room 0 1 4 0 Table

Stores the matrix room information associated with the communication instance.

reportbuilder_report 24 18 15 0 Table

Table to represent a report

glossary_entries 12 6 16 0 Table

all glossary entries

data 12 0 37 0 Table

all database activities

enrol_lti_user_resource_link 0 12 3 0 Table

Join table mapping users to resource links as this is a many:many relationship

block_rss_client 0 6 9 0 Table

Remote news feed information. Contains the news feed id, the userid of the user who added the feed, the title of the feed itself and a description of the feed contents along with the url used to access the remote feed. Preferredtitle is a field for future use - intended to allow for custom titles rather than those found in the feed

question_truefalse 0 6 5 0 Table

Options for True-False questions

tiny_autosave 0 1 9 0 Table

The content of the textarea saved during autosave operations

communication 3 1 10 0 Table

Communication records

lti 20 6 26 0 Table

This table contains Basic LTI activities instances

quizaccess_seb_template 6 6 9 0 Table

Templates for Safe Exam Browser configuration.

mnet_remote_rpc 0 0 6 0 Table

This table describes functions that might be called remotely (we have less information about them than local functions)

course_completion_aggr_methd 0 6 5 0 Table

Course completion aggregation methods for criteria

assignfeedback_editpdf_quick 0 6 5 0 Table

Stores teacher specified quicklist comments

bbbext_simple 0 1 3 0 Table

Default comment for bbbext_simple, please edit me

blog_association 0 12 3 0 Table

Associations of blog entries with courses and module instances

tool_customlang 0 6 11 0 Table

Contains the working checkout of all strings and their customization

enrol_lti_lti2_tool_proxy 0 6 6 0 Table

A tool proxy between moodle and a consumer

choice 12 0 19 0 Table

Available choices are stored here

external_tokens 0 24 14 0 Table

Security tokens for accessing of external services

oauth2_access_token 0 12 8 0 Table

Stores access tokens for system accounts in order to be able to use a single token across multiple sessions

events_handlers 6 0 8 0 Table

This table is for storing which components requests what type of event, and the location of the responsible handlers. For example, the assignment registers ‘grade_updated’ event with a function assignment_grade_handler() that should be called event time an ‘grade_updated’ event is triggered by grade_update() function.

messageinbound_datakeys 0 6 6 0 Table

Inbound Message data item secret keys.

question_attempt_step_data 0 6 4 0 Table

Each question_attempt_step has an associative array of the data that was submitted by the user in the POST request. It can also contain extra data from the question type or behaviour to avoid re-computation. The convention is that names belonging to the behaviour start with -, and cached values added to the submitted data start with _, or _-

message_email_messages 0 18 4 0 Table

Keeps track of what emails to send in an email digest

search_index_requests 0 6 7 0 Table

Records requests for (re)indexing of specific contexts. Entries will be removed from this table when indexing of that context is complete. (This table is not used for normal time-based indexing of new content.)

block_recent_activity 0 7 7 0 Table

Recent activity block

h5p_libraries 30 0 20 0 Table

Stores information about libraries used by H5P content.

lti_access_tokens 0 6 7 0 Table

Security tokens for accessing of LTI services

data_fields 6 6 16 0 Table

every field available

badge_backpack 12 12 7 0 Table

Defines settings for connecting external backpack

scorm_aicc_session 0 12 12 0 Table

Used by AICC HACP to store session information

tool_dataprivacy_purposerole 0 18 10 0 Table

Data purpose overrides for a specific role

grading_instances 12 12 9 0 Table

Grading form instance is an assessment record for one gradable item assessed by one rater

course_request 0 0 9 0 Table

course requests

question_numerical_options 0 6 6 0 Table

Options for questions of type numerical This table is also used by the calculated question type

role_allow_override 0 12 3 0 Table

this defines what role can override what role

user 1035 0 49 0 Table

One record for each person, custom profile fields can be added via /user/profile/index.php for sample reports see https://docs.moodle.org/en/ad-hoc_contributed_reports#USER_and_ENROLMENT_Reports

grade_import_newitem 6 6 4 0 Table

temporary table for storing new grade_item names from grade import

tool_dataprivacy_ctxlevel 0 12 7 0 Table

Default comment for the table, please edit me

workshopform_rubric_config 0 6 3 0 Table

Configuration table for the Rubric grading strategy

tool_customlang_components 6 0 3 0 Table

Contains the list of all installed plugins that provide their own language pack

message_user_actions 0 12 5 0 Table

Stores all per-user actions on individual messages

workshopallocation_scheduled 0 6 9 0 Table

Stores the allocation settings for the scheduled allocator

quiz_overrides 0 18 9 0 Table

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