Tables


SchemaSpy Analysis of moodle3.8

Generated on Mon Mar 02 20:43 GMT 2020

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

XML Representation
Insertion Order Deletion Order
TABLES 421
VIEWS 0
COLUMNS 3822
Constraints 525
Anomalies 60
Routines 0

Database Properties

Database Type: MySQL - 5.7.25

Schema moodle3.8

The Moodle Database is Complex

Tables

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

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

groups 5 1 11 0 Table

Each record represents a group.

tool_policy_acceptances 0 3 9 0 Table

Tracks users accepting the policy versions

lesson_answers 1 2 13 0 Table

Defines lesson_answers

scorm_scoes_data 0 1 4 0 Table

Contains variable data get from packages

data_records 1 1 7 0 Table

every record introduced

h5p_library_dependencies 0 2 4 0 Table

Stores H5P library dependencies

upgrade_log 0 1 10 0 Table

Upgrade logging

stats_daily 0 2 7 0 Table

to accumulate daily stats

stats_monthly 0 2 7 0 Table

To accumulate monthly stats

badge_issued 1 2 8 0 Table

Defines issued badges

assignment_submissions 0 1 14 0 Table

Info about submitted assignments

search_simpledb_index 0 2 14 0 Table

search_simpledb table containing the index data.

file_conversion 0 2 11 0 Table

Table to track file conversions.

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

Defines lesson_attempts

survey_questions 1 0 7 0 Table

the questions conforming one survey

portfolio_instance 4 0 4 0 Table

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

badge 7 3 26 0 Table

Defines badge

user_preferences 0 2 4 0 Table

Allows modules to store arbitrary user preferences

grade_outcomes 4 3 10 0 Table

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

quiz_statistics 0 0 19 0 Table

table to cache results from analysis done in statistics repo

stats_user_daily 0 2 8 0 Table

To accumulate daily stats per course/user

role 24 0 6 0 Table

moodle roles

message 1 0 17 0 Table

Stores all unread messages

qtype_essay_options 0 1 12 0 Table

Extra options for essay questions.

message_contacts 0 3 4 0 Table

Maintains lists of contacts between users

oauth2_issuer 5 0 20 0 Table

Details for an oauth 2 connect identity issuer.

message_conversation_actions 0 2 5 0 Table

Stores all per-user actions on individual conversations

qtype_randomsamatch_options 0 1 11 0 Table

Info about a random short-answer matching question

editor_atto_autosave 0 1 9 0 Table

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

qtype_ddmarker_drags 0 1 6 0 Table

Labels for markers to drag.

assignment_upgrade 0 0 6 0 Table

Info about upgraded assignments

tool_dataprivacy_ctxinstance 0 3 7 0 Table

Default comment for the table, please edit me

grade_categories_history 0 4 18 0 Table

History of grade_categories

analytics_models 6 0 13 0 Table

Analytic models.

imscp 0 1 9 0 Table

each record is one imscp resource

role_allow_view 0 2 3 0 Table

This table stores which which other roles a user is allowed

event_subscriptions 1 1 10 0 Table

Tracks subscriptions to remote calendars.

enrol_lti_lti2_share_key 0 1 5 0 Table

Resource link share key

course_completion_crit_compl 0 1 7 0 Table

Course completion user records

mnet_rpc 0 0 11 0 Table

Functions or methods that we may publish or subscribe to

tag_correlation 0 1 3 0 Table

The rationale for the ‘tag_correlation’ table is performance

scorm_seq_ruleconds 1 1 5 0 Table

SCORM2004 rule conditions

post 1 3 19 0 Table

Generic post table to hold data blog entries etc in differen

tool_dataprivacy_purpose 3 0 11 0 Table

Data purposes

assignfeedback_file 0 2 4 0 Table

Stores info about the number of files submitted by a student

question_gapselect 0 1 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 1 3 0 Table

Options for short answer questions

user_password_resets 0 1 5 0 Table

table tracking password reset confirmation tokens

feedback_valuetmp 0 1 6 0 Table

values of the completedstmp

modules 1 0 6 0 Table

modules available in the site

feedback_sitecourse_map 0 2 3 0 Table

feedback sitecourse map

scorm_seq_mapinfo 0 2 8 0 Table

SCORM2004 objective mapinfo description

