Tables


SchemaSpy Analysis of t2release22

Generated on Mon Jan 10 01:25 GMT 2022

Totara DB Schema t2-release-2.2

XML Representation
Insertion Order Deletion Order
TABLES 388
VIEWS 0
COLUMNS 3480
Constraints 0
Anomalies 23
Routines 3

Database Properties

Database Type: PostgreSQL - 9.6.23

Schema public

Foreign Key information for Totara tables

Tables

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

Contains settings for individual reports

app_course_completion_criteria 0 0 10 0 Table

Course completion criteria

app_scorm_seq_ruleconds 1 1 5 0 Table

SCORM2004 rule conditions

app_facetoface_notice_data 0 0 4 0 Table

Custom field filters for site notices

app_prog_extension 0 2 6 0 Table

Stores extension requests for programs

app_question_multianswer 0 1 3 0 Table

Options for multianswer questions

app_report_builder_preproc_track 0 0 5 0 Table

Stores which items have been preprocessed and when, to avoid processing unchanged items

app_org 0 0 16 0 Table

Totara organisations

app_grade_grades_history 0 6 24 0 Table

History table

app_page 0 0 13 0 Table

Each record is one page and its config data

app_feedback_item 2 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_cache_filters 0 0 6 0 Table

For keeping information about cached data

app_facetoface_sessions 3 1 12 0 Table

A given facetoface activity may be given at different times and places

app_block_rss_client 0 0 7 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_tool_customlang_components 1 0 3 0 Table

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

app_choice_answers 0 2 5 0 Table

choices performed by users

app_report_builder_saved 0 0 6 0 Table

Stores saved searches for reports

app_report_builder_filters 0 0 6 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_pos_assignment_history 0 0 14 0 Table

Tracks a users historical position assignments

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_enrol_authorize 1 0 13 0 Table

Holds all known information about authorize.net transactions

app_glossary_entries_categories 0 2 3 0 Table

categories of each glossary entry

app_dp_plan_history 0 0 6 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_cohort_msg_queue 0 0 8 0 Table

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

app_prog_completion 0 3 10 0 Table

Stores details of user’s program and course set completions

app_course_modules_availability 0 3 7 0 Table

Table stores conditions that affect whether a module/activity is currently available to students or not.

app_forum_queue 0 2 5 0 Table

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

app_lesson 7 0 40 0 Table

Defines lesson

app_license 0 0 6 9 Table

store licenses used by moodle

app_qtype_essay_options 0 1 7 0 Table

Extra options for essay questions.

app_mnet_session 0 0 9 0 Table

Store session data from users migrating to other sites

app_message_processors 0 0 3 5 Table

List of message output plugins

app_dp_course_settings 0 0 5 1 Table

Contains settings specific to the course component

app_repository_instance_config 0 0 4 0 Table

The config for intances

app_report_builder_columns 0 0 8 0 Table

Defines columns belonging to each report

app_backup_files_template 0 0 7 0 Table

To store files along the backup process. Note this table isn’t really used but its temporary counterpart.

app_mnet_service 0 0 5 4 Table

A service is a group of functions

app_org_relations 0 0 4 0 Table

Tracks relationships between organisations

app_dp_objective_scale_value 0 0 10 3 Table

Objective Scale values for development plan priority scales

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 0 0 18 0 Table

Stores the custom fields for each organisation type

app_assignment_submissions 0 1 14 0 Table

Info about submitted assignments

app_user_private_key 0 1 8 0 Table

access keys used in cookieless scripts - rss, etc.

app_quiz_reports 0 0 6 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_feedback_value 0 1 6 0 Table

values of the completeds

app_groups 3 1 10 0 Table

Each record represents a group.

app_lesson_branch 0 2 7 0 Table

branches for each lesson/user

app_workshopform_comments 0 1 5 0 Table

The assessment dimensions definitions of Comments strategy forms

app_role_allow_assign 0 2 3 11 Table

this defines what role can assign what role

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_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 0 0 13 0 Table

Course completion records

app_quiz_question_instances 0 2 4 0 Table

Stores the maximum possible grade (weight) for each question used in a quiz.

app_comp_scale 0 0 6 1 Table

Competency scale represents the different levels of achievement of a competency

app_forum 2 0 23 0 Table

Forums contain and structure discussion

app_config_log 0 1 7 759 Table

Changes done in server configuration through admin UI

app_prog_exception_data 0 1 4 0 Table

