General developer forum

Where is the link in the database between competenices and activities in the course?

 
Picture of Salha M. Alzahrani, PhD
Where is the link in the database between competenices and activities in the course?
 

Hi,

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. 

 
Average of ratings: -