SchemaSpy Analysis of totara.publicForeign Key information for Totara tables Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jan 15 19:50 EST 2018
Database Type: PostgreSQL - 9.2.23 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 2 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 4 8 0 Actual user who is subject of appraisal
mdl_appraisal_user_event 2 4 0 Appraisal events scheduled to specific users
mdl_assign 10 1 28 0 This table saves information about an instance of mod_assign in a course.
mdl_assign_grades 4 1 8 0 Grading information about a single assignment submission.
mdl_assign_overrides 3 8 0 The overrides to assign settings.
mdl_assign_plugin_config 1 6 0 Config data for an instance of a plugin in an assignment.
mdl_assign_submission 2 1 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 2 8 0 List of flags that can be set for a single user in a single assignment.
mdl_assign_user_mapping 2 3 0 Map an assignment specific id number to a user
mdl_assignfeedback_comments 2 5 0 Text feedback for submitted assignments
mdl_assignfeedback_editpdf_annot 1 11 0 stores annotations added to pdfs submitted by students
mdl_assignfeedback_editpdf_cmnt 1 9 0 Stores comments added to pdfs
mdl_assignfeedback_editpdf_queue 3 0 Queue for processing.
mdl_assignfeedback_editpdf_quick 1 5 0 Stores teacher specified quicklist comments
mdl_assignfeedback_file 2 4 0 Stores info about the number of files submitted by a student.
mdl_assignment 1 1 19 0 Defines assignments
mdl_assignment_submissions 1 14 0 Info about submitted assignments
mdl_assignment_upgrade 6 0 Info about upgraded assignments
mdl_assignsubmission_file 2 4 0 Info about file submissions for assignments
mdl_assignsubmission_onlinetext 2 5 0 Info about onlinetext submission
mdl_auth_approved_request 1 5 28 0 Self registration with approval details
mdl_auth_approved_request_snapshots 2 31 0 History of auth_approved_request records
mdl_auth_connect_ids 1 6 0 General server to client database id mappings
mdl_auth_connect_servers 5 12 0 List of servers
mdl_auth_connect_sso_requests 1 5 0 List of SSO requests from Totara Connect client to server
mdl_auth_connect_sso_sessions 2 7 0 List of SSO sessions on Client system, columns are not normalised to allow strict validation
mdl_auth_connect_user_collections 2 6 0 List of cohorts synced from server
mdl_auth_connect_users 2 5 0 List of users from each Totara Connect server
mdl_backup_controllers 1 1 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 1 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 59 contains all installed blocks
mdl_block_community 6 0 Community block
mdl_block_instances 2 1 10 27 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 2 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 9 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_featured_links_tiles 2 17 0 Defines tiles for Totara featured links blocks
mdl_block_totara_stats 6 0 Holds stats information
mdl_blog_association 2 3 0 Associations of blog entries with courses and module instances
mdl_blog_external 1 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 1 Cache of time-sensitive flags
mdl_capabilities 1 6 792 this defines all capabilities
mdl_certif 3 7 0 Certifications
mdl_certif_completion 2 10 0 Certifications completed
mdl_certif_completion_history 2 11 0 Previous completed certifications
mdl_certificate 1 29 0 Defines certificates
mdl_certificate_issues 5 0 Info about issued certificates
mdl_certificate_issues_history 2 10 0 Archived user certificates for Totara
mdl_chat 3 1 10 0 Each of these is a chat room
mdl_chat_messages 1 7 0 Stores all the actual chat messages
mdl_chat_messages_current 1 7 0 Stores current session
mdl_chat_users 1 12 0 Keeps track of which users are in which chat rooms
mdl_choice 2 1 18 0 Available choices are stored here
mdl_choice_answers 2 5 0 choices performed by users
mdl_choice_options 1 1 5 0 available options to choice
mdl_cohort 18 1 21 0 Each record represents one cohort (aka site-wide group).
mdl_cohort_members 2 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_config 1 8 0 A table to store the config for plans to be created for cohorts.
mdl_cohort_plan_history 3 10 0 A table to store the history of plans created for cohorts.
mdl_cohort_role 3 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 10 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 14 0 Track current proficiency of a user in each competency
mdl_comp_record_history 3 7 0 Store changes to proficiency in comp_record.
mdl_comp_relations 4 0 Tracks relationships between competencies
mdl_comp_scale 2 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 3 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 1 2 4 0 Stores custom field data related to competencies
mdl_comp_type_info_data_param 1 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_competency 3 17 0 This table contains the master record of each competency in a framework
mdl_competency_coursecomp 2 8 0 Link a competency to a course.
mdl_competency_coursecompsetting 1 6 0 This table contains the course specific settings for competencies.
mdl_competency_evidence 14 0 The evidence linked to a user competency
mdl_competency_framework 13 0 List of competency frameworks.
mdl_competency_modulecomp 2 8 0 Link a competency to a module.
mdl_competency_plan 13 0 Learning plans
mdl_competency_plancomp 7 0 Plan competencies
mdl_competency_relatedcomp 6 0 Related competencies
mdl_competency_template 1 10 0 Learning plan templates.
mdl_competency_templatecohort 6 0 Default comment for the table, please edit me
mdl_competency_templatecomp 2 7 0 Link a competency to a learning plan template.
mdl_competency_usercomp 10 0 User competencies
mdl_competency_usercompcourse 9 0 User competencies in a course
mdl_competency_usercompplan 10 0 User competencies plans
mdl_competency_userevidence 9 0 The evidence of prior learning
mdl_competency_userevidencecomp 6 0 Relationship between user evidence and competencies
mdl_config 3 528 Moodle configuration variables
mdl_config_log 1 7 1,154 Changes done in server configuration through admin UI
mdl_config_plugins 4 1,424 Moodle modules and plugins configuration variables
mdl_context 18 5 32 one of these must be set
mdl_context_temp 3 0 Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.
mdl_course 59 36 1 Central course table
mdl_course_categories 3 1 16 1 Course categories
mdl_course_completion_aggr_methd 1 5 0 Course completion aggregation methods for criteria
mdl_course_completion_crit_compl 1 8 0 Course completion user records
mdl_course_completion_criteria 1 10 0 Course completion criteria
mdl_course_completion_history 2 5 0 Course completion history archive
mdl_course_completion_log 3 6 0 Record of changes made to course completion records
mdl_course_completions 1 1 14 0 Course completion records
mdl_course_format_options 1 6 1 Stores format-specific options for the course or course section
mdl_course_info_data 1 4 0 Custom course fields data
mdl_course_info_data_param 1 3 0 Custom course fields data parameters
mdl_course_info_field 1 16 0 Custom course fields
mdl_course_modules 1 2 20 0 course_modules table retrofitted from MySQL
mdl_course_modules_completion 8 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 2 1 36 0 all database activities
mdl_data_content 2 8 0 the content introduced in each record/fields
mdl_data_fields 1 1 16 0 every field available
mdl_data_records 1 1 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 2 3 8 0 Contains user evidence in the record of learning
mdl_dp_plan_evidence_info_data 1 2 4 0 Stores custom field data related to evidence
mdl_dp_plan_evidence_info_data_param 1 3 0 Custom evidence fields data parameters
mdl_dp_plan_evidence_info_field 1 16 3 Stores the custom fields used in evidence
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 13 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 2 1 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 3 8 0 enrol_flatfile table retrofitted from MySQL
mdl_enrol_lti_lti2_consumer 5 19 0 LTI consumers interacting with moodle
mdl_enrol_lti_lti2_context 1 1 7 0 Information about a specific LTI contexts from the consumers
mdl_enrol_lti_lti2_nonce 1 4 0 Nonce used for authentication between moodle and a consumer
mdl_enrol_lti_lti2_resource_link 3 3 9 0 Link from the consumer to the tool
mdl_enrol_lti_lti2_share_key 1 5 0 Resource link share key
mdl_enrol_lti_lti2_tool_proxy 1 6 0 A tool proxy between moodle and a consumer
mdl_enrol_lti_lti2_user_result 1 6 0 Results for each user for each resource link
mdl_enrol_lti_tool_consumer_map 2 3 0 Table that maps the published tool to tool consumers.
mdl_enrol_lti_tools 2 2 19 0 List of tools provided to the remote system
mdl_enrol_lti_users 2 12 0 User access log and gradeback data
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 1 8 0 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 1 1 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 2 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 8 276 list of all external functions
mdl_external_services 3 11 0 built in and custom external services
mdl_external_services_functions 1 3 0 lists functions available in each service group
mdl_external_services_users 2 6 0 users allowed to use services with restricted users flag
mdl_external_tokens 4 12 0 Security tokens for accessing of external services
mdl_facetoface 3 1 29 0 Each seminar activity has an entry here
mdl_facetoface_asset 2 2 10 0 Table for storing seminar assets data
mdl_facetoface_asset_dates 2 3 0 Assets to session dates many-to-many relationship
mdl_facetoface_asset_info_data 1 2 4 0 Stores custom field data related to assets
mdl_facetoface_asset_info_data_param 1 3 0 Asset custom fields data parameters
mdl_facetoface_asset_info_field 1 16 0 Stores the definition of available asset custom fields
mdl_facetoface_cancellation_info_data 1 2 4 0 Stores custom field data related to user signup cancellation
mdl_facetoface_cancellation_info_data_param 1 3 0 Custom user signup cancellation fields data parameters
mdl_facetoface_cancellation_info_field 1 16 1 Stores the definitions for user signup cancellation custom fields
mdl_facetoface_interest 1 5 0 Users who have declared interest in a seminar activity
mdl_facetoface_notification 2 3 21 0 Seminar notifications
mdl_facetoface_notification_hist 4 8 0 Notifications history (stores ical event information)
mdl_facetoface_notification_sent 3 4 0 Seminar notification reciepts
mdl_facetoface_notification_tpl 7 17 Seminar notification templates
mdl_facetoface_room 2 2 11 0 Table for storing seminar room data
mdl_facetoface_room_info_data 1 2 4 0 Stores custom field data related to rooms
mdl_facetoface_room_info_data_param 1 3 0 Custom room fields data parameters
mdl_facetoface_room_info_field 1 16 2 Stores the definition of available room custom fields
mdl_facetoface_session_info_data 1 2 4 0 Stores custom field data related to event, these fields describe event details
mdl_facetoface_session_info_data_param 1 3 0 Custom event fields data parameters
mdl_facetoface_session_info_field 1 17 0 Stores the definitions for event custom fields
mdl_facetoface_session_roles 2 4 0 Users with a trainer-like role in a seminar event
mdl_facetoface_sessioncancel_info_data 1 2 4 0 Stores custom field data related to cancellation of the whole event
mdl_facetoface_sessioncancel_info_data_param 1 3 0 Whole event cancellation custom fields data parameters
mdl_facetoface_sessioncancel_info_field 1 16 0 Stores the definitions for whole event cancellation custom fields
mdl_facetoface_sessions 7 2 20 0 Describes seminar events
mdl_facetoface_sessions_dates 2 2 6 0 Describes sessions of event. Specifies the start time, end time and optionally room and assets. Sessions can be set over multiple days or blocks of time.
mdl_facetoface_signup_info_data 1 2 4 0 Stores custom field data related to user signups for events, this data is attached to signup table, not status
mdl_facetoface_signup_info_data_param 1 3 0 Custom event signup fields data parameters
mdl_facetoface_signup_info_field 1 16 1 Stores the definitions of user signup custom fields
mdl_facetoface_signups 3 4 9 0 User signups for events
mdl_facetoface_signups_status 2 7 0 Status of user signups, this table keeps the history for each user signup, no data is deleted
mdl_feedback 5 1 17 0 all feedbacks
mdl_feedback360 5 1 8 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 8 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 1 7 0 filled out feedback
mdl_feedback_completed_history 1 2 8 0 history of filled out feedback
mdl_feedback_completedtmp 1 8 0 filled out feedback
mdl_feedback_item 3 2 13 0 feedback_items
mdl_feedback_sitecourse_map 1 3 0 feedback sitecourse map
mdl_feedback_template 1 1 4 0 templates of feedbackstructures
mdl_feedback_value 1 6 0 values of the completeds
mdl_feedback_value_history 2 8 0 History of values of the completeds
mdl_feedback_valuetmp 1 6 0 values of the completedstmp
mdl_files 3 20 5 description of files, content is stored in sha1 file pool
mdl_files_reference 1 1 5 0 Store files references
mdl_filter_active 1 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 1 5 0 Stores per-context configuration settings for filters which have them.
mdl_folder 1 10 0 each record is one folder resource
mdl_forum 4 1 25 0 Forums contain and structure discussion
mdl_forum_digests 2 4 0 Keeps track of user mail delivery preferences for each forum
mdl_forum_discussion_subs 3 5 0 Users may choose to subscribe and unsubscribe from specific discussions.
mdl_forum_discussions 3 2 14 0 Forums are composed of discussions
mdl_forum_posts 2 2 15 0 All posts are stored in this table
mdl_forum_queue 2 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 1 3 0 Keeps track of who is subscribed to what forum
mdl_forum_track_prefs 3 0 Tracks each users untracked forums
mdl_gap_aspirational 2 6 0 Aspirational positions
mdl_glossary 2 1 28 0 all glossaries
mdl_glossary_alias 1 3 0 entries alias
mdl_glossary_categories 1 1 4 0 all categories for glossary entries
mdl_glossary_entries 2 1 16 0 all glossary entries
mdl_glossary_entries_categories 2 3 0 categories of each glossary entry
mdl_glossary_formats 10 7 Setting of the display formats
mdl_goal 8 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 1 4 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 8 0 Goal types are used to manage custom fields
mdl_goal_type_info_data 1 2 4 0 Stores custom field data related to goals
mdl_goal_type_info_data_param 1 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 1 2 4 0 Stores personal custom field data related to goals
mdl_goal_user_info_data_param 1 3 0 Custom organisations fields data parameters
mdl_goal_user_info_field 1 1 17 0 Stores the personal custom fields for each goal type
mdl_goal_user_type 2 9 0 Table to store goal types for personal goals.
mdl_goal_user_type_cohort 2 5 0 Contains audiences allowed to select specific personal goal types.
mdl_grade_categories 5 2 14 0 This table keeps information about categories, used for grouping items.
mdl_grade_categories_history 4 18 0 History of grade_categories
mdl_grade_grades 1 4 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 6 24 0 History table
mdl_grade_import_newitem 1 1 4 0 temporary table for storing new grade_item names from grade import
mdl_grade_import_values 3 9 0 Temporary table for importing grades
mdl_grade_items 4 4 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 6 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 4 3 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 2 3 0 stores what outcomes are used in what courses.
mdl_grade_outcomes_history 4 12 0 History table
mdl_grade_settings 1 4 0 gradebook settings
mdl_grading_areas 1 1 5 0 Identifies gradable areas where advanced grading can happen. For each area, the current active plugin can be set.
mdl_grading_definitions 4 3 14 0 Contains the basic information about an advanced grading form defined in the given gradable area
mdl_grading_instances 2 2 9 0 Grading form instance is an assessment record for one gradable item assessed by one rater
mdl_gradingform_guide_comments 1 5 0 frequently used comments used in marking guide
mdl_gradingform_guide_criteria 1 1 9 0 Stores the rows of the criteria grid.
mdl_gradingform_guide_fillings 2 6 0 Stores the data of how the guide is filled by a particular rater
mdl_gradingform_rubric_criteria 2 1 5 0 Stores the rows of the rubric grid.
mdl_gradingform_rubric_fillings 2 6 0 Stores the data of how the rubric is filled by a particular rater
mdl_gradingform_rubric_levels 1 5 0 Stores the columns of the rubric grid.
mdl_groupings 2 1 9 0 A grouping is a collection of groups. WAS: groups_groupings
mdl_groupings_groups 2 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 5 1 11 0 Each record represents a group.
mdl_groups_members 2 6 0 Link a user to a group.
mdl_imscp 1 9 0 each record is one imscp resource
mdl_job_assignment 5 7 22 0 Assignment of a job to a user
mdl_label 1 6 0 Defines labels
mdl_lesson 7 1 41 0 Defines lesson
mdl_lesson_answers 1 2 13 0 Defines lesson_answers
mdl_lesson_attempts 3 9 0 Defines lesson_attempts
mdl_lesson_branch 2 8 0 branches for each lesson/user
mdl_lesson_grades 1 6 0 Defines lesson_grades
mdl_lesson_overrides 3 11 0 The overrides to lesson settings.
mdl_lesson_pages 3 1 13 0 Defines lesson_pages
mdl_lesson_timer 1 6 0 lesson timer for each lesson
mdl_license 6 9 store licenses used by moodle
mdl_lock_db 4 1 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 207 For a particular module/action, specifies a moodle table/field
mdl_log_queries 9 0 Logged database queries.
mdl_logstore_standard_log 1 21 4 Standard log table
mdl_lti 1 1 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 1 13 0 LTI tool proxy registrations
mdl_lti_tool_settings 3 7 0 LTI tool setting values
mdl_lti_types 1 16 0 Basic LTI pre-configured activities
mdl_lti_types_config 4 0 Basic LTI types configuration
mdl_message 16 0 Stores all unread messages
mdl_message_airnotifier_devices 1 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_popup 3 0 Keep state of notifications for the popup message processor
mdl_message_processors 3 6 List of message output plugins
mdl_message_providers 4 34 This table stores the message providers (modules and core systems)
mdl_message_read 17 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 1 6 0 Inbound Message data item secret keys.
mdl_messageinbound_handlers 1 6 3 Inbound Message Handler definitions.
mdl_messageinbound_messagelist 1 5 0 A list of message IDs for existing replies
mdl_mnet_application 1 6 2 Information about applications on remote hosts
mdl_mnet_host 1 1 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 2 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 13 3 16 0 Totara organisations
mdl_org_competencies 2 7 0 Track competencies assigned to a particular organisation
mdl_org_framework 2 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 1 2 4 0 Stores custom field data related to organisations
mdl_org_type_info_data_param 1 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 1 13 0 Each record is one page and its config data
mdl_portfolio_instance 4 4 0 base table (not including config data) for instances of portfolio plugins.
mdl_portfolio_instance_config 1 4 0 config for portfolio plugin instances
mdl_portfolio_instance_user 2 5 0 user data for portfolio instances.
mdl_portfolio_log 2 11 0 log of portfolio transfers (used to later check for duplicates)
mdl_portfolio_mahara_queue 1 3 0 maps mahara tokens to transfer ids
mdl_portfolio_tempdata 1 2 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_competencies 2 7 0 Tracks competencies assigned to a particular position
mdl_pos_framework 2 11 0 A collection of positions
mdl_pos_relations 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 1 2 4 0 Stores custom field data related to positions
mdl_pos_type_info_data_param 1 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 1 1 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 11 2 21 0 Stores elemental details about programs
mdl_prog_assignment 1 8 0 Stores details of the assignments defined within a program
mdl_prog_completion 3 11 0 Stores details of user's program and course set completions
mdl_prog_completion_history 4 11 0 Stores details of user's program and course set completions history
mdl_prog_completion_log 3 6 0 Record of changes made to program completion records
mdl_prog_courseset 4 2 15 0 Stores details of the sets of courses and competencies contained within a program
mdl_prog_courseset_course 2 3 0 Stores the details of the individual courses contained in a course set
mdl_prog_exception 2 6 0 Stores details of any exceptions raised relating to a program
mdl_prog_extension 2 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 1 2 4 0 Stores custom field data related to programs
mdl_prog_info_data_param 1 3 0 Custom programs fields data parameters
mdl_prog_info_field 1 16 0 Stores the custom fields for each program type
mdl_prog_message 1 1 10 0 Stores details of the messages defined within a program
mdl_prog_messagelog 3 5 0 Stores details of program-related messages that have been issued to a user
mdl_prog_recurrence 3 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_ddimageortext 1 10 0 Defines drag and drop (text or images onto a background image) questions
mdl_qtype_ddimageortext_drags 1 6 0 Images to drag. Actual file names are not stored here we use the file names as found in the file storage area.
mdl_qtype_ddimageortext_drops 1 7 0 Drop boxes
mdl_qtype_ddmarker 1 11 0 Defines drag and drop (text or images onto a background image) questions
mdl_qtype_ddmarker_drags 1 6 0 Labels for markers to drag.
mdl_qtype_ddmarker_drops 1 6 0 drop regions
mdl_qtype_essay_options 1 11 0 Extra options for essay questions.
mdl_qtype_match_options 1 10 0 Defines the question-type specific options for matching questions
mdl_qtype_match_subquestions 1 5 0 The subquestions that make up a matching question
mdl_qtype_multichoice_options 1 13 0 Options for multiple choice questions
mdl_qtype_randomsamatch_options 1 11 0 Info about a random short-answer matching question
mdl_qtype_shortanswer_options 1 3 0 Options for short answer questions
mdl_question 27 4 19 0 The questions themselves
mdl_question_answers 1 7 0 Answers, with a fractional grade (0-1) and feedback
mdl_question_attempt_step_data 1 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 1 2 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 1 2 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 1 7 0 Options for questions of type calculated
mdl_question_calculated_options 1 13 0 Options for questions of type calculated
mdl_question_categories 3 1 8 0 Categories are for grouping questions
mdl_question_dataset_definitions 1 1 6 0 Organises and stores properties for dataset items
mdl_question_dataset_items 4 0 Individual dataset items
mdl_question_datasets 2 3 0 Many-many relation between questions and dataset definitions
mdl_question_ddwtos 1 10 0 Defines drag and drop (words into sentences) questions
mdl_question_gapselect 1 10 0 Defines select missing words questions
mdl_question_hints 1 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 1 3 0 Options for multianswer questions
mdl_question_numerical 1 4 0 Options for numerical questions.
mdl_question_numerical_options 1 6 0 Options for questions of type numerical This table is also used by the calculated question type
mdl_question_numerical_units 1 4 0 Optional unit options for numerical questions. This table is also used by the calculated question type.
mdl_question_response_analysis 1 10 0 Analysis of student responses given to questions.
mdl_question_response_count 1 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 1 4 0 Options for True-False questions
mdl_question_usages 2 1 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 6 1 41 0 The settings for each quiz.
mdl_quiz_attempts 3 15 0 Stores users attempts at quizzes.
mdl_quiz_feedback 1 6 0 Feedback given to students based on which grade band their overall score lies.
mdl_quiz_grades 1 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 3 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 1 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 2 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 2 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 8 19 58 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 289 Defines columns belonging to each report
mdl_report_builder_filters 1 9 125 Defines filters belonging to each report
mdl_report_builder_global_restriction 8 9 0 Global Report Restrictions
mdl_report_builder_graph 1 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 3 9 0 Storing details of scheduled reports
mdl_report_builder_schedule_email_audience 2 3 0 Storing audience to email in scheduled reports
mdl_report_builder_schedule_email_external 1 3 0 Storing external emails to send in scheduled reports
mdl_report_builder_schedule_email_systemuser 2 3 0 Storing system users to email in scheduled reports
mdl_report_builder_search_cols 1 4 8 Defines search columns belonging to each report
mdl_report_builder_settings 1 5 12 Contains settings for individual reports
mdl_reportbuilder_grp_cohort_record 2 4 0 Cohorts that restricted users can see
mdl_reportbuilder_grp_cohort_user 2 4 0 Restricted cohorts that will see only allowed records
mdl_reportbuilder_grp_org_record 2 5 0 Organisations that restricted users can see
mdl_reportbuilder_grp_org_user 2 5 0 Restricted organisations that will see only allowed records
mdl_reportbuilder_grp_pos_record 2 5 0 Positions that restricted users can see
mdl_reportbuilder_grp_pos_user 2 5 0 Restricted positions that will see only allowed records
mdl_reportbuilder_grp_user_record 2 4 0 Individual users that restricted users can see
mdl_reportbuilder_grp_user_user 2 4 0 Restricted individual users that will see only allowed records
mdl_repository 4 6 This table contains one entry for every configured external repository instance.
mdl_repository_instance_config 4 0 The config for intances
mdl_repository_instances 1 10 6 This table contains one entry for every configured external repository instance.
mdl_repository_opensesame_bdls 1 3 0 Totara OpenSesame course bundles
mdl_repository_opensesame_bps 2 3 0 Link an OpenSesame course to a bundle
mdl_repository_opensesame_pkgs 1 11 0 Totara OpenSesame course packages
mdl_resource 1 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 14 6 9 moodle roles
mdl_role_allow_assign 2 3 8 this defines what role can assign what role
mdl_role_allow_override 2 3 12 this defines what role can override what role
mdl_role_allow_switch 2 3 10 This table stores which which other roles a user is allowed to switch to if they have one role.
mdl_role_assignments 3 9 0 assigning roles in different context
mdl_role_capabilities 4 7 1,564 permission has to be signed, overriding a capability for a particular role in a particular context
mdl_role_context_levels 1 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 2 4 0 role names in native strings
mdl_role_sortorder 3 5 0 sort order of course managers in a course
mdl_scale 7 8 2 Defines grading scales
mdl_scale_history 3 11 0 History table
mdl_scorm 3 1 42 0 each table is one SCORM module and its configuration
mdl_scorm_aicc_session 2 12 0 Used by AICC HACP to store session information
mdl_scorm_scoes 8 1 10 0 each SCO part of the SCORM module
mdl_scorm_scoes_data 1 4 0 Contains variable data get from packages
mdl_scorm_scoes_track 2 8 0 to track SCOes
mdl_scorm_seq_mapinfo 2 8 0 SCORM2004 objective mapinfo description
mdl_scorm_seq_objective 1 1 6 0 SCORM2004 objective description
mdl_scorm_seq_rolluprule 1 1 7 0 SCORM2004 sequencing rule
mdl_scorm_seq_rolluprulecond 2 5 0 SCORM2004 sequencing rule
mdl_scorm_seq_rulecond 2 7 0 SCORM2004 rule condition
mdl_scorm_seq_ruleconds 1 1 5 0 SCORM2004 rule conditions
mdl_sessions 1 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 2 1 11 5 Each record is one SURVEY module with its configuration
mdl_survey_analysis 1 4 0 text about each survey submission
mdl_survey_answers 2 7 0 the answers to each questions filled by the users
mdl_survey_questions 1 7 73 the questions conforming one survey
mdl_tag 2 2 10 0 Tag table - this generic table will replace the old "tags" table.
mdl_tag_area 1 8 8 Defines various tag areas, one area is identified by component and itemtype
mdl_tag_coll 2 7 1 Defines different set of tags
mdl_tag_correlation 1 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 2 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 93 List of scheduled tasks to be run by cron.
mdl_tool_customlang 1 11 0 Contains the working checkout of all strings and their customization
mdl_tool_customlang_components 1 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 1 4 0 Table to store history of message notifications sent
mdl_tool_monitor_rules 1 14 0 Table to store rules
mdl_tool_monitor_subscriptions 1 1 8 0 Table to store user subscriptions to various rules
mdl_tool_recyclebin_category 1 5 0 A list of items in the category recycle bin
mdl_tool_recyclebin_course 1 6 0 A list of items in the course recycle bin
mdl_tool_usertours_steps 1 8 0 Steps in an tour
mdl_tool_usertours_tours 1 7 0 List of tours
mdl_totara_compl_import_cert 16 0 Intermediary file for importing certification completion data
mdl_totara_compl_import_course 16 0 Intermediary file for importing course completion data
mdl_totara_connect_client_cohorts 2 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 2 4 0 List of courses synced to a client, the enrolled users are restricted by totara_connect_clients.cohortid if specified
mdl_totara_connect_client_org_frameworks 2 4 0 List of organisation frameworks synced to a client
mdl_totara_connect_client_pos_frameworks 2 4 0 List of position frameworks synced to a client
mdl_totara_connect_clients 5 1 18 0 List of client systems registered with this server
mdl_totara_connect_sso_sessions 2 7 0 List of all SSO sessions on client systems connect to this server
mdl_totara_dashboard 2 5 1 Dashboards
mdl_totara_dashboard_cohort 2 3 0 Users modifications of pages
mdl_totara_dashboard_user 2 3 0 User modified instances of dashboards
mdl_totara_navigation 1 14 19 Totara navigation menu
mdl_totara_navigation_settings 1 6 0 Settings for navigation menu items
mdl_totara_sync_log 7 0 log table for totara element syncing
mdl_upgrade_log 1 10 1,304 Upgrade logging
mdl_url 1 10 0 each record is one url resource
mdl_user 149 54 2 One record for each person
mdl_user_devices 1 1 11 0 This table stores user's mobile devices information in order to send PUSH notifications
mdl_user_enrolments 3 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 1 4 0 A rotating log of hashes of previously used passwords for each user.
mdl_user_password_resets 1 5 0 table tracking password reset confirmation tokens
mdl_user_preferences 4 4 Allows modules to store arbitrary user preferences
mdl_user_private_key 1 8 0 access keys used in cookieless scripts - rss, etc.
mdl_wiki 1 1 13 0 Stores Wiki activity configuration
mdl_wiki_links 2 5 0 Page wiki links
mdl_wiki_locks 5 0 Manages page locks
mdl_wiki_pages 2 1 10 0 Stores wiki pages
mdl_wiki_subwikis 2 1 4 0 Stores subwiki instances
mdl_wiki_synonyms 4 0 Stores wiki pages synonyms
mdl_wiki_versions 1 7 0 Stores wiki page history
mdl_workshop 16 1 35 0 This table keeps information about the module instances and their settings
mdl_workshop_aggregations 2 5 0 Aggregated grades for assessment are stored here. The aggregated grade for submission is stored in workshop_submissions
mdl_workshop_assessments 3 3 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 2 17 0 Legacy workshop_assessments table to be dropped later in Moodle 2.x
mdl_workshop_comments_old 2 9 0 Legacy workshop_comments table to be dropped later in Moodle 2.x
mdl_workshop_elements_old 1 11 0 Legacy workshop_elements table to be dropped later in Moodle 2.x
mdl_workshop_grades 1 7 0 How the reviewers filled-up the grading forms, given grades and comments
mdl_workshop_grades_old 2 8 0 Legacy workshop_grades table to be dropped later in Moodle 2.x
mdl_workshop_old 1 34 0 Legacy workshop table to be dropped later in Moodle 2.x
mdl_workshop_rubrics_old 1 7 0 Legacy workshop_rubrics table to be dropped later in Moodle 2.x
mdl_workshop_stockcomments_old 1 6 0 Legacy workshop_stockcomments table to be dropped later in Moodle 2.x
mdl_workshop_submissions 2 3 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 1 13 0 Legacy workshop_submissions table to be dropped later in Moodle 2.x
mdl_workshopallocation_scheduled 1 9 0 Stores the allocation settings for the scheduled allocator
mdl_workshopeval_best_settings 1 3 0 Settings for the grading evaluation subplugin Comparison with the best assessment.
mdl_workshopform_accumulative 1 7 0 The assessment dimensions definitions of Accumulative grading strategy forms
mdl_workshopform_comments 1 5 0 The assessment dimensions definitions of Comments strategy forms
mdl_workshopform_numerrors 1 9 0 The assessment dimensions definitions of Number of errors grading strategy forms
mdl_workshopform_numerrors_map 1 4 0 This maps the number of errors to a percentual grade for submission
mdl_workshopform_rubric 1 1 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 1 5 0 The definition of rubric rating scales
           
611 Tables     5,326 8,478  
0 Views     0