Stores details of any data specific to the exceptions raised for a program

app_workshopform_rubric_levels 0 1 5 0 Table

The definition of rubric rating scales

app_course_categories 2 1 15 1 Table

Course categories

app_dp_plan_program_assign 0 0 7 0 Table

Stores program assigned to a particular plan

app_comp_type 0 0 9 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_stats_monthly 0 0 7 0 Table

To accumulate monthly stats

app_workshop_assessments 3 3 14 0 Table

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

app_config_plugins 0 0 4 744 Table

Moodle modules and plugins configuration variables

app_pos_framework 0 0 11 0 Table

A collection of positions

app_reminder_sent 0 0 5 0 Table

Totara course reminders log of messages sent

app_lesson_timer 0 1 5 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_evidence_items 0 0 9 0 Table

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

app_facetoface_notice 0 0 3 0 Table

Site-wide notices shown on the Training Calendar

app_dp_plan 1 0 9 0 Table

Stores individual plans belonging to users.

app_facetoface_signups_status 0 1 9 0 Table

User/session signup status

app_user_preferences 0 0 4 0 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_mnet_rpc 0 0 11 15 Table

Functions or methods that we may publish or subscribe to

app_scorm 3 0 36 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 0 5 0 Table

Data for the customisable user fields

app_question_dataset_definitions 1 1 6 0 Table

Organises and stores properties for dataset items

app_filter_config 0 1 5 0 Table

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

app_dp_program_settings 0 0 5 1 Table

Contains settings specific to the program component

app_facetoface_signups 1 1 6 0 Table

User/session signups

app_user_info_field 0 0 20 0 Table

Customisable user profile fields

app_course_info_data 0 0 4 0 Table

Custom course fields data

app_prog 8 1 17 0 Table

Stores elemental details about programs

app_comments 0 0 8 0 Table

moodle comments module

app_course_completion_aggr_methd 0 0 5 0 Table

Course completion aggregation methods for criteria

app_course_modules 2 1 22 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 0 0 10 4 Table

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

app_facetoface_session_field 0 0 9 3 Table

Definitions of custom info fields for Face-to-face session

app_profiling 0 0 11 0 Table

Stores the results of all the profiling runs

app_groups_members 0 2 4 0 Table

Link a user to a group.

app_cohort_rule_params 0 0 7 0 Table

The parameters of rules in cohort_rules

app_mnet_service2rpc 0 0 3 15 Table

Group functions or methods under a service

app_question_shortanswer 0 1 4 0 Table

Options for short answer questions

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_workshop_old 0 0 34 0 Table

Legacy workshop table to be dropped later in Moodle 2.x

app_workshopform_numerrors_map 0 1 4 0 Table

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

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 0 7 0 Table

Track competencies assigned to a particular organisation

app_dp_plan_competency_assign 0 0 8 0 Table

Stores competencies assigned to a particular plan

app_message 0 0 12 0 Table

Stores all unread messages

app_question_numerical 0 1 4 0 Table

Options for numerical questions.

app_grade_outcomes_history 0 4 12 0 Table

History table

app_label 0 0 6 0 Table

Defines labels

app_lesson_high_scores 0 1 5 0 Table

high scores for each lesson

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_dp_objective_settings 0 0 6 1 Table

Settings for a template’s objectives

app_facetoface 1 0 29 0 Table

Each facetoface activity has an entry here

app_survey 2 0 10 5 Table

Each record is one SURVEY module with its configuration

app_enrol 1 1 28 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_quiz_overrides 0 3 9 0 Table

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

app_question_calculated 0 1 7 0 Table

Options for questions of type calculated

app_workshop_rubrics_old 0 1 7 0 Table

Legacy workshop_rubrics table to be dropped later in Moodle 2.x

app_comp_type_info_data 0 0 4 0 Table

Stores custom field data related to competencies

app_org_framework 0 0 11 0 Table

A collection of organisations

app_role_context_levels 0 1 3 15 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 7 0 Table

filled out feedback

app_dp_plan_evidence 0 1 9 0 Table

Contains user evidence associated with a plan

app_wiki 1 0 13 0 Table

Stores Wiki activity configuration

app_data_records 1 1 7 0 Table

every record introduced

app_dp_competency_settings 0 0 10 1 Table

Contains settings specific to the competency component

app_forum_discussions 2 1 12 0 Table

Forums are composed of discussions

app_course_modules_completion 0 0 6 0 Table

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

