| SchemaSpy Analysis of totara.public Foreign Key information for moodle tables | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Mar 07 09:26 NZDT 2016 | |
| Database Type: PostgreSQL - 9.3.11 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| mdl_appraisal | 7 | 6 | 1 | Main appraisal table | |
| mdl_appraisal_event | 1 | 2 | 9 | 0 | Appraisal event notifications |
| mdl_appraisal_event_message | 1 | 1 | 4 | 0 | Appraisal event message |
| mdl_appraisal_event_rcpt | 1 | 3 | 0 | Appraisal events recipients (roles) | |
| mdl_appraisal_grp_cohort | 2 | 3 | 0 | Audiences assigned to appraisal | |
| mdl_appraisal_grp_org | 2 | 4 | 0 | Organisations assigned to appraisal | |
| mdl_appraisal_grp_pos | 2 | 4 | 0 | Positions assigned to appraisal | |
| mdl_appraisal_history | 2 | 4 | 0 | Appraisal access history | |
| mdl_appraisal_quest_field | 3 | 2 | 15 | 14 | Individual question list for appraisal page |
| mdl_appraisal_quest_field_role | 1 | 4 | 28 | Access restrictions for each question. access - APPRAISAL_ACCESS_* constant | |
| mdl_appraisal_review_data | 2 | 7 | 0 | Course, objectives, etc reviews in appraisal | |
| mdl_appraisal_role_assignment | 3 | 2 | 6 | 0 | Individual user assignments by their roles |
| mdl_appraisal_role_changes | 6 | 0 | Store role changes for assignments | ||
| mdl_appraisal_scale | 2 | 1 | 4 | 1 | Multiple choice sets |
| mdl_appraisal_scale_data | 3 | 4 | 0 | Multiple user answers | |
| mdl_appraisal_scale_value | 1 | 1 | 4 | 2 | Multiple choice options (score can be used when applicable) |
| mdl_appraisal_stage | 5 | 1 | 5 | 3 | Stages within appraisal |
| mdl_appraisal_stage_data | 2 | 4 | 0 | Appraisal stage completion for each asiignment | |
| mdl_appraisal_stage_page | 1 | 1 | 4 | 10 | Pages within appraisal stages. Each stage has at least one page |
| mdl_appraisal_stage_role_setting | 1 | 4 | 6 | Role access settings for each stage. appraisalrole - APPRAISAL_ROLE_* constant. | |
| mdl_appraisal_user_assignment | 1 | 3 | 6 | 0 | Actual user who is subject of appraisal |
| mdl_appraisal_user_event | 4 | 0 | Appraisal events scheduled to specific users | ||
| mdl_assign | 28 | 0 | This table saves information about an instance of mod_assign in a course. | ||
| mdl_assign_grades | 8 | 0 | Grading information about a single assignment submission. | ||
| mdl_assign_plugin_config | 6 | 0 | Config data for an instance of a plugin in an assignment. | ||
| mdl_assign_submission | 9 | 0 | 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. | ||
| mdl_assign_user_flags | 8 | 0 | List of flags that can be set for a single user in a single assignment. | ||
| mdl_assign_user_mapping | 3 | 0 | Map an assignment specific id number to a user | ||
| mdl_assignfeedback_comments | 5 | 0 | Text feedback for submitted assignments | ||
| mdl_assignfeedback_editpdf_annot | 11 | 0 | stores annotations added to pdfs submitted by students | ||
| mdl_assignfeedback_editpdf_cmnt | 9 | 0 | Stores comments added to pdfs | ||
| mdl_assignfeedback_editpdf_quick | 5 | 0 | Stores teacher specified quicklist comments | ||
| mdl_assignfeedback_file | 4 | 0 | Stores info about the number of files submitted by a student. | ||
| mdl_assignment | 19 | 0 | Defines assignments | ||
| mdl_assignment_submissions | 14 | 0 | Info about submitted assignments | ||
| mdl_assignment_upgrade | 6 | 0 | Info about upgraded assignments | ||
| mdl_assignsubmission_file | 4 | 0 | Info about file submissions for assignments | ||
| mdl_assignsubmission_onlinetext | 5 | 0 | Info about onlinetext submission | ||
| mdl_auth_connect_servers | 12 | 0 | List of servers | ||
| mdl_auth_connect_sso_requests | 5 | 0 | List of SSO requests from Totara Connect client to server | ||
| mdl_auth_connect_sso_sessions | 7 | 0 | List of SSO sessions on Client system, columns are not normalised to allow strict validation | ||
| mdl_auth_connect_user_collections | 6 | 0 | List of cohorts synced from server | ||
| mdl_auth_connect_users | 5 | 0 | List of users from each Totara Connect server | ||
| mdl_backup_controllers | 16 | 0 | To store the backup_controllers as they are used | ||
| mdl_backup_courses | 6 | 0 | To store every course backup status | ||
| mdl_backup_logs | 5 | 0 | To store all the logs from backup and restore operations (by db logger) | ||
| mdl_badge | 3 | 3 | 20 | 0 | Defines badge |
| mdl_badge_backpack | 1 | 1 | 7 | 0 | Defines settings for connecting external backpack |
| mdl_badge_criteria | 2 | 1 | 6 | 0 | Defines criteria for issuing badges |
| mdl_badge_criteria_met | 3 | 5 | 0 | Defines criteria that were met for an issued badge | |
| mdl_badge_criteria_param | 1 | 4 | 0 | Defines parameters for badges criteria | |
| mdl_badge_external | 1 | 3 | 0 | Setting for external badges display | |
| mdl_badge_issued | 1 | 2 | 8 | 0 | Defines issued badges |
| mdl_badge_manual_award | 4 | 6 | 0 | Track manual award criteria for badges | |
| mdl_block | 5 | 56 | contains all installed blocks | ||
| mdl_block_community | 6 | 0 | Community block | ||
| mdl_block_instances | 9 | 16 | 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 | ||
| mdl_block_positions | 8 | 0 | Stores the position of a sticky block_instance on a another page than the one where it was added. | ||
| mdl_block_quicklinks | 6 | 3 | Holds information on the defined links of a block | ||
| mdl_block_recent_activity | 7 | 0 | Recent activity block | ||
| mdl_block_rss_client | 7 | 0 | 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 | ||
| mdl_block_totara_stats | 6 | 0 | Holds stats information | ||
| mdl_blog_association | 3 | 0 | Associations of blog entries with courses and module instances | ||
| mdl_blog_external | 9 | 0 | External blog links used for RSS copying of blog entries to Moodle user blogs | ||
| mdl_book | 11 | 0 | Defines book | ||
| mdl_book_chapters | 11 | 0 | Defines book_chapters | ||
| mdl_cache_filters | 6 | 0 | For keeping information about cached data | ||
| mdl_cache_flags | 6 | 0 | Cache of time-sensitive flags | ||
| mdl_capabilities | 6 | 753 | this defines all capabilities | ||
| mdl_certif | 2 | 7 | 0 | Certifications | |
| mdl_certif_completion | 2 | 10 | 0 | Certifications completed | |
| mdl_certif_completion_history | 2 | 11 | 0 | Previous completed certifications | |
| mdl_certificate | 29 | 0 | Defines certificates | ||
| mdl_certificate_issues | 5 | 0 | Info about issued certificates | ||
| mdl_certificate_issues_history | 10 | 0 | Archived user certificates for Totara | ||
| mdl_chat | 10 | 0 | Each of these is a chat room | ||
| mdl_chat_messages | 7 | 0 | Stores all the actual chat messages | ||
| mdl_chat_messages_current | 7 | 0 | Stores current session | ||
| mdl_chat_users | 12 | 0 | Keeps track of which users are in which chat rooms | ||
| mdl_choice | 18 | 0 | Available choices are stored here | ||
| mdl_choice_answers | 5 | 0 | choices performed by users | ||
| mdl_choice_options | 5 | 0 | available options to choice | ||
| mdl_cohort | 7 | 21 | 0 | Each record represents one cohort (aka site-wide group). | |
| mdl_cohort_members | 4 | 0 | Link a user to a cohort. | ||
| mdl_cohort_msg_queue | 3 | 8 | 0 | A table to store cohort member join/delete notifications, to be sent at the next cron run. | |
| mdl_cohort_plan_history | 3 | 10 | 0 | A table to store the history of plans created for cohorts. | |
| mdl_cohort_role | 7 | 0 | A table to store roles assigned to a cohort | ||
| mdl_cohort_rule_collections | 1 | 2 | 9 | 0 | Collections of rulesets & rules for a dynamic cohort |
| mdl_cohort_rule_params | 2 | 7 | 0 | The parameters of rules in cohort_rules | |
| mdl_cohort_rules | 1 | 2 | 8 | 0 | Rules within a ruleset |
| mdl_cohort_rulesets | 1 | 2 | 8 | 0 | Rulesets for dynamic cohorts |
| mdl_cohort_visibility | 2 | 7 | 0 | A table to store cohorts visible learning assignments | |
| mdl_comments | 9 | 0 | moodle comments module | ||
| mdl_comp | 12 | 3 | 18 | 0 | Totara competencies |
| mdl_comp_criteria | 1 | 1 | 9 | 0 | A competency can be achieved by one or more forms of evidence |
| mdl_comp_criteria_record | 3 | 8 | 0 | Tracks historical progress towards a competency for each user | |
| mdl_comp_framework | 3 | 11 | 0 | A collection of competencies that use a common competency scale | |
| mdl_comp_record | 6 | 13 | 0 | Track current proficiency of a user in each competency | |
| mdl_comp_record_history | 3 | 6 | 0 | Store changes to proficiency in comp_record. | |
| mdl_comp_relations | 2 | 4 | 0 | Tracks relationships between competencies | |
| mdl_comp_scale | 2 | 1 | 6 | 1 | Competency scale represents the different levels of achievement of a competency |
| mdl_comp_scale_assignments | 2 | 5 | 0 | Tracks which scales are assigned to which competency frameworks | |
| mdl_comp_scale_values | 4 | 1 | 10 | 3 | The individual values that make up a competency scale |
| mdl_comp_template | 1 | 1 | 10 | 0 | A template is used to group competencies |
| mdl_comp_template_assignment | 3 | 6 | 0 | Track competencies belonging to a template | |
| mdl_comp_type | 2 | 8 | 0 | Competency types are used to manage custom fields | |
| mdl_comp_type_info_data | 2 | 4 | 0 | Stores custom field data related to competencies | |
| mdl_comp_type_info_data_param | 3 | 0 | Custom competencies fields data parameters | ||
| mdl_comp_type_info_field | 1 | 1 | 17 | 0 | Stores the custom fields for each competency type |
| mdl_config | 3 | 417 | Moodle configuration variables | ||
| mdl_config_log | 7 | 480 | Changes done in server configuration through admin UI | ||
| mdl_config_plugins | 4 | 814 | Moodle modules and plugins configuration variables | ||
| mdl_context | 5 | 21 | one of these must be set | ||
| mdl_context_temp | 3 | 0 | Used by context_helper::build_all_paths() in upgrade and cron to keep context depths and paths in sync. | ||
| mdl_course | 9 | 35 | 1 | Central course table | |
| mdl_course_categories | 16 | 1 | Course categories | ||
| mdl_course_completion_aggr_methd | 1 | 5 | 0 | Course completion aggregation methods for criteria | |
| mdl_course_completion_crit_compl | 3 | 8 | 0 | Course completion user records | |
| mdl_course_completion_criteria | 1 | 1 | 10 | 0 | Course completion criteria |
| mdl_course_completion_history | 2 | 5 | 0 | Course completion history archive | |
| mdl_course_completions | 1 | 4 | 14 | 0 | Course completion records |
| mdl_course_format_options | 6 | 1 | Stores format-specific options for the course or course section | ||
| mdl_course_info_data | 4 | 0 | Custom course fields data | ||
| mdl_course_info_data_param | 3 | 0 | Custom course fields data parameters | ||
| mdl_course_info_field | 16 | 0 | Custom course fields | ||
| mdl_course_modules | 19 | 0 | course_modules table retrofitted from MySQL | ||
| mdl_course_modules_completion | 7 | 0 | Stores the completion state (completed or not completed, etc) of each user on each activity. | ||
| mdl_course_published | 8 | 0 | Information about how and when an local courses were published to hubs | ||
| mdl_course_request | 9 | 0 | course requests | ||
| mdl_course_sections | 9 | 0 | to define the sections for each course | ||
| mdl_data | 33 | 0 | all database activities | ||
| mdl_data_content | 8 | 0 | the content introduced in each record/fields | ||
| mdl_data_fields | 16 | 0 | every field available | ||
| mdl_data_records | 7 | 0 | every record introduced | ||
| mdl_dp_competency_settings | 2 | 10 | 1 | Contains settings specific to the competency component | |
| mdl_dp_component_settings | 1 | 5 | 4 | Stores the names and component-independent settings for each installed component. | |
| mdl_dp_course_settings | 2 | 5 | 1 | Contains settings specific to the course component | |
| mdl_dp_evidence_type | 1 | 1 | 6 | 0 | Table to store evidence type menu |
| mdl_dp_objective_scale | 2 | 2 | 7 | 1 | Contains objective scales for development plans |
| mdl_dp_objective_scale_value | 2 | 2 | 10 | 3 | Objective Scale values for development plan priority scales |
| mdl_dp_objective_settings | 3 | 6 | 1 | Settings for a template's objectives | |
| mdl_dp_permissions | 1 | 6 | 52 | Stores the permission settings for plan templates | |
| mdl_dp_plan | 6 | 2 | 10 | 0 | Stores individual plans belonging to users. |
| mdl_dp_plan_competency_assign | 4 | 9 | 0 | Stores competencies assigned to a particular plan | |
| mdl_dp_plan_component_relation | 6 | 0 | Provides a way to link together items from different components within a plan | ||
| mdl_dp_plan_course_assign | 4 | 10 | 0 | Stores courses assigned to a particular plan | |
| mdl_dp_plan_evidence | 1 | 3 | 12 | 0 | Contains user evidence in the record of learning |
| mdl_dp_plan_evidence_relation | 2 | 5 | 0 | Related courses / objectives / competencies | |
| mdl_dp_plan_history | 2 | 7 | 0 | A table for tracking and recording modifications to a related dp_plan | |
| mdl_dp_plan_objective | 3 | 11 | 0 | One row for each objective in a plan | |
| mdl_dp_plan_program_assign | 3 | 8 | 0 | Stores program assigned to a particular plan | |
| mdl_dp_plan_settings | 1 | 5 | 1 | Contains settings for the plan | |
| mdl_dp_priority_scale | 4 | 2 | 7 | 1 | Contains priority scales for development plans |
| mdl_dp_priority_scale_value | 5 | 2 | 9 | 3 | Scale values for development plan priority scales |
| mdl_dp_program_settings | 1 | 5 | 1 | Contains settings specific to the program component | |
| mdl_dp_template | 9 | 9 | 1 | Templates store configuration options for a group of plans. | |
| mdl_editor_atto_autosave | 9 | 0 | Draft text that is auto-saved every 5 seconds while an editor is open. | ||
| mdl_enrol | 35 | 0 | 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. | ||
| mdl_enrol_flatfile | 8 | 0 | enrol_flatfile table retrofitted from MySQL | ||
| mdl_enrol_paypal | 21 | 0 | Holds all known information about PayPal transactions | ||
| mdl_enrol_totara_f2f_pending | 4 | 0 | Queue for users waiting for f2f approval before enrolment | ||
| mdl_errorlog | 6 | 0 | Totara additional errorlog data | ||
| mdl_event | 18 | 0 | For everything with a time associated to it | ||
| mdl_event_subscriptions | 9 | 0 | Tracks subscriptions to remote calendars. | ||
| mdl_events_handlers | 8 | 2 | 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 | ||
| mdl_events_queue | 5 | 0 | 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. | ||
| mdl_events_queue_handlers | 6 | 0 | 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 | ||
| mdl_external_functions | 7 | 146 | list of all external functions | ||
| mdl_external_services | 11 | 1 | built in and custom external services | ||
| mdl_external_services_functions | 3 | 67 | lists functions available in each service group | ||
| mdl_external_services_users | 6 | 0 | users allowed to use services with restricted users flag | ||
| mdl_external_tokens | 12 | 0 | Security tokens for accessing of external services | ||
| mdl_facetoface | 2 | 1 | 28 | 0 | Each facetoface activity has an entry here |
| mdl_facetoface_cancellation_info_data | 4 | 0 | Stores custom field data related to cancellation notes | ||
| mdl_facetoface_cancellation_info_data_param | 3 | 0 | Custom cancellation fields data parameters | ||
| mdl_facetoface_cancellation_info_field | 16 | 1 | Stores the custom fields for each cancellation type | ||
| mdl_facetoface_interest | 5 | 0 | Users who have declared interest in a facetoface session | ||
| mdl_facetoface_notice | 1 | 3 | 0 | Site-wide notices shown on the Training Calendar | |
| mdl_facetoface_notice_data | 2 | 4 | 0 | Custom field filters for site notices | |
| mdl_facetoface_notification | 2 | 3 | 20 | 0 | Facetoface notifications |
| mdl_facetoface_notification_hist | 4 | 8 | 0 | Notifications history (stores ical event information) | |
| mdl_facetoface_notification_sent | 2 | 4 | 0 | Face-to-face notification reciepts | |
| mdl_facetoface_notification_tpl | 6 | 12 | Face-to-face notification templates | ||
| mdl_facetoface_room | 1 | 10 | 0 | Table for storing pre-defined facetoface room data | |
| mdl_facetoface_session_info_data | 2 | 4 | 0 | Stores custom field data related to facetoface session | |
| mdl_facetoface_session_info_data_param | 3 | 0 | Custom facetoface session fields data parameters | ||
| mdl_facetoface_session_info_field | 2 | 17 | 0 | Stores the custom fields for each facetoface session type | |
| mdl_facetoface_session_roles | 3 | 4 | 0 | Users with a trainer role in a facetoface session | |
| mdl_facetoface_sessions | 6 | 3 | 20 | 0 | A given facetoface activity may be given at different times and places |
| mdl_facetoface_sessions_dates | 1 | 1 | 5 | 0 | The dates and times for each session. Sessions can be set over multiple days or blocks of time. |
| mdl_facetoface_signup_info_data | 4 | 0 | Stores custom field data related to signups | ||
| mdl_facetoface_signup_info_data_param | 3 | 0 | Custom signup fields data parameters | ||
| mdl_facetoface_signup_info_field | 16 | 1 | Stores the custom fields for each signup type | ||
| mdl_facetoface_signups | 1 | 2 | 10 | 0 | User/session signups |
| mdl_facetoface_signups_status | 2 | 8 | 0 | User/session signup status | |
| mdl_feedback | 17 | 0 | all feedbacks | ||
| mdl_feedback360 | 5 | 7 | 0 | 360 feedback360 form (recipients - feedback360_RECIPIENT_* bitmask). | |
| mdl_feedback360_email_assignment | 1 | 3 | 0 | Email addresses for feedback360 | |
| mdl_feedback360_grp_cohort | 2 | 3 | 0 | Audiences assigned to feedback360 | |
| mdl_feedback360_grp_org | 2 | 4 | 0 | Organisations assigned to feedback360 | |
| mdl_feedback360_grp_pos | 2 | 4 | 0 | Positions assigned to feedback360 | |
| mdl_feedback360_quest_field | 2 | 1 | 15 | 0 | Individual question definitions for each feedback360 |
| mdl_feedback360_resp_assignment | 1 | 3 | 7 | 0 | feedback360 responders assignments |
| mdl_feedback360_scale | 1 | 2 | 5 | 0 | Multiple choice sets |
| mdl_feedback360_scale_data | 3 | 4 | 0 | Multiple user answers | |
| mdl_feedback360_scale_value | 1 | 1 | 4 | 0 | Multiple choice options (score can be used when applicable) |
| mdl_feedback360_user_assignment | 1 | 2 | 4 | 0 | Actual user who is subject of feedback360 |
| mdl_feedback_completed | 6 | 0 | filled out feedback | ||
| mdl_feedback_completed_history | 8 | 0 | history of filled out feedback | ||
| mdl_feedback_completedtmp | 7 | 0 | filled out feedback | ||
| mdl_feedback_item | 13 | 0 | feedback_items | ||
| mdl_feedback_sitecourse_map | 3 | 0 | feedback sitecourse map | ||
| mdl_feedback_template | 4 | 0 | templates of feedbackstructures | ||
| mdl_feedback_tracking | 5 | 0 | feedback trackingdata | ||
| mdl_feedback_value | 6 | 0 | values of the completeds | ||
| mdl_feedback_value_history | 8 | 0 | History of values of the completeds | ||
| mdl_feedback_valuetmp | 6 | 0 | values of the completedstmp | ||
| mdl_files | 20 | 5 | description of files, content is stored in sha1 file pool | ||
| mdl_files_reference | 5 | 0 | Store files references | ||
| mdl_filter_active | 5 | 3 | 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. | ||
| mdl_filter_config | 5 | 0 | Stores per-context configuration settings for filters which have them. | ||
| mdl_folder | 9 | 0 | each record is one folder resource | ||
| mdl_forum | 24 | 0 | Forums contain and structure discussion | ||
| mdl_forum_digests | 4 | 0 | Keeps track of user mail delivery preferences for each forum | ||
| mdl_forum_discussion_subs | 5 | 0 | Users may choose to subscribe and unsubscribe from specific discussions. | ||
| mdl_forum_discussions | 13 | 0 | Forums are composed of discussions | ||
| mdl_forum_posts | 15 | 0 | All posts are stored in this table | ||
| mdl_forum_queue | 5 | 0 | For keeping track of posts that will be mailed in digest form | ||
| mdl_forum_read | 7 | 0 | Tracks each users read posts | ||
| mdl_forum_subscriptions | 3 | 0 | Keeps track of who is subscribed to what forum | ||
| mdl_forum_track_prefs | 3 | 0 | Tracks each users untracked forums | ||
| mdl_glossary | 28 | 0 | all glossaries | ||
| mdl_glossary_alias | 3 | 0 | entries alias | ||
| mdl_glossary_categories | 4 | 0 | all categories for glossary entries | ||
| mdl_glossary_entries | 16 | 0 | all glossary entries | ||
| mdl_glossary_entries_categories | 3 | 0 | categories of each glossary entry | ||
| mdl_glossary_formats | 9 | 0 | Setting of the display formats | ||
| mdl_goal | 7 | 3 | 17 | 0 | Totara goals |
| mdl_goal_framework | 2 | 11 | 0 | A collection of goals | |
| mdl_goal_grp_cohort | 2 | 5 | 0 | Stores the assignments of goals | |
| mdl_goal_grp_org | 2 | 6 | 0 | Stores the organisation assignments of goals | |
| mdl_goal_grp_pos | 2 | 6 | 0 | Stores the position assignments of goals | |
| mdl_goal_item_history | 1 | 6 | 0 | Store changes to scalevalueid in goal_record and goal_personal. | |
| mdl_goal_personal | 3 | 15 | 0 | Totara goals | |
| mdl_goal_record | 3 | 5 | 0 | Track current status of a user within goals | |
| mdl_goal_scale | 3 | 1 | 6 | 1 | Scale represents the different levels of achievement of a goal |
| mdl_goal_scale_assignments | 2 | 5 | 0 | Tracks which scales are assigned to which goal frameworks | |
| mdl_goal_scale_values | 4 | 1 | 10 | 3 | The individual values that make up a goal scale |
| mdl_goal_type | 2 | 7 | 0 | Goal types are used to manage custom fields | |
| mdl_goal_type_info_data | 2 | 4 | 0 | Stores custom field data related to goals | |
| mdl_goal_type_info_data_param | 3 | 0 | Custom organisations fields data parameters | ||
| mdl_goal_type_info_field | 1 | 1 | 17 | 0 | Stores the custom fields for each goal type |
| mdl_goal_user_assignment | 2 | 8 | 0 | Stores the user assignments of goals | |
| mdl_goal_user_info_data | 4 | 0 | Stores personal custom field data related to goals | ||
| mdl_goal_user_info_data_param | 3 | 0 | Custom organisations fields data parameters | ||
| mdl_goal_user_info_field | 17 | 0 | Stores the personal custom fields for each goal type | ||
| mdl_goal_user_type | 8 | 0 | Table to store goal types for personal goals. | ||
| mdl_goal_user_type_cohort | 5 | 0 | Contains audiences allowed to select specific personal goal types. | ||
| mdl_grade_categories | 14 | 0 | This table keeps information about categories, used for grouping items. | ||
| mdl_grade_categories_history | 18 | 0 | History of grade_categories | ||
| mdl_grade_grades | 23 | 0 | 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 | ||
| mdl_grade_grades_history | 24 | 0 | History table | ||
| mdl_grade_import_newitem | 4 | 0 | temporary table for storing new grade_item names from grade import | ||
| mdl_grade_import_values | 9 | 0 | Temporary table for importing grades | ||
| mdl_grade_items | 31 | 0 | 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 | ||
| mdl_grade_items_history | 34 | 0 | History of grade_items | ||
| mdl_grade_letters | 4 | 0 | Repository for grade letters, for courses and other moodle entities that use grades. | ||
| mdl_grade_outcomes | 10 | 0 | 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) | ||
| mdl_grade_outcomes_courses | 3 | 0 | stores what outcomes are used in what courses. | ||
| mdl_grade_outcomes_history | 12 | 0 | History table | ||
| mdl_grade_settings | 4 | 0 | gradebook settings | ||
| mdl_grading_areas | 5 | 0 | Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set. | ||
| mdl_grading_definitions | 14 | 0 | Contains the basic information about an advanced grading form defined in the given gradable area | ||
| mdl_grading_instances | 9 | 0 | Grading form instance is an assessment record for one gradable item assessed by one rater | ||
| mdl_gradingform_guide_comments | 5 | 0 | frequently used comments used in marking guide | ||
| mdl_gradingform_guide_criteria | 9 | 0 | Stores the rows of the criteria grid. | ||
| mdl_gradingform_guide_fillings | 6 | 0 | Stores the data of how the guide is filled by a particular rater | ||
| mdl_gradingform_rubric_criteria | 5 | 0 | Stores the rows of the rubric grid. | ||
| mdl_gradingform_rubric_fillings | 6 | 0 | Stores the data of how the rubric is filled by a particular rater | ||
| mdl_gradingform_rubric_levels | 5 | 0 | Stores the columns of the rubric grid. | ||
| mdl_groupings | 9 | 0 | A grouping is a collection of groups. WAS: groups_groupings | ||
| mdl_groupings_groups | 4 | 0 | Link a grouping to a group (note, groups can be in multiple groupings ONLY in a course). WAS: groups_groupings_groups | ||
| mdl_groups | 11 | 0 | Each record represents a group. | ||
| mdl_groups_members | 6 | 0 | Link a user to a group. | ||
| mdl_imscp | 9 | 0 | each record is one imscp resource | ||
| mdl_label | 6 | 0 | Defines labels | ||
| mdl_lesson | 43 | 0 | Defines lesson | ||
| mdl_lesson_answers | 13 | 0 | Defines lesson_answers | ||
| mdl_lesson_attempts | 9 | 0 | Defines lesson_attempts | ||
| mdl_lesson_branch | 8 | 0 | branches for each lesson/user | ||
| mdl_lesson_grades | 6 | 0 | Defines lesson_grades | ||
| mdl_lesson_high_scores | 5 | 0 | high scores for each lesson | ||
| mdl_lesson_overrides | 11 | 0 | The overrides to lesson settings. | ||
| mdl_lesson_pages | 13 | 0 | Defines lesson_pages | ||
| mdl_lesson_timer | 6 | 0 | lesson timer for each lesson | ||
| mdl_license | 6 | 9 | store licenses used by moodle | ||
| mdl_lock_db | 4 | 0 | Stores active and inactive lock types for db locking method. | ||
| mdl_log | 10 | 0 | Every action is logged as far as possible | ||
| mdl_log_display | 6 | 205 | For a particular module/action, specifies a moodle table/field | ||
| mdl_log_queries | 9 | 0 | Logged database queries. | ||
| mdl_logstore_standard_log | 21 | 1 | Standard log table | ||
| mdl_lti | 26 | 0 | This table contains Basic LTI activities instances | ||
| mdl_lti_submission | 9 | 0 | Keeps track of individual submissions for LTI activities. | ||
| mdl_lti_tool_proxies | 13 | 0 | LTI tool proxy registrations | ||
| mdl_lti_tool_settings | 7 | 0 | LTI tool setting values | ||
| mdl_lti_types | 15 | 0 | Basic LTI pre-configured activities | ||
| mdl_lti_types_config | 4 | 0 | Basic LTI types configuration | ||
| mdl_message | 12 | 0 | Stores all unread messages | ||
| mdl_message_airnotifier_devices | 3 | 0 | Store information about the devices registered in Airnotifier for PUSH notifications | ||
| mdl_message_contacts | 4 | 0 | Maintains lists of relationships between users | ||
| mdl_message_metadata | 11 | 0 | type, status, and workflow additions to messages | ||
| mdl_message_processors | 3 | 6 | List of message output plugins | ||
| mdl_message_providers | 4 | 31 | This table stores the message providers (modules and core systems) | ||
| mdl_message_read | 13 | 0 | Stores all messages that have been read | ||
| mdl_message_working | 3 | 0 | Lists all the messages and processors that need to be processed | ||
| mdl_messageinbound_datakeys | 6 | 0 | Inbound Message data item secret keys. | ||
| mdl_messageinbound_handlers | 6 | 3 | Inbound Message Handler definitions. | ||
| mdl_messageinbound_messagelist | 5 | 0 | A list of message IDs for existing replies | ||
| mdl_mnet_application | 6 | 2 | Information about applications on remote hosts | ||
| mdl_mnet_host | 15 | 2 | Information about the local and remote hosts for RPC | ||
| mdl_mnet_host2service | 5 | 0 | Information about the services for a given host | ||
| mdl_mnet_log | 13 | 0 | Store session data from users migrating to other sites | ||
| mdl_mnet_remote_rpc | 6 | 16 | This table describes functions that might be called remotely (we have less information about them than local functions) | ||
| mdl_mnet_remote_service2rpc | 3 | 16 | Group functions or methods under a service | ||
| mdl_mnet_rpc | 11 | 15 | Functions or methods that we may publish or subscribe to | ||
| mdl_mnet_service | 5 | 4 | A service is a group of functions | ||
| mdl_mnet_service2rpc | 3 | 15 | Group functions or methods under a service | ||
| mdl_mnet_session | 9 | 0 | Store session data from users migrating to other sites | ||
| mdl_mnet_sso_access_control | 4 | 0 | Users by host permitted (or not) to login from a remote provider | ||
| mdl_mnetservice_enrol_courses | 14 | 0 | Caches the information fetched via XML-RPC about courses on remote hosts that are offered for our users | ||
| mdl_mnetservice_enrol_enrolments | 7 | 0 | Caches the information about enrolments of our local users in courses on remote hosts | ||
| mdl_modules | 6 | 24 | modules available in the site | ||
| mdl_my_pages | 5 | 2 | Extra user pages for the My Moodle system | ||
| mdl_org | 12 | 3 | 16 | 0 | Totara organisations |
| mdl_org_competencies | 2 | 7 | 0 | Track competencies assigned to a particular organisation | |
| mdl_org_framework | 1 | 11 | 0 | A collection of organisations | |
| mdl_org_relations | 2 | 4 | 0 | Tracks relationships between organisations | |
| mdl_org_type | 2 | 8 | 0 | Organisation types are used to manage custom fields | |
| mdl_org_type_info_data | 2 | 4 | 0 | Stores custom field data related to organisations | |
| mdl_org_type_info_data_param | 3 | 0 | Custom organisations fields data parameters | ||
| mdl_org_type_info_field | 1 | 1 | 17 | 0 | Stores the custom fields for each organisation type |
| mdl_page | 13 | 0 | Each record is one page and its config data | ||
| mdl_portfolio_instance | 4 | 0 | base table (not including config data) for instances of portfolio plugins. | ||
| mdl_portfolio_instance_config | 4 | 0 | config for portfolio plugin instances | ||
| mdl_portfolio_instance_user | 5 | 0 | user data for portfolio instances. | ||
| mdl_portfolio_log | 11 | 0 | log of portfolio transfers (used to later check for duplicates) | ||
| mdl_portfolio_mahara_queue | 3 | 0 | maps mahara tokens to transfer ids | ||
| mdl_portfolio_tempdata | 6 | 0 | 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. | ||
| mdl_pos | 12 | 3 | 18 | 0 | Totara positions |
| mdl_pos_assignment | 6 | 18 | 0 | Tracks a users current position assignments | |
| mdl_pos_assignment_history | 4 | 14 | 0 | Tracks a users historical position assignments | |
| mdl_pos_competencies | 2 | 7 | 0 | Tracks competencies assigned to a particular position | |
| mdl_pos_framework | 1 | 11 | 0 | A collection of positions | |
| mdl_pos_relations | 2 | 4 | 0 | Tracks relationships between positions | |
| mdl_pos_type | 2 | 8 | 0 | Position types are used to manage custom fields | |
| mdl_pos_type_info_data | 2 | 4 | 0 | Stores custom field data related to positions | |
| mdl_pos_type_info_data_param | 3 | 0 | Custom positions fields data parameters | ||
| mdl_pos_type_info_field | 1 | 1 | 17 | 0 | Stores the custom fields for each position type |
| mdl_post | 19 | 0 | Generic post table to hold data blog entries etc in different modules | ||
| mdl_profiling | 11 | 0 | Stores the results of all the profiling runs | ||
| mdl_prog | 1 | 21 | 0 | Stores elemental details about programs | |
| mdl_prog_assignment | 8 | 0 | Stores details of the assignments defined within a program | ||
| mdl_prog_completion | 10 | 0 | Stores details of user's program and course set completions | ||
| mdl_prog_completion_history | 11 | 0 | Stores details of user's program and course set completions history | ||
| mdl_prog_courseset | 15 | 0 | Stores details of the sets of courses and competencies contained within a program | ||
| mdl_prog_courseset_course | 3 | 0 | Stores the details of the individual courses contained in a course set | ||
| mdl_prog_exception | 6 | 0 | Stores details of any exceptions raised relating to a program | ||
| mdl_prog_extension | 7 | 0 | Stores extension requests for programs | ||
| mdl_prog_future_user_assignment | 4 | 0 | Future user assignments such as from first login | ||
| mdl_prog_info_data | 4 | 0 | Stores custom field data related to programs | ||
| mdl_prog_info_data_param | 3 | 0 | Custom programs fields data parameters | ||
| mdl_prog_info_field | 16 | 0 | Stores the custom fields for each program type | ||
| mdl_prog_message | 9 | 0 | Stores details of the messages defined within a program | ||
| mdl_prog_messagelog | 5 | 0 | Stores details of program-related messages that have been issued to a user | ||
| mdl_prog_pos_assignment | 5 | 0 | Stores when users were last assigned a position | ||
| mdl_prog_recurrence | 4 | 0 | 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 | ||
| mdl_prog_user_assignment | 6 | 0 | Stores details of the user assignments that have been made for a program based on the program's assignment criteria | ||
| mdl_qtype_essay_options | 11 | 0 | Extra options for essay questions. | ||
| mdl_qtype_match_options | 10 | 0 | Defines the question-type specific options for matching questions | ||
| mdl_qtype_match_subquestions | 5 | 0 | The subquestions that make up a matching question | ||
| mdl_qtype_multichoice_options | 13 | 0 | Options for multiple choice questions | ||
| mdl_qtype_randomsamatch_options | 11 | 0 | Info about a random short-answer matching question | ||
| mdl_qtype_shortanswer_options | 3 | 0 | Options for short answer questions | ||
| mdl_question | 19 | 0 | The questions themselves | ||
| mdl_question_answers | 7 | 0 | Answers, with a fractional grade (0-1) and feedback | ||
| mdl_question_attempt_step_data | 4 | 0 | 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 | ||
| mdl_question_attempt_steps | 7 | 0 | 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. | ||
| mdl_question_attempts | 14 | 0 | 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 | ||
| mdl_question_calculated | 7 | 0 | Options for questions of type calculated | ||
| mdl_question_calculated_options | 13 | 0 | Options for questions of type calculated | ||
| mdl_question_categories | 8 | 0 | Categories are for grouping questions | ||
| mdl_question_dataset_definitions | 6 | 0 | Organises and stores properties for dataset items | ||
| mdl_question_dataset_items | 4 | 0 | Individual dataset items | ||
| mdl_question_datasets | 3 | 0 | Many-many relation between questions and dataset definitions | ||
| mdl_question_hints | 7 | 0 | Stores the the part of the question definition that gives different feedback after each try in interactive and similar behaviours. | ||
| mdl_question_multianswer | 3 | 0 | Options for multianswer questions | ||
| mdl_question_numerical | 4 | 0 | Options for numerical questions. | ||
| mdl_question_numerical_options | 6 | 0 | Options for questions of type numerical This table is also used by the calculated question type | ||
| mdl_question_numerical_units | 4 | 0 | Optional unit options for numerical questions. This table is also used by the calculated question type. | ||
| mdl_question_response_analysis | 10 | 0 | Analysis of student responses given to questions. | ||
| mdl_question_response_count | 4 | 0 | Count for each responses for each try at a question. | ||
| mdl_question_statistics | 18 | 0 | Statistics for individual questions used in an activity. | ||
| mdl_question_truefalse | 4 | 0 | Options for True-False questions | ||
| mdl_question_usages | 4 | 0 | 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. | ||
| mdl_quiz | 40 | 0 | The settings for each quiz. | ||
| mdl_quiz_attempts | 14 | 0 | Stores users attempts at quizzes. | ||
| mdl_quiz_feedback | 6 | 0 | Feedback given to students based on which grade band their overall score lies. | ||
| mdl_quiz_grades | 5 | 0 | Stores the overall grade for each user on the quiz, based on their various attempts and the quiz.grademethod setting. | ||
| mdl_quiz_overrides | 9 | 0 | The overrides to quiz settings on a per-user and per-group basis. | ||
| mdl_quiz_overview_regrades | 7 | 0 | This table records which question attempts need regrading and the grade they will be regraded to. | ||
| mdl_quiz_reports | 4 | 4 | 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. | ||
| mdl_quiz_sections | 5 | 0 | Stores sections of a quiz with section name (heading), from slot-number N and whether the question order should be shuffled. | ||
| mdl_quiz_slots | 7 | 0 | Stores the question used in a quiz, with the order, and for each question, which page it appears on, and the maximum mark (weight). | ||
| mdl_quiz_statistics | 19 | 0 | table to cache results from analysis done in statistics report for quizzes. | ||
| mdl_rating | 10 | 0 | moodle ratings | ||
| mdl_registration_hubs | 7 | 0 | hub where the site is registered on with their associated token | ||
| mdl_reminder | 9 | 0 | Totara course reminders | ||
| mdl_reminder_message | 8 | 0 | Totara course reminder messages | ||
| mdl_reminder_sent | 5 | 0 | Totara course reminders log of messages sent | ||
| mdl_report_builder | 6 | 17 | 0 | Each report has an entry here | |
| mdl_report_builder_cache | 1 | 10 | 0 | Storing details of scheduled reports caching | |
| mdl_report_builder_columns | 1 | 10 | 0 | Defines columns belonging to each report | |
| mdl_report_builder_filters | 1 | 9 | 0 | Defines filters belonging to each report | |
| mdl_report_builder_global_restriction | 9 | 0 | Global Report Restrictions | ||
| mdl_report_builder_graph | 10 | 0 | Report graphs | ||
| mdl_report_builder_group | 2 | 6 | 0 | Defines activity groups | |
| mdl_report_builder_group_assign | 1 | 3 | 0 | Assigns activities to groups | |
| mdl_report_builder_preproc_track | 1 | 5 | 0 | Stores which items have been preprocessed and when, to avoid processing unchanged items | |
| mdl_report_builder_saved | 1 | 2 | 7 | 0 | Stores saved searches for reports |
| mdl_report_builder_schedule | 3 | 9 | 0 | Storing details of scheduled reports | |
| mdl_report_builder_schedule_email_audience | 3 | 0 | Storing audience to email in scheduled reports | ||
| mdl_report_builder_schedule_email_external | 3 | 0 | Storing external emails to send in scheduled reports | ||
| mdl_report_builder_schedule_email_systemuser | 3 | 0 | Storing system users to email in scheduled reports | ||
| mdl_report_builder_search_cols | 4 | 0 | Defines search columns belonging to each report | ||
| mdl_report_builder_settings | 1 | 5 | 0 | Contains settings for individual reports | |
| mdl_reportbuilder_grp_cohort_record | 4 | 0 | Cohorts that restricted users can see | ||
| mdl_reportbuilder_grp_cohort_user | 4 | 0 | Restricted cohorts that will see only allowed records | ||
| mdl_reportbuilder_grp_org_record | 5 | 0 | Organisations that restricted users can see | ||
| mdl_reportbuilder_grp_org_user | 5 | 0 | Restricted organisations that will see only allowed records | ||
| mdl_reportbuilder_grp_pos_record | 5 | 0 | Positions that restricted users can see | ||
| mdl_reportbuilder_grp_pos_user | 5 | 0 | Restricted positions that will see only allowed records | ||
| mdl_reportbuilder_grp_user_record | 4 | 0 | Individual users that restricted users can see | ||
| mdl_reportbuilder_grp_user_user | 4 | 0 | Restricted individual users that will see only allowed records | ||
| mdl_repository | 4 | 7 | This table contains one entry for every configured external repository instance. | ||
| mdl_repository_instance_config | 4 | 0 | The config for intances | ||
| mdl_repository_instances | 10 | 7 | This table contains one entry for every configured external repository instance. | ||
| mdl_repository_opensesame_bdls | 3 | 0 | Totara OpenSesame course bundles | ||
| mdl_repository_opensesame_bps | 3 | 0 | Link an OpenSesame course to a bundle | ||
| mdl_repository_opensesame_pkgs | 11 | 0 | Totara OpenSesame course packages | ||
| mdl_resource | 13 | 0 | Each record is one resource and its config data | ||
| mdl_resource_old | 16 | 0 | backup of all old resource instances from 1.9 | ||
| mdl_role | 2 | 6 | 9 | moodle roles | |
| mdl_role_allow_assign | 3 | 8 | this defines what role can assign what role | ||
| mdl_role_allow_override | 3 | 12 | this defines what role can override what role | ||
| mdl_role_allow_switch | 3 | 10 | This table stores which which other roles a user is allowed to switch to if they have one role. | ||
| mdl_role_assignments | 2 | 9 | 0 | assigning roles in different context | |
| mdl_role_capabilities | 7 | 1,494 | permission has to be signed, overriding a capability for a particular role in a particular context | ||
| mdl_role_context_levels | 3 | 13 | Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table. | ||
| mdl_role_names | 4 | 0 | role names in native strings | ||
| mdl_role_sortorder | 5 | 0 | sort order of course managers in a course | ||
| mdl_scale | 8 | 0 | Defines grading scales | ||
| mdl_scale_history | 11 | 0 | History table | ||
| mdl_scorm | 41 | 0 | each table is one SCORM module and its configuration | ||
| mdl_scorm_aicc_session | 12 | 0 | Used by AICC HACP to store session information | ||
| mdl_scorm_scoes | 10 | 0 | each SCO part of the SCORM module | ||
| mdl_scorm_scoes_data | 4 | 0 | Contains variable data get from packages | ||
| mdl_scorm_scoes_track | 8 | 0 | to track SCOes | ||
| mdl_scorm_seq_mapinfo | 8 | 0 | SCORM2004 objective mapinfo description | ||
| mdl_scorm_seq_objective | 6 | 0 | SCORM2004 objective description | ||
| mdl_scorm_seq_rolluprule | 7 | 0 | SCORM2004 sequencing rule | ||
| mdl_scorm_seq_rolluprulecond | 5 | 0 | SCORM2004 sequencing rule | ||
| mdl_scorm_seq_rulecond | 7 | 0 | SCORM2004 rule condition | ||
| mdl_scorm_seq_ruleconds | 5 | 0 | SCORM2004 rule conditions | ||
| mdl_sessions | 9 | 1 | Database based session storage - now recommended | ||
| mdl_stats_daily | 7 | 0 | to accumulate daily stats | ||
| mdl_stats_monthly | 7 | 0 | To accumulate monthly stats | ||
| mdl_stats_user_daily | 8 | 0 | To accumulate daily stats per course/user | ||
| mdl_stats_user_monthly | 8 | 0 | To accumulate monthly stats per course/user | ||
| mdl_stats_user_weekly | 8 | 0 | To accumulate weekly stats per course/user | ||
| mdl_stats_weekly | 7 | 0 | To accumulate weekly stats | ||
| mdl_survey | 10 | 5 | Each record is one SURVEY module with its configuration | ||
| mdl_survey_analysis | 4 | 0 | text about each survey submission | ||
| mdl_survey_answers | 7 | 0 | the answers to each questions filled by the users | ||
| mdl_survey_questions | 7 | 73 | the questions conforming one survey | ||
| mdl_tag | 9 | 0 | Tag table - this generic table will replace the old "tags" table. | ||
| mdl_tag_correlation | 3 | 0 | 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 | ||
| mdl_tag_instance | 10 | 0 | tag_instance table holds the information of associations between tags and other items | ||
| mdl_task_adhoc | 7 | 0 | List of adhoc tasks waiting to run. | ||
| mdl_task_scheduled | 14 | 72 | List of scheduled tasks to be run by cron. | ||
| mdl_temporary_manager | 3 | 6 | 0 | Stores a user's temporary manager data | |
| mdl_tool_customlang | 11 | 0 | Contains the working checkout of all strings and their customization | ||
| mdl_tool_customlang_components | 3 | 0 | Contains the list of all installed plugins that provide their own language pack | ||
| mdl_tool_monitor_events | 8 | 0 | A table that keeps a log of events related to subscriptions | ||
| mdl_tool_monitor_history | 4 | 0 | Table to store history of message notifications sent | ||
| mdl_tool_monitor_rules | 14 | 0 | Table to store rules | ||
| mdl_tool_monitor_subscriptions | 7 | 0 | Table to store user subscriptions to various rules | ||
| mdl_totara_compl_import_cert | 14 | 0 | Intermediary file for importing certification completion data | ||
| mdl_totara_compl_import_course | 14 | 0 | Intermediary file for importing course completion data | ||
| mdl_totara_connect_client_cohorts | 4 | 0 | List of cohorts synced to a client, the members are restricted by totara_connect_clients.cohortid if specified | ||
| mdl_totara_connect_client_courses | 4 | 0 | List of courses synced to a client, the enrolled users are restricted by totara_connect_clients.cohortid if specified | ||
| mdl_totara_connect_clients | 15 | 0 | List of client systems registered with this server | ||
| mdl_totara_connect_sso_sessions | 6 | 0 | List of all SSO sessions on client systems connect to this server | ||
| mdl_totara_dashboard | 5 | 0 | Dashboards | ||
| mdl_totara_dashboard_cohort | 3 | 0 | Users modifications of pages | ||
| mdl_totara_dashboard_user | 3 | 0 | User modified instances of dashboards | ||
| mdl_totara_navigation | 14 | 19 | Totara navigation menu | ||
| mdl_totara_navigation_settings | 6 | 0 | Settings for navigation menu items | ||
| mdl_totara_sync_log | 7 | 0 | log table for totara element syncing | ||
| mdl_upgrade_log | 10 | 1,252 | Upgrade logging | ||
| mdl_url | 10 | 0 | each record is one url resource | ||
| mdl_user | 59 | 54 | 2 | One record for each person | |
| mdl_user_devices | 11 | 0 | This table stores user's mobile devices information in order to send PUSH notifications | ||
| mdl_user_enrolments | 9 | 0 | Users participating in courses (aka enrolled users) - everybody who is participating/visible in course, that means both teachers and students | ||
| mdl_user_info_category | 3 | 0 | Customisable fields categories | ||
| mdl_user_info_data | 5 | 0 | Data for the customisable user fields | ||
| mdl_user_info_field | 20 | 0 | Customisable user profile fields | ||
| mdl_user_lastaccess | 4 | 0 | To keep track of course page access times, used in online participants block, and participants list | ||
| mdl_user_password_history | 4 | 0 | A rotating log of hashes of previously used passwords for each user. | ||
| mdl_user_password_resets | 5 | 0 | table tracking password reset confirmation tokens | ||
| mdl_user_preferences | 4 | 0 | Allows modules to store arbitrary user preferences | ||
| mdl_user_private_key | 8 | 0 | access keys used in cookieless scripts - rss, etc. | ||
| mdl_webdav_locks | 10 | 0 | Resource locks for WebDAV users | ||
| mdl_wiki | 13 | 0 | Stores Wiki activity configuration | ||
| mdl_wiki_links | 5 | 0 | Page wiki links | ||
| mdl_wiki_locks | 5 | 0 | Manages page locks | ||
| mdl_wiki_pages | 10 | 0 | Stores wiki pages | ||
| mdl_wiki_subwikis | 4 | 0 | Stores subwiki instances | ||
| mdl_wiki_synonyms | 4 | 0 | Stores wiki pages synonyms | ||
| mdl_wiki_versions | 7 | 0 | Stores wiki page history | ||
| mdl_workshop | 33 | 0 | This table keeps information about the module instances and their settings | ||
| mdl_workshop_aggregations | 5 | 0 | Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions | ||
| mdl_workshop_assessments | 15 | 0 | Info about the made assessment and automatically calculated grade for it. The proposed grade can be overridden by teacher. | ||
| mdl_workshop_assessments_old | 17 | 0 | Legacy workshop_assessments table to be dropped later in Moodle 2.x | ||
| mdl_workshop_comments_old | 9 | 0 | Legacy workshop_comments table to be dropped later in Moodle 2.x | ||
| mdl_workshop_elements_old | 11 | 0 | Legacy workshop_elements table to be dropped later in Moodle 2.x | ||
| mdl_workshop_grades | 7 | 0 | How the reviewers filled-up the grading forms, given grades and comments | ||
| mdl_workshop_grades_old | 8 | 0 | Legacy workshop_grades table to be dropped later in Moodle 2.x | ||
| mdl_workshop_old | 34 | 0 | Legacy workshop table to be dropped later in Moodle 2.x | ||
| mdl_workshop_rubrics_old | 7 | 0 | Legacy workshop_rubrics table to be dropped later in Moodle 2.x | ||
| mdl_workshop_stockcomments_old | 6 | 0 | Legacy workshop_stockcomments table to be dropped later in Moodle 2.x | ||
| mdl_workshop_submissions | 19 | 0 | 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 | ||
| mdl_workshop_submissions_old | 13 | 0 | Legacy workshop_submissions table to be dropped later in Moodle 2.x | ||
| mdl_workshopallocation_scheduled | 9 | 0 | Stores the allocation settings for the scheduled allocator | ||
| mdl_workshopeval_best_settings | 3 | 0 | Settings for the grading evaluation subplugin Comparison with the best assessment. | ||
| mdl_workshopform_accumulative | 7 | 0 | The assessment dimensions definitions of Accumulative grading strategy forms | ||
| mdl_workshopform_comments | 5 | 0 | The assessment dimensions definitions of Comments strategy forms | ||
| mdl_workshopform_numerrors | 9 | 0 | The assessment dimensions definitions of Number of errors grading strategy forms | ||
| mdl_workshopform_numerrors_map | 4 | 0 | This maps the number of errors to a percentual grade for submission | ||
| mdl_workshopform_rubric | 5 | 0 | The assessment dimensions definitions of Rubric grading strategy forms | ||
| mdl_workshopform_rubric_config | 3 | 0 | Configuration table for the Rubric grading strategy | ||
| mdl_workshopform_rubric_levels | 5 | 0 | The definition of rubric rating scales | ||
| 551 Tables | 4,731 | 6,283 | |||
| 0 Views | 0 |