# 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 |  |  |
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_ans_ix | Performance | Asc | answerid
lessatte_les_ix | Performance | Asc | lessonid
lessatte_pag_ix | Performance | Asc | pageid
lessatte_use_ix | Performance | Asc | userid

### Relationships