Tables


SchemaSpy Analysis of Totara Learn 12

Generated on Fri Sep 04 13:11 GMT 2020

XML Representation
TABLES 664
VIEWS 0
COLUMNS 5691
Constraints 817
Anomalies 209
Routines 0

Database Properties

Database Type: MySQL - 5.7.31

Tables

Table / View Children Parents Columns Rows Type Comments
comp_type_info_data_param 0 1 3 -1 Table

Custom competencies fields data parameters

feedback360_grp_cohort 0 2 3 -1 Table

Audiences assigned to feedback360

quiz_grades 0 2 5 -1 Table

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

block_community 0 1 6 -1 Table

Community block

facetoface_signup_info_data_param 0 1 3 -1 Table

Custom event signup fields data parameters

groups 5 1 11 -1 Table

Each record represents a group.

course_completion_history 0 2 5 -1 Table

Course completion history archive

certif 4 0 7 -1 Table

Certifications

dp_plan_evidence_relation 0 2 5 -1 Table

Related courses / objectives / competencies

questionnaire_survey 1 1 17 -1 Table

questionnaire_survey table retrofitted from MySQL

lesson_answers 1 2 13 -1 Table

Defines lesson_answers

report_builder_filters 0 1 10 -1 Table

Defines filters belonging to each report

certif_completion_history 0 2 12 -1 Table

Previous completed certifications

scorm_scoes_data 0 1 4 -1 Table

Contains variable data get from packages

data_records 1 2 7 -1 Table

every record introduced

catalog 0 1 9 -1 Table

Catalog table

upgrade_log 0 1 10 -1 Table

Upgrade logging

stats_daily 0 2 7 -1 Table

to accumulate daily stats

block_zoola_reports 0 1 5 -1 Table

Reports configured in this block instance

stats_monthly 0 2 7 -1 Table

To accumulate monthly stats

questionnaire_question 0 0 13 -1 Table

questionnaire_question table retrofitted from MySQL

badge_issued 1 2 8 -1 Table

Defines issued badges

assignment_submissions 0 2 14 -1 Table

Info about submitted assignments

block_zoola_reports_user 0 2 3 -1 Table

Users that can access this block instance

dp_objective_scale_value 1 2 10 -1 Table

Objective Scale values for development plan priority scales

goal_scale 3 1 6 -1 Table

Scale represents the different levels of achievement of a goal

file_conversion 0 2 11 -1 Table

Table to track file conversions.

feedback360_email_assignment 1 0 3 -1 Table

Email addresses for feedback360

competency_coursecomp 0 2 8 -1 Table

Link a competency to a course.

facetoface_signup_info_data 1 2 4 -1 Table

Stores custom field data related to user signups for events, this data is attached to signup table, not status

facetoface_cancellation_info_data 1 2 4 -1 Table

Stores custom field data related to user signup cancellation

cache_filters 0 0 6 -1 Table

For keeping information about cached data

cohort_role 0 4 7 -1 Table

A table to store roles assigned to a cohort

lesson_attempts 0 4 9 -1 Table

Defines lesson_attempts

survey_questions 1 0 7 -1 Table

the questions conforming one survey

catalog_search_metadata 0 0 8 -1 Table

Search metadata table where the search metadata are being stored

portfolio_instance 4 0 4 -1 Table

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

badge 3 3 20 -1 Table

Defines badge

appraisal_event_rcpt 0 1 3 -1 Table

Appraisal events recipients (roles)

cohort_rules 1 2 8 -1 Table

Rules within a ruleset

goal_grp_cohort 0 2 5 -1 Table

Stores the assignments of goals

user_preferences 0 1 4 -1 Table

Allows modules to store arbitrary user preferences

grade_outcomes 4 3 10 -1 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)

local_ld_course 2 2 4 -1 Table

Total time spent within a course

quiz_statistics 0 0 19 -1 Table

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

course_info_data 1 2 4 -1 Table

Custom course fields data

stats_user_daily 0 3 8 -1 Table

To accumulate daily stats per course/user

role 26 0 6 -1 Table

moodle roles

message 4 0 16 -1 Table

Stores all unread messages

qtype_essay_options 0 1 11 -1 Table

Extra options for essay questions.

message_contacts 0 1 4 -1 Table

Maintains lists of relationships between users

facetoface_cancellation_info_field 1 0 16 -1 Table

Stores the definitions for user signup cancellation custom fields

oauth2_issuer 3 0 20 -1 Table

Details for an oauth 2 connect identity issuer.

goal_type_info_field 1 1 17 -1 Table

Stores the custom fields for each goal type

facetoface_notification_hist 0 4 8 -1 Table

Notifications history (stores ical event information)

qtype_randomsamatch_options 0 1 11 -1 Table

Info about a random short-answer matching question

block_zoola_reports_cohort 0 2 3 -1 Table

Cohorts that can access this block instance

report_builder_columns 0 1 10 -1 Table

Defines columns belonging to each report

editor_atto_autosave 0 2 9 -1 Table

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

facetoface_signups_status 0 2 7 -1 Table

Status of user signups, this table keeps the history for each user signup, no data is deleted

local_ld_import_logs_status 0 1 7 -1 Table

Current status of the import logs task

qtype_ddmarker_drags 0 1 6 -1 Table

Labels for markers to drag.

assignment_upgrade 0 0 6 -1 Table

Info about upgraded assignments

grade_categories_history 0 4 18 -1 Table

History of grade_categories

imscp 0 0 9 -1 Table

each record is one imscp resource

message_metadata 0 2 11 -1 Table

type, status, and workflow additions to messages

event_subscriptions 0 2 9 -1 Table

Tracks subscriptions to remote calendars.

local_ld_course_day 0 1 6 -1 Table

Time spent on a course at day level

enrol_lti_lti2_share_key 0 1 5 -1 Table

Resource link share key

course_completion_crit_compl 0 3 8 -1 Table

Course completion user records

mnet_rpc 0 0 11 -1 Table

Functions or methods that we may publish or subscribe to

feedback360_scale_data 0 3 4 -1 Table

Multiple user answers

tag_correlation 0 1 3 -1 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

scorm_seq_ruleconds 1 1 5 -1 Table

SCORM2004 rule conditions

dp_priority_scale 4 2 7 -1 Table

Contains priority scales for development plans

post 1 4 19 -1 Table

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

comp_scale_assignments 0 2 5 -1 Table

Tracks which scales are assigned to which competency frameworks

org_competencies 0 2 7 -1 Table

Track competencies assigned to a particular organisation

org_framework 2 0 11 -1 Table

A collection of organisations

assignfeedback_file 0 2 4 -1 Table

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

