Tables


SchemaSpy Analysis of t16release

Generated on Mon May 23 02:23 GMT 2022

Totara DB Schema t16-release

XML Representation
Insertion Order Deletion Order
TABLES 753
VIEWS 0
COLUMNS 6316
Constraints 94
Anomalies 36
Routines 0

Database Properties

Database Type: PostgreSQL - 12.10 (Debian 12.10-1.pgdg110+1)

Schema public

Foreign Key information for Totara tables

Tables

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

Contains settings for individual reports

app_course_completion_criteria 0 0 10 0 Table

Course completion criteria

app_feedback_completed_history 1 2 8 0 Table

history of filled out feedback

app_prog_info_data_param 0 1 3 0 Table

Custom programs fields data parameters

app_appraisal_grp_org 0 2 4 0 Table

Organisations assigned to appraisal

app_enrol_lti_lti2_consumer 5 0 19 0 Table

LTI consumers interacting with moodle

app_oauth2_issuer 8 0 22 0 Table

Details for an oauth 2 connect identity issuer.

app_scorm_seq_ruleconds 1 1 5 0 Table

SCORM2004 rule conditions

app_totara_competency_assignments 10 2 13 0 Table

Totara assignments

app_perform_type 2 0 4 3 Table

Perform activity types

app_prog_extension 0 2 7 0 Table

Stores extension requests for programs

app_question_multianswer 0 1 3 0 Table

Options for multianswer questions

app_backup_trusted_files 0 1 6 0 Table

List of files that are trusted

app_org 15 3 16 0 Table

Totara organisations

app_grade_grades_history 0 6 24 0 Table

History table

app_org_type_info_data_param 0 1 3 0 Table

Custom organisations fields data parameters

app_page 0 0 13 0 Table

Each record is one page and its config data

app_enrol_totara_f2f_pending 0 0 4 0 Table

Queue for users waiting for f2f approval before enrolment

app_prog_info_field 1 0 16 0 Table

Stores the custom fields for each program type

app_feedback_item 3 2 13 0 Table

feedback_items

app_workshopform_rubric_config 0 0 3 0 Table

Configuration table for the Rubric grading strategy

app_lti_submission 0 0 9 0 Table

Keeps track of individual submissions for LTI activities.

app_grade_import_newitem 1 1 4 0 Table

temporary table for storing new grade_item names from grade import

app_competency_evidence 0 0 14 0 Table

The evidence linked to a user competency

app_totara_competency_achievement 2 5 12 0 Table

Record of competency proficiency of a user

app_cache_filters 0 0 6 0 Table

For keeping information about cached data

app_goal_type_info_data 1 2 4 0 Table

Stores custom field data related to goals

app_question_ddwtos 0 1 10 0 Table

Defines drag and drop (words into sentences) questions

app_facetoface_sessions 7 2 20 0 Table

Describes seminar events

app_block_rss_client 0 0 9 0 Table

Remote news feed information. Contains the news feed id, the userid of the user who added the feed, the title of the feed itself and a description of the feed contents along with the url used to access the remote feed. Preferredtitle is a field for f

app_messageinbound_handlers 1 0 6 3 Table

Inbound Message Handler definitions.

app_certif 3 0 7 0 Table

Certifications

app_tool_customlang_components 1 0 3 0 Table

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

app_oauth2_endpoint 0 1 7 0 Table

Describes the named endpoint for an oauth2 service.

app_choice_answers 0 2 5 0 Table

choices performed by users

app_report_builder_saved 1 2 8 0 Table

Stores saved searches for reports

app_report_builder_filters 0 1 11 0 Table

Defines filters belonging to each report

app_stats_user_monthly 0 0 8 0 Table

To accumulate monthly stats per course/user

app_totara_mobile_tokens 0 0 3 0 Table

List of tokins for mobile login setup

app_workshop_aggregations 0 2 5 0 Table

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

app_tool_sitepolicy_user_consent 0 2 6 0 Table

Answers from the user in the localised policy

app_assign_overrides 0 3 8 0 Table

The overrides to assign settings.

app_feedback360_grp_cohort 0 2 3 0 Table

Audiences assigned to feedback360

app_glossary_entries_categories 0 2 3 0 Table

categories of each glossary entry

app_reportbuilder_grp_org_user 0 2 5 0 Table

Restricted organisations that will see only allowed records

app_totara_core_certification_vis_map 0 2 3 0 Table

Certification view hidden capability to role map

app_dp_plan_history 0 2 7 0 Table

A table for tracking and recording modifications to a related dp_plan

app_block_positions 0 2 8 0 Table

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

app_forum_read 0 0 7 0 Table

Tracks each users read posts

app_totara_userdata_export_type 2 0 9 0 Table

List of available user data export types

app_course_completion_log 0 3 6 0 Table

Record of changes made to course completion records

app_cohort_msg_queue 0 3 8 0 Table

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

app_facetoface_interest 0 0 5 0 Table

Users who have declared interest in a seminar activity

app_certificate_issues_history 0 2 10 0 Table

Archived user certificates for Totara

app_question_statistics 0 0 18 0 Table

Statistics for individual questions used in an activity.

app_prog_completion 0 3 11 0 Table

Stores details of user’s program and course set completions

app_certif_completion_history 0 2 12 0 Table

Previous completed certifications

app_totara_msteams_channel 1 0 2 0 Table

Stores channel information of MS Teams.

app_forum_queue 0 2 5 0 Table

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

app_lesson 7 0 42 0 Table

Defines lesson

app_totara_core_relationship_resolver 0 2 3 9 Table

The resolvers for each relationship

app_appraisal_stage_role_setting 0 1 4 6 Table

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

app_license 0 0 6 9 Table

store licenses used by moodle

app_qtype_essay_options 0 1 11 0 Table

Extra options for essay questions.

app_marketplace_linkedin_learning_object_classify 0 2 3 0 Table

Stores the relationship between the marketplace linkedin learning object and the classification

app_totara_msteams_bot 3 0 4 0 Table

Stores bot information.

app_appraisal_scale_data 0 3 4 0 Table

Multiple user answers

app_message_popup_notifications 0 1 2 0 Table

List of notifications to display in the message output popup

app_message_processors 0 0 3 7 Table

List of message output plugins

app_assignfeedback_editpdf_annot 0 1 11 0 Table

stores annotations added to pdfs submitted by students

app_dp_course_settings 0 2 5 1 Table

Contains settings specific to the course component

app_repository_instance_config 0 0 4 0 Table

The config for intances

app_tool_usertours_steps 0 1 8 0 Table

Steps in an tour

app_engage_article 0 0 4 0 Table

Article record

app_report_builder_columns 0 1 10 0 Table

Defines columns belonging to each report

app_auth_connect_servers 5 0 12 0 Table

List of servers

app_goal_item_target_date_history 0 0 6 0 Table

Store changes to target dates in goal_record and goal_personal.

app_org_relations 0 2 4 0 Table

Tracks relationships between organisations

app_pathway_manual 1 0 3 0 Table

Criteria manual pathway definition

app_dp_objective_scale_value 2 2 10 3 Table

Objective Scale values for development plan priority scales

app_report_builder_schedule_email_external 0 1 3 0 Table

Storing external emails to send in scheduled reports

app_tool_sitepolicy_consent_options 2 1 4 0 Table

Manages localised consents

app_tool_monitor_subscriptions 1 1 8 0 Table

Table to store user subscriptions to various rules

app_totara_cloudfiledir_sync 0 0 6 0 Table

Table for tracking of cloud file content storage sync - main purpose is to improve peformance

app_totara_criteria_item 2 2 4 0 Table

Items linked to a specific criterion

app_log 0 0 10 0 Table

Every action is logged as far as possible

