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 10 null
lesson_attempts.answerid lessatte_ans2_fk R
lessonid bigint 10 0
lesson.id lessansw_les2_fk R
pageid bigint 10 0
lesson_pages.id lessansw_pag2_fk R
jumpto bigint 11 0
grade smallint 4 0
score bigint 10 0
flags smallint 3 0
timecreated bigint 10 0
timemodified bigint 10 0
answer longtext 2147483647 null
answerformat tinyint 2 0
response longtext 2147483647 null
responseformat tinyint 2 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