question_gapselect 0 1 10 -1 Table

Defines select missing words questions

prog_user_assignment 0 2 6 -1 Table

Stores details of the user assignments that have been made for a program based on the program's assignment criteria

quiz_overview_regrades 0 1 7 -1 Table

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

qtype_shortanswer_options 0 1 3 -1 Table

Options for short answer questions

user_password_resets 0 1 5 -1 Table

table tracking password reset confirmation tokens

totara_compl_import_cert 0 1 18 -1 Table

Intermediary file for importing certification completion data

cohort_rule_collections 1 2 9 -1 Table

Collections of rulesets & rules for a dynamic cohort

facetoface_sessions 7 2 20 -1 Table

Describes seminar events

feedback_valuetmp 0 1 6 -1 Table

values of the completedstmp

modules 2 0 6 -1 Table

modules available in the site

facetoface_room 2 2 11 -1 Table

Table for storing seminar room data

feedback_sitecourse_map 0 2 3 -1 Table

feedback sitecourse map

scorm_seq_mapinfo 0 2 8 -1 Table

SCORM2004 objective mapinfo description

goal_type_info_data 1 2 4 -1 Table

Stores custom field data related to goals

role_sortorder 0 3 5 -1 Table

sort order of course managers in a course

choice_options 1 1 5 -1 Table

available options to choice

lesson 7 0 42 -1 Table

Defines lesson

lti_types 1 0 16 -1 Table

Basic LTI pre-configured activities

prog_courseset 4 2 15 -1 Table

Stores details of the sets of courses and competencies contained within a program

questionnaire 0 1 19 -1 Table

Main questionnaire table.

license 0 0 6 -1 Table

store licenses used by moodle

feedback360_scale 1 2 5 -1 Table

Multiple choice sets

lesson_branch 0 3 8 -1 Table

branches for each lesson/user

report_builder_search_cols 0 1 4 -1 Table

Defines search columns belonging to each report

dp_plan_evidence_info_data_param 0 1 3 -1 Table

Custom evidence fields data parameters

comp_type_info_field 1 1 17 -1 Table

Stores the custom fields for each competency type

cache_flags 0 0 6 -1 Table

Cache of time-sensitive flags

facetoface_sessioncancel_info_field 1 0 16 -1 Table

Stores the definitions for whole event cancellation custom fields

scorm_seq_rolluprule 1 1 7 -1 Table

SCORM2004 sequencing rule

wiki_locks 0 2 5 -1 Table

Manages page locks

prog_messagelog 0 3 5 -1 Table

Stores details of program-related messages that have been issued to a user

oauth2_user_field_mapping 0 1 7 -1 Table

Mapping of oauth user fields to moodle fields.

auth_oauth2_linked_login 0 3 10 -1 Table

Accounts linked to a users Moodle account.

dp_plan_competency_assign 0 4 9 -1 Table

Stores competencies assigned to a particular plan

role_capabilities 0 4 7 -1 Table

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

survey_analysis 0 2 4 -1 Table

text about each survey submission

facetoface 2 1 34 -1 Table

Each seminar activity has an entry here

badge_criteria_met 0 3 5 -1 Table

Defines criteria that were met for an issued badge

feedback 5 0 17 -1 Table

all feedbacks

workshop_grades 0 1 7 -1 Table

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

qtype_ddmarker 0 1 11 -1 Table

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

mnet_remote_service2rpc 0 0 3 -1 Table

Group functions or methods under a service

report_builder_cache 0 1 10 -1 Table

Storing details of scheduled reports caching

context_map 0 0 3 -1 Table

Map context hierarchy into a flat structure to make parent-child queries in Totara SQL access more efficient

feedback_item 3 2 13 -1 Table

feedback_items

org_type_info_data_param 0 1 3 -1 Table

Custom organisations fields data parameters

competency_template 3 1 10 -1 Table

Learning plan templates.

workshop_assessments 1 3 15 -1 Table

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

facetoface_notification_sent 0 3 4 -1 Table

Seminar notification reciepts

grade_letters 0 1 4 -1 Table

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

totara_userdata_purge_type 4 0 11 -1 Table

List of available user data purge types

dp_component_settings 0 1 5 -1 Table

Stores the names and component-independent settings for each installed component.

dp_program_settings 0 0 5 -1 Table

Contains settings specific to the program component

totara_connect_sso_sessions 0 2 7 -1 Table

List of all SSO sessions on client systems connect to this server

assignment 1 0 19 -1 Table

Defines assignments

enrol_flatfile 0 3 8 -1 Table

enrol_flatfile table retrofitted from MySQL

totara_connect_clients 5 1 18 -1 Table

List of client systems registered with this server

facetoface_session_info_field 1 0 17 -1 Table

Stores the definitions for event custom fields

assign_submission 2 2 9 -1 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.

block_quicklinks 0 1 6 -1 Table

Holds information on the defined links of a block

comp_relations 0 0 4 -1 Table

Tracks relationships between competencies

mnet_application 1 0 6 -1 Table

Information about applications on remote hosts

survey_answers 0 3 7 -1 Table

the answers to each questions filled by the users

dp_competency_settings 0 1 10 -1 Table

Contains settings specific to the competency component

dp_plan_program_assign 0 3 8 -1 Table

Stores program assigned to a particular plan

facetoface_room_info_data 1 2 4 -1 Table

Stores custom field data related to rooms

forum_queue 0 3 5 -1 Table

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

tag_area 0 1 8 -1 Table

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

backup_controllers 1 1 16 -1 Table

To store the backup_controllers as they are used

report_builder_schedule_email_external 0 1 3 -1 Table

Storing external emails to send in scheduled reports

block_zoola_module_name 0 1 5 -1 Table

Module names

totara_dashboard 2 0 5 -1 Table

Dashboards

feedback360_user_assignment 1 2 4 -1 Table

Actual user who is subject of feedback360

tool_sitepolicy_localised_consent 0 2 6 -1 Table

The options which the user can choose from in a localised policy

facetoface_cancellation_info_data_param 0 1 3 -1 Table

Custom user signup cancellation fields data parameters

report_builder 8 0 20 -1 Table

Each report has an entry here

cohort_plan_history 0 3 10 -1 Table

A table to store the history of plans created for cohorts.

cohort_plan_config 0 1 8 -1 Table

A table to store the config for plans to be created for cohorts.

quickaccess_preferences 0 1 4 -1 Table

Stores user preferences for the quick access menu

facetoface_signup_info_field 1 0 16 -1 Table

Stores the definitions of user signup custom fields

lti_tool_settings 0 3 7 -1 Table

LTI tool setting values

