Lesson Pages table / lesson_pages - Totara Learn 12 Database schema / Zoola Analytics

lesson_pages table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

lesson_answers.pageid	lessansw_pag2_fk R
lesson_attempts.pageid	lessatte_pag2_fk R
lesson_branch.pageid	lessbran_pag2_fk R

lessonid

BIGINT

19

0

lesson.id

lesspage_les2_fk R

prevpageid

BIGINT

19

0

nextpageid

BIGINT

19

0

qtype

SMALLINT

5

0

qoption

SMALLINT

5

0

layout

SMALLINT

5

1

display

SMALLINT

5

1

timecreated

BIGINT

19

0

timemodified

BIGINT

19

0

title

VARCHAR

255

contents

LONGTEXT

2147483647

null

contentsformat

TINYINT

3

0

Showing 1 to 13 of 13 entries

Table contained -1 rows

lesson_pages table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
lesspage_les_ix	Performance	Asc	lessonid

Showing 1 to 2 of 2 entries

Lesson Pages Table Schema (lesson_pages)

Description

lesson_pages table columns

lesson_pages table indexes

lesson_pages table relationships

Close relationships within degrees of separation