choice_options 1 1 5 0 Table

available options to choice

lesson 7 0 42 0 Table

Defines lesson

lti_types 3 0 18 0 Table

Basic LTI pre-configured activities

license 0 0 6 0 Table

store licenses used by moodle

lesson_branch 0 2 8 0 Table

branches for each lesson/user

cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

analytics_indicator_calc 0 1 9 0 Table

Stored indicator calculations

message_popup_notifications 0 1 2 0 Table

List of notifications to display in the message output popup

customfield_data 0 2 12 0 Table

core_customfield data table

scorm_seq_rolluprule 1 1 7 0 Table

SCORM2004 sequencing rule

wiki_locks 0 1 5 0 Table

Manages page locks

oauth2_user_field_mapping 0 1 7 0 Table

Mapping of oauth user fields to moodle fields.

auth_oauth2_linked_login 0 3 10 0 Table

Accounts linked to a users Moodle account.

role_capabilities 0 4 7 0 Table

Override a capability for a particular role in a particular context https://github.com/moodle/moodle/blob/master/lib/db/install.xml https://docs.moodle.org/dev/Access_API

survey_analysis 0 1 4 0 Table

text about each survey submission

badge_criteria_met 0 3 5 0 Table

Defines criteria that were met for an issued badge

feedback 4 0 17 0 Table

all feedbacks

workshop_grades 0 1 7 0 Table

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

qtype_ddmarker 0 1 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 2 2 13 0 Table

feedback_items

competency_template 3 1 10 0 Table

Learning plan templates.

workshop_assessments 1 3 15 0 Table

Info about the made assessment and automatically calculated

grade_letters 0 1 4 0 Table

Repository for grade letters, for courses and other moodle e

assignment 1 0 19 0 Table

Defines assignments

enrol_flatfile 0 3 8 0 Table

enrol_flatfile table retrofitted from MySQL

analytics_train_samples 0 1 6 0 Table

Samples used for training

assign_submission 3 1 9 0 Table

This table keeps information about student interactions with

mnet_application 1 0 6 0 Table

Information about applications on remote hosts

tool_dataprivacy_category 2 0 7 0 Table

Data categories

survey_answers 0 2 7 0 Table

the answers to each questions filled by the users

forum_queue 0 2 5 0 Table

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

tag_area 0 1 9 0 Table

Defines various tag areas, one area is identified by compone

backup_controllers 1 1 17 0 Table

To store the backup_controllers as they are used

analytics_predictions 1 2 11 0 Table

Predictions

ltiservice_gradebookservices 0 3 8 0 Table

This file records the grade items created by the LTI Gradebo

repository_onedrive_access 0 1 6 0 Table

List of temporary access grants.

h5p 1 1 9 0 Table

Stores H5P content information

lti_tool_settings 0 4 8 0 Table

LTI tool setting values

assign_grades 5 1 8 0 Table

Grading information about a single assignment submission.

course_categories 5 2 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 1 4 0 Table

config for portfolio plugin instances

resource_old 0 1 16 0 Table

backup of all old resource instances from 1.9

scorm_scoes_track 0 2 8 0 Table

to track SCOes

forum_grades 0 1 7 0 Table

Grading data for forum instances

user_lastaccess 0 3 4 0 Table

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

survey 2 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 3 15 0 Table

Stores users attempts at quizzes.

backup_courses 0 1 6 0 Table

To store every course backup status

tool_usertours_tours 1 0 7 0 Table

List of tours

oauth2_system_account 0 1 9 0 Table

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

question_hints 0 1 7 0 Table

Stores the the part of the question definition that gives di

cohort 3 1 11 0 Table

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

workshop 11 1 37 0 Table

This table keeps information about the module instances and

question_statistics 0 1 18 0 Table

Statistics for individual questions used in an activity.

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

all glossaries

url 0 1 10 0 Table

each record is one url resource

mnet_session 0 1 9 0 Table

Store session data from users migrating to other sites

competency_templatecomp 0 3 7 0 Table

Link a competency to a learning plan template.

badge_external_identifier 0 1 5 0 Table

Setting for external badges mappings

glossary_entries_categories 0 2 3 0 Table

categories of each glossary entry

enrol_paypal 0 4 21 0 Table

Holds all known information about PayPal transactions

