h5p

0 rows


Description

Stores H5P content information

Columns

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

The content in json format

mainlibraryid BIGINT 19 null
h5p_libraries.id h5p_mai2_fkR

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

Indexes

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

Relationships