lesson_answers

0 rows


Description

Defines lesson_answers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lesson_attempts.answerid lessatte_ans2_fkR
lessonid BIGINT 19 0
lesson.id lessansw_les2_fkR
pageid BIGINT 19 0
lesson_pages.id lessansw_pag2_fkR
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

Indexes

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

Relationships