h5pactivity_attempts_results

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 14 entries

Indexes

Search:

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

Showing 1 to 3 of 3 entries

Relationships

Close relationships within degrees of separation

One
Two degrees

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation