Tables

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

Each record represents a group.

Tracks users accepting the policy versions

Defines lesson_answers

Contains variable data get from packages

every record introduced

Stores H5P library dependencies

Upgrade logging

to accumulate daily stats

Table to represent a report schedule

Stores the link associated with a custom link communication instance.

To accumulate monthly stats

Defines issued badges

List of contexts for a component

Table to represent a report filter/condition

List of SCORM attempts made by user.

Records MoodleNet share progress

search_simpledb table containing the index data.

Table to track file conversions.

Link a competency to a course.

For keeping information about cached data

Each row represents a resource link for a platform and deployment

Defines lesson_attempts

the questions conforming one survey

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

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

Defines badge

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

Allows modules to store arbitrary user preferences

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)

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

To accumulate daily stats per course/user

moodle roles

Stores all unread messages

Extra options for essay questions.

Maintains lists of contacts between users

Details for an oauth 2 connect identity issuer.

Stores all per-user actions on individual conversations

Info about a random short-answer matching question

Draft text that is auto-saved every 5 seconds while an editor is open.

Labels for markers to drag.

Default comment for the table, please edit me

History of grade_categories

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

Analytic models.

each record is one imscp resource

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

Tracks subscriptions to remote calendars.

Resource link share key

Course completion user records

Functions or methods that we may publish or subscribe to

Details of each application that has been registered with the tool

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

Link LTI types to course categories

SCORM2004 rule conditions

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

Data purposes

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

Defines select missing words questions

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

Options for short answer questions

table tracking password reset confirmation tokens

values of the completedstmp

modules available in the site

feedback sitecourse map

SCORM2004 objective mapinfo description

Where a quiz supports mulitple grades, this table stores what those grade items are.

available options to choice

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

Basic LTI pre-configured activities

store licenses used by moodle

branches for each lesson/user

The bigbluebuttonbn table to store meeting activity events

Defines report audience

Cache of time-sensitive flags

Stored indicator calculations

List of notifications to display in the message output popup

core_customfield data table

SCORM2004 sequencing rule

Manages page locks

Mapping of oauth user fields to moodle fields.

Accounts linked to a users Moodle account.

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

text about each survey submission

Defines criteria that were met for an issued badge

all feedbacks

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

Table to represent a report column

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

Group functions or methods under a service

feedback_items

Table to store infected file details.

Learning plan templates.

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

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

Stores PayPal related information

enrol_flatfile table retrofitted from MySQL

Samples used for training

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.

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

Information about applications on remote hosts

Data categories

Table to store coursevisible setting for site tool on course level

the answers to each questions filled by the users

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

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

To store the backup_controllers as they are used

Predictions

List of scorm elements.

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

A contextlist context item

List of temporary access grants.

Checks details

Stores H5P content information

LTI tool setting values

Grading information about a single assignment submission.

Course categories

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.

config for portfolio plugin instances

backup of all old resource instances from 1.9

Grading data for forum instances

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

Values passed from SCORM package

Default comment for the table, please edit me

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

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

Stores users attempts at quizzes.

To store every course backup status

List of tours

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

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

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

Payment accounts

This table keeps information about the module instances and their settings

Statistics for individual questions used in an activity.

Users attempts inside H5P activities

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

hub where the site is registered on with their associated token

all glossaries

each record is one url resource

Store session data from users migrating to other sites

Link a competency to a learning plan template.

Setting for external badges mappings

categories of each glossary entry

Holds all known information about PayPal transactions

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

Defines alignment for badges

Drop boxes

Stores all notifications

Categories are for grouping questions

Association table joining requests and contextlists

Info about file submissions for assignments

Stores all members in a conversations

List of adhoc tasks waiting to run.

This table stores content data in the content bank.

Setting of the display formats

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.

Defines book_chapters

Admin presets applied items. To maintain the relation with config_log

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.

Setting for external badges display

Count for each responses for each try at a question.

History table

Analysis of student responses given to questions.

Group functions or methods under a service

Contains accessibility summary information per activity.

