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 | 6 | 0 | Table | Individual user assignments by their roles |
| app_appraisal_role_changes | 0 | 0 | 6 | 0 | Table | Store role changes for assignments |
| 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 | 6 | 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 | 28 | 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 | 9 | 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_assignment_upgrade | 0 | 0 | 6 | 0 | Table | Info about upgraded 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_auth_connect_servers | 4 | 0 | 12 | 0 | Table | List of servers |
| app_auth_connect_sso_requests | 0 | 1 | 5 | 0 | Table | List of SSO requests from Totara Connect client to server |
| app_auth_connect_sso_sessions | 0 | 2 | 7 | 0 | Table | List of SSO sessions on Client system, columns are not normalised to allow strict validation |
| app_auth_connect_user_collections | 0 | 2 | 6 | 0 | Table | List of cohorts synced from server |
| app_auth_connect_users | 0 | 2 | 5 | 0 | Table | List of users from each Totara Connect server |
| 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 |