H5p Contents Libraries Table Schema (h5p_contents_libraries)


Description

Store which library is used in which content.

h5p_contents_libraries table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
h5pid BIGINT 19 null
h5p.id h5pcontlibr_h5p2_fk R

Identifier for the h5p content
libraryid BIGINT 19 null
h5p_libraries.id h5pcontlibr_lib2_fk R

The identifier of a H5P library this content uses
dependencytype VARCHAR 10

dynamic, preloaded or editor
dropcss BIT 1 null

1 if the preloaded css from the dependency is to be excluded
weight BIGINT 19 null

Determines the order in which the preloaded libraries will be loaded

Table contained -1 rows

h5p_contents_libraries table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
h5pcontlibr_h5p_ix Performance Asc h5pid
h5pcontlibr_lib_ix Performance Asc libraryid

h5p_contents_libraries table relationships

Close relationships within degrees of separation