app_block 0 0 6 48 Table

contains all installed blocks

app_external_tokens 0 4 12 0 Table

Security tokens for accessing of external services

app_dp_priority_scale_value 0 0 9 3 Table

Scale values for development plan priority scales

app_facetoface_session_roles 0 1 4 0 Table

Users with a trainer role in a facetoface session

app_survey_analysis 0 1 4 0 Table

text about each survey submission

app_course_sections 0 0 8 0 Table

to define the sections for each course

app_book_chapters 0 0 11 0 Table

Defines book_chapters

app_user 56 0 52 2 Table

One record for each person

app_comp_scale_assignments 0 0 5 0 Table

Tracks which scales are assigned to which competency frameworks

app_question_multichoice 0 1 14 0 Table

Options for multiple choice questions

app_cohort 1 1 19 0 Table

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

app_tag_instance 0 1 7 0 Table

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

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

The dates and times for each session. 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 2 3 14 0 Table

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

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_mnet_host2service 0 0 5 0 Table

Information about the services for a given host

app_prog_future_user_assignment 0 0 4 0 Table

Future user assignments such as from first login

app_errorlog 0 0 6 0 Table

Totara additional errorlog data

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 21 4 19 0 Table

The questions themselves

app_grade_settings 0 1 4 0 Table

gradebook settings

app_report_builder_group_assign 0 0 3 0 Table

Assigns activities to groups

app_pos 0 0 18 0 Table

Totara positions

app_upgrade_log 0 1 10 831 Table

Upgrade logging

app_pos_type_info_data 0 0 4 0 Table

Stores custom field data related to positions

app_workshop_grades_old 0 2 8 0 Table

Legacy workshop_grades table to be dropped later in Moodle 2.x

app_grade_items 5 4 29 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_course_request 0 0 8 0 Table

course requests

app_tool_customlang 0 1 11 0 Table

Contains the working checkout of all strings and their customization

app_workshop_assessments_old 0 2 17 0 Table

Legacy workshop_assessments table to be dropped later in Moodle 2.x

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_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 27 0 Table

all glossaries

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 13 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_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 39 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_modules 0 0 7 23 Table

modules available in the site

app_question_attempts 3 2 13 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_backup_ids_template 0 0 7 0 Table

To store all sort of ids along the backup process. Note this table isn’t really used but its temporary counterpart.

app_groupings 2 1 8 0 Table

A grouping is a collection of groups. WAS: groups_groupings

app_role_allow_override 0 2 3 15 Table

this defines what role can override what role

app_dp_plan_course_assign 0 0 9 0 Table

Stores courses assigned to a particular plan

app_lti_types 0 0 10 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

The overall grade for each user on the quiz, based on their individual and the quiz.grademethod setting.

app_grade_categories 5 2 15 0 Table

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

app_pos_type_info_field 0 0 18 0 Table

Stores the custom fields for each position type

app_config 0 0 3 422 Table

Moodle configuration variables

app_grading_instances 1 2 9 0 Table

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

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

Contains objective scales for development plans

app_glossary_formats 0 0 9 7 Table

Setting of the display formats

app_role 12 0 6 12 Table

moodle roles

app_dp_permissions 0 0 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_resource_old 0 0 16 0 Table

backup of all old resource instances from 1.9

app_wiki_synonyms 0 0 4 0 Table

Stores wiki pages synonyms

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

templates of feedbackstructures

app_facetoface_session_data 0 0 4 0 Table

Contents of custom info fields for Face-to-face session

app_grade_import_values 0 3 8 0 Table

Temporary table for importing grades

app_quiz_statistics 0 0 16 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_post 1 1 19 0 Table

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

app_external_services 3 0 10 1 Table

built in and custom external services

app_enrol_paypal 0 0 21 0 Table

Holds all known information about PayPal transactions

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 3 0 Table

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

app_comp_evidence_items_evidence 0 0 8 0 Table

Tracks historical progress towards a competency for each user

app_lesson_answers 1 2 13 0 Table

Defines lesson_answers

app_enrol_authorize_refunds 0 1 6 0 Table

Authorize.net refunds

app_external_services_users 0 2 6 0 Table

users allowed to use services with restricted users flag

app_stats_user_weekly 0 0 8 0 Table

To accumulate weekly stats per course/user

app_log_queries 0 0 9 0 Table

Logged database queries.

app_quiz_question_statistics 0 0 16 0 Table

Default comment for the table, please edit me

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

