Database Properties
Database Type: PostgreSQL - 9.6.23
Schema public
Foreign Key information for Totara tables
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| app_appraisal | 7 | 0 | 6 | 1 | Table | Main appraisal table |
| app_appraisal_event | 2 | 2 | 9 | 0 | Table | Appraisal event notifications |
| app_appraisal_event_message | 1 | 1 | 4 | 0 | Table | Appraisal event message |
| app_appraisal_event_rcpt | 0 | 1 | 3 | 0 | Table | Appraisal events recipients (roles) |
| app_appraisal_grp_cohort | 0 | 2 | 3 | 0 | Table | Audiences assigned to appraisal |
| app_appraisal_grp_org | 0 | 2 | 4 | 0 | Table | Organisations assigned to appraisal |
| app_appraisal_grp_pos | 0 | 2 | 4 | 0 | Table | Positions assigned to appraisal |
| app_appraisal_history | 0 | 2 | 4 | 0 | Table | Appraisal access history |
| app_appraisal_quest_field | 3 | 2 | 15 | 14 | Table | Individual question list for appraisal page |
| app_appraisal_quest_field_role | 0 | 1 | 4 | 28 | Table | Access restrictions for each question. access - APPRAISAL_ACCESS_* constant |
| app_appraisal_review_data | 0 | 2 | 7 | 0 | Table | Course, objectives, etc reviews in appraisal |
| app_appraisal_role_assignment | 3 | 2 | 5 | 0 | Table | Individual user assignments by their roles |
| app_appraisal_scale | 2 | 1 | 4 | 1 | Table | Multiple choice sets |
| app_appraisal_scale_data | 0 | 3 | 4 | 0 | Table | Multiple user answers |
| app_appraisal_scale_value | 1 | 1 | 4 | 2 | Table | Multiple choice options (score can be used when applicable) |
| app_appraisal_stage | 5 | 1 | 5 | 3 | Table | Stages within appraisal |
| app_appraisal_stage_data | 0 | 2 | 4 | 0 | Table | Appraisal stage completion for each asiignment |
| app_appraisal_stage_page | 1 | 1 | 4 | 10 | Table | Pages within appraisal stages. Each stage has at least one page |
| app_appraisal_stage_role_setting | 0 | 1 | 4 | 6 | Table | Role access settings for each stage. appraisalrole - APPRAISAL_ROLE_* constant. |
| app_appraisal_user_assignment | 1 | 3 | 5 | 0 | Table | Actual user who is subject of appraisal |
| app_appraisal_user_event | 0 | 2 | 4 | 0 | Table | Appraisal events scheduled to specific users |
| app_assign | 9 | 0 | 26 | 0 | Table | This table saves information about an instance of mod_assign in a course. |
| app_assign_grades | 4 | 1 | 8 | 0 | Table | Grading information about a single assignment submission. |
| app_assign_plugin_config | 0 | 1 | 6 | 0 | Table | Config data for an instance of a plugin in an assignment. |
| app_assign_submission | 2 | 1 | 8 | 0 | Table | 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. |
| app_assign_user_flags | 0 | 2 | 8 | 0 | Table | List of flags that can be set for a single user in a single assignment. |
| app_assign_user_mapping | 0 | 2 | 3 | 0 | Table | Map an assignment specific id number to a user |
| app_assignfeedback_comments | 0 | 2 | 5 | 0 | Table | Text feedback for submitted assignments |
| app_assignfeedback_editpdf_annot | 0 | 1 | 11 | 0 | Table | stores annotations added to pdfs submitted by students |
| app_assignfeedback_editpdf_cmnt | 0 | 1 | 9 | 0 | Table | Stores comments added to pdfs |
| app_assignfeedback_editpdf_quick | 0 | 1 | 5 | 0 | Table | Stores teacher specified quicklist comments |
| app_assignfeedback_file | 0 | 2 | 4 | 0 | Table | Stores info about the number of files submitted by a student. |
| app_assignment | 1 | 0 | 19 | 0 | Table | Defines assignments |
| app_assignment_submissions | 0 | 1 | 14 | 0 | Table | Info about submitted assignments |
| app_assignsubmission_file | 0 | 2 | 4 | 0 | Table | Info about file submissions for assignments |
| app_assignsubmission_onlinetext | 0 | 2 | 5 | 0 | Table | Info about onlinetext submission |
| app_backup_controllers | 1 | 1 | 16 | 0 | Table | To store the backup_controllers as they are used |
| app_backup_courses | 0 | 0 | 6 | 0 | Table | To store every course backup status |
| app_backup_logs | 0 | 1 | 5 | 0 | Table | To store all the logs from backup and restore operations (by db logger) |
| app_badge | 3 | 3 | 20 | 0 | Table | Defines badge |
| app_badge_backpack | 1 | 1 | 7 | 0 | Table | Defines settings for connecting external backpack |
| app_badge_criteria | 2 | 1 | 6 | 0 | Table | Defines criteria for issuing badges |
| app_badge_criteria_met | 0 | 3 | 5 | 0 | Table | Defines criteria that were met for an issued badge |
| app_badge_criteria_param | 0 | 1 | 4 | 0 | Table | Defines parameters for badges criteria |
| app_badge_external | 0 | 1 | 3 | 0 | Table | Setting for external badges display |
| app_badge_issued | 1 | 2 | 8 | 0 | Table | Defines issued badges |
| app_badge_manual_award | 0 | 4 | 6 | 0 | Table | Track manual award criteria for badges |
| app_block | 0 | 0 | 5 | 51 | Table | contains all installed blocks |
| app_block_community | 0 | 0 | 6 | 0 | Table | Community block |
| app_block_instances | 1 | 1 | 9 | 13 | Table | 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 |