H5pactivity Attempts Table Schema (h5pactivity_attempts)


Users attempts inside H5P activities

h5pactivity_attempts table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
h5pactivity_attempts_results.attemptid h5paatteresu_att2_fk R
h5pactivityid BIGINT 19 null
h5pactivity.id h5paatte_h5p2_fk R

H5P activity ID

userid BIGINT 19 null
user.id Implied Constraint R

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.

Table contained -1 rows

h5pactivity_attempts table 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

h5pactivity_attempts table relationships