Learning and LMS Database Structure

Please note: Access to database is only possible for on-premise deployment and you have direct access to the SQL database and require in-house DBA skills.

 

Understanding Learning & LMS Tables

1. Where does the training record of the users are stored?

Training Records are stored in Claromentis database table called learning_record

user_id can be reference back in a table called users

 

2. Where can I find the completion of an e-learning course?

Database table called  lms_course_audit

find the course name by cross-referencing course_id column in the database table: lms_course

3. Where can I find the completion of e-learning module?

Database table called lms_module_audit

find the module name by cross-referencing module_id column in the database table: lms_module

Last modified on 1 December 2023 by Hannah Door
Created on 11 March 2018 by Michael Christian

Was this helpful?  

Share