app_org_type_info_field 1 1 17 0 Table

Stores the custom fields for each organisation type

app_totara_userdata_export_item 0 1 7 0 Table

Items of each user data export and their result

app_engage_answer_option 1 2 5 0 Table

Table for the options of question

app_marketplace_linkedin_classification_relationship 0 2 3 0 Table

Stores the relationship between the classifications only

app_totara_competency_configuration_change 0 3 6 0 Table

Record of changes to criteria configuration of competency

app_user_private_key 0 1 8 0 Table

access keys used in cookieless scripts - rss, etc.

app_facetoface_room_info_data_param 0 1 3 0 Table

Custom room fields data parameters

app_quiz_reports 0 0 4 4 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.

app_tag_area 0 1 8 16 Table

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

app_feedback_value 0 1 6 0 Table

values of the completeds

app_groups 5 1 11 0 Table

Each record represents a group.

app_lesson_branch 0 2 8 0 Table

branches for each lesson/user

app_event_subscriptions 0 0 10 0 Table

Tracks subscriptions to remote calendars.

app_workshopform_comments 0 1 5 0 Table

The assessment dimensions definitions of Comments strategy forms

app_role_allow_assign 0 2 3 8 Table

this defines what role can assign what role

app_workspace_discussion 0 2 12 0 Table

Table to store the discussions within the workspace

app_reaction 0 4 7 0 Table

User’s reaction

app_facetoface_facilitator 2 3 11 0 Table

Table for storing seminar facilitator data

app_glossary_alias 0 1 3 0 Table

entries alias

app_prog_completion_history 0 4 11 0 Table

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

app_engage_share_recipient 0 3 10 0 Table

Share recipients

app_perform_subject_instance 14 3 14 0 Table

Represents a single activity for one subject user

app_quiz_sections 0 1 5 0 Table

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

app_totara_connect_client_pos_frameworks 0 2 4 0 Table

List of position frameworks synced to a client

app_question_numerical_units 0 1 4 0 Table

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

app_course_completions 1 0 15 0 Table

Course completion records

app_ml_recommender_users 0 2 9 0 Table

Suggested content for users

app_reportbuilder_grp_pos_record 0 2 5 0 Table

Positions that restricted users can see

app_auth_connect_user_collections 0 2 6 0 Table

List of cohorts synced from server

app_comp_scale 2 2 7 1 Table

Competency scale represents the different levels of achievement of a competency

app_forum 4 0 25 0 Table

Forums contain and structure discussion

app_totara_contentmarketplace_course_module_source 0 0 4 0 Table

Stores the relationship between a course module and a totara_contentmarketplace plugin

app_enrol_lti_users 0 2 12 0 Table

User access log and gradeback data

app_goal_perform_status 0 13 10 0 Table

Stores the goal assignment status changes that were made in performance activities

app_config_log 0 1 7 1739 Table

Changes done in server configuration through admin UI

app_competency_usercompplan 0 0 10 0 Table

User competencies plans

app_workshopform_rubric_levels 0 1 5 0 Table

The definition of rubric rating scales

app_course_categories 6 1 17 3 Table

Course categories

app_engage_survey 2 0 2 0 Table

Table for pulse survey

app_oauth2_system_account 0 1 9 0 Table

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

app_dp_plan_program_assign 0 3 8 0 Table

Stores program assigned to a particular plan

app_facetoface_notification 2 3 22 0 Table

Seminar notifications

app_lti_tool_settings 0 4 8 0 Table

LTI tool setting values

app_comp_type 2 0 8 0 Table

Competency types are used to manage custom fields

app_stats_weekly 0 0 7 0 Table

To accumulate weekly stats

app_facetoface_signup_info_data 1 2 4 0 Table

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

app_goal_type 2 0 8 0 Table

Goal types are used to manage custom fields

app_stats_monthly 0 0 7 0 Table

To accumulate monthly stats

app_workshop_assessments 1 3 15 0 Table

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

app_auth_connect_sso_requests 0 1 5 0 Table

List of SSO requests from Totara Connect client to server

app_facetoface_asset_info_data_param 0 1 3 0 Table

Asset custom fields data parameters

app_totara_userdata_export_type_item 0 1 7 0 Table

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

app_appraisal_event_message 1 1 4 0 Table

Appraisal event message

app_config_plugins 0 0 4 2364 Table

Moodle modules and plugins configuration variables

app_tool_monitor_history 0 1 4 0 Table

Table to store history of message notifications sent

app_pos_framework 2 0 11 0 Table

A collection of positions

app_enrol_lti_lti2_share_key 0 1 5 0 Table

Resource link share key

app_reminder_sent 0 0 5 0 Table

Totara course reminders log of messages sent

app_block_totara_featured_links_tiles 1 3 18 0 Table

Defines tiles for Totara featured links blocks

app_lesson_timer 0 1 7 0 Table

lesson timer for each lesson

app_prog_message 1 1 10 0 Table

Stores details of the messages defined within a program

app_quiz_overview_regrades 0 0 7 0 Table

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

app_comp_type_info_data_param 0 1 3 0 Table

Custom competencies fields data parameters

app_dp_plan_competency_value 0 6 12 0 Table

Competency values set via the learning plan

app_dp_plan 6 2 10 0 Table

Stores individual plans belonging to users.

app_facetoface_signups_status 0 2 7 0 Table

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

app_repository_opensesame_bdls 1 0 3 0 Table

Totara OpenSesame course bundles

app_totara_core_relationship 15 0 6 9 Table

List of relationships that can exist between users

app_user_preferences 0 0 4 1 Table

Allows modules to store arbitrary user preferences

app_question_usages 2 1 4 0 Table

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

app_goal_record 0 3 5 0 Table

Track current status of a user within goals

app_scorm 3 0 43 0 Table

each table is one SCORM module and its configuration

app_stats_user_daily 0 0 8 0 Table

To accumulate daily stats per course/user

app_totara_sync_log 0 0 7 0 Table

log table for totara element syncing

app_user_info_data 0 2 5 0 Table

Data for the customisable user fields

app_reportbuilder_grp_user_record 0 2 4 0 Table

Individual users that restricted users can see

app_playlist 2 2 9 0 Table

Table for playlist records

app_messageinbound_datakeys 0 1 6 0 Table

Inbound Message data item secret keys.

app_question_dataset_definitions 1 1 6 0 Table

Organises and stores properties for dataset items

app_lesson_overrides 0 3 11 0 Table

The overrides to lesson settings.

app_filter_config 0 1 5 0 Table

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

app_assign_submission 2 1 9 0 Table

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

app_perform_section_element 3 4 4 0 Table

Table to connect a specific question to a specific performance activity section

app_dp_program_settings 0 1 5 1 Table

Contains settings specific to the program component

app_perform_notification_recipient 0 4 4 0 Table

Represents a notification setting recipient

app_totara_msteams_bot_settings 0 1 6 0 Table

Stores per bot settings.

app_prog_info_data 1 2 4 0 Table

Stores custom field data related to programs

app_facetoface_signups 4 4 9 0 Table

User signups for events

app_report_builder_graph 0 1 10 0 Table

Report graphs

app_competency_template 1 0 10 0 Table

Learning plan templates.

app_user_info_field 1 0 20 0 Table

Customisable user profile fields

app_feedback360_scale_data 0 3 4 0 Table

Multiple user answers

app_course_info_data 1 2 4 0 Table

Custom course fields data

app_prog 13 2 21 0 Table

Stores elemental details about programs

app_comments 0 1 9 0 Table

moodle comments module

app_appraisal_stage 5 1 5 3 Table

Stages within appraisal

app_course_completion_aggr_methd 0 0 5 0 Table

Course completion aggregation methods for criteria

app_course_modules 1 1 21 0 Table

