Tables

Custom programs fields data parameters

LTI consumers interacting with moodle

SCORM2004 rule conditions

List of files that are trusted

Each record is one page and its config data

feedback_items

Configuration table for the Rubric grading strategy

Keeps track of individual submissions for LTI activities.

Record of competency proficiency of a user

For keeping information about cached data

Describes seminar events

Inbound Message Handler definitions.

Table to store interaction transition configurations

Describes the named endpoint for an oauth2 service.

Stores saved searches for reports

Defines filters belonging to each report

Audiences assigned to feedback360

categories of each glossary entry

Certification view hidden capability to role map

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

Table to store workflow stage form configuration

List of available user data export types

Record of changes made to course completion records

Users who have declared interest in a seminar activity

Archived user certificates for Totara

Statistics for individual questions used in an activity.

Stores details of user’s program and course set completions

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

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

store licenses used by moodle

Extra options for essay questions.

Multiple user answers

stores annotations added to pdfs submitted by students

Contains settings specific to the course component

Article record

Defines columns belonging to each report

List of servers

Store changes to target dates in goal_record and goal_personal.

Tracks relationships between organisations

Manages localised consents

Table to store user subscriptions to various rules

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

Items linked to a specific criterion

Every action is logged as far as possible

Stores the custom fields for each organisation type

Table for the options of question

Stores the relationship between the classifications only

Record of changes to criteria configuration of competency

access keys used in cookieless scripts - rss, etc.

values of the completeds

branches for each lesson/user

Each record represents a group.

Tracks subscriptions to remote calendars.

The assessment dimensions definitions of Comments strategy forms

this defines what role can assign what role

Table to store the discussions within the workspace

Table for storing seminar facilitator data

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

Share recipients

A table to store the notification events logs which is used in centralized notification reporting.

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

List of position frameworks synced to a client

Suggested content for users

List of cohorts synced from server

Competency scale represents the different levels of achievement of a competency

A table to store the notification delivery logs which is used in centralized notification reporting.

Forums contain and structure discussion

User access log and gradeback data

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

Changes done in server configuration through admin UI

User competencies plans

Course categories

Table for pulse survey

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

Seminar notifications

Goal types are used to manage custom fields

To accumulate monthly stats

Moodle modules and plugins configuration variables

Table to store history of message notifications sent

A collection of positions

Totara course reminders log of messages sent

Defines tiles for Totara featured links blocks

lesson timer for each lesson

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

Competency values set via the learning plan

Totara OpenSesame course bundles

List of relationships that can exist between users

Allows modules to store arbitrary user preferences

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.

Track current status of a user within goals

each table is one SCORM module and its configuration

To accumulate daily stats per course/user

log table for totara element syncing

Data for the customisable user fields

Table for playlist records

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

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.

Stores per bot settings.

Stores custom field data related to programs

Learning plan templates.

Stores elemental details about programs

moodle comments module

Stages within appraisal

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

Stores custom field data related to facilitators

Roles for a given manual pathway definition

Performance activities are split into one or more sections

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

Contains audiences allowed to select specific personal goal types.

Stores the learning assets from Go1 locally

Lookup table of courses which are suitable for native app rendering

Mapping of tracks to user group assignments

Link a competency to a course.

Table to index assignments where user has view_in_dashboard_pending_application_any capability

The parameters of rules in cohort_rules

Stores the definitions for event custom fields

List of client systems registered with this server

Table to index assignments where user has view_in_dashboard_application_any capability

Keeps track of which users are in which chat rooms

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

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

Appraisal events scheduled to specific users

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

Track competencies assigned to a particular organisation

Multiple choice sets

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

Represents progress on a section for a single participant

Whitelist of known trusted SCORM packages

History table

Defines labels

feedback360 responders assignments

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

Stores wiki pages

Settings for a template’s objectives

Each record is one SURVEY module with its configuration

Table containing identifier strings that can be used to tag elements

The table to store a client rate limiting settings

Users modifications of pages

Options for questions of type calculated

Options for short answer questions

filled out feedback

Seminar notification templates

Contains settings specific to the competency component

Virtual meeting configurations

Table for centralized engage questions

contains all installed blocks

Security tokens for accessing of external services

An element used within a section of a performance activity

