Lesson Answers Table Schema (lesson_answers)


Description

Defines lesson_answers

lesson_answers table columns

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

Table contained -1 rows

lesson_answers table indexes

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

lesson_answers table relationships

Close relationships within degrees of separation