role_allow_switch 0 2 3 0 Table

This table stores which which other roles a user is allowed

badge_alignment 0 1 7 0 Table

Defines alignment for badges

qtype_ddimageortext_drops 0 1 7 0 Table

Drop boxes

notifications 1 1 15 0 Table

Stores all notifications

question_categories 4 2 9 0 Table

Categories are for grouping questions

assignsubmission_file 0 2 4 0 Table

Info about file submissions for assignments

message_conversation_members 0 2 4 0 Table

Stores all members in a conversations

task_adhoc 0 1 8 0 Table

List of adhoc tasks waiting to run.

grade_items 5 4 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 1 11 0 Table

Defines book_chapters

badge_external 0 1 4 0 Table

Setting for external badges display

block_instances 1 2 12 0 Table

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

question_response_count 0 1 4 0 Table

Count for each responses for each try at a question.

grade_grades_history 0 6 24 0 Table

History table

question_response_analysis 1 1 10 0 Table

Analysis of student responses given to questions.

mnet_service2rpc 0 1 3 0 Table

Group functions or methods under a service

lti_tool_proxies 1 0 13 0 Table

LTI tool proxy registrations

scorm_seq_rolluprulecond 0 2 5 0 Table

SCORM2004 sequencing rule

grade_import_values 0 3 9 0 Table

Temporary table for importing grades

grade_outcomes_courses 0 2 3 0 Table

stores what outcomes are used in what courses.

workshop_submissions 1 3 19 0 Table

Info about the submission and the aggregation of the grade f

enrol_lti_lti2_user_result 0 1 6 0 Table

Results for each user for each resource link

event 0 3 23 0 Table

For everything with a time associated to it

badge_endorsement 0 1 8 0 Table

Defines endorsement for badge

tool_dataprivacy_ctxexpired 0 1 9 0 Table

Default comment for the table, please edit me

config 0 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 1 4 0 Table

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

question_dataset_definitions 1 1 6 0 Table

Organises and stores properties for dataset items

scale 10 1 8 0 Table

Defines grading scales

analytics_prediction_actions 0 2 5 0 Table

Register of user actions over predictions.

tool_policy 1 1 3 0 Table

Contains the list of policy documents defined on the site.

files 3 3 20 0 Table

Description of files, content is stored in sha1 file pool https://docs.moodle.org/dev/File_API and https://docs.moodle.org/dev/File_API_internals

competency_usercompcourse 0 2 9 0 Table

User competencies in a course

feedback_template 1 0 4 0 Table

templates of feedbackstructures

wiki_subwikis 3 1 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 2 3 0 Table

Many-many relation between questions and dataset definitions

assign_overrides 0 3 8 0 Table

The overrides to assign settings.

user_private_key 0 1 8 0 Table

access keys used in cookieless scripts - rss, etc.

feedback_completedtmp 0 2 8 0 Table

filled out feedback

wiki_links 0 2 5 0 Table

Page wiki links

gradingform_guide_criteria 1 1 9 0 Table

Stores the rows of the criteria grid.

message_read 0 1 17 0 Table

Stores all messages that have been read

events_queue 1 1 5 0 Table

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

badge_criteria 2 1 6 0 Table

Defines criteria for issuing badges

quiz_sections 0 1 5 0 Table

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

forum_digests 0 2 4 0 Table

Keeps track of user mail delivery preferences for each forum

forum_subscriptions 0 1 3 0 Table

Keeps track of who is subscribed to what forum

assign_user_mapping 0 2 3 0 Table

Map an assignment specific id number to a user

wiki_pages 4 1 10 0 Table

Stores wiki pages

competency_coursecompsetting 0 1 6 0 Table

This table contains the course specific settings for compete

message_popup 0 1 3 0 Table

Keep state of notifications for the popup message processor

repository_instance_config 0 1 4 0 Table

The config for intances

lti_types_config 0 1 4 0 Table

Basic LTI types configuration

data_content 0 2 8 0 Table

the content introduced in each record/fields

assignfeedback_editpdf_cmnt 0 1 9 0 Table

Stores comments added to pdfs

context 38 0 6 0 Table

A context is a scope in Moodle, for example the whole system, a course, a particular activity. The type is given by contextlevel, and depending on context level, instanceid points to one of a number of different tables. https://docs.moodle.org/en/Context