Indicates the roles who need to manually choose participant roles

to define the sections for each course

One record for each person

Table that maps the published tool to tool consumers.

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

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

Labels for markers to drag.

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

Tracks competencies assigned to a particular position

Stores the definition of available facilitator custom fields

Page wiki links

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

Holds information on the defined links of a block

each record is one imscp resource

Table to store goal types for personal goals.

Restricted positions that will see only allowed records

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

Defines lesson_pages

Stores all message conversations

The questions themselves

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

gradebook settings

Totara positions

Stores custom field data related to positions

General server to client database id mappings

Criterion in this group of criteria

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

course requests

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

Stores the personal custom fields for each goal type

Table for storing seminar assets data

Stores all per-user actions on individual messages

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

all glossaries

the questions conforming one survey

stores what outcomes are used in what courses.

Course completion history archive

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

Security tokens for accessing of LTI services

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

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

this defines what role can override what role

Email addresses for feedback360

A table to store roles assigned to a cohort

Stores courses assigned to a particular plan

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

Session date to virtual meeting room relationship

History of auth_approved_request records

Organisations assigned to feedback360

Moodle configuration variables

type, status, and workflow additions to messages

Table to index users where user has view_in_dashboard_application_user capability

Setting of the display formats

Stores the definition of available room custom fields

Default comment for the table, please edit me

Stores user preferences for the quick access menu

Stores the permission settings for plan templates

Tracks each users untracked forums

Table to store the owner’s information of the workspace

Facilitators to session dates many-to-many relationship

Stores wiki pages synonyms

Individual user assignments by their roles

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

Count for each responses for each try at a question.

List of tours

built in and custom external services

Link an OpenSesame course to a bundle

Table for storing seminar room data

Stores per user settings.

Stores active and inactive lock types for db locking method.

users allowed to use services with restricted users flag

Defines select missing words questions

Table for survey questions

Logged database queries.

Related content

Persistent user logins

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

A table to store the notification logs which is used in centralized notification reporting.

Stores the assignments of goals

Criteria group pathway definition

Table to store workflow metadata

available options to choice

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

Link a competency to a module.

Restricted cohorts that will see only allowed records

Results for each user for each resource link

Analysis of student responses given to questions.

The assessment dimensions definitions of Number of errors grading strategy forms

Stores the user assignments of goals

Stores authentication state of a user for MS Teams.

Nonce used for authentication between moodle and a consumer

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

Search metadata table where the search metadata are being stored

The table to store a client setting

Stores subwiki instances

Whole event cancellation custom fields data parameters

Positions assigned to feedback360

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

Table to index users where user has view_in_dashboard_application_applicant capability

Info about file submissions for assignments

Totara navigation menu

Multiple choice sets

Evidence item field data

Stores the learning assets from linkedin learning locally

Scale represents the different levels of achievement of a goal

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

Link a user to a cohort.

Each record holds the settings for one performance activity

Stores format-specific options for the course or course section

Information about a specific LTI contexts from the consumers

Each record is one resource and its config data

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

User modified instances of dashboards

Stores the custom fields for each competency type

Central course table

Stores references between elements and section elements

Individual dataset items

Global Report Restrictions

Position types are used to manage custom fields

Trending recommendation items

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

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

SCORM2004 sequencing rule

Custom course fields data parameters

Stores the rows of the rubric grid.

Stores teacher specified quicklist comments

Keeps track of user mail delivery preferences for each forum

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

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

Stores the definition of available asset custom fields

Organisation types are used to manage custom fields

Virtual meeting authentication tokens

moodle ratings

Storing system users to email in scheduled reports

LTI tool proxy registrations

Storing details of scheduled reports

List of available user data purge types

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

Totara Competency Users

Custom course fields

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

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

the content introduced in each record/fields

Program view hidden capability to role map

values of the completedstmp

Stores the definitions of user signup custom fields

Stores all notifications

Table to store form sub-plugin instances for use with with workflows

all feedbacks

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

each SCO part of the SCORM module

Stores comments added to pdfs

Each of these is a chat room

Appraisal stage completion for each asiignment

Many-many relation between questions and dataset definitions

Options for True-False questions

list of all external functions

Course view hidden capability to role map

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

Defines endorsement for badge

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