course_modules table retrofitted from MySQL

app_events_queue_handlers 0 2 6 0 Table

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

app_prog_recurrence 0 3 4 0 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

app_repository_instances 1 0 10 6 Table

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

app_facetoface_facilitator_info_data 1 2 4 0 Table

Stores custom field data related to facilitators

app_pathway_manual_role 0 1 3 0 Table

Roles for a given manual pathway definition

app_perform_section 6 2 6 0 Table

Performance activities are split into one or more sections

app_profiling 0 0 11 0 Table

Stores the results of all the profiling runs

app_totara_competency_configuration_history 0 3 6 0 Table

History of criteria configuration during a specific period

app_totara_evidence_type_info_field 2 2 17 10 Table

Evidence fields

app_appraisal_user_assignment 1 4 8 0 Table

Actual user who is subject of appraisal

app_groups_members 0 2 6 0 Table

Link a user to a group.

app_totara_criteria_item_record 0 3 6 0 Table

Record regarding whether a user met a specific criterion item or not

app_goal_user_type_cohort 0 2 5 0 Table

Contains audiences allowed to select specific personal goal types.

app_marketplace_goone_learning_object 0 0 2 0 Table

Stores the learning assets from Go1 locally

app_totara_mobile_compatible_courses 0 2 2 0 Table

Lookup table of courses which are suitable for native app rendering

app_totara_criteria 4 0 8 0 Table

Totara boolean criteria definitions

app_perform_track_assignment 2 2 9 0 Table

Mapping of tracks to user group assignments

app_competency_coursecomp 0 2 8 0 Table

Link a competency to a course.

app_cohort_rule_params 0 2 7 0 Table

The parameters of rules in cohort_rules

app_facetoface_session_info_field 1 0 17 0 Table

Stores the definitions for event custom fields

app_ml_recommender_components 2 0 3 0 Table

Dictionary of components and areas used in recommender tables

app_totara_connect_clients 5 1 18 0 Table

List of client systems registered with this server

app_stats_daily 0 0 7 0 Table

to accumulate daily stats

app_chat_users 0 1 12 0 Table

Keeps track of which users are in which chat rooms

app_wiki_versions 0 1 7 0 Table

Stores wiki page history

app_competency 3 0 17 0 Table

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

app_cohort_plan_history 0 3 10 0 Table

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

app_notification_queue 0 2 9 0 Table

A table to queue all the notifications to be sending out to the outputs

app_workshopform_numerrors_map 0 1 4 0 Table

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

app_appraisal_user_event 0 2 4 0 Table

Appraisal events scheduled to specific users

app_dp_plan_component_relation 0 0 6 0 Table

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

app_org_competencies 0 2 7 0 Table

Track competencies assigned to a particular organisation

app_reportbuilder_grp_org_record 0 2 5 0 Table

Organisations that restricted users can see

app_dp_plan_competency_assign 0 4 9 0 Table

Stores competencies assigned to a particular plan

app_feedback360_scale 1 2 5 0 Table

Multiple choice sets

app_assignfeedback_file 0 2 4 0 Table

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

app_message 0 0 16 0 Table

Stores all unread messages

app_perform_participant_section 0 4 7 0 Table

Represents progress on a section for a single participant

app_question_numerical 0 1 4 0 Table

Options for numerical questions.

app_scorm_trusted_packages 0 1 4 0 Table

Whitelist of known trusted SCORM packages

app_grade_outcomes_history 0 4 12 0 Table

History table

app_label 0 0 6 0 Table

Defines labels

app_feedback360_resp_assignment 1 3 8 0 Table

feedback360 responders assignments

app_user_enrolments 0 3 9 0 Table

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

app_wiki_pages 2 1 10 0 Table

Stores wiki pages

app_totara_userdata_purge_item 0 1 7 0 Table

Items of each user data purge and their result

app_totara_userdata_purge 1 2 11 0 Table

List of all user data purges and their result

app_dp_objective_settings 0 3 6 1 Table

Settings for a template’s objectives

app_engage_bookmark 0 2 5 0 Table

Table for bookmarks

app_totara_mobile_requests 0 1 4 0 Table

List of registration requests

app_facetoface 2 1 43 0 Table

Each seminar activity has an entry here

app_survey 2 0 11 5 Table

Each record is one SURVEY module with its configuration

app_enrol 3 1 35 0 Table

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

app_perform_element_identifier 1 0 2 0 Table

Table containing identifier strings that can be used to tag elements

app_totara_dashboard_cohort 0 2 3 0 Table

Users modifications of pages

app_quiz_overrides 0 3 9 0 Table

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

app_appraisal_scale_value 1 1 4 2 Table

Multiple choice options (score can be used when applicable)

app_question_calculated 0 1 7 0 Table

Options for questions of type calculated

app_totara_msteams_user 2 2 5 0 Table

Stores user mapping for MS Teams.

app_comp_type_info_data 1 2 4 0 Table

Stores custom field data related to competencies

app_org_framework 2 0 11 0 Table

A collection of organisations

app_qtype_shortanswer_options 0 1 3 0 Table

Options for short answer questions

app_report_builder_schedule_email_audience 0 2 3 0 Table

Storing audience to email in scheduled reports

app_role_context_levels 0 1 3 20 Table

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

app_feedback_completedtmp 0 1 8 0 Table

filled out feedback

app_badge_issued 1 2 8 0 Table

Defines issued badges

app_competency_plancomp 0 0 7 0 Table

Plan competencies

app_competency_plan 0 0 13 0 Table

Learning plans

app_wiki 1 0 13 0 Table

Stores Wiki activity configuration

app_editor_weka_emojis 0 0 6 32 Table

Emoji details

app_data_records 1 1 7 0 Table

every record introduced

app_facetoface_notification_tpl 0 0 7 24 Table

Seminar notification templates

app_dp_competency_settings 0 2 10 1 Table

Contains settings specific to the competency component

app_virtualmeeting_config 0 2 6 0 Table

Virtual meeting configurations

app_forum_discussions 3 1 14 0 Table

Forums are composed of discussions

app_totara_competency_scale_aggregation 0 1 4 0 Table

Method of aggregation when determining achieved value

app_engage_question 4 2 7 0 Table

Table for centralized engage questions

app_course_modules_completion 0 0 9 0 Table

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

app_block 0 0 5 63 Table

contains all installed blocks

app_qtype_ddimageortext_drops 0 1 7 0 Table

Drop boxes

app_external_tokens 0 4 12 0 Table

Security tokens for accessing of external services

app_dp_priority_scale_value 5 2 9 3 Table

Scale values for development plan priority scales

app_perform_element 6 2 9 0 Table

An element used within a section of a performance activity

app_totara_msteams_subscription 0 6 5 0 Table

Stores subscription information.

app_facetoface_session_roles 0 2 4 0 Table

Users with a trainer-like role in a seminar event

app_perform_manual_relation_selection 2 3 5 0 Table

Indicates the roles who need to manually choose participant roles

app_survey_analysis 0 1 4 0 Table

text about each survey submission

app_course_sections 0 0 10 0 Table

to define the sections for each course

app_book_chapters 0 0 11 0 Table

Defines book_chapters

app_goal_framework 2 0 11 0 Table

A collection of goals

app_user 243 2 51 2 Table

One record for each person

app_comp_scale_assignments 0 2 5 0 Table

Tracks which scales are assigned to which competency frameworks

app_enrol_lti_tool_consumer_map 0 2 3 0 Table

Table that maps the published tool to tool consumers.

app_appraisal_event_rcpt 0 1 3 0 Table

Appraisal events recipients (roles)

app_notification_preference 1 1 19 54 Table

A table to store the overridden of built-in and custom notification preferences

