Totara Learn Open Discussions

Database table/column for course completion

 
ZelinskayaMarina
Database table/column for course completion
ZelinskayaMarina 发表于 2024年06月28日 Friday 08:10
 

Hello, everyone,

We use Totara Learn 12, and I was wondering if someone knows which table/column stores the course completion information in the database?

Thank you,

Marina Zelinskaya

Craig Eves
Re: Database table/column for course completion
Eves (Totara Support)Craig 发表于 2024年06月30日 Sunday 16:32
小组 Totara

Hi Marina

There are a few tables around course completions - the users grades for current course completion are stored inhttps://db-schema.totaralearning.com/t12-release/tables/app_course_completion_crit_compl.html and the historic course https://db-schema.totaralearning.com/t12-release/tables/app_course_completion_history.htmlhttps://db-schema.totaralearning.com/t18-release/tables/app_course_completion_history.html . The schema links above show how the tables are related.

Regards