assigning roles in different context

Customisable fields categories

frequently used comments used in marking guide

SCORM2004 sequencing rule

Stores the position assignments of goals

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

Relationship between user evidence and competencies

A list of message IDs for existing replies

Rules within a ruleset

Totara course reminders

Criteria or actions required to receive a scale value

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

Table to index assignments where user has view_draft_in_dashboard_application_any capability

Defines a relationship used in a specific section

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

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

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

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

Used by AICC HACP to store session information

Evidence items

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

Additional data for a specific criterion

Record of changes made to program completion records

The individual values that make up a competency scale

Custom user signup cancellation fields data parameters

filled out feedback

Positions assigned to appraisal

Table to track versions of form definitions

Defines book

Aspirational positions

Custom event fields data parameters

Related courses / objectives / competencies

each record is one folder resource

Restricted individual users that will see only allowed records

Standard log table

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

Table to store workflow configuration

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

Table to index users where user has view_draft_in_dashboard_application_applicant capability

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

Maintains lists of relationships between users

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

A collection of competencies that use a common competency scale

List of registered mobile devices for each user

Resource properties

Stores custom field data related to cancellation of the whole event

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

facilitator custom fields data parameters

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

The settings for each quiz.

Info about issued certificates

Stores details of any exceptions raised relating to a program

Map an assignment specific id number to a user

Keeps track of who is subscribed to what forum

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

config for portfolio plugin instances

Appraisal event notifications

Shares

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

This table links the assignment with the user assignment table

Defines criteria for issuing badges

Individual question list for appraisal page

Contains settings for individual reports

Course completion criteria

history of filled out feedback

Organisations assigned to appraisal

Details for an oauth 2 connect identity issuer.

Totara assignments

Perform activity types

Stores extension requests for programs

Options for multianswer questions

Totara organisations

History table

Custom organisations fields data parameters

Queue for users waiting for f2f approval before enrolment

Stores the custom fields for each program type

temporary table for storing new grade_item names from grade import

The evidence linked to a user competency

Stores custom field data related to goals

Defines drag and drop (words into sentences) questions

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

Certifications

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

choices performed by users

To accumulate monthly stats per course/user

List of tokins for mobile login setup

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

Answers from the user in the localised policy

The overrides to assign settings.

Restricted organisations that will see only allowed records

A table for tracking and recording modifications to a related dp_plan

Tracks each users read posts

The table to store a global rate limiting settings

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

Previous completed certifications

Stores channel information of MS Teams.

Defines lesson

The resolvers for each relationship

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

Stores bot information.

List of notifications to display in the message output popup

List of message output plugins

The config for intances

Steps in an tour

Criteria manual pathway definition

Objective Scale values for development plan priority scales

Storing external emails to send in scheduled reports

Items of each user data export and their result

Custom room fields data parameters

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.

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

User’s reaction

entries alias

Represents a single activity for one subject user

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

Course completion records

Positions that restricted users can see

Stores the relationship between a course module and a totara_contentmarketplace plugin

The definition of rubric rating scales

Stores program assigned to a particular plan

LTI tool setting values

Competency types are used to manage custom fields

To accumulate weekly stats

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

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

List of SSO requests from Totara Connect client to server

Asset custom fields data parameters

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

Appraisal event message

Resource link share key

Stores details of the messages defined within a program

Custom competencies fields data parameters

Stores individual plans belonging to users.

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

Individual users that restricted users can see

Inbound Message data item secret keys.

Organises and stores properties for dataset items

The overrides to lesson settings.

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

Contains settings specific to the program component

Represents a notification setting recipient

User signups for events

Report graphs

Customisable user profile fields

Multiple user answers

Table to index users where user has view_in_dashboard_pending_application_user capability

Custom course fields data

Course completion aggregation methods for criteria

course_modules table retrofitted from MySQL

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

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

Stores the results of all the profiling runs

History of criteria configuration during a specific period

Evidence fields

Actual user who is subject of appraisal

Link a user to a group.

Totara boolean criteria definitions

Dictionary of components and areas used in recommender tables

to accumulate daily stats

Capability to role map

Stores wiki page history

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

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

Organisations that restricted users can see

Stores competencies assigned to a particular plan

Stores all unread messages

Options for numerical questions.