appraisal_grp_pos 0 2 4 -1 Table

Positions assigned to appraisal

reportbuilder_grp_pos_user 0 2 5 -1 Table

Restricted positions that will see only allowed records

assign_grades 4 2 8 -1 Table

Grading information about a single assignment submission.

course_categories 4 1 16 -1 Table

Course categories

prog_info_data_param 0 1 3 -1 Table

Custom programs fields data parameters

quiz_reports 0 0 4 -1 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.

report_builder_schedule 3 4 11 -1 Table

Storing details of scheduled reports

questionnaire_response_other 0 0 5 -1 Table

questionnaire_response_other table retrofitted from MySQL

org_type 2 0 8 -1 Table

Organisation types are used to manage custom fields

auth_connect_sso_requests 0 1 5 -1 Table

List of SSO requests from Totara Connect client to server

facetoface_sessions_dates 2 2 6 -1 Table

Describes sessions of event. Specifies the start time, end time and optionally room and assets. Sessions can be set over multiple days or blocks of time.

portfolio_instance_config 0 1 4 -1 Table

config for portfolio plugin instances

reportbuilder_grp_org_record 0 2 5 -1 Table

Organisations that restricted users can see

facetoface_asset 2 2 10 -1 Table

Table for storing seminar assets data

questionnaire_fb_sections 0 0 7 -1 Table

questionnaire_fb_sections table retrofitted from MySQL

resource_old 0 0 16 -1 Table

backup of all old resource instances from 1.9

scorm_scoes_track 0 3 8 -1 Table

to track SCOes

user_lastaccess 0 2 4 -1 Table

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

questionnaire_resp_multiple 0 0 4 -1 Table

questionnaire_resp_multiple table retrofitted from MySQL

report_builder_saved 1 2 7 -1 Table

Stores saved searches for reports

appraisal_event 2 2 9 -1 Table

Appraisal event notifications

reportbuilder_grp_cohort_user 0 2 4 -1 Table

Restricted cohorts that will see only allowed records

appraisal_stage_page 1 1 4 -1 Table

Pages within appraisal stages. Each stage has at least one page

block_zoola_reports_schreps 1 2 23 -1 Table

Manually scheduled reports

cohort_rulesets 1 2 8 -1 Table

Rulesets for dynamic cohorts

totara_connect_client_org_frameworks 0 2 4 -1 Table

List of organisation frameworks synced to a client

survey 2 0 11 -1 Table

Each record is one SURVEY module with its configuration

workshopeval_best_settings 0 1 3 -1 Table

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

auth_connect_servers 5 0 12 -1 Table

List of servers

quiz_attempts 0 2 15 -1 Table

Stores users attempts at quizzes.

backup_courses 0 1 6 -1 Table

To store every course backup status

tool_usertours_tours 1 0 7 -1 Table

List of tours

oauth2_system_account 0 0 9 -1 Table

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

question_hints 0 1 7 -1 Table

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

cohort 20 1 21 -1 Table

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

comp_record 0 6 14 -1 Table

Track current proficiency of a user in each competency

workshop 10 1 35 -1 Table

This table keeps information about the module instances and their settings

pos_framework 2 0 11 -1 Table

A collection of positions

question_statistics 0 1 18 -1 Table

Statistics for individual questions used in an activity.

groupings_groups 0 2 4 -1 Table

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

dp_objective_scale 2 2 7 -1 Table

Contains objective scales for development plans

dp_plan_component_relation 0 0 6 -1 Table

Provides a way to link together items from different components within a plan

registration_hubs 0 0 7 -1 Table

hub where the site is registered on with their associated token

glossary 2 0 28 -1 Table

all glossaries

reportbuilder_grp_user_user 0 2 4 -1 Table

Restricted individual users that will see only allowed records

goal_user_info_data_param 0 1 3 -1 Table

Custom organisations fields data parameters

url 0 0 10 -1 Table

each record is one url resource

mnet_session 0 1 9 -1 Table

Store session data from users migrating to other sites

competency_templatecomp 0 2 7 -1 Table

Link a competency to a learning plan template.

glossary_entries_categories 0 2 3 -1 Table

categories of each glossary entry

enrol_paypal 0 2 21 -1 Table

Holds all known information about PayPal transactions

appraisal_scale 2 1 4 -1 Table

Multiple choice sets

role_allow_switch 0 2 3 -1 Table

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

qtype_ddimageortext_drops 0 1 7 -1 Table

Drop boxes

totara_core_certification_vis_map 0 2 3 -1 Table

Certification view hidden capability to role map

totara_userdata_purge_item 0 1 7 -1 Table

Items of each user data purge and their result

question_categories 3 2 8 -1 Table

Categories are for grouping questions

assignsubmission_file 0 2 4 -1 Table

Info about file submissions for assignments

task_adhoc 1 0 7 -1 Table

List of adhoc tasks waiting to run.

course_completion_log 0 3 6 -1 Table

Record of changes made to course completion records

glossary_formats 0 0 10 -1 Table

Setting of the display formats

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

Defines book_chapters

badge_external 0 1 3 -1 Table

Setting for external badges display

block_instances 6 2 11 -1 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.

goal_record 0 3 5 -1 Table

Track current status of a user within goals

dp_evidence_type 1 1 6 -1 Table

Table to store evidence type menu

question_response_count 0 1 4 -1 Table

Count for each responses for each try at a question.

comp_scale_values 4 1 10 -1 Table

The individual values that make up a competency scale

prog_completion_log 0 3 6 -1 Table

Record of changes made to program completion records

grade_grades_history 0 6 24 -1 Table

History table

question_response_analysis 1 1 10 -1 Table

Analysis of student responses given to questions.

mnet_service2rpc 0 0 3 -1 Table

Group functions or methods under a service

dp_objective_settings 0 3 6 -1 Table

Settings for a template's objectives

lti_tool_proxies 1 0 13 -1 Table

LTI tool proxy registrations

comp_template_assignment 0 3 6 -1 Table

Track competencies belonging to a template

appraisal_scale_value 1 1 4 -1 Table

Multiple choice options (score can be used when applicable)

scorm_seq_rolluprulecond 0 2 5 -1 Table

SCORM2004 sequencing rule

grade_import_values 0 4 9 -1 Table

Temporary table for importing grades

questionnaire_resp_single 0 0 4 -1 Table

questionnaire_resp_single table retrofitted from MySQL

grade_outcomes_courses 0 2 3 -1 Table

stores what outcomes are used in what courses.

lti_submission_history 0 2 5 -1 Table

Tracking of user submission history for the LTI activity

workshop_submissions 1 3 19 -1 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.

