I'm trying to understand the relationship between a course and it's questions. Each question has a unique id (id) and question type (qtype) that link to the question's answers and I've been able to understand that relationship. What I don't understand is how the questions are linked to the course.
In order to link questions to a course, I would have expected to see either the course id in the mdl_questions table or an id to an "intermediate" assessment/exam/test table which in turn would contain the id of a course. Since there is no course id in the mdl_questions table, I've got to assume there is an "intermediate" table somewhere that links to each question, but I can't find it anywhere.
Can someone point me in the right direction on how courses and questions link together? It would be greatly appreciated.
Steve