app_cohort 20 1 21 0 Table

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

app_qtype_ddmarker_drags 0 1 6 0 Table

Labels for markers to drag.

app_qtype_ddimageortext 0 1 10 0 Table

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

app_catalog 0 0 9 0 Table

Catalog table

app_tag_instance 0 2 10 0 Table

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

app_pos_competencies 0 2 7 0 Table

Tracks competencies assigned to a particular position

app_glossary_categories 1 1 4 0 Table

all categories for glossary entries

app_facetoface_facilitator_info_field 1 0 16 0 Table

Stores the definition of available facilitator custom fields

app_facetoface_sessions_dates 6 1 5 0 Table

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

app_wiki_links 0 2 5 0 Table

Page wiki links

app_workshopeval_best_settings 0 1 3 0 Table

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

app_grading_definitions 4 3 14 0 Table

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

app_totara_dashboard 2 2 7 1 Table

Dashboards

app_context_map 0 0 3 80 Table

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

app_block_quicklinks 0 0 6 3 Table

Holds information on the defined links of a block

app_imscp 0 0 9 0 Table

each record is one imscp resource

app_editor_atto_autosave 0 0 9 0 Table

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

app_badge_external_identifier 0 1 5 0 Table

Setting for external badges mappings

app_files_reference 1 1 5 0 Table

Store files references

app_dp_record_of_learning 0 1 4 0 Table

Holds the record of learning for a user (courses only for now)

app_goal_user_type 2 0 9 0 Table

Table to store goal types for personal goals.

app_prog_future_user_assignment 0 0 4 0 Table

Future user assignments such as from first login

app_reportbuilder_grp_pos_user 0 2 5 0 Table

Restricted positions that will see only allowed records

app_competency_templatecohort 0 0 6 0 Table

Default comment for the table, please edit me

app_user_devices 0 1 11 0 Table

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

app_tag_correlation 0 1 3 0 Table

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

app_lesson_pages 3 1 13 0 Table

Defines lesson_pages

app_message_conversations 2 0 3 0 Table

Stores all message conversations

app_question 27 4 19 0 Table

The questions themselves

app_totara_connect_client_cohorts 0 2 4 0 Table

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

app_workspace_off_notification 0 2 4 0 Table

Table to store the record whether user want to stop receiving notification about workspace or not

app_grade_settings 0 1 4 0 Table

gradebook settings

app_pos 14 3 18 0 Table

Totara positions

app_upgrade_log 0 1 10 1529 Table

Upgrade logging

app_facetoface_signup_info_data_param 0 1 3 0 Table

Custom event signup fields data parameters

app_pos_type_info_data 1 2 4 0 Table

Stores custom field data related to positions

app_feedback_value_history 0 2 8 0 Table

History of values of the completeds

app_auth_connect_ids 0 1 6 0 Table

General server to client database id mappings

app_badge_criteria_param 0 1 4 0 Table

Defines parameters for badges criteria

app_grade_items 5 4 31 0 Table

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

app_pathway_criteria_group_criterion 0 2 4 0 Table

Criterion in this group of criteria

app_totara_oauth2_access_token 0 2 5 0 Table

A Table to store the list of access tokens that had been generated for OAuth2 clients.

app_course_request 0 0 9 0 Table

course requests

app_assign_user_flags 0 2 8 0 Table

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

app_tool_customlang 0 1 11 0 Table

Contains the working checkout of all strings and their customization

app_cohort_plan_config 0 2 8 0 Table

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

app_goal_user_info_field 1 1 17 0 Table

Stores the personal custom fields for each goal type

app_totara_userdata_export 1 2 10 0 Table

List of all user data exports and their result

app_enrol_lti_tools 2 2 19 0 Table

List of tools provided to the remote system

app_facetoface_asset 2 2 10 0 Table

Table for storing seminar assets data

app_message_user_actions 0 2 5 0 Table

Stores all per-user actions on individual messages

app_blog_external 0 1 9 0 Table

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

app_url 0 0 10 0 Table

each record is one url resource

app_facetoface_asset_dates 0 2 3 0 Table

Assets to session dates many-to-many relationship

app_facetoface_notification_hist 0 4 8 0 Table

Notifications history (stores ical event information)

app_grade_categories_history 0 4 18 0 Table

History of grade_categories

app_glossary 2 0 28 0 Table

all glossaries

app_tool_sitepolicy_localised_policy 1 2 11 0 Table

A policy in a particular language

app_totara_connect_client_org_frameworks 0 2 4 0 Table

List of organisation frameworks synced to a client

app_pos_relations 0 0 4 0 Table

Tracks relationships between positions

app_survey_questions 1 0 7 73 Table

the questions conforming one survey

app_role_names 0 2 4 0 Table

role names in native strings

app_message_read 0 0 17 0 Table

Stores all messages that have been read

app_grade_outcomes_courses 0 2 3 0 Table

stores what outcomes are used in what courses.

app_course_completion_history 0 2 5 0 Table

Course completion history archive

app_lti_types_config 0 0 4 0 Table

Basic LTI types configuration

app_events_handlers 1 0 8 0 Table

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

app_scorm_scoes_data 0 1 4 0 Table

Contains variable data get from packages

app_facetoface_room_info_data 1 2 4 0 Table

Stores custom field data related to rooms

app_task_adhoc 0 1 8 1 Table

List of adhoc tasks waiting to run.

app_job_assignment 7 7 22 0 Table

Assignment of a job to a user

app_modules 1 0 6 25 Table

modules available in the site

app_question_attempts 1 2 14 0 Table

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

app_badge_backpack 2 2 7 0 Table

Defines settings for connecting external backpack

app_totara_compl_import_cert 0 0 18 0 Table

Intermediary file for importing certification completion data

app_oauth2_access_token 0 1 8 0 Table

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

app_lti_access_tokens 0 1 7 0 Table

Security tokens for accessing of LTI services

app_groupings 2 1 9 0 Table

A grouping is a collection of groups. WAS: groups_groupings

app_totara_userdata_purge_type_item 0 1 7 0 Table

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

app_badge_external_backpack 2 1 7 4 Table

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

app_role_allow_override 0 2 3 12 Table

this defines what role can override what role

app_feedback360_email_assignment 1 0 3 0 Table

Email addresses for feedback360

app_comp_record_history 0 3 7 0 Table

Deprecated since Totara 13, please do not use

app_cohort_role 0 3 7 0 Table

A table to store roles assigned to a cohort

app_dp_plan_course_assign 0 4 10 0 Table

Stores courses assigned to a particular plan

app_lti_submission_history 0 4 5 0 Table

Tracking of user submission history for the LTI activity

app_task_scheduled 0 0 14 140 Table

List of scheduled tasks to be run by cron.

app_lti_types 2 0 18 0 Table

Basic LTI pre-configured activities

app_grade_letters 0 0 4 0 Table

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

app_quiz_grades 0 1 5 0 Table

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

app_facetoface_room_dates_virtualmeeting 0 3 5 0 Table

Session date to virtual meeting room relationship

app_grade_categories 5 2 14 0 Table

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

app_auth_approved_request_snapshots 0 2 31 0 Table

History of auth_approved_request records

app_feedback360_grp_org 0 2 4 0 Table

Organisations assigned to feedback360

app_pos_type_info_field 1 1 17 0 Table

Stores the custom fields for each position type

app_config 0 0 3 567 Table

Moodle configuration variables

app_perform_participant_external 0 0 5 0 Table

Details of an external participant ie a non system user

app_contentmarketplace 0 0 9 0 Table

Content marketplace module records are stored here

app_pos_type_info_data_param 0 1 3 0 Table

Custom positions fields data parameters

app_grading_instances 2 2 9 0 Table

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