dp_plan_history 0 2 7 -1 Table

A table for tracking and recording modifications to a related dp_plan

enrol_lti_lti2_user_result 0 1 6 -1 Table

Results for each user for each resource link

event 0 2 21 -1 Table

For everything with a time associated to it

persistent_login 0 1 9 -1 Table

Persistent user logins

config 0 0 3 -1 Table

Moodle configuration variables

appraisal 8 0 6 -1 Table

Main appraisal table

auth_connect_sso_sessions 0 2 7 -1 Table

List of SSO sessions on Client system, columns are not normalised to allow strict validation

goal_personal 1 4 15 -1 Table

Totara goals

prog_assignment 0 1 8 -1 Table

Stores details of the assignments defined within a program

workshopform_comments 0 1 5 -1 Table

The assessment dimensions definitions of Comments strategy forms

facetoface_room_info_data_param 0 1 3 -1 Table

Custom room fields data parameters

mnet_sso_access_control 0 0 4 -1 Table

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

appraisal_grp_org 0 2 4 -1 Table

Organisations assigned to appraisal

question_dataset_definitions 1 1 6 -1 Table

Organises and stores properties for dataset items

scale 10 2 8 -1 Table

Defines grading scales

block_zoola_reports_eventcfg 1 0 14 -1 Table

Event schedules configuration

questionnaire_quest_choice 0 0 4 -1 Table

questionnaire_quest_choice table retrofitted from MySQL

reportbuilder_grp_pos_record 0 2 5 -1 Table

Positions that restricted users can see

pos_competencies 0 2 7 -1 Table

Tracks competencies assigned to a particular position

prog_exception 0 2 6 -1 Table

Stores details of any exceptions raised relating to a program

dp_plan_evidence 2 3 8 -1 Table

Contains user evidence in the record of learning

files 2 3 20 -1 Table

description of files, content is stored in sha1 file pool

competency_usercompcourse 0 3 9 -1 Table

User competencies in a course

feedback_template 1 0 4 -1 Table

templates of feedbackstructures

wiki_subwikis 2 2 4 -1 Table

Stores subwiki instances

mnetservice_enrol_courses 0 1 14 -1 Table

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

totara_dashboard_cohort 0 2 3 -1 Table

Users modifications of pages

dp_plan_course_assign 0 4 10 -1 Table

Stores courses assigned to a particular plan

question_datasets 0 2 3 -1 Table

Many-many relation between questions and dataset definitions

facetoface_room_info_field 1 0 16 -1 Table

Stores the definition of available room custom fields

assign_overrides 0 3 8 -1 Table

The overrides to assign settings.

prog_info_field 1 0 16 -1 Table

Stores the custom fields for each program type

certificate 1 0 29 -1 Table

Defines certificates

user_private_key 0 1 8 -1 Table

access keys used in cookieless scripts - rss, etc.

appraisal_grp_cohort 0 2 3 -1 Table

Audiences assigned to appraisal

feedback_completedtmp 0 3 8 -1 Table

filled out feedback

feedback_completed_history 1 2 8 -1 Table

history of filled out feedback

facetoface_asset_dates 0 2 3 -1 Table

Assets to session dates many-to-many relationship

totara_userdata_export 1 3 10 -1 Table

List of all user data exports and their result

wiki_links 0 2 5 -1 Table

Page wiki links

certif_completion 0 2 11 -1 Table

Certifications completed

questionnaire_question_type 0 0 5 -1 Table

questionnaire_question_type table retrofitted from MySQL

gradingform_guide_criteria 1 1 9 -1 Table

Stores the rows of the criteria grid.

message_read 0 2 17 -1 Table

Stores all messages that have been read

events_queue 1 1 5 -1 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.

cohort_msg_queue 0 3 8 -1 Table

A table to store cohort member join/delete notifications, to be sent at the next cron run.

badge_criteria 2 1 6 -1 Table

Defines criteria for issuing badges

quiz_sections 0 1 5 -1 Table

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

reminder_sent 0 3 5 -1 Table

Totara course reminders log of messages sent

forum_digests 0 2 4 -1 Table

Keeps track of user mail delivery preferences for each forum

comp_type 2 0 8 -1 Table

Competency types are used to manage custom fields

errorlog 0 0 6 -1 Table

Deprecated since Totara 11.

report_builder_schedule_email_audience 0 2 3 -1 Table

Storing audience to email in scheduled reports

comp_framework 3 0 11 -1 Table

A collection of competencies that use a common competency scale

totara_connect_client_courses 0 2 4 -1 Table

List of courses synced to a client, the enrolled users are restricted by totara_connect_clients.cohortid if specified

forum_subscriptions 0 2 3 -1 Table

Keeps track of who is subscribed to what forum

feedback_value_history 0 2 8 -1 Table

History of values of the completeds

reportbuilder_grp_cohort_record 0 2 4 -1 Table

Cohorts that restricted users can see

assign_user_mapping 0 2 3 -1 Table

Map an assignment specific id number to a user

questionnaire_response_text 0 0 4 -1 Table

questionnaire_response_text table retrofitted from MySQL

reportbuilder_grp_org_user 0 2 5 -1 Table

Restricted organisations that will see only allowed records

wiki_pages 2 2 10 -1 Table

Stores wiki pages

totara_core_program_vis_map 0 2 3 -1 Table

Program view hidden capability to role map

pos_type_info_data 1 2 4 -1 Table

Stores custom field data related to positions

repository_opensesame_bps 0 2 3 -1 Table

Link an OpenSesame course to a bundle

dp_plan 6 2 10 -1 Table

Stores individual plans belonging to users.

competency_coursecompsetting 0 1 6 -1 Table

This table contains the course specific settings for competencies.

org_type_info_data 1 2 4 -1 Table

Stores custom field data related to organisations

message_popup 0 1 3 -1 Table

Keep state of notifications for the popup message processor

repository_instance_config 0 0 4 -1 Table

The config for intances

appraisal_event_message 1 1 4 -1 Table

Appraisal event message

lti_types_config 0 0 4 -1 Table

Basic LTI types configuration

block_totara_featured_links_tiles 0 2 18 -1 Table

Defines tiles for Totara featured links blocks

data_content 0 2 8 -1 Table

the content introduced in each record/fields

questionnaire_response_date 0 0 4 -1 Table

questionnaire_response_date table retrofitted from MySQL

assignfeedback_editpdf_cmnt 0 1 9 -1 Table

Stores comments added to pdfs

pos_type 2 0 8 -1 Table

Position types are used to manage custom fields

appraisal_user_event 0 2 4 -1 Table

Appraisal events scheduled to specific users

