H5pactivity Table Schema (h5pactivity)


Stores the h5pactivity activity module instances.

h5pactivity table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
h5pactivity_attempts.h5pactivityid h5paatte_h5p2_fk R
course BIGINT 19 null
course.id h5pa_cou2_fk R

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

Table contained -1 rows

h5pactivity table indexes

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

h5pactivity table relationships