available options to choice

app_lesson_attempts 0 3 9 0 Table

Defines lesson_attempts

app_message_providers 0 0 4 20 Table

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

app_question_categories 3 1 8 0 Table

Categories are for grouping questions

app_registration_hubs 0 0 6 0 Table

hub where the site is registered on with their associated token

app_comp_template 0 0 10 0 Table

A template is used to group competencies

app_backup_controllers 1 1 16 0 Table

To store the backup_controllers as they are used

app_workshopform_numerrors 0 1 9 0 Table

The assessment dimensions definitions of Number of errors grading strategy forms

app_course_display 0 0 4 0 Table

Stores info about how to display the course

app_wiki_subwikis 2 1 4 0 Table

Stores subwiki instances

app_question_sessions 0 4 9 0 Table

Gives ids of the newest open and newest graded states

app_message_working 0 0 3 0 Table

Lists all the messages and processors that need to be processed

app_org_type_info_data 0 0 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_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_question_match 0 1 11 0 Table

Defines fixed matching questions

app_comp_evidence 0 0 13 0 Table

Track current proficiency of a user in each competency

app_course_completion_crit_compl 0 0 9 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_quiz_question_response_stats 0 0 8 0 Table

Quiz question responses.

app_portfolio_log 0 2 10 0 Table

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

app_my_pages 0 0 5 2 Table

Extra user pages for the My Moodle system

app_dp_plan_objective 0 0 10 0 Table

One row for each objective in a plan

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_timezone 0 0 16 0 Table

Rules for calculating local wall clock time for users

app_question_states 2 2 10 0 Table

Stores user responses to an attempt, and percentage grades

app_certificate 0 0 29 0 Table

Defines certificates

app_resource 0 0 13 0 Table

Each record is one resource and its config data

app_block_instances 1 1 9 13 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_workshop_comments_old 0 2 9 0 Table

Legacy workshop_comments table to be dropped later in Moodle 2.x

app_comp_type_info_field 0 0 18 0 Table

Stores the custom fields for each competency type

app_course 18 0 36 1 Table

Central course table

app_question_dataset_items 0 0 4 0 Table

Individual dataset items

app_workshop 15 1 27 0 Table

This table keeps information about the module instances and their settings

app_grade_items_history 0 6 32 0 Table

History of grade_items

app_pos_type 0 0 9 0 Table

Position types are used to manage custom fields

app_role_sortorder 0 3 5 0 Table

sort order of course managers in a course

app_block_community 0 0 6 0 Table

Community block

app_workshop_submissions_old 0 1 13 0 Table

Legacy workshop_submissions table to be dropped later in Moodle 2.x

app_prog_courseset 4 1 11 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 0 0 12 0 Table

Each report has an entry here

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 0 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 487 Table

this defines all capabilities

app_gradingform_rubric_criteria 2 1 5 0 Table

Stores the rows of the rubric grid.

app_mnet_host 1 1 14 2 Table

Information about the local and remote hosts for RPC

app_feedback_tracking 0 2 5 0 Table

feedback trackingdata

app_data 2 0 33 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_survey_answers 0 2 7 0 Table

the answers to each questions filled by the users

app_pos_assignment 0 0 17 0 Table

Tracks a users current position assignments

app_portfolio_mahara_queue 0 1 3 0 Table

maps mahara tokens to transfer ids

app_org_type 0 0 9 0 Table

Organisation types are used to manage custom fields

app_rating 0 2 10 0 Table

moodle ratings

app_course_allowed_modules 0 0 3 0 Table

allowed modules foreach course

app_report_builder_schedule 0 0 9 0 Table

Storing details of scheduled reports

app_dp_component_settings 0 0 5 4 Table

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

app_question_randomsamatch 0 1 3 0 Table

Info about a random short-answer matching question

app_context_temp 0 0 3 0 Table

Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.

app_mnet_sso_access_control 0 0 4 0 Table

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

app_course_info_field 0 0 17 0 Table

Custom course fields

app_workshop_stockcomments_old 0 1 6 0 Table

Legacy workshop_stockcomments table to be dropped later in Moodle 2.x

app_lti 0 0 26 0 Table

This table contains Basic LTI activities instances

app_scale 7 0 8 0 Table

Defines grading scales

app_chat_messages 0 1 7 0 Table

Stores all the actual chat messages

app_role_capabilities 0 4 7 1087 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_dp_priority_scale 0 0 7 1 Table

