What tables affected when registering student?

Backend functionalities: user management, course management, reports, certificates, etc.
Post Reply
ebsi
FormaLms User
Posts: 28
Joined: Mon Jun 25, 2012 3:50 pm
Location: Mayo, Ireland
Contact:

What tables affected when registering student?

Post by ebsi »

Hi all,

From DATABASE viewpoint, when a student registers on docebo 3.6 What tables affected when registering student?

Is there any difference in 4.05?

Thanks in advance

Thomas

User avatar
alberto
FormaLms Guru
Posts: 1066
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: What tables affected when registering student?

Post by alberto »

Hi Thomas, both on versions 3.6 and 4 the tables involved in user registration are:

core_st: add incremental id
core_users: add user with idst from core_st
core_group_members: on first user access adds 3 rows with permission 1,2 (orgchart),5 (5 if user, 3 if superadmin, 4 if admin)

Then if you have custom fields you'll have to populate also "core_field_userentry".

Only on user self registration also table "core_user_temp" is used to store temporary user data and the code of the confirmation login sent via email on registration form submit.
--------------------------------------------------
Become a CONTRIBUTOR

Support the project for FREE!
www.Elearnit.net

ebsi
FormaLms User
Posts: 28
Joined: Mon Jun 25, 2012 3:50 pm
Location: Mayo, Ireland
Contact:

Re: What tables affected when registering student?

Post by ebsi »

Hi Alberto...

Regarding the core_Group_Members... does this permission reflect the same structure as user levels?

Also you say level 1 is ghost and 7 Super Admin... so

7 Course administrator
6 Teacher
5 Mentor: a subject expert
4 Tutor: a communication processes expert
3 Student
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)

From the look of what you say above the groups dont reflect the same as user levels...

so is group levels different?

Also where does roles enter into it?

Or am I confusing it too much (or did docebo :) )

Thanks again

Thomas

User avatar
alberto
FormaLms Guru
Posts: 1066
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: What tables affected when registering student?

Post by alberto »

All the permissions in docebo are stored in table "core_group", both for platform profiling (Superadmin, admin, publicadmin, user) and course profiling (student, tutor, mentor, ecc).
Groups for platform profiling are 4 and fixed, groups for course profiling are 7 and different for each course, so of course the structure con't be the same ;)
--------------------------------------------------
Become a CONTRIBUTOR

Support the project for FREE!
www.Elearnit.net

Post Reply