Database Properties
Database Type: PostgreSQL - 12.8 (Debian 12.8-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 | 7 | 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 | 1 | 12 | 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 | 8 | 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_totara_msteams_bot | 3 | 0 | 4 | 0 | Table | Stores bot information. |
app_appraisal_scale_data | 0 | 3 | 4 | 0 | Table | Multiple user answers |
app_mnet_session | 0 | 0 | 9 | 0 | Table | Store session data from users migrating to other sites |
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_mnet_service | 0 | 0 | 5 | 4 | Table | A service is a group of functions |
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_mnetservice_enrol_enrolments | 0 | 2 | 7 | 0 | Table | Caches the information about enrolments of our local users in courses on remote hosts |
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_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 | 8 | 3 | 12 | 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 | 14 | 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_enrol_lti_users | 0 | 2 | 12 | 0 | Table | User access log and gradeback data |
app_config_log | 0 | 1 | 7 | 1735 | 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_mnet_application | 1 | 0 | 6 | 2 | Table | Information about applications on remote hosts |
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 | 2348 | 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 | 6 | 2 | 10 | 0 | Table | Stores individual plans belonging to users. |
app_dp_plan_competency_value | 0 | 6 | 12 | 0 | Table | Competency values set via the learning plan |
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 | 11 | 0 | 6 | 8 | 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_mnet_rpc | 0 | 0 | 11 | 15 | Table | Functions or methods that we may publish or subscribe to |
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 | 1 | 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_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_mnet_service2rpc | 0 | 0 | 3 | 15 | Table | Group functions or methods under a service |
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_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 | 42 | 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 | 23 | 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 | 8 | 0 | Table | Stores the completion state (completed or not completed, etc) of each user on each activity. |
app_block | 0 | 0 | 5 | 64 | 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 | 2 | 1 | 7 | 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 | 231 | 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_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 | 5 | 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_mnet_host2service | 0 | 0 | 5 | 0 | Table | Information about the services for a given host |
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_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 | 1505 | 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_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_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_mnet_remote_service2rpc | 0 | 0 | 3 | 16 | Table | Group functions or methods under a service |
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_mnet_remote_rpc | 0 | 0 | 6 | 16 | Table | This table describes functions that might be called remotely (we have less information about them than local functions) |
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 | 2 | 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 | 24 | 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 | 1 | 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 | 132 | 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 | 2 | 4 | 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 | 556 | Table | Moodle configuration variables |
app_perform_participant_external | 0 | 0 | 5 | 0 | Table | Details of an external participant ie a non system user |
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 | 11 | 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 | 3 | 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 | 7 | 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 | 63 | Table | This table stores the message providers (modules and core systems) |
app_perform | 9 | 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 | 9 | 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_catalog_search_metadata | 0 | 0 | 8 | 0 | Table | Search metadata table where the search metadata are being stored |
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_goal_scale | 3 | 1 | 6 | 1 | Table | Scale represents the different levels of achievement of a goal |
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 | 37 | 1 | Table | Central course table |
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 | 903 | 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_mnet_host | 1 | 1 | 15 | 2 | Table | Information about the local and remote hosts for RPC |
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 | 4 | 1 | 10 | 3 | Table | The individual values that make up a goal scale |
app_portfolio_mahara_queue | 0 | 1 | 3 | 0 | Table | maps mahara tokens to transfer ids |
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 | 1 | 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_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_mnet_sso_access_control | 0 | 0 | 4 | 0 | Table | Users by host permitted (or not) to login from a remote provider |
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 | 1706 | Table | permission has to be signed, overriding a capability for a particular role in a particular context |
app_mnetservice_enrol_courses | 0 | 0 | 14 | 0 | Table | Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users |
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 | 16 | 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_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 | 21 | 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 | 393 | 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 | 1 | 4 | 15 | 0 | Table | Totara goals |
app_scorm_seq_rulecond | 0 | 2 | 7 | 0 | Table | SCORM2004 rule condition |
app_glossary_entries | 2 | 1 | 16 | 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 | 4 | 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 | 3 | 10 | 0 | Table | Accounts linked to a users Moodle account. |
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 | 8 | 3 | 17 | 0 | Table | Totara goals |
app_comp | 20 | 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 | 10 | 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 | 4 | 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_facetoface_cancellation_info_data_param | 0 | 1 | 3 | 0 | Table | Custom user signup cancellation fields data parameters |
app_goal_scale_assignments | 0 | 2 | 5 | 0 | Table | Tracks which scales are assigned to which goal frameworks |
app_goal_user_info_data | 1 | 2 | 4 | 0 | Table | Stores personal custom field data related to goals |
app_competency_relatedcomp | 0 | 0 | 6 | 0 | Table | Related competencies |
app_portfolio_tempdata | 1 | 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_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_mnet_log | 0 | 0 | 13 | 0 | Table | Store session data from users migrating to other sites |
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 | 8 | 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_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 | 27 | 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_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 | 7 | 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_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 | 19 | 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 |