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