| Column | Type | Description |
|---|---|---|
id | uuidv4 | Unique ID generated by LearnInk |
user_id | uuidv4 | Foreign key → users.id |
sequence_id | uuidv4 | Foreign key → sequences.id |
started_at | timestamptz | When the user started the sequence |
completed_at | timestamptz | null | When the user completed all courses in the sequence. Null if not yet complete. |
average_score | integer | Average score across all courses in the sequence |
num_courses_complete | integer | Number of courses in the sequence that the user has completed |
updated_at | timestamptz | When this row was last updated |
Table Reference
user_sequence_performance
Per-user, per-sequence performance data
Each row summarises a single user’s performance across an entire sequence of courses.