Items of each user data purge and their result

List of all user data purges and their result

Table for bookmarks

List of registration requests

Each seminar activity has an entry here

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.

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

Multiple choice options (score can be used when applicable)

Stores user mapping for MS Teams.

Stores custom field data related to competencies

A collection of organisations

Storing audience to email in scheduled reports

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

Defines issued badges

Plan competencies

Learning plans

Stores Wiki activity configuration

Emoji details

every record introduced

Forums are composed of discussions

Method of aggregation when determining achieved value

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

Drop boxes

Scale values for development plan priority scales

Stores subscription information.

Users with a trainer-like role in a seminar event

text about each survey submission

Defines book_chapters

A collection of goals

Tracks which scales are assigned to which competency frameworks

Appraisal events recipients (roles)

Catalog table

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

all categories for glossary entries

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

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

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

Dashboards

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

Setting for external badges mappings

Store files references

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

Table to index users where user has view_draft_in_dashboard_application_user capability

Future user assignments such as from first login

Default comment for the table, please edit me

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

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

Upgrade logging

Custom event signup fields data parameters

History of values of the completeds

Defines parameters for badges criteria

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

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

Contains the working checkout of all strings and their customization

List of all user data exports and their result

List of tools provided to the remote system

each record is one url resource

Assets to session dates many-to-many relationship

Notifications history (stores ical event information)

History of grade_categories

A policy in a particular language

List of organisation frameworks synced to a client

Tracks relationships between positions

Table to store application event logs

role names in native strings

Stores all messages that have been read

Basic LTI types configuration

Contains variable data get from packages

Stores custom field data related to rooms

List of adhoc tasks waiting to run.

Assignment of a job to a user

modules available in the site

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

Defines settings for connecting external backpack

A table to store API clients

Intermediary file for importing certification completion data

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

A grouping is a collection of groups. WAS: groups_groupings

Deprecated since Totara 13, please do not use

Tracking of user submission history for the LTI activity

List of scheduled tasks to be run by cron.

Basic LTI pre-configured activities

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

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

Stores the custom fields for each position type

Details of an external participant ie a non system user

Content marketplace module records are stored here

Custom positions fields data parameters

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

Link from the consumer to the tool

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.

Contains objective scales for development plans

Defines badge related for badges

moodle roles

Appraisal access history

Represents a single notification setting

Options for multiple choice questions

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

backup of all old resource instances from 1.9

Table for the picked option of the question

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.

Options for questions of type calculated

Stores the rows of the criteria grid.

templates of feedbackstructures

Keep state of notifications for the popup message processor

A list of items in the course recycle bin

Temporary table for importing grades

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

Manages page locks

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

Holds all known information about PayPal transactions

Defines criteria that were met for an issued badge

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)

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

Table to store the member request

Defines lesson_answers

Seminar notification reciepts

To accumulate weekly stats per course/user

Store role changes for assignments

Record of scale value achieved by a user via a pathway

Defines badge

Defines lesson_attempts

User competencies

Each record is one performance activity

Individual question definitions for each feedback360

Categories are for grouping questions

Custom organisations fields data parameters

A template is used to group competencies

Facetoface room to virtual meeting plugin type relationship

Actual user who is subject of feedback360

To store the backup_controllers as they are used

The subquestions that make up a matching question

Defines search columns belonging to each report

Stores the classfications from linkedin learning locally

Defines the question-type specific options for matching questions

Lists all the messages and processors that need to be processed

Self registration with approval details

Values given for a user on a manual pathway

Types of assignment available on competencies

Stores custom field data related to organisations

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

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

to track SCOes

A tool proxy between moodle and a consumer

A table stores the system’s configurations of notifiable events

Manually selected participants for each subject instance

Course completion user records

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

Course, objectives, etc reviews in appraisal

Extra user pages for the My Moodle system

table tracking password reset confirmation tokens

User interactions with Engage resources for recommendation purposes

One row for each objective in a plan

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

Stores current session

Queuing table to hold aggregations to process

Defines certificates

Inappropriate content reported by users

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

Table to store rules

This table keeps information about the module instances and their settings

History of grade_items

Evidence types

Tracks relationships between competencies

Each report has an entry here

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

Contains settings for the plan

this defines all capabilities

