| 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 |
|
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 |