h5pactivity_attempts_results

0 rows


Description

H5Pactivities_attempts tracking info

Columns

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

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 3 √ NULL

Store the xAPI tracking completion result.

success BIT 3 √ NULL

Store the xAPI tracking success result.

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

Relationships