Stores all messages

A table for storing comments

Stores the allocation settings for the scheduled allocator

Main appraisal table

Table to store workflow stage configuration

all database activities

This table contains the course specific settings for competencies.

the answers to each questions filled by the users

Table to track file conversions.

The individual values that make up a goal scale

Storing details of scheduled reports caching

Stores the definitions for whole event cancellation custom fields

Rooms to session dates many-to-many relationship

drop regions

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

Deprecated since Totara 13, please do not use

Stores custom field data related to user signup cancellation

Store changes to scalevalueid in goal_record and goal_personal.

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

A table to store cohorts visible learning assignments

Evidence item field data parameters

Info about onlinetext submission

Indicates how the choosing of manually participant roles has progressed

User competencies in a course

Web view mobile access with real browser session

Table to store application actions, such as approved and denied

This table contains Basic LTI activities instances

Defines grading scales

Stores all the actual chat messages

Contains priority scales for development plans

Represents a single job assignment at the time of subject creation

All posts are stored in this table

SCORM2004 objective mapinfo description

Collections of rulesets & rules for a dynamic cohort

one of these must be set

Table to store workflow application metadata

A table that keeps a log of events related to subscriptions

The assessment dimensions definitions of Rubric grading strategy forms

List of users from each Totara Connect server

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

enrol_flatfile table retrofitted from MySQL

Settings for navigation menu items

List of competency frameworks.

Track competencies belonging to a template

Multiple choice options (score can be used when applicable)

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.

Totara goals

SCORM2004 rule condition

The table that stores the xapi statement from xapi request

all glossary entries

every field available

Stores custom field data related to assets

Contains a single response to a single performance activity element

A list of items in the category recycle bin

Holds stats information

Stores users attempts at quizzes.

Associations of blog entries with courses and module instances

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

Link a competency to a learning plan template.

Table to store workflow assignment/override approvers

Database based session storage - now recommended

Table to store workflow stage approval level configuration

Dictionary of interactions used in recommender tables

Stores the default search to be used for a user

description of files, content is stored in sha1 file pool

Stores the custom fields for each goal type

Templates store configuration options for a group of plans.

Grading information about a single assignment submission.

To store every course backup status

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

Totara course reminder messages

feedback sitecourse map

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

Stores the columns of the rubric grid.

Access restrictions for each question. access - APPRAISAL_ACCESS_* constant

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

Totara goals

Totara competencies

A list of site policies

The evidence of prior learning

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

For everything with a time associated to it

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

Setting for external badges display

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

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

Workflow types

Links external content to a performance activity

Stores personal custom field data related to goals

Tracks which scales are assigned to which goal frameworks

Related competencies

Stores rating received via a performance activity

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.

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

Rulesets for dynamic cohorts

Intermediary file for importing course completion data

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

Totara OpenSesame course packages

Stores all members in a conversations

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

Table for mapping the resources within playlist

A table for storing ratings

Custom organisations fields data parameters

Stores tenant information of MS Teams.

Record of pathways that contributed to a specific competency achievement

lists functions available in each service group

The assessment dimensions definitions of Accumulative grading strategy forms

Virtual meetings

SCORM2004 objective description

Totara Tenant information

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

Table to store workflow stage interaction configuration

Recent activity block

Table to store application form submissions

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

Deprecated since Totara 13, please do not use

Cache of time-sensitive flags

Stores the definitions for user signup cancellation custom fields

Stores details of the assignments defined within a program

Certifications completed

Defines different set of tags

360 feedback360 form (recipients - feedback360_RECIPIENT_* bitmask).

Mapping of oauth user fields to moodle fields.

Available choices are stored here

History table

A linking table for API clients and OAuth2 client providers

Responses for sub-elements to the specified content

Stores the organisation assignments of goals

Users may choose to subscribe and unsubscribe from specific discussions.

Defines lesson_grades

Text feedback for submitted assignments

Cohorts that restricted users can see

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

user data for portfolio instances.

User overrides for a notifiable event in a specific context

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

Individual track assignments for real users

Audiences assigned to appraisal

mod_approval; Table to store workflow assignments and assignment overrides

Queue for processing.

Track manual award criteria for badges

Table to store interaction action configurations

Info about a random short-answer matching question