certificate_issues_history 0 2 10 -1 Table

Archived user certificates for Totara

appraisal_history 0 2 4 -1 Table

Appraisal access history

context 33 0 6 -1 Table

one of these must be set

groupings 2 1 9 -1 Table

A grouping is a collection of groups. WAS: groups_groupings

log_display 0 0 6 -1 Table

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

role_names 0 2 4 -1 Table

role names in native strings

totara_userdata_user 0 4 9 -1 Table

Extension of user table for tracking of selected purging types for each user - 1 to 1 mapping to user table

auth_connect_ids 0 1 6 -1 Table

General server to client database id mappings

competency_userevidence 0 1 9 -1 Table

The evidence of prior learning

auth_connect_user_collections 0 2 6 -1 Table

List of cohorts synced from server

goal_type 2 0 8 -1 Table

Goal types are used to manage custom fields

course_completions 1 4 14 -1 Table

Course completion records

assignsubmission_onlinetext 0 2 5 -1 Table

Info about onlinetext submission

tool_monitor_subscriptions 1 3 8 -1 Table

Table to store user subscriptions to various rules

enrol_lti_users 0 2 12 -1 Table

User access log and gradeback data

local_ld_lastactivity 0 3 5 -1 Table

Last activity that user has performed

gap_aspirational 0 2 6 -1 Table

Aspirational positions

gradingform_rubric_criteria 2 1 5 -1 Table

Stores the rows of the rubric grid.

prog_extension 0 2 7 -1 Table

Stores extension requests for programs

user_password_history 0 1 4 -1 Table

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

feedback360 5 1 8 -1 Table

360 feedback360 form (recipients - feedback360_RECIPIENT_* bitmask).

auth_approved_request 1 5 29 -1 Table

Self registration with approval details

feedback_value 0 1 6 -1 Table

values of the completeds

config_log 0 1 7 -1 Table

Changes done in server configuration through admin UI

comp_scale 2 1 6 -1 Table

Competency scale represents the different levels of achievement of a competency

competency_framework 1 2 13 -1 Table

List of competency frameworks.

profiling 0 0 11 -1 Table

Stores the results of all the profiling runs

tool_sitepolicy_site_policy 1 0 2 -1 Table

A list of site policies

goal_user_info_data 1 2 4 -1 Table

Stores personal custom field data related to goals

scorm_seq_objective 1 1 6 -1 Table

SCORM2004 objective description

prog_completion 0 5 11 -1 Table

Stores details of user's program and course set completions

dp_template 5 0 9 -1 Table

Templates store configuration options for a group of plans.

pos 16 3 18 -1 Table

Totara positions

rating 0 3 10 -1 Table

moodle ratings

my_pages 0 1 5 -1 Table

Extra user pages for the My Moodle system

competency_modulecomp 0 2 8 -1 Table

Link a competency to a module.

goal_grp_pos 0 2 6 -1 Table

Stores the position assignments of goals

grade_items_history 0 6 34 -1 Table

History of grade_items

dp_plan_objective 0 2 13 -1 Table

One row for each objective in a plan

enrol_lti_tool_consumer_map 0 2 3 -1 Table

Table that maps the published tool to tool consumers.

appraisal_stage_data 0 2 6 -1 Table

Appraisal stage completion for each asiignment

course_completion_criteria 1 3 10 -1 Table

Course completion criteria

goal_type_info_data_param 0 1 3 -1 Table

Custom organisations fields data parameters

course_modules 4 3 21 -1 Table

course_modules table retrofitted from MySQL

forum_posts 3 3 16 -1 Table

All posts are stored in this table

tool_recyclebin_course 0 1 6 -1 Table

A list of items in the course recycle bin

glossary_alias 0 1 3 -1 Table

entries alias

grade_grades 1 4 23 -1 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.

cohort_rule_params 0 2 7 -1 Table

The parameters of rules in cohort_rules

pos_relations 0 0 4 -1 Table

Tracks relationships between positions

scorm_scoes 8 1 10 -1 Table

each SCO part of the SCORM module

stats_user_weekly 0 3 8 -1 Table

To accumulate weekly stats per course/user

chat_messages_current 0 2 7 -1 Table

Stores current session

dp_plan_evidence_info_data 1 2 4 -1 Table

Stores custom field data related to evidence

enrol_lti_tools 2 2 19 -1 Table

List of tools provided to the remote system

gradingform_rubric_levels 0 1 5 -1 Table

Stores the columns of the rubric grid.

workshopform_accumulative 0 1 7 -1 Table

The assessment dimensions definitions of Accumulative grading strategy forms

comp_criteria_record 0 3 8 -1 Table

Tracks historical progress towards a competency for each user

facetoface_notification_tpl 0 0 7 -1 Table

Seminar notification templates

dp_plan_settings 0 0 5 -1 Table

Contains settings for the plan

tool_monitor_history 0 2 4 -1 Table

Table to store history of message notifications sent

competency_usercomp 1 2 10 -1 Table

User competencies

tag_coll 2 0 7 -1 Table

Defines different set of tags

feedback360_scale_value 1 1 4 -1 Table

Multiple choice options (score can be used when applicable)

mnetservice_enrol_enrolments 0 2 7 -1 Table

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

external_services_functions 0 1 3 -1 Table

lists functions available in each service group

competency 9 2 17 -1 Table

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

facetoface_signups 3 4 9 -1 Table

User signups for events

resource 1 0 13 -1 Table

Each record is one resource and its config data

tag_instance 0 2 10 -1 Table

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

user_devices 0 1 11 -1 Table

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

facetoface_asset_info_data_param 0 1 3 -1 Table

Asset custom fields data parameters

question_ddwtos 0 1 10 -1 Table

Defines drag and drop (words into sentences) questions

block_zoola_schedule_rcp 0 2 3 -1 Table

Scheduled reports recipients

grade_categories 5 2 14 -1 Table

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

prog_completion_history 0 6 11 -1 Table

Stores details of user's program and course set completions history

assign_plugin_config 0 1 6 -1 Table

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

quiz 6 0 41 -1 Table

The settings for each quiz.

question_attempt_steps 1 2 7 -1 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.

appraisal_stage_role_setting 0 1 4 -1 Table

Role access settings for each stage. appraisalrole - APPRAISAL_ROLE_* constant.

repository 0 0 4 -1 Table

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

lesson_pages 3 1 13 -1 Table

Defines lesson_pages

message_providers 0 0 4 -1 Table

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

assignfeedback_editpdf_annot 0 1 11 -1 Table

stores annotations added to pdfs submitted by students

prog_courseset_course 0 2 3 -1 Table

Stores the details of the individual courses contained in a course set

