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