| Column | Type | Description |
|---|---|---|
id | uuidv4 | Unique ID generated by LearnInk |
user_id | uuidv4 | Foreign key → users.id |
course_id | uuidv4 | Foreign key → courses.id |
started_at | timestamptz | When the user started the course |
completed_at | timestamptz | null | When the user completed the course. Null if not yet complete. |
average_score | integer | Average score across all modules in the course. See the LearnInk help docs for the scoring methodology. |
certificate_id | text | null | Unique ID of the certificate issued upon completion |
num_baseline_answers_correct | integer | Correct answers in pre-lesson (baseline) quizzes. 0 if baseline quizzes are not enabled for this course. |
num_baseline_answers_incorrect | integer | Incorrect answers in pre-lesson quizzes |
num_endline_answers_correct | integer | Correct answers in post-lesson (endline) quizzes |
num_endline_answers_incorrect | integer | Incorrect answers in post-lesson quizzes |
num_endline_attempts_successful | integer | Number of endline quiz attempts where the score met or exceeded the minimum pass mark |
num_endline_attempts_unsuccessful | integer | Number of endline quiz attempts where the score fell below the minimum pass mark |
updated_at | timestamptz | When this row was last updated |
Table Reference
user_course_performance
Per-user, per-course performance data
Each row summarises a single user’s performance on a single course. This is the primary table for analysing learning outcomes.