app_enrol_lti_lti2_resource_link 3 3 9 0 Table

Link from the consumer to the tool

app_events_queue 1 1 5 0 Table

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

app_message_metadata 0 0 13 0 Table

type, status, and workflow additions to messages

app_dp_objective_scale 2 2 7 1 Table

Contains objective scales for development plans

app_badge_related 0 2 3 0 Table

Defines badge related for badges

app_glossary_formats 0 0 10 7 Table

Setting of the display formats

app_facetoface_room_info_field 1 0 16 2 Table

Stores the definition of available room custom fields

app_role 16 0 6 13 Table

moodle roles

app_badge_backpack_oauth2 0 4 11 0 Table

Default comment for the table, please edit me

app_quickaccess_preferences 0 0 4 0 Table

Stores user preferences for the quick access menu

app_appraisal_history 0 2 4 0 Table

Appraisal access history

app_perform_notification 2 2 8 0 Table

Represents a single notification setting

app_qtype_multichoice_options 0 1 13 0 Table

Options for multiple choice questions

app_dp_permissions 0 1 6 52 Table

Stores the permission settings for plan templates

app_forum_track_prefs 0 0 3 0 Table

Tracks each users untracked forums

app_comp_criteria 1 1 9 0 Table

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

app_resource_old 0 0 16 0 Table

backup of all old resource instances from 1.9

app_workspace 0 2 6 0 Table

Table to store the owner’s information of the workspace

app_engage_answer_choice 0 4 5 0 Table

Table for the picked option of the question

app_facetoface_facilitator_dates 0 2 3 0 Table

Facilitators to session dates many-to-many relationship

app_wiki_synonyms 0 0 4 0 Table

Stores wiki pages synonyms

app_appraisal_role_assignment 3 2 6 0 Table

Individual user assignments by their roles

app_question_attempt_steps 1 2 7 0 Table

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

app_question_calculated_options 0 1 13 0 Table

Options for questions of type calculated

app_gradingform_guide_criteria 1 1 9 0 Table

Stores the rows of the criteria grid.

app_feedback_template 1 0 4 0 Table

templates of feedbackstructures

app_message_popup 0 0 3 0 Table

Keep state of notifications for the popup message processor

app_tool_recyclebin_course 0 1 6 0 Table

A list of items in the course recycle bin

app_grade_import_values 0 3 9 0 Table

Temporary table for importing grades

app_quiz_statistics 0 0 19 0 Table

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

app_wiki_locks 0 0 5 0 Table

Manages page locks

app_appraisal_stage_page 1 1 4 10 Table

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

app_post 1 1 19 0 Table

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

app_question_response_count 0 1 4 0 Table

Count for each responses for each try at a question.

app_tool_usertours_tours 1 0 7 0 Table

List of tours

app_external_services 3 0 11 0 Table

built in and custom external services

app_repository_opensesame_bps 0 2 3 0 Table

Link an OpenSesame course to a bundle

app_enrol_paypal 0 3 21 0 Table

Holds all known information about PayPal transactions

app_facetoface_room 4 2 12 0 Table

Table for storing seminar room data

app_badge_criteria_met 0 3 5 0 Table

Defines criteria that were met for an issued badge

app_grade_outcomes 4 3 10 0 Table

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

app_prog_courseset_course 0 2 4 0 Table

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

app_totara_msteams_user_settings 0 1 6 0 Table

Stores per user settings.

app_lock_db 0 0 4 0 Table

Stores active and inactive lock types for db locking method.

app_workspace_member_request 0 2 9 0 Table

Table to store the member request

app_lesson_answers 1 2 13 0 Table

Defines lesson_answers

app_facetoface_notification_sent 0 3 4 0 Table

Seminar notification reciepts

app_external_services_users 0 2 6 0 Table

users allowed to use services with restricted users flag

app_question_gapselect 0 1 10 0 Table

Defines select missing words questions

app_stats_user_weekly 0 0 8 0 Table

To accumulate weekly stats per course/user

app_appraisal_role_changes 0 0 6 0 Table

Store role changes for assignments

app_engage_survey_question 0 3 4 0 Table

Table for survey questions

app_log_queries 0 0 9 0 Table

Logged database queries.

app_ml_recommender_items 0 0 10 0 Table

Related content

app_persistent_login 0 1 9 0 Table

Persistent user logins

app_groupings_groups 0 2 4 0 Table

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

app_totara_competency_pathway_achievement 2 4 8 0 Table

Record of scale value achieved by a user via a pathway

app_goal_grp_cohort 0 2 5 0 Table

Stores the assignments of goals

app_pathway_criteria_group 2 1 2 0 Table

Criteria group pathway definition

app_choice_options 1 1 5 0 Table

available options to choice

app_badge 6 3 26 0 Table

Defines badge

app_lesson_attempts 0 3 9 0 Table

Defines lesson_attempts

app_competency_usercomp 0 0 10 0 Table

User competencies

app_message_providers 0 0 4 64 Table

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

app_perform 13 2 9 0 Table

Each record is one performance activity

app_feedback360_quest_field 2 1 15 0 Table

Individual question definitions for each feedback360

app_question_categories 3 1 8 0 Table

Categories are for grouping questions

app_goal_type_info_data_param 0 1 3 0 Table

Custom organisations fields data parameters

app_competency_modulecomp 0 2 8 0 Table

Link a competency to a module.

app_reportbuilder_grp_cohort_user 0 2 4 0 Table

Restricted cohorts that will see only allowed records

app_enrol_lti_lti2_user_result 0 1 6 0 Table

Results for each user for each resource link

app_question_response_analysis 1 0 10 0 Table

Analysis of student responses given to questions.

app_comp_template 1 1 10 0 Table

A template is used to group competencies

app_facetoface_room_virtualmeeting 0 2 6 0 Table

Facetoface room to virtual meeting plugin type relationship

app_feedback360_user_assignment 1 2 4 0 Table

Actual user who is subject of feedback360

app_backup_controllers 1 1 16 0 Table

To store the backup_controllers as they are used

app_qtype_match_subquestions 0 1 5 0 Table

The subquestions that make up a matching question

app_workshopform_numerrors 0 1 8 0 Table

The assessment dimensions definitions of Number of errors grading strategy forms

app_goal_user_assignment 0 2 8 0 Table

Stores the user assignments of goals

app_totara_msteams_user_state 0 1 6 0 Table

Stores authentication state of a user for MS Teams.

app_enrol_lti_lti2_nonce 0 1 4 0 Table

Nonce used for authentication between moodle and a consumer

app_report_builder_search_cols 0 1 4 0 Table

Defines search columns belonging to each report

app_totara_oauth2_client_provider 2 0 9 0 Table

A table to store the client’s id and secret that we are providing to other parties

app_catalog_search_metadata 0 0 8 0 Table

Search metadata table where the search metadata are being stored

app_marketplace_linkedin_classification 3 0 6 0 Table

Stores the classfications from linkedin learning locally

app_wiki_subwikis 2 1 4 0 Table

Stores subwiki instances

app_qtype_match_options 0 1 10 0 Table

Defines the question-type specific options for matching questions

app_message_working 0 0 3 0 Table

Lists all the messages and processors that need to be processed

app_facetoface_sessioncancel_info_data_param 0 1 3 0 Table

Whole event cancellation custom fields data parameters

app_auth_approved_request 1 5 29 0 Table

Self registration with approval details

app_feedback360_grp_pos 0 2 4 0 Table

Positions assigned to feedback360

app_pathway_manual_rating 0 4 8 0 Table

Values given for a user on a manual pathway

app_comp_assign_availability 0 0 3 0 Table

Types of assignment available on competencies

app_org_type_info_data 1 2 4 0 Table

Stores custom field data related to organisations

