learning_activities_summary

416 rows


Description

Stores student learning activity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
user_id VARCHAR 36 √ null
subject_id VARCHAR 36 null
lesson_id VARCHAR 36 √ null
selected_lesson_id LONGTEXT 2147483647 √ null
skill_id VARCHAR 36 √ null
no_of_question INT 10 √ null
score VARCHAR 10 √ null
json_result_summary LONGTEXT 2147483647 √ null
created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
deleted_at DATETIME 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lesson_id Performance Asc lesson_id
subject_id Performance Asc subject_id
user_id Performance Asc user_id

Relationships