course_progress

12054073 rows


Description

student course progress

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 36 null
centre_id VARCHAR 36 √ null
batch_id VARCHAR 36 √ null
course_id VARCHAR 36 null
completed_count INT 10 √ null
activity_count INT 10 √ 1
total_count INT 10 √ null
progress FLOAT 12 √ null
created_at DATETIME 19 √ CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
course_progress_course_id_IDX Performance Asc/Asc/Asc user_id + centre_id + course_id
unique_user_course Must be unique Asc/Asc user_id + course_id

Relationships