groupings 2 1 9 0 Table

A grouping is a collection of groups. WAS: groups_groupings

log_display 0 0 6 0 Table

For a particular module/action, specifies a moodle table/fie

role_names 0 2 4 0 Table

role names in native strings

competency_userevidence 0 1 9 0 Table

The evidence of prior learning

course_completions 0 1 7 0 Table

Course completion records

assignsubmission_onlinetext 0 2 5 0 Table

Info about onlinetext submission

tool_monitor_subscriptions 1 2 8 0 Table

Table to store user subscriptions to various rules

enrol_lti_users 0 2 12 0 Table

User access log and gradeback data

customfield_category 1 1 11 0 Table

core_customfield category table

gradingform_rubric_criteria 2 1 5 0 Table

Stores the rows of the rubric grid.

user_password_history 0 1 4 0 Table

A rotating log of hashes of previously used passwords for ea

feedback_value 0 1 6 0 Table

values of the completeds

config_log 0 1 7 0 Table

Changes done in server configuration through admin UI

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

SCORM2004 objective description

rating 0 3 10 0 Table

moodle ratings

my_pages 0 1 5 0 Table

Extra user pages for the My Moodle system

competency_modulecomp 0 3 8 0 Table

Link a competency to a module.

grade_items_history 0 6 34 0 Table

History of grade_items

enrol_lti_tool_consumer_map 0 2 3 0 Table

Table that maps the published tool to tool consumers.

course_completion_criteria 0 1 10 0 Table

Course completion criteria

h5p_libraries_cachedassets 0 1 3 0 Table

H5P cached library assets

assignfeedback_editpdf_rot 0 1 6 0 Table

Stores rotation information of a page.

course_modules 3 2 21 0 Table

course_modules table retrofitted from MySQL

forum_posts 3 2 18 0 Table

All posts are stored in this table

tool_recyclebin_course 0 1 6 0 Table

A list of items in the course recycle bin

glossary_alias 0 1 3 0 Table

entries alias

grade_grades 1 4 23 0 Table

grade_grades This table keeps individual grades for each us

scorm_scoes 8 1 10 0 Table

each SCO part of the SCORM module

stats_user_weekly 0 2 8 0 Table

To accumulate weekly stats per course/user

chat_messages_current 0 1 7 0 Table

Stores current session

enrol_lti_tools 2 2 19 0 Table

List of tools provided to the remote system

gradingform_rubric_levels 0 1 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 1 4 0 Table

Table to store history of message notifications sent

competency_usercomp 1 1 10 0 Table

User competencies

tag_coll 2 0 7 0 Table

Defines different set of tags

mnetservice_enrol_enrolments 0 2 7 0 Table

Caches the information about enrolments of our local users i

external_services_functions 0 1 3 0 Table

lists functions available in each service group

message_conversations 4 1 11 0 Table

Stores all message conversations

messages 2 2 11 0 Table

Stores all messages

h5p_contents_libraries 0 2 6 0 Table

Store which library is used in which content.

competency 11 2 17 0 Table

This table contains the master record of each competency in

resource 0 1 13 0 Table

Each record is one resource and its config data

tag_instance 0 2 10 0 Table

tag_instance table holds the information of associations bet

user_devices 1 1 11 0 Table

This table stores user’s mobile devices information in order

question_ddwtos 0 1 10 0 Table

Defines drag and drop (words into sentences) questions

grade_categories 5 2 14 0 Table

This table keeps information about categories, used for grou

assign_plugin_config 0 1 6 0 Table

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

quiz 6 0 41 0 Table

For api links see https://wimski.org/api/3.8/dd/df0/group__mod__quiz.html

tool_cohortroles 0 2 7 0 Table

Mapping of users to cohort role assignments.

question_attempt_steps 1 2 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 3 1 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 1 11 0 Table

stores annotations added to pdfs submitted by students

badge_related 0 2 3 0 Table

Defines badge related for badges

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

Stores the position of a sticky block_instance on a another

tool_policy_versions 2 2 16 0 Table

Holds versions of the policy documents

config_plugins 0 0 4 0 Table

Moodle modules and plugins configuration variables

qtype_match_subquestions 0 1 5 0 Table

The subquestions that make up a matching question

customfield_field 1 1 11 0 Table

