Data Dictionary

List of tables in Cassandra database used in LMS service

sunbird_courses.question [PRIMARY KEY: id] - (User Defined Type - used in sunbird_courses.assessment_aggregator)

sunbird_courses.user_content_consumption [PRIMARY KEY (userid, contentid, batchid, courseid)]

Table used to store user content consumption status as part of Course consumption.

sunbird_courses.user_activity_agg [PRIMARY KEY ((activity_type, activity_id, user_id), context_id)]

Table used to store User's Course consumption progress aggregates

sunbird_courses.assessment_aggregator [PRIMARY KEY ((user_id, course_id), batch_id, content_id, attempt_id)]

Table used to store User's Assessment Contents' consumption aggregates

sunbird_courses.course_batch [PRIMARY KEY (courseid, batchid)]

Table used to store Batch information created against Courses.

sunbird_courses.user_enrolments [PRIMARY KEY (userid, courseid, batchid)]

Table used to capture User's information who have enrolled to Course Batch

sunbird_courses.report_user_enrolments [PRIMARY KEY (userid, courseid, batchid)]

Table same as that of 'sunbird_courses.user_enrolments' used for certificate migration

sunbird_courses.bulk_upload_process [PRIMARY KEY: id]

Table used to store information about the bulk user enrolments file upload process.

Last updated