0 rows


Stores the h5pactivity activity module instances.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
h5pactivity_attempts.h5pactivityid h5paatte_h5p2_fkR
course BIGINT 19 null
course.id h5pa_cou2_fkR

ID of the course this activity is part of.

name VARCHAR 255

The name of the activity module instance

timecreated BIGINT 19 null

Timestamp of when the instance was added to the course.

timemodified BIGINT 19 null

Timestamp of when the instance was last modified.

intro LONGTEXT 2147483647 null

Activity description.

introformat SMALLINT 5 0

The format of the intro field.

grade BIGINT 19 0
displayoptions SMALLINT 5 0

H5P Button display options

enabletracking BIT 1 1

Enable xAPI tracking

grademethod SMALLINT 5 1

Which H5P attempt is used for grading

reviewmode SMALLINT 5 1


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
h5pa_cou2_ix Performance Asc course