core_customfield field table

question_numerical 0 1 4 0 Table

Options for numerical questions.

messageinbound_handlers 1 0 6 0 Table

Inbound Message Handler definitions.

user_info_data 0 2 5 0 Table

Data for the customisable user fields

label 0 1 6 0 Table

Defines labels

mnet_service 1 0 5 0 Table

A service is a group of functions

analytics_used_analysables 0 1 6 0 Table

List of analysables used by each model

quiz_slot_tags 0 2 4 0 Table

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

forum_read 0 3 7 0 Table

Tracks each users read posts

forum_discussions 4 1 14 0 Table

Forums are composed of discussions

user_info_field 0 1 20 0 Table

Customisable user profile fields

page 0 1 13 0 Table

Each record is one page and its config data

workshopform_rubric 1 2 5 0 Table

The assessment dimensions definitions of Rubric grading stra

enrol_lti_lti2_consumer 5 0 19 0 Table

LTI consumers interacting with moodle

scorm_seq_rulecond 0 2 7 0 Table

SCORM2004 rule condition

wiki_synonyms 0 2 4 0 Table

Stores wiki pages synonyms

question_usages 2 1 4 0 Table

This table’s main purpose it to assign a unique id to each a

tool_monitor_events 0 3 8 0 Table

A table that keeps a log of events related to subscriptions

chat_messages 0 1 7 0 Table

Stores all the actual chat messages

external_services 3 0 11 0 Table

built in and custom external services

grading_areas 1 1 5 0 Table

Identifies gradable areas where advanced grading can happen.

scale_history 0 3 11 0 Table

History table

role_context_levels 0 1 3 0 Table

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

stats_user_monthly 0 2 8 0 Table

To accumulate monthly stats per course/user

user_enrolments 0 3 9 0 Table

Users participating in courses (aka enrolled users) - everyb

lesson_timer 0 1 7 0 Table

lesson timer for each lesson

qtype_ddimageortext_drags 0 1 6 0 Table

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

role_assignments 0 3 9 0 Table

assigning roles in different context

portfolio_instance_user 0 2 5 0 Table

user data for portfolio instances.

assignfeedback_comments 0 2 5 0 Table

Text feedback for submitted assignments

choice_answers 0 2 5 0 Table

choices performed by users

capabilities 1 0 6 0 Table

this defines all capabilities

badge_external_backpack 1 0 6 0 Table

Defines settings for site level backpacks that a user can co

groups_members 0 2 6 0 Table

Link a user to a group.

enrol_lti_lti2_resource_link 3 3 9 0 Table

Link from the consumer to the tool

scorm 3 0 42 0 Table

each table is one SCORM module and its configuration

course 62 1 32 0 Table

Central course table

question 29 4 20 0 Table

The questions themselves

stats_weekly 0 2 7 0 Table

To accumulate weekly stats

qtype_ddmarker_drops 0 1 6 0 Table

drop regions

lesson_grades 0 1 6 0 Table

Defines lesson_grades

log_queries 0 0 9 0 Table

Logged database queries.

backup_logs 0 1 5 0 Table

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

user_info_category 1 0 3 0 Table

Customisable fields categories

question_answers 0 1 7 0 Table

Answers, with a fractional grade (0-1) and feedback

question_dataset_items 0 0 4 0 Table

Individual dataset items

message_contact_requests 0 2 4 0 Table

Maintains list of contact requests between users

enrol_lti_lti2_context 1 1 7 0 Table

Information about a specific LTI contexts from the consumers

message_processors 0 0 3 0 Table

List of message output plugins

workshopform_rubric_levels 0 1 5 0 Table

The definition of rubric rating scales

lock_db 0 0 4 0 Table

Stores active and inactive lock types for db locking method.

assignfeedback_editpdf_queue 0 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 1 8 0 Table

Information about how and when an local courses were publish

grade_outcomes_history 0 4 12 0 Table

History table

book 1 0 11 0 Table

Defines book

lti_submission 0 1 9 0 Table

Keeps track of individual submissions for LTI activities.

portfolio_mahara_queue 0 1 3 0 Table

maps mahara tokens to transfer ids

oauth2_endpoint 0 1 7 0 Table

Describes the named endpoint for an oauth2 service.

analytics_models_log 0 1 12 0 Table

