Database Properties
Database Type: PostgreSQL - 16.9 (Debian 16.9-1.pgdg120+1)
Schema public
Foreign Key information for Totara tables
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| app_ai_interaction_log | 0 | 1 | 9 | -1 | Table | Log of AI interaction requests |
| app_appraisal | 7 | 0 | 6 | -1 | Table | Main appraisal table |
| app_appraisal_event | 2 | 2 | 9 | -1 | Table | Appraisal event notifications |
| app_appraisal_event_message | 1 | 1 | 4 | -1 | Table | Appraisal event message |
| app_appraisal_event_rcpt | 0 | 1 | 3 | -1 | Table | Appraisal events recipients (roles) |
| app_appraisal_grp_cohort | 0 | 2 | 3 | -1 | Table | Audiences assigned to appraisal |
| app_appraisal_grp_org | 0 | 2 | 4 | -1 | Table | Organisations assigned to appraisal |
| app_appraisal_grp_pos | 0 | 2 | 4 | -1 | Table | Positions assigned to appraisal |
| app_appraisal_history | 0 | 2 | 4 | -1 | Table | Appraisal access history |
| app_appraisal_quest_field | 3 | 2 | 15 | -1 | Table | Individual question list for appraisal page |
| app_appraisal_quest_field_role | 0 | 1 | 4 | -1 | Table | Access restrictions for each question. access - APPRAISAL_ACCESS_* constant |
| app_appraisal_review_data | 0 | 2 | 7 | -1 | Table | Course, objectives, etc reviews in appraisal |
| app_appraisal_role_assignment | 3 | 2 | 6 | -1 | Table | Individual user assignments by their roles |
| app_appraisal_role_changes | 0 | 0 | 6 | -1 | Table | Store role changes for assignments |
| app_appraisal_scale | 2 | 1 | 4 | -1 | Table | Multiple choice sets |
| app_appraisal_scale_data | 0 | 3 | 4 | -1 | Table | Multiple user answers |
| app_appraisal_scale_value | 1 | 1 | 4 | -1 | Table | Multiple choice options (score can be used when applicable) |
| app_appraisal_stage | 5 | 1 | 5 | -1 | Table | Stages within appraisal |
| app_appraisal_stage_data | 0 | 2 | 6 | -1 | Table | Appraisal stage completion for each asiignment |
| app_appraisal_stage_page | 1 | 1 | 4 | -1 | Table | Pages within appraisal stages. Each stage has at least one page |
| app_appraisal_stage_role_setting | 0 | 1 | 4 | -1 | Table | Role access settings for each stage. appraisalrole - APPRAISAL_ROLE_* constant. |
| app_appraisal_user_assignment | 1 | 4 | 8 | -1 | Table | Actual user who is subject of appraisal |
| app_appraisal_user_event | 0 | 2 | 4 | -1 | Table | Appraisal events scheduled to specific users |
| app_approval | 14 | 2 | 11 | -1 | Table | mod_approval; Table to store workflow assignments and assignment overrides |
| app_approval_application | 8 | 14 | 18 | -1 | Table | Table to store workflow application metadata |
| app_approval_application_action | 0 | 6 | 9 | -1 | Table | Table to store application actions, such as approved and denied |
| app_approval_application_activity | 0 | 8 | 8 | -1 | Table | Table to store application event logs |
| app_approval_application_submission | 0 | 6 | 9 | -1 | Table | Table to store application form submissions |
| app_approval_approver | 0 | 4 | 9 | -1 | Table | Table to store workflow assignment/override approvers |
| app_approval_dashboard_application_any | 0 | 4 | 3 | -1 | Table | Table to index assignments where user has view_in_dashboard_application_any capability |
| app_approval_dashboard_application_applicant | 0 | 3 | 3 | -1 | Table | Table to index users where user has view_in_dashboard_application_applicant capability |
| app_approval_dashboard_application_user | 0 | 3 | 3 | -1 | Table | Table to index users where user has view_in_dashboard_application_user capability |
| app_approval_dashboard_draft_application_any | 0 | 4 | 3 | -1 | Table | Table to index assignments where user has view_draft_in_dashboard_application_any capability |
| app_approval_dashboard_draft_application_applicant | 0 | 3 | 3 | -1 | Table | Table to index users where user has view_draft_in_dashboard_application_applicant capability |
| app_approval_dashboard_draft_application_user | 0 | 3 | 3 | -1 | Table | Table to index users where user has view_draft_in_dashboard_application_user capability |
| app_approval_dashboard_pending_application_any | 0 | 6 | 4 | -1 | Table | Table to index assignments where user has view_in_dashboard_pending_application_any capability |
| app_approval_dashboard_pending_application_user | 0 | 5 | 4 | -1 | Table | Table to index users where user has view_in_dashboard_pending_application_user capability |
| app_approval_form | 4 | 0 | 6 | -1 | Table | Table to store form sub-plugin instances for use with with workflows |
| app_approval_form_version | 4 | 2 | 7 | -1 | Table | Table to track versions of form definitions |
| app_approval_role_capability_map | 0 | 2 | 4 | -1 | Table | Capability to role map |
| app_approval_workflow | 1 | 6 | 12 | -1 | Table | Table to store workflow metadata |
| app_approval_workflow_stage | 12 | 2 | 8 | -1 | Table | Table to store workflow stage configuration |
| app_approval_workflow_stage_approval_level | 8 | 2 | 7 | -1 | Table | Table to store workflow stage approval level configuration |
| app_approval_workflow_stage_formview | 0 | 2 | 9 | -1 | Table | Table to store workflow stage form configuration |
| app_approval_workflow_stage_interaction | 4 | 2 | 5 | -1 | Table | Table to store workflow stage interaction configuration |
| app_approval_workflow_stage_interaction_action | 0 | 2 | 8 | -1 | Table | Table to store interaction action configurations |
| app_approval_workflow_stage_interaction_transition | 0 | 2 | 8 | -1 | Table | Table to store interaction transition configurations |
| app_approval_workflow_type | 2 | 0 | 5 | -1 | Table | Workflow types |
| app_approval_workflow_version | 4 | 3 | 6 | -1 | Table | Table to store workflow configuration |
| app_assign | 10 | 0 | 30 | -1 | Table | This table saves information about an instance of mod_assign in a course. |