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
subcontent VARCHAR 128 null
timecreated BIGINT 19 null
interactiontype VARCHAR 128 null
description LONGTEXT 2147483647 null
correctpattern LONGTEXT 2147483647 null
response LONGTEXT 2147483647 null
additionals LONGTEXT 2147483647 null
rawscore BIGINT 19 0
maxscore BIGINT 19 0
duration BIGINT 19 0
completion BIT 1 null
success BIT 1 null

Indexes

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

Relationships