Analytic models changes during evaluation.

competency_userevidencecomp 0 1 6 0 Table

Relationship between user evidence and competencies

sessions 0 1 9 0 Table

Database based session storage - now recommended

question_calculated_options 0 1 13 0 Table

Options for questions of type calculated

repository_instances 2 1 10 0 Table

This table contains one entry for every configured external

forum 8 0 29 0 Table

Forums contain and structure discussion

feedback_completed 0 2 7 0 Table

filled out feedback

assign_user_flags 0 2 8 0 Table

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

gradingform_guide_comments 0 1 5 0 Table

frequently used comments used in marking guide

grade_settings 0 1 4 0 Table

gradebook settings

course_format_options 0 1 6 0 Table

Stores format-specific options for the course or course sect

course_sections 0 1 10 0 Table

to define the sections for each course

logstore_standard_log 0 3 21 0 Table

Standard log table

enrol_lti_lti2_nonce 0 1 4 0 Table

Nonce used for authentication between moodle and a consumer

portfolio_tempdata 1 2 6 0 Table

stores temporary data for portfolio exports. the id of this

files_reference 1 1 5 0 Table

Store files references

mnet_log 0 1 13 0 Table

Store session data from users migrating to other sites

course_completion_defaults 0 2 8 0 Table

Default settings for activities completion

log 0 1 10 0 Table

Every action is logged as far as possible

block_recentlyaccesseditems 0 3 5 0 Table

Most recently accessed items accessed by a user

qtype_multichoice_options 0 1 13 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 0 11 0 Table

The log table for all tasks

blog_external 0 1 9 0 Table

External blog links used for RSS copying of blog entries to

tool_usertours_steps 0 1 8 0 Table

Steps in an tour

quiz_feedback 0 1 6 0 Table

Feedback given to students based on which grade band their o

lesson_overrides 0 3 11 0 Table

The overrides to lesson settings.

tool_monitor_rules 1 1 14 0 Table

Table to store rules

task_scheduled 0 0 14 0 Table

List of scheduled tasks to be run by cron.

events_queue_handlers 0 2 6 0 Table

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

analytics_predict_samples 0 1 8 0 Table

Samples already used for predictions.

question_numerical_units 0 1 4 0 Table

Optional unit options for numerical questions. This table is

quiz_slots 1 3 9 0 Table

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

cohort_members 0 2 4 0 Table

Link a user to a cohort.

chat 3 0 10 0 Table

Each of these is a chat room

question_attempts 3 2 14 0 Table

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

comments 0 2 9 0 Table

moodle comments module

assign 10 0 30 0 Table

mod_assign instances. For API https://wimski.org/api/3.8/d3/d4f/group__mod__assign.html

portfolio_log 0 2 11 0 Table

