Can someone tell me exactly how a student is added to a course from the perspective of the DATABASE? What tables are affected if I add a student to :
a) A course
b) a curriculum
Thanks for your help!
learning_courseuser: matches user and course id
core_group_members: add a row with the permission idst from core_group for each course
To add a user to a course:
1 - find user id (core_user) and course id (learning_course)
2 - in core_group find the rows containing /lms/course/[idcourse]/subscribed/[level 1-7], and find the id of the required user level (from 1 - ghost to 7 - administrator)
3 - in core_group_member add a new record with the user id (idstmember), and the user level id found above
4 - in in learning_courseuser add a new record with the user id (idstmember), course id and the user level
For curricula use also table "learning_coursepath_user".
To clarify, if I have a curriculum of 4 course units, do I have to add the user to the 4 courses AND the curriculum?
Also you say level 1 is ghost and 7 Super Admin... so
7 Course administrator
5 Mentor: a subject expert
4 Tutor: a communication processes expert
2 Guest (a guest user subscribed to the course with visual access rights only)
1 Ghost (a user whose activity is not tracked by the system)
So its different to the group level numbers where a student would be entered into core group 5, correct?
Thanks for your expert advice Alberto!
Correct, in course profiling "student" is level 3, but the permission id will be different for each course.
"5" is the idst for the group of normal users in platform profiling, and is the same in every docebo installation.