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 | 6 | 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 | 4 | 8 | 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 | 10 | 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_overrides | 0 | 3 | 8 | 0 | Table | The overrides to assign settings. |
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_queue | 0 | 0 | 3 | 0 | Table | Queue for processing. |
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_approved_request | 1 | 5 | 29 | 0 | Table | Self registration with approval details |
app_auth_approved_request_snapshots | 0 | 2 | 31 | 0 | Table | History of auth_approved_request records |
app_auth_connect_ids | 0 | 1 | 6 | 0 | Table | General server to client database id mappings |
app_auth_connect_servers | 5 | 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 |