SchemaSpy Analysis of jenkins-Totara-1.0-PostgreSQL.public Foreign Key information for moodle tables Generated by
SchemaSpy
Generated by SchemaSpy on Mon May 11 05:06 NZST 2015
Database Type: PostgreSQL - 8.4.22 SourceForge.net


XML Representation
Insertion Order Deletion Order (for database loading/purging scripts)

Table Children Parents Columns Rows Comments
tst_assignment 19 0 Defines assignments
tst_assignment_submissions 14 0 Info about submitted assignments
tst_backup_config 3 17 To store backup configuration variables
tst_backup_courses 6 0 To store every course backup status
tst_backup_files 6 0 To store and recode ids to user and course files
tst_backup_ids 6 0 To store and convert ids in backup/restore
tst_backup_log 5 0 To store every course backup log info
tst_block 7 44 to store installed blocks
tst_block_guides_guide 6 5 table to store guide records
tst_block_guides_guide_instance 5 0 table to store guide records
tst_block_instance 8 11 to store block instances in pages
tst_block_pinned 7 2 to pin blocks
tst_block_quicklinks 6 6 Holds information on the defined links of a block
tst_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
tst_block_search_documents 10 0 table to store search index backups
tst_block_totara_stats 6 0 Holds stats information
tst_book 9 0 Defines book
tst_book_chapters 10 0 Defines book_chapters
tst_cache_filters 6 0 For keeping information about cached data
tst_cache_flags 6 1 Cache of time-sensitive flags
tst_cache_text 4 1 For storing temporary copies of processed texts
tst_capabilities 6 325 this defines all capabilities
tst_certificate 28 0 Defines certificates
tst_certificate_issues 10 0 Info about issued certificates
tst_certificate_linked_modules 5 0 Defines certificate dependencies
tst_chat 9 0 Each of these is a chat room
tst_chat_messages 7 0 Stores all the actual chat messages
tst_chat_users 12 0 Keeps track of which users are in which chat rooms
tst_choice 14 0 Available choices are stored here
tst_choice_answers 5 0 choices performed by users
tst_choice_options 5 0 available options to choice
tst_comp 9 3 17 0
tst_comp_depth 3 1 9 1
tst_comp_depth_info_category 1 1 4 0
tst_comp_depth_info_data 2 4 0
tst_comp_depth_info_field 1 2 18 0
tst_comp_evidence 6 13 0
tst_comp_evidence_items 1 1 8 0
tst_comp_evidence_items_evidence 3 8 0
tst_comp_framework 4 13 1
tst_comp_relations 2 4 0
tst_comp_scale 2 1 6 1
tst_comp_scale_assignments 2 5 2
tst_comp_scale_values 3 1 10 3
tst_comp_template 1 1 10 0
tst_comp_template_assignment 2 6 0
tst_config 3 477 Moodle configuration variables
tst_config_plugins 4 15 Moodle modules and plugins configuration variables
tst_context 5 14 one of these must be set
tst_context_temp 3 0 Used by build_context_path() in upgrade and cron to keep context depths and paths in sync.
tst_course 7 49 1 Central course table
tst_course_allowed_modules 3 0 allowed modules foreach course
tst_course_categories 12 1 Course categories
tst_course_completion_aggr_methd 1 5 0 Course completion aggregation methods for criteria
tst_course_completion_crit_compl 3 9 0 Course completion user records
tst_course_completion_criteria 1 1 10 0 Course completion criteria
tst_course_completion_notify 1 5 0 Course completion notification emails
tst_course_completions 1 4 13 0 Course completion records
tst_course_display 4 0 Stores info about how to display the course
tst_course_info_category 3 0
tst_course_info_data 4 0
tst_course_info_field 17 0
tst_course_meta 3 0 to store meta-courses relations
tst_course_modules 21 0 course_modules table retrofitted from MySQL
tst_course_modules_availability 7 0 Table stores conditions that affect whether a module/activity is currently available to students or not.
tst_course_modules_completion 6 0 Stores the completion state (completed or not completed, etc) of each user on each activity.
tst_course_request 7 0 course requests
tst_course_sections 6 1 to define the sections for each course
tst_dashb 4 2 Defines a dashboard
tst_dashb_instance 5 2 Holds instances of a specific dashboard
tst_dashb_instance_dashlet 7 7 Contains all data relating to dashlets of a specific dashboard instance
tst_data 30 0 all database activities
tst_data_comments 7 0 to comment data records
tst_data_content 8 0 the content introduced in each record/fields
tst_data_fields 15 0 every field available
tst_data_ratings 4 0 to rate data records
tst_data_records 7 0 every record introduced
tst_dp_competency_settings 2 9 1 Contains settings specific to the competency component
tst_dp_component_settings 1 5 3 Stores the names and component-independent settings for each installed component.
tst_dp_course_settings 2 5 1 Contains settings specific to the course component
tst_dp_objective_scale 2 1 7 1 Contains objective scales for development plans
tst_dp_objective_scale_value 2 1 10 3 Objective Scale values for development plan priority scales
tst_dp_objective_settings 3 6 1 Settings for a template's objectives
tst_dp_permissions 1 6 42 Stores the permission settings for plan templates
tst_dp_plan 5 2 8 0 Stores individual plans belonging to users.
tst_dp_plan_competency_assign 4 7 0 Stores competencies assigned to a particular plan
tst_dp_plan_component_relation 5 0 Provides a way to link together items from different components within a plan
tst_dp_plan_course_assign 4 8 0 Stores courses assigned to a particular plan
tst_dp_plan_evidence 1 9 0 Contains user evidence associated with a plan
tst_dp_plan_history 1 5 0 A table for tracking and recording modifications to a related dp_plan
tst_dp_plan_objective 3 9 0 One row for each objective in a plan
tst_dp_priority_scale 4 1 7 1 Contains priority scales for development plans
tst_dp_priority_scale_value 4 1 9 3 Scale values for development plan priority scales
tst_dp_template 6 8 1 Templates store configuration options for a group of plans.
tst_enrol_authorize 12 0 Holds all known information about authorize.net transactions
tst_enrol_authorize_refunds 6 0 Authorize.net refunds
tst_enrol_paypal 20 0 Holds all known information about PayPal transactions
tst_event 17 0 For everything with a time associated to it
tst_events_handlers 7 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
tst_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.
tst_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
tst_exercise 17 0 Defines exercise
tst_exercise_assessments 11 0 Info about assessments by teacher and students
tst_exercise_elements 7 0 Info about marking scheme of assignment
tst_exercise_grades 6 0 Info about individual grades given to each element
tst_exercise_rubrics 5 0 Info about the rubrics marking scheme
tst_exercise_submissions 9 0 Info about submitted work from teacher and students
tst_facetoface 1 1 27 0 Each facetoface activity has an entry here
tst_facetoface_notice 3 0 Site-wide notices shown on the Training Calendar
tst_facetoface_notice_data 4 0 Custom field filters for site notices
tst_facetoface_session_data 2 4 0 Contents of custom info fields for Face-to-face session
tst_facetoface_session_field 1 9 3 Definitions of custom info fields for Face-to-face session
tst_facetoface_session_roles 3 4 0 Users with a trainer role in a facetoface session
tst_facetoface_sessions 4 1 11 0 A given facetoface activity may be given at different times and places
tst_facetoface_sessions_dates 1 4 0 The dates and times for each session. Sessions can be set over multiple days or blocks of time.
tst_facetoface_signups 1 2 6 0 User/session signups
tst_facetoface_signups_status 1 9 0 User/session signup status
tst_feedback 14 0 all feedbacks
tst_feedback_completed 6 0 filled out feedback
tst_feedback_completedtmp 7 0 filled out feedback
tst_feedback_item 9 0 feedback_items
tst_feedback_sitecourse_map 3 0 feedback sitecourse map
tst_feedback_template 4 0 templates of feedbackstructures
tst_feedback_tracking 6 0 feedback trackingdata
tst_feedback_value 6 0 values of the completeds
tst_feedback_valuetmp 6 0 values of the completedstmp
tst_forum 21 0 Forums contain and structure discussion
tst_forum_discussions 12 0 Forums are composed of discussions
tst_forum_posts 13 0 All posts are stored in this table
tst_forum_queue 5 0 For keeping track of posts that will be mailed in digest form
tst_forum_ratings 5 0 forum_ratings table retrofitted from MySQL
tst_forum_read 7 0 Tracks each users read posts
tst_forum_subscriptions 3 0 Keeps track of who is subscribed to what forum
tst_forum_track_prefs 3 0 Tracks each users untracked forums
tst_glossary 25 0 all glossaries
tst_glossary_alias 3 0 entries alias
tst_glossary_categories 4 0 all categories for glossary entries
tst_glossary_comments 6 0 comments on glossary entries
tst_glossary_entries 15 0 all glossary entries
tst_glossary_entries_categories 3 0 categories of each glossary entry
tst_glossary_formats 9 7 Setting of the display formats
tst_glossary_ratings 5 0 Contains user ratings for entries
tst_grade_categories 14 0 This table keeps information about categories, used for grouping items.
tst_grade_categories_history 17 0 History of grade_categories
tst_grade_grades 21 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
tst_grade_grades_history 24 0 History table
tst_grade_import_newitem 4 0 temporary table for storing new grade_item names from grade import
tst_grade_import_values 8 0 Temporary table for importing grades
tst_grade_items 29 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
tst_grade_items_history 30 0 History of grade_items
tst_grade_letters 4 0 Repository for grade letters, for courses and other moodle entities that use grades.
tst_grade_outcomes 9 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)
tst_grade_outcomes_courses 3 0 stores what outcomes are used in what courses.
tst_grade_outcomes_history 11 0 History table
tst_grade_settings 4 0 gradebook settings
tst_groupings 7 0 A grouping is a collection of groups. WAS: groups_groupings
tst_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
tst_groups 9 0 Each record represents a group.
tst_groups_members 4 0 Link a user to a group.
tst_hotpot 23 0 details about Hot Potatoes quizzes
tst_hotpot_attempts 12 0 details about Hot Potatoes quiz attempts
tst_hotpot_details 3 0 raw details (as XML) of Hot Potatoes quiz attempts
tst_hotpot_questions 6 0 details about questions in Hot Potatoes quiz attempts
tst_hotpot_responses 11 0 details about responses in Hot Potatoes quiz attempts
tst_hotpot_strings 3 0 strings used in Hot Potatoes questions and responses
tst_journal 8 0 data for each journal
tst_journal_entries 11 0 All the journal entries of all people
tst_label 5 0 Defines labels
tst_lams 6 0 LAMS activity
tst_lesson 40 0 Defines lesson
tst_lesson_answers 11 0 Defines lesson_answers
tst_lesson_attempts 9 0 Defines lesson_attempts
tst_lesson_branch 7 0 branches for each lesson/user
tst_lesson_default 33 0 Defines lesson_default
tst_lesson_grades 6 0 Defines lesson_grades
tst_lesson_high_scores 5 0 high scores for each lesson
tst_lesson_pages 12 0 Defines lesson_pages
tst_lesson_timer 5 0 lesson timer for each lesson
tst_log 10 242 Every action is logged as far as possible
tst_log_display 5 145 For a particular module/action, specifies a moodle table/field
tst_message 7 0 Stores all unread messages
tst_message20 12 0 Stores all unread messages
tst_message_contacts 4 0 Maintains lists of relationships between users
tst_message_metadata 11 0 type, status, and workflow additions to messages
tst_message_processors20 2 2 List of message output plugins
tst_message_providers20 4 2 This table stores the message providers (modules and core systems)
tst_message_read 9 0 Stores all messages that have been read
tst_message_read20 13 0 Stores all messages that have been read
tst_message_working20 3 0 Lists all the messages and processors that need to be processed
tst_mnet_application 5 2 Information about applications on remote hosts
tst_mnet_enrol_assignments 7 0 Information about enrolments on courses on remote hosts
tst_mnet_enrol_course 16 0 Information about courses on remote hosts
tst_mnet_host 14 2 Information about the local and remote hosts for RPC
tst_mnet_host2service 5 0 Information about the services for a given host
tst_mnet_log 13 0 Store session data from users migrating to other sites
tst_mnet_rpc 8 14 Functions or methods that we may publish or subscribe to
tst_mnet_service 5 3 A service is a group of functions
tst_mnet_service2rpc 3 14 Group functions or methods under a service
tst_mnet_session 9 0 Store session data from users migrating to other sites
tst_mnet_sso_access_control 4 0 Users by host permitted (or not) to login from a remote provider
tst_modules 7 22 modules available in the site
tst_oauth_access_token 4 0 Access tokens per user per site
tst_oauth_site_directory 8 0 Sites registered as OAuth providers
tst_oldpassword 3 0
tst_org 7 3 14 2
tst_org_competencies 6 0
tst_org_depth 3 1 9 2
tst_org_depth_info_category 1 1 4 3
tst_org_depth_info_data 2 4 0
tst_org_depth_info_field 1 2 18 0
tst_org_framework 2 13 3
tst_org_relations 2 4 0
tst_pos 7 3 16 0
tst_pos_assignment 4 15 0
tst_pos_assignment_history 14 0
tst_pos_competencies 6 0
tst_pos_depth 3 1 9 2
tst_pos_depth_info_category 1 1 4 2
tst_pos_depth_info_data 2 4 0
tst_pos_depth_info_field 1 2 18 0
tst_pos_framework 2 13 1
tst_pos_relations 2 4 0
tst_post 18 0 Generic post table to hold data blog entries etc in different modules
tst_question 19 0 The questions themselves
tst_question_answers 5 0 Answers, with a fractional grade (0-1) and feedback
tst_question_attempts 2 0 Student attempts. This table gets extended by the modules
tst_question_calculated 7 0 Options for questions of type calculated
tst_question_categories 7 0 Categories are for grouping questions
tst_question_dataset_definitions 6 0 Organises and stores properties for dataset items
tst_question_dataset_items 4 0 Individual dataset items
tst_question_datasets 3 0 Many-many relation between questions and dataset definitions
tst_question_match 4 0 Defines fixed matching questions
tst_question_match_sub 5 0 Defines the subquestions that make up a matching question
tst_question_multianswer 3 0 Options for multianswer questions
tst_question_multichoice 10 0 Options for multiple choice questions
tst_question_numerical 4 0 Options for numerical questions
tst_question_numerical_units 4 0 Optional unit options for numerical questions
tst_question_randomsamatch 3 0 Info about a random short-answer matching question
tst_question_sessions 7 0 Gives ids of the newest open and newest graded states
tst_question_shortanswer 4 0 Options for short answer questions
tst_question_states 11 0 Stores user responses to an attempt, and percentage grades
tst_question_truefalse 4 0 Options for True-False questions
tst_quiz 27 0 Main information about each quiz
tst_quiz_attempts 11 0 Stores various attempts on a quiz
tst_quiz_feedback 5 0 Feedback given to students based on their overall score on the test
tst_quiz_grades 5 0 Final quiz grade (may be best of several attempts)
tst_quiz_question_instances 4 0 The grade for a question in a quiz
tst_quiz_question_versions 7 0 quiz_question_versions table retrofitted from MySQL
tst_reminder 9 0
tst_reminder_message 8 0
tst_reminder_sent 5 0
tst_report_builder 4 12 6
tst_report_builder_columns 1 7 34
tst_report_builder_filters 1 6 15
tst_report_builder_group 6 0
tst_report_builder_group_assign 3 0
tst_report_builder_preproc_track 5 0
tst_report_builder_saved 2 6 0
tst_report_builder_schedule 8 0
tst_report_builder_settings 1 5 4
tst_report_heading_items 5 0
tst_resource 10 0 each record is one resource and its config data
tst_role 1 5 11 moodle roles
tst_role_allow_assign 3 15 this defines what role can assign what role
tst_role_allow_override 3 7 this defines what role can override what role
tst_role_assignments 1 11 1 assigning roles to different context
tst_role_capabilities 7 765 permission has to be signed, overriding a capability for a particular role in a particular context
tst_role_names 4 0 role names in native strings
tst_role_sortorder 5 0 sort order of course managers in a course
tst_scale 7 0 Defines grading scales
tst_scale_history 11 0 History table
tst_scorm 26 0 each table is one SCORM module and its configuration
tst_scorm_scoes 9 0 each SCO part of the SCORM module
tst_scorm_scoes_data 4 0 Contains variable data get from packages
tst_scorm_scoes_track 8 0 to track SCOes
tst_scorm_seq_mapinfo 8 0 SCORM2004 objective mapinfo description
tst_scorm_seq_objective 6 0 SCORM2004 objective description
tst_scorm_seq_rolluprule 7 0 SCORM2004 sequencing rule
tst_scorm_seq_rolluprulecond 5 0 SCORM2004 sequencing rule
tst_scorm_seq_rulecond 7 0 SCORM2004 rule condition
tst_scorm_seq_ruleconds 5 0 SCORM2004 rule conditions
tst_sessions2 6 0 Optional database session storage in new format, not used by default
tst_stats_daily 7 0 to accumulate daily stats
tst_stats_monthly 7 0 To accumulate monthly stats
tst_stats_user_daily 8 0 To accumulate daily stats per course/user
tst_stats_user_monthly 8 0 To accumulate monthly stats per course/user
tst_stats_user_weekly 8 0 To accumulate weekly stats per course/user
tst_stats_weekly 7 0 To accumulate weekly stats
tst_survey 9 5 Each record is one SURVEY module with its configuration
tst_survey_analysis 4 0 text about each survey submission
tst_survey_answers 7 0 the answers to each questions filled by the users
tst_survey_questions 7 73 the questions conforming one survey
tst_tag 9 0 Tag table - this generic table will replace the old "tags" table.
tst_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
tst_tag_instance 6 0 tag_instance table holds the information of associations between tags and other items
tst_timezone 16 0 Rules for calculating local wall clock time for users
tst_user 10 48 5 One record for each person
tst_user_info_category 3 0 Customisable fields categories
tst_user_info_data 4 0 Data for the customisable user fields
tst_user_info_field 18 0 Customisable user profile fields
tst_user_lastaccess 4 0 To keep track of course page access times, used in online participants block, and participants list
tst_user_preferences 4 2 Allows modules to store arbitrary user preferences
tst_user_private_key 8 0 access keys used in cookieless scripts - rss, etc.
tst_webdav_locks 10 0 Resource locks for WebDAV users
tst_wiki 16 0 Main wik table
tst_wiki_entries 7 0 Holds entries for each wiki start instance
tst_wiki_locks 6 0 Stores editing locks on Wiki pages
tst_wiki_pages 13 0 Holds the Wiki-Pages
tst_workshop 32 0 Defines workshop
tst_workshop_assessments 15 0 Info about assessments by teacher and students
tst_workshop_comments 7 0 Defines comments
tst_workshop_elements 9 0 Info about marking scheme of assignment
tst_workshop_grades 6 0 Info about individual grades given to each element
tst_workshop_rubrics 5 0 Info about the rubrics marking scheme
tst_workshop_stockcomments 4 0 Info about the teacher comment bank
tst_workshop_submissions 11 0 Info about submitted work from teacher and students
           
316 Tables     2,761 2,415  
0 Views     0