# h5pactivity_attempts

0 rows

### Description

Users attempts inside H5P activities

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
h5pactivity_attempts_results.attemptid | h5paatteresu_att2_fkR
h5pactivityid | BIGINT | 19 |  |  | null |  |
h5pactivity.id | h5paatte_h5p2_fkR
| H5P activity ID
userid | BIGINT | 19 |  |  | null |  |  | Attempt user ID
timecreated | BIGINT | 19 |  |  | null |  |  |
timemodified | BIGINT | 19 |  |  | null |  |  |
attempt | MEDIUMINT | 7 |  |  | 1 |  |  | Attempt number
rawscore | BIGINT | 19 | √ |  | 0 |  |  |
maxscore | BIGINT | 19 | √ |  | 0 |  |  |
scaled | DECIMAL | 10,5 |  |  | 0.00000 |  |  | Number 0..1 that reflects the performance of the learner
duration | BIGINT | 19 | √ |  | 0 |  |  | Number of second inverted in that attempt (provided by the statement)
completion | BIT | 1 | √ |  | null |  |  | Store the xAPI tracking completion result.
success | BIT | 1 | √ |  | null |  |  | Store the xAPI tracking success result.

### Indexes

Constraint Name | Type | Sort | Column(s)
--- | --- | --- | ---
PRIMARY | Primary key | Asc | id
h5paatte_h5p_ix | Performance | Asc | h5pactivityid
h5paatte_h5ptim_ix | Performance | Asc/Asc | h5pactivityid + timecreated
h5paatte_h5puse_ix | Performance | Asc/Asc | h5pactivityid + userid
h5paatte_h5puseatt_uix | Must be unique | Asc/Asc/Asc | h5pactivityid + userid + attempt
h5paatte_tim_ix | Performance | Asc | timecreated

### Relationships