lessons_view

0 rows


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

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
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

Relationships

View Definition


Possibly Referenced Tables/Views