lesson_attempts

0 rows


Description

Defines lesson_attempts

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lessonid BIGINT 19 0
lesson.id lessatte_les2_fkR
pageid BIGINT 19 0
lesson_pages.id lessatte_pag2_fkR
userid BIGINT 19 0
user.id Implied ConstraintR
answerid BIGINT 19 0
lesson_answers.id lessatte_ans2_fkR
retry SMALLINT 5 0
correct BIGINT 19 0
useranswer LONGTEXT 2147483647 null
timeseen BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lessatte_ans2_ix Performance Asc answerid
lessatte_les2_ix Performance Asc lessonid
lessatte_pag2_ix Performance Asc pageid
lessatte_use2_ix Performance Asc userid

Relationships