Skip to main content
Each row summarises a single user’s performance on a single course. This is the primary table for analysing learning outcomes.
ColumnTypeDescription
iduuidv4Unique ID generated by LearnInk
user_iduuidv4Foreign key → users.id
course_iduuidv4Foreign key → courses.id
started_attimestamptzWhen the user started the course
completed_attimestamptz | nullWhen the user completed the course. Null if not yet complete.
average_scoreintegerAverage score across all modules in the course. See the LearnInk help docs for the scoring methodology.
certificate_idtext | nullUnique ID of the certificate issued upon completion
num_baseline_answers_correctintegerCorrect answers in pre-lesson (baseline) quizzes. 0 if baseline quizzes are not enabled for this course.
num_baseline_answers_incorrectintegerIncorrect answers in pre-lesson quizzes
num_endline_answers_correctintegerCorrect answers in post-lesson (endline) quizzes
num_endline_answers_incorrectintegerIncorrect answers in post-lesson quizzes
num_endline_attempts_successfulintegerNumber of endline quiz attempts where the score met or exceeded the minimum pass mark
num_endline_attempts_unsuccessfulintegerNumber of endline quiz attempts where the score fell below the minimum pass mark
updated_attimestamptzWhen this row was last updated