I am a Moodle 3.5.1 developer, and I would like to create a plugin for certain reports that show the activities in the course associated with their related competences and students grades.
Firstly, I added my competences framework, and linked the course to the competences needed.
As you know, when we add any activity in the course, a quiz for example, we can link it to the competences. I am trying to understand how this quizid is linked to competencyid in the database schema. I found the competency_coursecomp table which relates the course and competency tables. However, I could not realise where can I find the table that relates the activities such as quizzes to the competences. Any help or clarification would be greatly appreciated.