LTI tool proxy registrations

SCORM2004 sequencing rule

Temporary table for importing grades

stores what outcomes are used in what courses.

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.

Results for each user for each resource link

For everything with a time associated to it

Defines endorsement for badge

Default comment for the table, please edit me

Moodle configuration variables

The assessment dimensions definitions of Comments strategy forms

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

Organises and stores properties for dataset items

Defines grading scales

Register of user actions over predictions.

Contains the list of policy documents defined on the site.

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

User competencies in a course

templates of feedbackstructures

Contains accessibility summary information per check.

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

Stores subwiki instances

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

Many-many relation between questions and dataset definitions

The overrides to assign settings.

H5Pactivities_attempts tracking info

access keys used in cookieless scripts - rss, etc.

filled out feedback

Stores the h5pactivity activity module instances.

Page wiki links

Stores the quiz level Safe Exam Browser configuration.

Stores the rows of the criteria grid.

Stores all messages that have been read

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.

Defines criteria for issuing badges

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

Keeps track of user mail delivery preferences for each forum

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

Keeps track of who is subscribed to what forum

Map an assignment specific id number to a user

Stores wiki pages

This table contains the course specific settings for competencies.

Options for ordering questions

Configuration for one gateway for one payment account

Errors during the accessibility checks

Keep state of notifications for the popup message processor

The config for intances

Basic LTI types configuration

the content introduced in each record/fields

Stores comments added to pdfs

one of these must be set

A grouping is a collection of groups. WAS: groups_groupings

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

role names in native strings

Records where a specific question is used.

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

The evidence of prior learning

Course completion records

Info about onlinetext submission

Table to store user subscriptions to various rules

Stores information about payments

User access log and gradeback data

core_customfield category table

Stores the rows of the rubric grid.

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

values of the completeds

Changes done in server configuration through admin UI

List of competency frameworks.

Stores the results of all the profiling runs

SCORM2004 objective description

moodle ratings

Extra user pages for the My Moodle system

Link a competency to a module.

History of grade_items

Table that maps the published tool to tool consumers.

Course completion criteria

H5P cached library assets

Stores rotation information of a page.

course_modules table retrofitted from MySQL

All posts are stored in this table

A list of items in the course recycle bin

entries alias

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.

Keeps the per course content analysis schedule.

each SCO part of the SCORM module

To accumulate weekly stats per course/user

Stores current session

List of tools provided to the remote system

Stores the columns of the rubric grid.

The assessment dimensions definitions of Accumulative grading strategy forms

Table to store history of message notifications sent

User competencies

Defines different set of tags

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

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

lists functions available in each service group

Stores all message conversations

Stores all messages

Store which library is used in which content.

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

Each record is one resource and its config data

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

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

Defines drag and drop (words into sentences) questions

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

Records where groups of questions are used.

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

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

Mapping of users to cohort role assignments.

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.

Accounts linked to a users Moodle account.

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

Defines lesson_pages

Table to store settings

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

stores annotations added to pdfs submitted by students

The bigbluebuttonbn table to store information about a meeting activities.

Defines badge related for badges

Table for data requests

The assessment dimensions definitions of Number of errors grading strategy forms

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

Areas that have been checked for accessibility problems

Holds versions of the policy documents

Moodle modules and plugins configuration variables

The subquestions that make up a matching question

core_customfield field table

Options for numerical questions.

Inbound Message Handler definitions.

Data for the customisable user fields

Defines labels

A service is a group of functions

List of analysables used by each model

Tracks each users read posts

Forums are composed of discussions

Customisable user profile fields

Each record is one page and its config data

The assessment dimensions definitions of Rubric grading strategy forms

LTI consumers interacting with moodle

SCORM2004 rule condition

Stores wiki pages synonyms

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.

A table that keeps a log of events related to subscriptions

Stores all the actual chat messages

built in and custom external services

Table to store factor configurations for users

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

History table

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

To accumulate monthly stats per course/user

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

lesson timer for each lesson

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

assigning roles in different context

user data for portfolio instances.

