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 19 √ null
lessonid BIGINT 19 0
lesson.id lessatte_les2_fk R
pageid BIGINT 19 0
lesson_pages.id lessatte_pag2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
answerid BIGINT 19 0
lesson_answers.id lessatte_ans2_fk R
retry SMALLINT 5 0
correct BIGINT 19 0
useranswer LONGTEXT 2147483647 √ null
timeseen BIGINT 19 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

Close relationships within degrees of separation