Lesson Attempts Table Schema (lesson_attempts)


Description

Defines lesson_attempts

lesson_attempts table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
lessonid bigint 10 0
lesson.id lessatte_les2_fk R
pageid bigint 10 0
lesson_pages.id lessatte_pag2_fk R
userid bigint 10 0
user.id Implied Constraint R
answerid bigint 10 0
lesson_answers.id lessatte_ans2_fk R
retry smallint 3 0
correct bigint 10 0
useranswer longtext 2147483647 null
timeseen bigint 10 0

Table contained -1 rows

lesson_attempts table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lessatte_ans_ix Performance Asc answerid
lessatte_les_ix Performance Asc lessonid
lessatte_pag_ix Performance Asc pageid
lessatte_use_ix Performance Asc userid

lesson_attempts table relationships