Contains priority scales for development plans

app_data_content 0 2 8 0 Table

the content introduced in each record/fields

app_forum_posts 2 2 14 0 Table

All posts are stored in this table

app_feedback_valuetmp 0 1 6 0 Table

values of the completedstmp

app_scorm_seq_mapinfo 0 2 8 0 Table

SCORM2004 objective mapinfo description

app_feedback 5 0 18 0 Table

all feedbacks

app_log_display 0 0 6 165 Table

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

app_scorm_scoes 8 1 9 0 Table

each SCO part of the SCORM module

app_cohort_rule_collections 0 0 7 0 Table

Collections of rulesets & rules for a dynamic cohort

app_context 15 0 5 15 Table

one of these must be set

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_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_prog_pos_assignment 0 0 5 0 Table

Stores when users were last assigned a position

app_enrol_flatfile 0 3 8 0 Table

enrol_flatfile table retrofitted from MySQL

app_external_functions 0 0 7 50 Table

list of all external functions

app_comp_template_assignment 0 0 6 0 Table

Track competencies belonging to a template

app_filter_active 0 1 5 0 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_scorm_seq_rulecond 0 2 7 0 Table

SCORM2004 rule condition

app_glossary_entries 2 1 16 0 Table

all glossary entries

app_data_fields 1 1 15 0 Table

every field available

app_block_totara_stats 0 0 6 0 Table

Holds stats information

app_quiz_attempts 0 2 12 0 Table

Stores various attempts on a quiz

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_role_assignments 0 3 9 0 Table

assigning roles in different context

app_sessions 0 1 9 0 Table

Database based session storage - now recommended

app_user_info_category 0 0 3 0 Table

Customisable fields categories

app_scorm_seq_rolluprule 1 1 7 0 Table

SCORM2004 sequencing rule

app_grade_grades 1 4 21 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_files 0 2 19 0 Table

description of files, content is stored in sha1 file pool

app_question_match_sub 0 1 6 0 Table

Defines the subquestions that make up a matching question

app_dp_template 0 0 8 1 Table

Templates store configuration options for a group of plans.

app_backup_courses 0 0 6 0 Table

To store every course backup status

app_course_completion_notify 0 0 5 0 Table

Course completion notification emails

app_workshop_elements_old 0 1 11 0 Table

Legacy workshop_elements table to be dropped later in Moodle 2.x

app_cohort_rules 0 0 8 0 Table

Rules within a ruleset

app_reminder 0 0 9 0 Table

Totara course reminders

app_reminder_message 0 0 8 0 Table

Totara course reminder messages

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

Stores the columns of the rubric grid.

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_workshop_grades 0 1 7 0 Table

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

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_user_lastaccess 0 0 4 0 Table

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

app_comp 0 0 18 0 Table

Totara competencies

app_assignment 1 0 19 0 Table

Defines assignments

app_course_published 0 0 8 0 Table

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

app_comp_scale_values 0 0 10 3 Table

The individual values that make up a competency scale

app_event 0 0 17 0 Table

For everything with a time associated to it

app_report_builder_group 0 0 6 0 Table

Defines activity groups

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

filled out feedback

app_cohort_rulesets 0 0 8 0 Table

Rulesets for dynamic cohorts

app_book 0 0 10 0 Table

Defines book

app_repository 0 0 4 4 Table

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

app_mnet_log 0 0 13 0 Table

Store session data from users migrating to other sites

app_external_services_functions 0 1 3 9 Table

lists functions available in each service group

app_folder 0 0 7 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_tag 2 1 9 0 Table

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

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_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_cache_flags 0 0 6 0 Table

Cache of time-sensitive flags

app_comp_framework 0 0 11 0 Table

A collection of competencies that use a common competency scale

app_oldpassword 0 0 3 0 Table

Password rotation log of old passwords

app_prog_assignment 0 1 8 0 Table

Stores details of the assignments defined within a program

app_quiz 5 0 36 0 Table

Main information about each quiz

app_certificate_issues 0 0 5 0 Table

Info about issued certificates

app_choice 2 0 15 0 Table

Available choices are stored here

app_prog_exception 1 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_lesson_grades 0 1 6 0 Table

Defines lesson_grades

app_cache_text 0 0 4 0 Table

For storing temporary copies of processed texts

app_portfolio_instance_user 0 2 5 0 Table

user data for portfolio instances.

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

config for portfolio plugin instances

app_workshop_submissions 2 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