Activities-competencies relationship

Activities-competencies relationship

by Luis de la Torre -
Number of replies: 3

Hi, where can I find the relationship between competencies and activities in the database? When you assign a competency to an activity, that information must be stored in a DB table I presume, but I can't find it.

It looks like the relationship for course and competencies is in the table competency_coursecomp and competency_usercompcourse, but, again, i cannot find the relation like between activity and competency.

Any help would be much appreciated.

Average of ratings: -
In reply to Luis de la Torre

Re: Activities-competencies relationship

by Randy Thornton -
Picture of Documentation writers
Luis,

You will find this in the table mdl_competency_modulecomp.

The column cmid holds the id of the activity module in the mdl_course modules table, while the column comptencyid hold the particular competency id linking to the main mdl_competency table. That is how they are connected.

Randy
Average of ratings: Useful (2)
In reply to Randy Thornton

Re: Activities-competencies relationship

by Luis de la Torre -
Thanks for that, Randy! I'm sorry I was so late on saying thanks. I had some very busy days and didn't come here to check if anyone had answered to me. Thanks a lot!!!
Average of ratings: -