app_backup_logs 0 1 5 0 Table

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

app_totara_connect_sso_sessions 0 2 7 0 Table

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

app_gradingform_rubric_fillings 0 2 6 0 Table

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

app_scorm_scoes_track 0 2 8 0 Table

to track SCOes

app_assignsubmission_file 0 2 4 0 Table

Info about file submissions for assignments

app_totara_navigation 1 0 14 30 Table

Totara navigation menu

app_appraisal_scale 2 1 4 1 Table

Multiple choice sets

app_totara_evidence_type_info_data 2 4 4 0 Table

Evidence item field data

app_enrol_lti_lti2_tool_proxy 0 1 6 0 Table

A tool proxy between moodle and a consumer

app_marketplace_linkedin_learning_object 1 0 18 0 Table

Stores the learning assets from linkedin learning locally

app_goal_scale 3 1 6 1 Table

Scale represents the different levels of achievement of a goal

app_notifiable_event_preference 0 1 8 0 Table

A table stores the system’s configurations of notifiable events

app_perform_subject_instance_manual_participant 0 6 8 0 Table

Manually selected participants for each subject instance

app_course_completion_crit_compl 0 0 8 0 Table

Course completion user records

app_prog_user_assignment 0 0 6 0 Table

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

app_portfolio_log 0 2 11 0 Table

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

app_appraisal_review_data 0 2 7 0 Table

Course, objectives, etc reviews in appraisal

app_my_pages 0 0 5 2 Table

Extra user pages for the My Moodle system

app_user_password_resets 0 1 5 0 Table

table tracking password reset confirmation tokens

app_ml_recommender_interactions 0 4 7 0 Table

User interactions with Engage resources for recommendation purposes

app_dp_plan_objective 0 3 13 0 Table

One row for each objective in a plan

app_qtype_ddmarker 0 1 11 0 Table

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

app_chat_messages_current 0 1 7 0 Table

Stores current session

app_cohort_members 0 2 4 0 Table

Link a user to a cohort.

app_perform_setting 0 2 6 0 Table

Each record holds the settings for one performance activity

app_course_format_options 0 1 6 1 Table

Stores format-specific options for the course or course section

app_totara_competency_aggregation_queue 0 2 6 0 Table

Queuing table to hold aggregations to process

app_certificate 1 0 29 0 Table

Defines certificates

app_totara_reportedcontent 0 4 15 0 Table

Inappropriate content reported by users

app_enrol_lti_lti2_context 1 1 7 0 Table

Information about a specific LTI contexts from the consumers

app_resource 0 0 13 0 Table

Each record is one resource and its config data

app_totara_competency_assignment_user_logs 0 3 5 0 Table

Keep a history of all changes regarding assigned users to competencies to be able to refer to it later, not meant to be cleared while related assignments exist

app_totara_dashboard_user 0 2 3 0 Table

User modified instances of dashboards

app_block_instances 2 1 13 32 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 a

app_comp_type_info_field 1 1 17 0 Table

Stores the custom fields for each competency type

app_course 41 0 40 1 Table

Central course table

app_perform_section_element_reference 0 2 3 0 Table

Stores references between elements and section elements

app_question_dataset_items 0 0 4 0 Table

Individual dataset items

app_tool_monitor_rules 1 0 14 0 Table

Table to store rules

app_workshop 9 1 35 0 Table

This table keeps information about the module instances and their settings

app_grade_items_history 0 6 34 0 Table

History of grade_items

app_report_builder_global_restriction 8 0 9 0 Table

Global Report Restrictions

app_pos_type 2 0 8 0 Table

Position types are used to manage custom fields

app_ml_recommender_trending 0 0 7 0 Table

Trending recommendation items

app_totara_evidence_type 4 2 11 2 Table

Evidence types

app_prog_courseset 4 2 15 0 Table

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

app_comp_relations 0 0 4 0 Table

Tracks relationships between competencies

app_report_builder 8 0 21 0 Table

Each report has an entry here

app_auth_connect_sso_sessions 0 2 7 0 Table

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

app_prog_messagelog 0 3 5 0 Table

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

app_dp_plan_settings 0 1 5 1 Table

Contains settings for the plan

app_scorm_seq_rolluprulecond 0 2 5 0 Table

SCORM2004 sequencing rule

app_capabilities 1 0 6 908 Table

this defines all capabilities

app_course_info_data_param 0 1 3 0 Table

Custom course fields data parameters

app_gradingform_rubric_criteria 2 1 5 0 Table

Stores the rows of the rubric grid.

app_messages 1 2 9 0 Table

Stores all messages

app_totara_comment 0 0 13 0 Table

A table for storing comments

app_workshopallocation_scheduled 0 1 9 0 Table

Stores the allocation settings for the scheduled allocator

app_appraisal 7 0 6 1 Table

Main appraisal table

app_assignfeedback_editpdf_quick 0 1 5 0 Table

Stores teacher specified quicklist comments

app_forum_digests 0 2 4 0 Table

Keeps track of user mail delivery preferences for each forum

app_data 2 0 37 0 Table

all database activities

app_portfolio_instance 4 0 4 0 Table

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

app_competency_coursecompsetting 0 1 6 0 Table

This table contains the course specific settings for competencies.

app_survey_answers 0 2 7 0 Table

the answers to each questions filled by the users

app_facetoface_signups_dates_status 0 3 7 0 Table

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

app_file_conversion 0 2 11 0 Table

Table to track file conversions.

app_goal_scale_values 5 1 10 3 Table

The individual values that make up a goal scale

app_facetoface_asset_info_field 1 0 16 0 Table

Stores the definition of available asset custom fields

app_report_builder_cache 0 1 10 0 Table

Storing details of scheduled reports caching

app_facetoface_sessioncancel_info_field 1 0 16 0 Table

Stores the definitions for whole event cancellation custom fields

app_org_type 2 0 8 0 Table

Organisation types are used to manage custom fields

app_virtualmeeting_auth 0 2 8 0 Table

Virtual meeting authentication tokens

app_facetoface_room_dates 0 2 3 0 Table

Rooms to session dates many-to-many relationship

app_qtype_ddmarker_drops 0 1 6 0 Table

drop regions

app_rating 0 2 10 0 Table

moodle ratings

app_totara_core_mention 0 2 5 0 Table

Mentioning records to keep track of who had been mentioned in a specific context

app_comp_record 0 6 14 0 Table

Deprecated since Totara 13, please do not use

app_facetoface_cancellation_info_data 1 2 4 0 Table

Stores custom field data related to user signup cancellation

app_report_builder_schedule_email_systemuser 0 2 3 0 Table

Storing system users to email in scheduled reports

app_lti_tool_proxies 1 0 13 0 Table

LTI tool proxy registrations

app_goal_item_history 0 1 6 0 Table

Store changes to scalevalueid in goal_record and goal_personal.

app_report_builder_schedule 3 4 11 0 Table

Storing details of scheduled reports

app_marketplace_linkedin_user_progress 0 2 7 0 Table

A table to keep track of user completion progress on linkedin learning content.

app_cohort_visibility 0 2 7 0 Table

A table to store cohorts visible learning assignments

app_totara_userdata_purge_type 4 0 11 0 Table

List of available user data purge types

app_totara_evidence_type_info_data_param 0 2 3 0 Table

Evidence item field data parameters

app_dp_component_settings 0 1 5 4 Table

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

app_assignsubmission_onlinetext 0 2 5 0 Table

Info about onlinetext submission

app_perform_manual_relation_selection_progress 2 4 6 0 Table

Indicates how the choosing of manually participant roles has progressed

app_totara_competency_assignment_users 0 4 6 0 Table

Totara Competency Users

app_course_info_field 2 0 16 0 Table

Custom course fields

