Lesson Table Schema (lesson)


Description

Defines lesson

lesson table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
lesson_answers.lessonid lessansw_les2_fk R
lesson_attempts.lessonid lessatte_les2_fk R
lesson_branch.lessonid lessbran_les2_fk R
lesson_grades.lessonid lessgrad_les2_fk R
lesson_overrides.lessonid lessover_les2_fk R
lesson_pages.lessonid lesspage_les2_fk R
lesson_timer.lessonid lesstime_les2_fk R
course bigint 10 0
name varchar 255
intro longtext 2147483647 null
introformat smallint 4 0
practice smallint 3 0
modattempts smallint 3 0
usepassword smallint 3 0
password varchar 32
dependency bigint 10 0
conditions longtext 2147483647 null
grade bigint 10 0
custom smallint 3 0
ongoing smallint 3 0
usemaxgrade smallint 3 0
maxanswers smallint 3 4
maxattempts smallint 3 5
review smallint 3 0
nextpagedefault smallint 3 0
feedback smallint 3 1
minquestions smallint 3 0
maxpages smallint 3 0
timelimit bigint 10 0
retake smallint 3 1
activitylink bigint 10 0
mediafile varchar 255

Local file path or full external URL

mediaheight bigint 10 100
mediawidth bigint 10 650
mediaclose smallint 3 0
slideshow smallint 3 0
width bigint 10 640
height bigint 10 480
bgcolor varchar 7 #FFFFFF
displayleft smallint 3 0
displayleftif smallint 3 0
progressbar smallint 3 0
available bigint 10 0
deadline bigint 10 0
timemodified bigint 10 0
completionendreached BIT 1 0
completiontimespent bigint 11 0
allowofflineattempts BIT 1 0

Whether to allow the lesson to be attempted offline in the mobile app

Table contained -1 rows

lesson table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
less_cou_ix Performance Asc course

lesson table relationships