batch_lesson_view

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
name VARCHAR 255 null
subject_id VARCHAR 36 null
course_id VARCHAR 36 √ null
point TINYINT 3 √ null
lesson_type_id VARCHAR 36 √ null
lesson_category_id VARCHAR 36 √ null
web_access TINYINT 3 √ 1

0:No Access,1:Have Access

mobile_access TINYINT 3 √ 1

0:No Access,1:Have Access

student_access TINYINT 3 √ null

0:No Access,1:Have Access

facilitator_access TINYINT 3 √ null

0:No Access,1:Have Access

lesson_order INT 10 √ null
is_assessment TINYINT 3 √ 0

0:No,1:Yes

assessment_question MEDIUMTEXT 16777215 √ null
is_portrait_view TINYINT 3 √ null
tenant_id VARCHAR 36 null
status TINYINT 3 √ 1

0:Inactive,1:Active

created_at DATETIME 19 √ null
updated_at DATETIME 19 √ null
deleted_at TIMESTAMP 19 √ null
description LONGTEXT 2147483647 √ null
duration VARCHAR 45 √ null

Stores Duration of lesson

batch_id VARCHAR 36 √ null
subject_name VARCHAR 255 null
course_name VARCHAR 255 √ null

Relationships

View Definition


Possibly Referenced Tables/Views