app_competency_usercompcourse 0 0 9 0 Table

User competencies in a course

app_totara_mobile_webviews 0 4 8 0 Table

Web view mobile access with real browser session

app_lti 4 0 26 0 Table

This table contains Basic LTI activities instances

app_scale 7 0 8 2 Table

Defines grading scales

app_chat_messages 0 1 7 0 Table

Stores all the actual chat messages

app_role_capabilities 0 4 7 1717 Table

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

app_totara_connect_client_courses 0 2 4 0 Table

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

app_dp_priority_scale 4 2 7 1 Table

Contains priority scales for development plans

app_perform_subject_static_instance 0 7 9 0 Table

Represents a single job assignment at the time of subject creation

app_data_content 0 2 8 0 Table

the content introduced in each record/fields

app_totara_core_program_vis_map 0 2 3 0 Table

Program view hidden capability to role map

app_feedback_valuetmp 0 1 6 0 Table

values of the completedstmp

app_forum_posts 2 2 15 0 Table

All posts are stored in this table

app_facetoface_signup_info_field 1 0 16 1 Table

Stores the definitions of user signup custom fields

app_scorm_seq_mapinfo 0 2 8 0 Table

SCORM2004 objective mapinfo description

app_notifications 1 1 14 0 Table

Stores all notifications

app_feedback 5 0 17 0 Table

all feedbacks

app_log_display 0 0 6 202 Table

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

app_scorm_scoes 8 1 10 0 Table

each SCO part of the SCORM module

app_cohort_rule_collections 1 2 9 0 Table

Collections of rulesets & rules for a dynamic cohort

app_assignfeedback_editpdf_cmnt 0 1 9 0 Table

Stores comments added to pdfs

app_context 26 2 7 39 Table

one of these must be set

app_tool_monitor_events 0 0 8 0 Table

A table that keeps a log of events related to subscriptions

app_chat 3 0 10 0 Table

Each of these is a chat room

app_workshopform_rubric 1 1 5 0 Table

The assessment dimensions definitions of Rubric grading strategy forms

app_appraisal_stage_data 0 2 6 0 Table

Appraisal stage completion for each asiignment

app_question_datasets 0 2 3 0 Table

Many-many relation between questions and dataset definitions

app_question_truefalse 0 1 4 0 Table

Options for True-False questions

app_auth_connect_users 0 2 5 0 Table

List of users from each Totara Connect server

app_gradingform_guide_fillings 0 2 6 0 Table

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

app_enrol_flatfile 0 3 8 0 Table

enrol_flatfile table retrofitted from MySQL

app_external_functions 0 0 8 397 Table

list of all external functions

app_totara_navigation_settings 0 1 6 0 Table

Settings for navigation menu items

app_comp_template_assignment 0 3 6 0 Table

Track competencies belonging to a template

app_competency_framework 0 0 13 0 Table

List of competency frameworks.

app_feedback360_scale_value 1 1 4 0 Table

Multiple choice options (score can be used when applicable)

app_totara_core_course_vis_map 0 2 3 0 Table

Course view hidden capability to role map

app_filter_active 0 1 5 3 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.

app_quiz_slots 0 2 7 0 Table

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

app_badge_endorsement 0 1 8 0 Table

Defines endorsement for badge

app_goal_personal 3 4 15 0 Table

Totara goals

app_scorm_seq_rulecond 0 2 7 0 Table

SCORM2004 rule condition

app_totara_xapi_statement 0 0 4 0 Table

The table that stores the xapi statement from xapi request

app_glossary_entries 2 1 15 0 Table

all glossary entries

app_totara_userdata_user 0 3 9 2 Table

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

app_data_fields 1 1 16 0 Table

every field available

app_facetoface_asset_info_data 1 2 4 0 Table

Stores custom field data related to assets

app_perform_element_response 0 3 6 0 Table

Contains a single response to a single performance activity element

app_tool_recyclebin_category 0 1 5 0 Table

A list of items in the category recycle bin

app_block_totara_stats 0 0 6 0 Table

Holds stats information

app_quiz_attempts 0 3 15 0 Table

Stores users attempts at quizzes.

app_blog_association 0 2 3 0 Table

Associations of blog entries with courses and module instances

app_role_allow_switch 0 2 3 10 Table

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

app_competency_templatecomp 0 2 7 0 Table

Link a competency to a learning plan template.

app_role_assignments 0 3 9 0 Table

assigning roles in different context

app_sessions 2 1 9 0 Table

Database based session storage - now recommended

app_user_info_category 0 0 3 0 Table

Customisable fields categories

app_gradingform_guide_comments 0 1 5 0 Table

frequently used comments used in marking guide

app_scorm_seq_rolluprule 1 1 7 0 Table

SCORM2004 sequencing rule

app_goal_grp_pos 0 2 6 0 Table

Stores the position assignments of goals

app_grade_grades 1 4 23 0 Table

grade_grades This table keeps individual grades for each user and each item, exactly as imported or submitted by modules. The rawgrademax/min and rawscaleid are stored here to record the values at the time the grade was stored, because teachers migh

app_ml_recommender_interaction_types 2 0 2 0 Table

Dictionary of interactions used in recommender tables

app_report_builder_saved_user_default 0 0 4 0 Table

Stores the default search to be used for a user

app_files 2 3 20 5 Table

description of files, content is stored in sha1 file pool

app_competency_userevidencecomp 0 0 6 0 Table

Relationship between user evidence and competencies

app_goal_type_info_field 1 1 17 0 Table

Stores the custom fields for each goal type

app_dp_template 10 0 9 1 Table

Templates store configuration options for a group of plans.

app_assign_grades 4 1 8 0 Table

Grading information about a single assignment submission.

app_backup_courses 0 0 6 0 Table

To store every course backup status

app_messageinbound_messagelist 0 1 5 0 Table

A list of message IDs for existing replies

app_cohort_rules 1 2 8 0 Table

Rules within a ruleset

app_reminder 0 0 9 0 Table

Totara course reminders

app_qtype_ddimageortext_drags 0 1 6 0 Table

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

app_reminder_message 0 0 8 0 Table

Totara course reminder messages

app_totara_competency_pathway 2 1 8 0 Table

Criteria or actions required to receive a scale value

app_question_hints 0 1 7 0 Table

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

app_feedback_sitecourse_map 0 1 3 0 Table

feedback sitecourse map

app_course_completion_defaults 0 2 8 0 Table

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

app_gradingform_rubric_levels 0 1 5 0 Table

Stores the columns of the rubric grid.

app_perform_section_relationship 0 4 6 0 Table

Defines a relationship used in a specific section

app_grading_areas 1 1 5 0 Table

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

app_facetoface_session_info_data 1 2 4 0 Table

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

app_workshop_grades 0 1 7 0 Table

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

app_appraisal_quest_field_role 0 1 4 28 Table

Access restrictions for each question. access - APPRAISAL_ACCESS_* constant

app_auth_oauth2_linked_login 0 5 11 0 Table

Linking of external issuer account to a Totara user account - oauth2 may be either primary auth account or an alternative login method for other auth plugins

app_question_answers 0 1 7 0 Table

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

app_scorm_aicc_session 0 2 12 0 Table

Used by AICC HACP to store session information

app_totara_evidence_item 3 5 9 0 Table

Evidence items

app_user_lastaccess 0 0 4 0 Table

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

app_goal 10 3 17 0 Table

Totara goals

app_comp 22 3 19 0 Table

Totara competencies

app_tool_sitepolicy_site_policy 1 0 2 0 Table

A list of site policies

app_totara_criteria_metadata 0 2 4 0 Table

Additional data for a specific criterion

app_competency_userevidence 0 0 9 0 Table

The evidence of prior learning