auth_connect_users 0 2 5 -1 Table

List of users from each Totara Connect server

workshopform_numerrors 0 1 9 -1 Table

The assessment dimensions definitions of Number of errors grading strategy forms

block_positions 0 2 8 -1 Table

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

appraisal_stage 5 1 5 -1 Table

Stages within appraisal

local_ld_module 1 2 4 -1 Table

Time spent on a module

config_plugins 0 0 4 -1 Table

Moodle modules and plugins configuration variables

qtype_match_subquestions 0 1 5 -1 Table

The subquestions that make up a matching question

question_numerical 0 1 4 -1 Table

Options for numerical questions.

totara_connect_client_cohorts 0 2 4 -1 Table

List of cohorts synced to a client, the members are restricted by totara_connect_clients.cohortid if specified

messageinbound_handlers 1 0 6 -1 Table

Inbound Message Handler definitions.

user_info_data 0 4 5 -1 Table

Data for the customisable user fields

label 0 0 6 -1 Table

Defines labels

mnet_service 0 0 5 -1 Table

A service is a group of functions

course_info_data_param 0 1 3 -1 Table

Custom course fields data parameters

forum_read 0 4 7 -1 Table

Tracks each users read posts

forum_discussions 4 2 14 -1 Table

Forums are composed of discussions

user_info_field 2 1 20 -1 Table

Customisable user profile fields

dp_course_settings 0 1 5 -1 Table

Contains settings specific to the course component

comp_type_info_data 1 2 4 -1 Table

Stores custom field data related to competencies

pos_type_info_data_param 0 1 3 -1 Table

Custom positions fields data parameters

page 2 0 13 -1 Table

Each record is one page and its config data

workshopform_rubric 1 1 5 -1 Table

The assessment dimensions definitions of Rubric grading strategy forms

enrol_lti_lti2_consumer 5 0 19 -1 Table

LTI consumers interacting with moodle

scorm_seq_rulecond 0 2 7 -1 Table

SCORM2004 rule condition

prog_message 1 1 10 -1 Table

Stores details of the messages defined within a program

wiki_synonyms 0 1 4 -1 Table

Stores wiki pages synonyms

question_usages 1 1 4 -1 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.

totara_sync_log 0 0 7 -1 Table

log table for totara element syncing

comp_criteria 1 1 9 -1 Table

A competency can be achieved by one or more forms of evidence

totara_userdata_purge 1 4 11 -1 Table

List of all user data purges and their result

tool_monitor_events 0 3 8 -1 Table

A table that keeps a log of events related to subscriptions

comp_template 1 1 10 -1 Table

A template is used to group competencies

course_info_field 2 0 16 -1 Table

Custom course fields

chat_messages 0 2 7 -1 Table

Stores all the actual chat messages

dp_priority_scale_value 5 2 9 -1 Table

Scale values for development plan priority scales

external_services 3 0 11 -1 Table

built in and custom external services

dp_plan_evidence_info_field 1 0 16 -1 Table

Stores the custom fields used in evidence

grading_areas 1 1 5 -1 Table

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

scale_history 0 4 11 -1 Table

History table

role_context_levels 0 1 3 -1 Table

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

report_builder_settings 0 1 5 -1 Table

Contains settings for individual reports

stats_user_monthly 0 3 8 -1 Table

To accumulate monthly stats per course/user

user_enrolments 0 3 9 -1 Table

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

lesson_timer 0 2 7 -1 Table

lesson timer for each lesson

qtype_ddimageortext_drags 0 1 6 -1 Table

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

local_ld_module_day 0 1 5 -1 Table

Time spent on a module at day level

role_assignments 0 3 9 -1 Table

assigning roles in different context

portfolio_instance_user 0 2 5 -1 Table

user data for portfolio instances.

report_builder_graph 0 1 10 -1 Table

Report graphs

assignfeedback_comments 0 2 5 -1 Table

Text feedback for submitted assignments

capabilities 1 0 6 -1 Table

this defines all capabilities

choice_answers 0 3 5 -1 Table

choices performed by users

org 17 3 16 -1 Table

Totara organisations

groups_members 0 2 6 -1 Table

Link a user to a group.

appraisal_review_data 0 3 7 -1 Table

Course, objectives, etc reviews in appraisal

enrol_lti_lti2_resource_link 2 3 9 -1 Table

Link from the consumer to the tool

scorm 3 0 42 -1 Table

each table is one SCORM module and its configuration

course 75 1 36 -1 Table

Central course table

question 30 4 19 -1 Table

The questions themselves

goal_user_type_cohort 0 2 5 -1 Table

Contains audiences allowed to select specific personal goal types.

stats_weekly 0 2 7 -1 Table

To accumulate weekly stats

qtype_ddmarker_drops 0 1 6 -1 Table

drop regions

goal_scale_values 4 1 10 -1 Table

The individual values that make up a goal scale

lesson_grades 0 2 6 -1 Table

Defines lesson_grades

log_queries 0 0 9 -1 Table

Logged database queries.

backup_logs 0 1 5 -1 Table

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

user_info_category 1 0 3 -1 Table

Customisable fields categories

question_answers 0 1 7 -1 Table

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

question_dataset_items 0 0 4 -1 Table

Individual dataset items

appraisal_role_assignment 3 2 6 -1 Table

Individual user assignments by their roles

report_builder_schedule_email_systemuser 0 2 3 -1 Table

Storing system users to email in scheduled reports

enrol_lti_lti2_context 1 1 7 -1 Table

Information about a specific LTI contexts from the consumers

tool_sitepolicy_localised_policy 1 2 11 -1 Table

A policy in a particular language

message_processors 0 0 3 -1 Table

List of message output plugins

workshopform_rubric_levels 0 1 5 -1 Table

The definition of rubric rating scales

repository_opensesame_bdls 1 0 3 -1 Table

Totara OpenSesame course bundles

lock_db 0 0 4 -1 Table

Stores active and inactive lock types for db locking method.

assignfeedback_editpdf_queue 0 0 3 -1 Table

Queue for processing.

questionnaire_response_rank 0 0 5 -1 Table

questionnaire_response_rank table retrofitted from MySQL

totara_dashboard_user 0 2 3 -1 Table

User modified instances of dashboards

course_published 0 1 8 -1 Table

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

prog_info_data 1 2 4 -1 Table

Stores custom field data related to programs

grade_outcomes_history 0 4 12 -1 Table

History table

reportbuilder_grp_user_record 0 2 4 -1 Table

Individual users that restricted users can see

book 1 0 11 -1 Table

Defines book

lti_submission 0 2 9 -1 Table

