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