H5pactivity Attempts Results Table Schema (h5pactivity_attempts_results)


H5Pactivities_attempts tracking info

h5pactivity_attempts_results table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
attemptid BIGINT 19 null
h5pactivity_attempts.id h5paatteresu_att2_fk R

h5pactivity_attempts ID

subcontent VARCHAR 128 null
timecreated BIGINT 19 null
interactiontype VARCHAR 128 null
description LONGTEXT 2147483647 null
correctpattern LONGTEXT 2147483647 null

Correct Pattern in xAPI format

response LONGTEXT 2147483647 null

User response data in xAPI format

additionals LONGTEXT 2147483647 null

Extra subcontent information in JSON format

rawscore BIGINT 19 0
maxscore BIGINT 19 0
duration BIGINT 19 0

Seconds inverted in this result (exctracted directly from 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_results table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
h5paatteresu_att_ix Performance Asc attemptid
h5paatteresu_atttim_ix Performance Asc/Asc attemptid + timecreated

h5pactivity_attempts_results table relationships