lessons

16786 rows


Description

Stores lesson data

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
subject_id VARCHAR 36 null
name VARCHAR 255 null
lesson_type_id VARCHAR 36 √ null
lesson_category_id VARCHAR 36 √ null
assessment_question MEDIUMTEXT 16777215 √ null
facilitator_access TINYINT 3 √ null

0:No Access,1:Have Access

student_access TINYINT 3 √ null

0:No Access,1:Have Access

status TINYINT 3 √ 1

0:Inactive,1:Active

created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
created_by VARCHAR 36 √ null
created_platform TINYINT 3 √ null
deleted_at TIMESTAMP 19 √ null
web_access TINYINT 3 √ 1

0:No Access,1:Have Access

mobile_access TINYINT 3 √ 1

0:No Access,1:Have Access

point TINYINT 3 √ null
is_portrait_view TINYINT 3 √ null
course_id VARCHAR 36 √ null
is_assessment TINYINT 3 √ 0

0:No,1:Yes

tenant_id VARCHAR 36 null
old_data_id INT 10 √ null
lesson_order INT 10 √ null
description LONGTEXT 2147483647 √ null
duration VARCHAR 45 √ null

Stores Duration of lesson

mastertrainer_access TINYINT 3 √ 0
sub_student_access TINYINT 3 √ 0
leader_access TINYINT 3 √ 0
primary_teacher_access TINYINT 3 √ 0
secondary_teacher_access TINYINT 3 √ 0
govt_official_access TINYINT 3 √ 0
content_id VARCHAR 36 √ null
updated_by VARCHAR 36 √ null
deleted_by VARCHAR 36 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
course_id Performance Asc course_id
facilitator_access Performance Asc facilitator_access
fk_lessons_1_idx Performance Asc subject_id
idx_lessons_cat_status_access_del Performance Asc/Asc/Asc/Asc/Asc lesson_category_id + status + student_access + deleted_at + id
idx_lessons_subject_category_status_deleted Performance Asc/Asc/Asc/Asc subject_id + lesson_category_id + status + deleted_at
idx_lessons_subject_deleted Performance Asc/Asc subject_id + deleted_at
lesson_category_id Performance Asc lesson_category_id
lessons_subject_id_IDX Performance Asc/Asc/Asc/Asc/Asc/Asc subject_id + student_access + web_access + status + lesson_category_id + deleted_at
migration_lesson_type Performance Asc lesson_type_id
status Performance Asc status
student_access Performance Asc student_access
subject_id Performance Asc/Asc/Asc/Asc/Asc subject_id + lesson_category_id + student_access + status + deleted_at
tenant_id Performance Asc tenant_id

Relationships