| Column | Type | Description |
|---|---|---|
id | uuidv4 | Unique ID generated by LearnInk |
user_id | uuidv4 | Foreign key → users.id |
learningpath_id | text | Foreign key → learning_paths.id |
learningpath_start_date | date | The date the user was due to start the learning path. If in the future, the path remains locked until this date. |
completed_at | timestamptz | null | When the user completed the learning path. Null if not yet complete. |
is_active | boolean | Whether this is the user’s currently active learning path |
created_at | timestamptz | When this assignment was created |
updated_at | timestamptz | When this row was last updated |
Table Reference
user_learningpaths
Each user’s current and historical learning path status
Each row represents a user’s assignment to a specific learning path. A user can only have one active learning path at a time.