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 SourceForge.net


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