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_assignment | 1 | 0 | 19 | 0 | Table | Defines assignments |
app_assignment_submissions | 0 | 1 | 14 | 0 | Table | Info about submitted assignments |
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_files_template | 0 | 0 | 7 | 0 | Table | To store files along the backup process. Note this table isn’t really used but its temporary counterpart. |
app_backup_ids_template | 0 | 0 | 7 | 0 | Table | To store all sort of ids along the backup process. Note this table isn’t really used but its temporary counterpart. |
app_backup_logs | 0 | 1 | 5 | 0 | Table | To store all the logs from backup and restore operations (by db logger) |
app_block | 0 | 0 | 6 | 48 | 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 |
app_block_positions | 0 | 2 | 8 | 0 | Table | Stores the position of a sticky block_instance on a another page than the one where it was added. |
app_block_quicklinks | 0 | 0 | 6 | 3 | Table | Holds information on the defined links of a block |
app_block_rss_client | 0 | 0 | 7 | 0 | Table | 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 |
app_block_totara_stats | 0 | 0 | 6 | 0 | Table | Holds stats information |
app_blog_association | 0 | 2 | 3 | 0 | Table | Associations of blog entries with courses and module instances |
app_blog_external | 0 | 1 | 9 | 0 | Table | External blog links used for RSS copying of blog entries to Moodle user blogs |
app_book | 0 | 0 | 10 | 0 | Table | Defines book |
app_book_chapters | 0 | 0 | 11 | 0 | Table | Defines book_chapters |
app_cache_filters | 0 | 0 | 6 | 0 | Table | For keeping information about cached data |
app_cache_flags | 0 | 0 | 6 | 0 | Table | Cache of time-sensitive flags |
app_cache_text | 0 | 0 | 4 | 0 | Table | For storing temporary copies of processed texts |
app_capabilities | 1 | 0 | 6 | 487 | Table | this defines all capabilities |
app_certificate | 0 | 0 | 29 | 0 | Table | Defines certificates |
app_certificate_issues | 0 | 0 | 5 | 0 | Table | Info about issued certificates |
app_chat | 3 | 0 | 10 | 0 | Table | Each of these is a chat room |
app_chat_messages | 0 | 1 | 7 | 0 | Table | Stores all the actual chat messages |
app_chat_messages_current | 0 | 1 | 7 | 0 | Table | Stores current session |
app_chat_users | 0 | 1 | 12 | 0 | Table | Keeps track of which users are in which chat rooms |
app_choice | 2 | 0 | 15 | 0 | Table | Available choices are stored here |
app_choice_answers | 0 | 2 | 5 | 0 | Table | choices performed by users |
app_choice_options | 1 | 1 | 5 | 0 | Table | available options to choice |
app_cohort | 1 | 1 | 19 | 0 | Table | Each record represents one cohort (aka site-wide group). |
app_cohort_members | 0 | 2 | 4 | 0 | Table | Link a user to a cohort. |
app_cohort_msg_queue | 0 | 0 | 8 | 0 | Table | A table to store cohort member join/delete notifications, to be sent at the next cron run. |
app_cohort_rule_collections | 0 | 0 | 7 | 0 | Table | Collections of rulesets & rules for a dynamic cohort |
app_cohort_rule_params | 0 | 0 | 7 | 0 | Table | The parameters of rules in cohort_rules |
app_cohort_rules | 0 | 0 | 8 | 0 | Table | Rules within a ruleset |
app_cohort_rulesets | 0 | 0 | 8 | 0 | Table | Rulesets for dynamic cohorts |
app_comments | 0 | 0 | 8 | 0 | Table | moodle comments module |
app_comp | 0 | 0 | 18 | 0 | Table | Totara competencies |
app_comp_evidence | 0 | 0 | 13 | 0 | Table | Track current proficiency of a user in each competency |
app_comp_evidence_items | 0 | 0 | 9 | 0 | Table | A competency can be achieved by one or more forms of evidence |
app_comp_evidence_items_evidence | 0 | 0 | 8 | 0 | Table | Tracks historical progress towards a competency for each user |
app_comp_framework | 0 | 0 | 11 | 0 | Table | A collection of competencies that use a common competency scale |
app_comp_relations | 0 | 0 | 4 | 0 | Table | Tracks relationships between competencies |
app_comp_scale | 0 | 0 | 6 | 1 | Table | Competency scale represents the different levels of achievement of a competency |
app_comp_scale_assignments | 0 | 0 | 5 | 0 | Table | Tracks which scales are assigned to which competency frameworks |
app_comp_scale_values | 0 | 0 | 10 | 3 | Table | The individual values that make up a competency scale |
app_comp_template | 0 | 0 | 10 | 0 | Table | A template is used to group competencies |
app_comp_template_assignment | 0 | 0 | 6 | 0 | Table | Track competencies belonging to a template |