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 |