Keeps track of individual submissions for LTI activities.

portfolio_mahara_queue 0 1 3 -1 Table

maps mahara tokens to transfer ids

oauth2_endpoint 0 1 7 -1 Table

Describes the named endpoint for an oauth2 service.

competency_userevidencecomp 0 2 6 -1 Table

Relationship between user evidence and competencies

sessions 0 1 9 -1 Table

Database based session storage - now recommended

question_calculated_options 0 1 13 -1 Table

Options for questions of type calculated

block_zoola_reports_schedule 0 3 5 -1 Table

Reports scheduled from an event

cohort_visibility 0 2 7 -1 Table

A table to store cohorts visible learning assignments

repository_instances 1 2 10 -1 Table

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

totara_navigation_settings 0 1 6 -1 Table

Settings for navigation menu items

forum 7 0 25 -1 Table

Forums contain and structure discussion

feedback_completed 0 3 7 -1 Table

filled out feedback

totara_connect_client_pos_frameworks 0 2 4 -1 Table

List of position frameworks synced to a client

assign_user_flags 0 2 8 -1 Table

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

facetoface_asset_info_field 1 0 16 -1 Table

Stores the definition of available asset custom fields

facetoface_session_roles 0 3 4 -1 Table

Users with a trainer-like role in a seminar event

grade_settings 0 1 4 -1 Table

gradebook settings

gradingform_guide_comments 0 1 5 -1 Table

frequently used comments used in marking guide

goal_item_history 0 1 6 -1 Table

Store changes to scalevalueid in goal_record and goal_personal.

facetoface_asset_info_data 1 2 4 -1 Table

Stores custom field data related to assets

questionnaire_response 0 1 6 -1 Table

questionnaire_response table retrofitted from MySQL

totara_navigation 1 0 14 -1 Table

Totara navigation menu

course_format_options 0 1 6 -1 Table

Stores format-specific options for the course or course section

comp 10 3 19 -1 Table

Totara competencies

course_sections 0 1 9 -1 Table

to define the sections for each course

totara_core_course_vis_map 0 2 3 -1 Table

Course view hidden capability to role map

logstore_standard_log 0 4 21 -1 Table

Standard log table

enrol_lti_lti2_nonce 0 1 4 -1 Table

Nonce used for authentication between moodle and a consumer

portfolio_tempdata 1 2 6 -1 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 1 1 5 -1 Table

Store files references

mnet_log 0 1 13 -1 Table

Store session data from users migrating to other sites

course_completion_defaults 0 2 8 -1 Table

Totara: Not used (MDL-58138). Default settings for activities completion

log 0 1 10 -1 Table

Every action is logged as far as possible

qtype_multichoice_options 0 1 13 -1 Table

Options for multiple choice questions

feedback360_quest_field 2 1 15 -1 Table

Individual question definitions for each feedback360

workshopform_numerrors_map 0 1 4 -1 Table

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

prog_recurrence 0 3 4 -1 Table

Store the id numbers of the courses that will replace existing courses in a recurring program so that the system can know which course will be used when the current course ends

blog_external 0 1 9 -1 Table

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

goal 8 3 17 -1 Table

Totara goals

tool_usertours_steps 0 1 8 -1 Table

Steps in an tour

block_zoola_notifications 0 1 2 -1 Table

Zoola notifications

quiz_feedback 0 1 6 -1 Table

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

facetoface_session_info_data_param 0 1 3 -1 Table

Custom event fields data parameters

lesson_overrides 0 3 11 -1 Table

The overrides to lesson settings.

tool_monitor_rules 1 2 14 -1 Table

Table to store rules

task_scheduled 0 0 14 -1 Table

List of scheduled tasks to be run by cron.

events_queue_handlers 0 2 6 -1 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.

facetoface_interest 0 1 5 -1 Table

Users who have declared interest in a seminar activity

question_numerical_units 0 1 4 -1 Table

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

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

Link a user to a cohort.

message_working 0 0 3 -1 Table

Lists all the messages and processors that need to be processed

chat 3 0 10 -1 Table

Each of these is a chat room

question_attempts 1 2 14 -1 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

goal_user_type 2 0 9 -1 Table

Table to store goal types for personal goals.

appraisal_scale_data 0 3 4 -1 Table

Multiple user answers

comments 0 2 9 -1 Table

moodle comments module

certificate_issues 0 1 5 -1 Table

Info about issued certificates

assign 10 0 29 -1 Table

This table saves information about an instance of mod_assign in a course.

portfolio_log 0 2 11 -1 Table

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

course_modules_completion 0 2 8 -1 Table

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

appraisal_quest_field_role 0 1 4 -1 Table

Access restrictions for each question. access - APPRAISAL_ACCESS_* constant

local_activityvisibility_que 0 2 4 -1 Table

The update queue

qtype_ddimageortext 0 1 10 -1 Table

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

questionnaire_response_bool 0 0 4 -1 Table

questionnaire_response_bool table retrofitted from MySQL

facetoface_session_info_data 1 2 4 -1 Table

Stores custom field data related to event, these fields describe event details

gradingform_rubric_fillings 0 2 6 -1 Table

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

glossary_categories 1 1 4 -1 Table

all categories for glossary entries

totara_userdata_export_type 2 0 9 -1 Table

List of available user data export types

competency_plan 0 2 13 -1 Table

Learning plans

chat_users 0 2 12 -1 Table

Keeps track of which users are in which chat rooms

facetoface_sessioncancel_info_data_param 0 1 3 -1 Table

Whole event cancellation custom fields data parameters

grading_definitions 4 3 14 -1 Table

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

competency_usercompplan 0 2 10 -1 Table

User competencies plans

gradingform_guide_fillings 0 2 6 -1 Table

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

org_type_info_field 1 1 17 -1 Table

Stores the custom fields for each organisation type

goal_framework 2 0 11 -1 Table

A collection of goals

report_builder_global_restriction 8 0 9 -1 Table

Global Report Restrictions

goal_user_assignment 0 2 8 -1 Table

Stores the user assignments of goals

mnet_host2service 0 0 5 -1 Table

Information about the services for a given host

backup_trusted_files 0 1 6 -1 Table

List of files that are trusted

qtype_match_options 0 1 10 -1 Table

Defines the question-type specific options for matching questions

badge_manual_award 0 4 6 -1 Table

Track manual award criteria for badges

feedback360_grp_pos 0 2 4 -1 Table

Positions assigned to feedback360

tool_sitepolicy_consent_options 2 1 4 -1 Table

Manages localised consents

question_multianswer 0 1 3 -1 Table

Options for multianswer questions

tag 2 2 10 -1 Table