Text feedback for submitted assignments

this defines all capabilities

choices performed by users

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

Link a user to a group.

Link from the consumer to the tool

Attributes of the applied items

each table is one SCORM module and its configuration

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

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

Communication user records mapping

To accumulate weekly stats

drop regions

Defines lesson_grades

Logged database queries.

Table to store factor secrets

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

Customisable fields categories

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

Individual dataset items

Maintains list of contact requests between users

The bigbluebuttonbn table to store references to recordings

Information about a specific LTI contexts from the consumers

List of message output plugins

The definition of rubric rating scales

Stores active and inactive lock types for db locking method.

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

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

History table

Defines book

Keeps track of individual submissions for LTI activities.

maps mahara tokens to transfer ids

Describes the named endpoint for an oauth2 service.

Analytic models changes during evaluation.

Relationship between user evidence and competencies

Database based session storage - now recommended

Options for questions of type calculated

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

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

filled out feedback

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

gradebook settings

frequently used comments used in marking guide

Stores format-specific options for the course or course section

to define the sections for each course

Standard log table

Nonce used for authentication between moodle and a consumer

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.

Store files references

Results of the accessibility checks

Applied presets

Store session data from users migrating to other sites

Default settings for activities completion

Every action is logged as far as possible

Most recently accessed items accessed by a user

Options for multiple choice questions

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

The log table for all tasks

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

Steps in an tour

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

The overrides to lesson settings.

Table to store rules

List of scheduled tasks to be run by cron.

Stores refresh tokens which can be exchanged for access tokens

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.

Samples already used for predictions.

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

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

Link a user to a cohort.

Each of these is a chat room

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 For documentation https://docs.moodle.org/dev/Overview_of_the_Moodle_question_engine

moodle comments module

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

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

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

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

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

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

all categories for glossary entries

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

Learning plans

Keeps track of which users are in which chat rooms

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

Contains accessibility check results summary information.

User competencies plans

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

Information about the services for a given host

Defines the question-type specific options for matching questions

Track manual award criteria for badges

Admin presets plugins applied

Options for multianswer questions

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

Queued records to initiate new processing of specific targets

Files that have already been used for training and prediction.

Users may choose to subscribe and unsubscribe from specific discussions.

Information about the local and remote hosts for RPC

A list of items in the category recycle bin

Tracks each users untracked forums

Store information about the devices registered in Airnotifier for PUSH notifications

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

Stores wiki page history

Options for questions of type calculated

this defines what role can assign what role

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.

A list of message IDs for existing replies

The stored xAPI states

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.

Defines parameters for badges criteria

Stores Wiki activity configuration

Default comment for the table, please edit me

each record is one folder resource

The evidence linked to a user competency

Plan competencies

list of all external functions

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

users allowed to use services with restricted users flag

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

Maintains lists of blocked users

contains all installed blocks

Related competencies

Stores the matrix room information associated with the communication instance.

Table to represent a report

all glossary entries

all database activities

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

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

Options for True-False questions

The content of the textarea saved during autosave operations

Communication records

This table contains Basic LTI activities instances

Templates for Safe Exam Browser configuration.

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

Course completion aggregation methods for criteria

Stores teacher specified quicklist comments

Default comment for bbbext_simple, please edit me

Associations of blog entries with courses and module instances

Contains the working checkout of all strings and their customization

A tool proxy between moodle and a consumer

Available choices are stored here

Security tokens for accessing of external services

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

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.

Inbound Message data item secret keys.

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 _-

Keeps track of what emails to send in an email digest

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.)

Recent activity block

Stores information about libraries used by H5P content.

Security tokens for accessing of LTI services

every field available

Defines settings for connecting external backpack

Used by AICC HACP to store session information

Data purpose overrides for a specific role

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

course requests

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

this defines what role can override what role

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

temporary table for storing new grade_item names from grade import

Default comment for the table, please edit me

Configuration table for the Rubric grading strategy

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

Stores all per-user actions on individual messages

Stores the allocation settings for the scheduled allocator

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