Skip to main content
This section is your reference for the LearnInk data sync database. For an overview of what data sync is and how to get access, see the Data sync overview in the Guides tab.

Table reference

The database contains 11 tables. Each table page documents every column, its type, and what it contains.

users

User profiles and registration status

user_groups

Group definitions for content access and segmentation

courses

Course catalogue

sequences

Ordered collections of courses

learning_paths

Assigned learning programmes with deadlines

learningpath_courses

Relationship between learning paths and courses

user_learningpaths

Each user’s learning path status

user_course_performance

Per-user, per-course performance data

user_sequence_performance

Per-user, per-sequence performance data

survey_questions

Survey questions attached to courses

survey answers

Answer options and user survey responses

Sample queries

Ready-to-use SQL to replicate common analytics views. Each query includes column definitions and notes on how to adapt it.