Tag table - this generic table will replace the old "tags" table.

prog 15 2 21 -1 Table

Stores elemental details about programs

prog_future_user_assignment 0 2 4 -1 Table

Future user assignments such as from first login

forum_discussion_subs 0 3 5 -1 Table

Users may choose to subscribe and unsubscribe from specific discussions.

mnet_host 1 1 15 -1 Table

Information about the local and remote hosts for RPC

totara_userdata_export_item 0 1 7 -1 Table

Items of each user data export and their result

tool_recyclebin_category 0 1 5 -1 Table

A list of items in the category recycle bin

forum_track_prefs 0 2 3 -1 Table

Tracks each users untracked forums

message_airnotifier_devices 0 1 3 -1 Table

Store information about the devices registered in Airnotifier for PUSH notifications

workshop_aggregations 0 2 5 -1 Table

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

appraisal_user_assignment 1 4 8 -1 Table

Actual user who is subject of appraisal

wiki_versions 0 2 7 -1 Table

Stores wiki page history

questionnaire_feedback 0 0 7 -1 Table

questionnaire_feedback table retrofitted from MySQL

question_calculated 0 1 7 -1 Table

Options for questions of type calculated

role_allow_assign 0 2 3 -1 Table

this defines what role can assign what role

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

A list of message IDs for existing replies

questionnaire_attempts 0 1 5 -1 Table

questionnaire_attempts table retrofitted from MySQL

enrol 3 2 35 -1 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 1 4 -1 Table

Defines parameters for badges criteria

wiki 1 0 13 -1 Table

Stores Wiki activity configuration

competency_templatecohort 0 2 6 -1 Table

Default comment for the table, please edit me

appraisal_quest_field 3 2 15 -1 Table

Individual question list for appraisal page

folder 0 0 10 -1 Table

each record is one folder resource

competency_evidence 0 2 14 -1 Table

The evidence linked to a user competency

dp_permissions 0 1 6 -1 Table

Stores the permission settings for plan templates

competency_plancomp 0 1 7 -1 Table

Plan competencies

external_functions 0 0 8 -1 Table

list of all external functions

totara_compl_import_course 0 1 17 -1 Table

Intermediary file for importing course completion data

external_services_users 0 2 6 -1 Table

users allowed to use services with restricted users flag

filter_config 0 1 5 -1 Table

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

goal_grp_org 0 2 6 -1 Table

Stores the organisation assignments of goals

block 1 0 5 -1 Table

contains all installed blocks

competency_relatedcomp 0 1 6 -1 Table

Related competencies

facetoface_sessioncancel_info_data 1 2 4 -1 Table

Stores custom field data related to cancellation of the whole event

glossary_entries 2 2 16 -1 Table

all glossary entries

data 2 0 37 -1 Table

all database activities

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

Options for True-False questions

goal_user_info_field 1 1 17 -1 Table

Stores the personal custom fields for each goal type

org_relations 0 2 4 -1 Table

Tracks relationships between organisations

lti 3 1 26 -1 Table

This table contains Basic LTI activities instances

mnet_remote_rpc 0 0 6 -1 Table

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

comp_record_history 0 3 7 -1 Table

Store changes to proficiency in comp_record.

course_completion_aggr_methd 0 1 5 -1 Table

Course completion aggregation methods for criteria

assignfeedback_editpdf_quick 0 1 5 -1 Table

Stores teacher specified quicklist comments

blog_association 0 2 3 -1 Table

Associations of blog entries with courses and module instances

local_activityvisibility 0 3 7 -1 Table

Default comment for local_activityvisibility, please edit me

reminder 2 1 9 -1 Table

Totara course reminders

tool_customlang 0 1 11 -1 Table

Contains the working checkout of all strings and their customization

totara_userdata_purge_type_item 0 1 7 -1 Table

Purge type items and their settings, each purge type has records for all items available at the time of saving changes

enrol_lti_lti2_tool_proxy 0 1 6 -1 Table

A tool proxy between moodle and a consumer

choice 2 0 18 -1 Table

Available choices are stored here

enrol_totara_f2f_pending 0 2 4 -1 Table

Queue for users waiting for f2f approval before enrolment

external_tokens 0 4 12 -1 Table

Security tokens for accessing of external services

events_handlers 1 0 8 -1 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.

reminder_message 0 1 8 -1 Table

Totara course reminder messages

messageinbound_datakeys 0 1 6 -1 Table

Inbound Message data item secret keys.

question_attempt_step_data 0 1 4 -1 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 _-

goal_scale_assignments 0 2 5 -1 Table

Tracks which scales are assigned to which goal frameworks

block_recent_activity 0 2 7 -1 Table

Recent activity block

tool_sitepolicy_user_consent 0 2 6 -1 Table

Answers from the user in the localised policy

auth_approved_request_snapshots 0 5 31 -1 Table

History of auth_approved_request records

data_fields 1 1 16 -1 Table

every field available

badge_backpack 1 1 7 -1 Table

Defines settings for connecting external backpack

job_assignment 5 7 22 -1 Table

Assignment of a job to a user

pos_type_info_field 1 1 17 -1 Table

Stores the custom fields for each position type

scorm_aicc_session 0 2 12 -1 Table

Used by AICC HACP to store session information

feedback360_grp_org 0 2 4 -1 Table

Organisations assigned to feedback360

grading_instances 2 2 9 -1 Table

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

course_request 0 0 9 -1 Table

course requests

question_numerical_options 0 1 6 -1 Table

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

role_allow_override 0 2 3 -1 Table

this defines what role can override what role

user 255 0 54 -1 Table

One record for each person

appraisal_role_changes 0 1 6 -1 Table

Store role changes for assignments

repository_opensesame_pkgs 1 0 11 -1 Table

Totara OpenSesame course packages

facetoface_notification 2 3 21 -1 Table

Seminar notifications

grade_import_newitem 1 1 4 -1 Table

temporary table for storing new grade_item names from grade import

feedback360_resp_assignment 1 3 8 -1 Table

feedback360 responders assignments

workshopform_rubric_config 0 1 3 -1 Table

Configuration table for the Rubric grading strategy

tool_customlang_components 1 0 3 -1 Table

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

tool_sitepolicy_policy_version 2 2 7 -1 Table

Record of all versions of a policy, including not yet published

totara_userdata_export_type_item 0 1 7 -1 Table

Export type items and their settings, each export type has records for all items available at the time of saving changes

block_totara_stats 0 1 6 -1 Table

Holds stats information

workshopallocation_scheduled 0 1 9 -1 Table

Stores the allocation settings for the scheduled allocator

quiz_overrides 0 3 9 -1 Table

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