log of portfolio transfers (used to later check for duplicat

course_modules_completion 0 1 7 0 Table

Stores the completion state (completed or not completed, etc

favourite 0 2 9 0 Table

Stores the relationship between an arbitrary item (itemtype,

qtype_ddimageortext 0 1 10 0 Table

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

gradingform_rubric_fillings 0 2 6 0 Table

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

glossary_categories 1 1 4 0 Table

all categories for glossary entries

competency_plan 0 1 13 0 Table

Learning plans

chat_users 0 1 12 0 Table

Keeps track of which users are in which chat rooms

grading_definitions 4 3 14 0 Table

Contains the basic information about an advanced grading for

competency_usercompplan 0 1 10 0 Table

User competencies plans

gradingform_guide_fillings 0 2 6 0 Table

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

mnet_host2service 0 0 5 0 Table

Information about the services for a given host

qtype_match_options 0 1 10 0 Table

Defines the question-type specific options for matching ques

badge_manual_award 0 4 6 0 Table

Track manual award criteria for badges

question_multianswer 0 1 3 0 Table

Options for multianswer questions

tag 3 2 10 0 Table

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

analytics_used_files 0 2 5 0 Table

Files that have already been used for training and predictio

forum_discussion_subs 0 3 5 0 Table

Users may choose to subscribe and unsubscribe from specific

mnet_host 2 1 15 0 Table

Information about the local and remote hosts for RPC

tool_recyclebin_category 0 1 5 0 Table

A list of items in the category recycle bin

forum_track_prefs 0 2 3 0 Table

Tracks each users untracked forums

message_airnotifier_devices 0 1 3 0 Table

Store information about the devices registered in Airnotifie

workshop_aggregations 0 2 5 0 Table

Aggregated grades for assessment are stored here. The aggreg

wiki_versions 0 1 7 0 Table

Stores wiki page history

question_calculated 0 1 7 0 Table

Options for questions of type calculated

role_allow_assign 0 2 3 0 Table

this defines what role can assign what role

filter_active 0 1 5 0 Table

Stores information about which filters are active in which c

messageinbound_messagelist 0 1 5 0 Table

A list of message IDs for existing replies

enrol 3 2 35 0 Table

Instances of enrolment plugins used in courses, fields marke

badge_criteria_param 0 1 4 0 Table

Defines parameters for badges criteria

wiki 1 0 13 0 Table

Stores Wiki activity configuration

competency_templatecohort 0 2 6 0 Table

Default comment for the table, please edit me

folder 0 1 10 0 Table

each record is one folder resource

competency_evidence 0 2 14 0 Table

The evidence linked to a user competency

competency_plancomp 0 1 7 0 Table

Plan competencies

external_functions 0 0 8 0 Table

list of all external functions

external_services_users 0 2 6 0 Table

users allowed to use services with restricted users flag

filter_config 0 1 5 0 Table

Stores per-context configuration settings for filters which

message_users_blocked 0 2 4 0 Table

Maintains lists of blocked users

block 1 0 5 0 Table

contains all installed blocks

competency_relatedcomp 0 1 6 0 Table

Related competencies

glossary_entries 2 1 16 0 Table

all glossary entries

data 2 0 37 0 Table

all database activities

block_rss_client 0 1 9 0 Table

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

question_truefalse 0 1 4 0 Table

Options for True-False questions

lti 4 1 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 1 5 0 Table

Course completion aggregation methods for criteria

assignfeedback_editpdf_quick 0 1 5 0 Table

Stores teacher specified quicklist comments

blog_association 0 2 3 0 Table

Associations of blog entries with courses and module instanc

tool_customlang 0 1 11 0 Table

Contains the working checkout of all strings and their custo

enrol_lti_lti2_tool_proxy 0 1 6 0 Table

A tool proxy between moodle and a consumer

choice 2 0 18 0 Table

Available choices are stored here

external_tokens 0 4 13 0 Table

Security tokens for accessing of external services

oauth2_access_token 0 1 8 0 Table

Stores access tokens for system accounts in order to be able

events_handlers 1 0 8 0 Table

This table is for storing which components requests what typ

messageinbound_datakeys 0 1 6 0 Table

Inbound Message data item secret keys.

question_attempt_step_data 0 1 4 0 Table

Each question_attempt_step has an associative array of the d

message_email_messages 0 3 4 0 Table

Keeps track of what emails to send in an email digest

search_index_requests 0 1 7 0 Table

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

block_recent_activity 0 2 7 0 Table

Recent activity block

h5p_libraries 5 0 16 0 Table

Stores information about libraries used by H5P content.

lti_access_tokens 0 1 7 0 Table

Security tokens for accessing of LTI services

data_fields 1 1 16 0 Table

every field available

badge_backpack 2 2 7 0 Table

Defines settings for connecting external backpack

scorm_aicc_session 0 2 12 0 Table

Used by AICC HACP to store session information

tool_dataprivacy_purposerole 0 2 10 0 Table

Data purpose overrides for a specific role

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

Options for questions of type numerical This table is also u

role_allow_override 0 2 3 0 Table

this defines what role can override what role

user 113 0 54 0 Table

One record for each person, there are no gender or age fields

grade_import_newitem 1 1 4 0 Table

temporary table for storing new grade_item names from grade

tool_dataprivacy_ctxlevel 0 2 7 0 Table

Default comment for the table, please edit me

workshopform_rubric_config 0 1 3 0 Table

Configuration table for the Rubric grading strategy

tool_customlang_components 1 0 3 0 Table

Contains the list of all installed plugins that provide thei

message_user_actions 0 2 5 0 Table

Stores all per-user actions on individual messages

workshopallocation_scheduled 0 1 9 0 Table

Stores the allocation settings for the scheduled allocator

quiz_overrides 0 3 9 0 Table

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