Lesson Answers table / lesson_answers - Moodle LMS 3.9 Database schema / Zoola Analytics

lesson_answers table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

lesson_attempts.answerid

lessatte_ans2_fk R

lessonid

BIGINT

19

0

lesson.id

lessansw_les2_fk R

pageid

BIGINT

19

0

lesson_pages.id

lessansw_pag2_fk R

jumpto

BIGINT

19

0

grade

SMALLINT

5

0

score

BIGINT

19

0

flags

SMALLINT

5

0

timecreated

BIGINT

19

0

timemodified

BIGINT

19

0

answer

LONGTEXT

2147483647

√

null

answerformat

TINYINT

3

0

response

LONGTEXT

2147483647

√

null

responseformat

TINYINT

3

0

Showing 1 to 13 of 13 entries

Table contained -1 rows

lesson_answers table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
lessansw_les_ix	Performance	Asc	lessonid
lessansw_pag_ix	Performance	Asc	pageid

Showing 1 to 3 of 3 entries

Lesson Answers Table Schema (lesson_answers)

Description

lesson_answers table columns

lesson_answers table indexes

lesson_answers table relationships

Close relationships within degrees of separation