H5p Table Schema (h5p)


Stores H5P content information

h5p table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
h5p_contents_libraries.h5pid h5pcontlibr_h5p2_fk R
jsoncontent LONGTEXT 2147483647 null

The content in json format

mainlibraryid BIGINT 19 null
h5p_libraries.id h5p_mai2_fk R

The library we first instanciate for this node

displayoptions SMALLINT 5 null

H5P Button display options

pathnamehash VARCHAR 40

Defines the complete unique hash for the file path where the H5P content was added.

contenthash VARCHAR 40

Defines the hash for the file content.

filtered LONGTEXT 2147483647 null

Filtered version of json_content

timecreated BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

h5p table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
h5p_mai_ix Performance Asc mainlibraryid

h5p table relationships