app_course_published 0 0 8 0 Table

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

app_prog_completion_log 0 3 6 0 Table

Record of changes made to program completion records

app_comp_scale_values 12 1 10 3 Table

The individual values that make up a competency scale

app_event 0 1 22 0 Table

For everything with a time associated to it

app_assign_plugin_config 0 1 6 0 Table

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

app_badge_external 0 1 5 0 Table

Setting for external badges display

app_perform_participant_instance 6 3 10 0 Table

Each participant instance represents a form to be completed by a a single participant

app_perform_manual_relation_selector 0 3 5 0 Table

Represents the actual users who will select the participants for this instance

app_perform_element_linked_review_content 1 5 8 0 Table

Links external content to a performance activity

app_facetoface_cancellation_info_data_param 0 1 3 0 Table

Custom user signup cancellation fields data parameters

app_goal_user_info_data 1 2 4 0 Table

Stores personal custom field data related to goals

app_goal_scale_assignments 0 2 5 0 Table

Tracks which scales are assigned to which goal frameworks

app_competency_relatedcomp 0 0 6 0 Table

Related competencies

app_pathway_perform_rating 0 11 9 0 Table

Stores rating received via a performance activity

app_portfolio_tempdata 0 2 6 0 Table

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

app_feedback_completed 0 1 7 0 Table

filled out feedback

app_appraisal_grp_pos 0 2 4 0 Table

Positions assigned to appraisal

app_assign 10 0 30 0 Table

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

app_cohort_rulesets 1 2 8 0 Table

Rulesets for dynamic cohorts

app_totara_compl_import_course 0 0 18 0 Table

Intermediary file for importing course completion data

app_tool_sitepolicy_localised_consent 0 2 6 0 Table

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

app_book 0 0 11 0 Table

Defines book

app_repository_opensesame_pkgs 1 0 11 0 Table

Totara OpenSesame course packages

app_gap_aspirational 0 2 6 0 Table

Aspirational positions

app_message_conversation_members 0 2 4 0 Table

Stores all members in a conversations

app_repository 0 0 4 6 Table

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

app_playlist_resource 0 3 6 0 Table

Table for mapping the resources within playlist

app_facetoface_session_info_data_param 0 1 3 0 Table

Custom event fields data parameters

app_dp_plan_evidence_relation 0 2 5 0 Table

Related courses / objectives / competencies

app_engage_rating 0 0 7 0 Table

A table for storing ratings

app_goal_user_info_data_param 0 1 3 0 Table

Custom organisations fields data parameters

app_totara_msteams_tenant 2 0 2 0 Table

Stores tenant information of MS Teams.

app_totara_competency_achievement_via 0 4 3 0 Table

Record of pathways that contributed to a specific competency achievement

app_external_services_functions 0 1 3 0 Table

lists functions available in each service group

app_folder 0 0 10 0 Table

each record is one folder resource

app_workshopform_accumulative 0 1 7 0 Table

The assessment dimensions definitions of Accumulative grading strategy forms

app_reportbuilder_grp_user_user 0 2 4 0 Table

Restricted individual users that will see only allowed records

app_logstore_standard_log 0 1 21 0 Table

Standard log table

app_tag 2 2 10 0 Table

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

app_virtualmeeting 3 2 5 0 Table

Virtual meetings

app_scorm_seq_objective 1 1 6 0 Table

SCORM2004 objective description

app_question_numerical_options 0 1 6 0 Table

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

app_tenant 6 5 10 0 Table

Totara Tenant information

app_engage_resource_completion 0 2 4 0 Table

Table that holds the completion record of a user for a particular resource

app_search_index_requests 0 1 6 0 Table

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

app_block_recent_activity 0 0 7 0 Table

Recent activity block

app_message_contacts 0 0 4 0 Table

Maintains lists of relationships between users

app_quiz_feedback 0 1 6 0 Table

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

app_comp_criteria_record 0 3 8 0 Table

Deprecated since Totara 13, please do not use

app_user_password_history 0 1 4 0 Table

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

app_cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

app_comp_framework 3 0 11 0 Table

A collection of competencies that use a common competency scale

app_totara_mobile_devices 2 1 9 0 Table

List of registered mobile devices for each user

app_engage_resource 0 2 11 0 Table

Resource properties

app_facetoface_cancellation_info_field 1 0 16 1 Table

Stores the definitions for user signup cancellation custom fields

app_prog_assignment 0 1 10 0 Table

Stores details of the assignments defined within a program

app_certif_completion 0 2 11 0 Table

Certifications completed

app_facetoface_sessioncancel_info_data 1 2 4 0 Table

Stores custom field data related to cancellation of the whole event

app_notifiable_event_queue 0 1 8 0 Table

A table to queue the events from system which is used to queue the notifications

app_tag_coll 2 0 7 3 Table

Defines different set of tags

app_facetoface_facilitator_info_data_param 0 1 3 0 Table

facilitator custom fields data parameters

app_perform_track 4 2 28 0 Table

Each performance activity can have multiple tracks, each with their own independent assignments and config

app_quiz 6 0 41 0 Table

The settings for each quiz.

app_certificate_issues 0 0 5 0 Table

Info about issued certificates

app_feedback360 5 1 8 0 Table

360 feedback360 form (recipients - feedback360_RECIPIENT_* bitmask).

app_oauth2_user_field_mapping 0 1 7 0 Table

Mapping of oauth user fields to moodle fields.

app_choice 2 0 18 0 Table

Available choices are stored here

app_prog_exception 0 2 6 0 Table

Stores details of any exceptions raised relating to a program

app_scale_history 0 3 11 0 Table

History table

app_perform_element_linked_review_content_response 0 4 7 0 Table

Responses for sub-elements to the specified content

app_goal_grp_org 0 2 6 0 Table

Stores the organisation assignments of goals

app_forum_discussion_subs 0 3 5 0 Table

Users may choose to subscribe and unsubscribe from specific discussions.

app_lesson_grades 0 1 6 0 Table

Defines lesson_grades

app_assignfeedback_comments 0 2 5 0 Table

Text feedback for submitted assignments

app_reportbuilder_grp_cohort_record 0 2 4 0 Table

Cohorts that restricted users can see

app_tool_sitepolicy_policy_version 2 2 8 0 Table

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

app_portfolio_instance_user 0 2 5 0 Table

user data for portfolio instances.

app_assign_user_mapping 0 2 3 0 Table

Map an assignment specific id number to a user

app_forum_subscriptions 0 1 3 0 Table

Keeps track of who is subscribed to what forum

app_notifiable_event_user_preference 0 2 9 0 Table

User overrides for a notifiable event in a specific context

app_question_attempt_step_data 0 1 4 0 Table

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

app_ltiservice_gradebookservices 0 3 8 0 Table

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

app_perform_track_user_assignment 4 3 9 0 Table

Individual track assignments for real users

app_portfolio_instance_config 0 1 4 0 Table

config for portfolio plugin instances

app_appraisal_grp_cohort 0 2 3 0 Table

Audiences assigned to appraisal

app_appraisal_event 2 2 9 0 Table

Appraisal event notifications

app_assignfeedback_editpdf_queue 0 0 3 0 Table

Queue for processing.

app_engage_share 2 2 7 0 Table

Shares

app_workshop_submissions 1 3 18 0 Table

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

app_perform_track_user_assignment_via 0 4 4 0 Table

This table links the assignment with the user assignment table

app_badge_manual_award 0 4 6 0 Table

Track manual award criteria for badges

app_badge_criteria 2 1 6 0 Table

Defines criteria for issuing badges

app_appraisal_quest_field 3 2 15 14 Table

Individual question list for appraisal page

app_qtype_randomsamatch_options 0 1 11 0 Table

Info about a random short-answer matching question