*_h5p_contents table and mapping to *_h5p_tags

Submitted by pnorway20277 on Wed, 03/19/2025 - 07:47
Forums: 
Developers

I'm trying to find the mapping between the content and the tags.

But I cannot see the usage of a foreign key in *_h5p_contents table that (would) map to *_h5p_tags?

What am I missing..?

I also tried to find the database schema for H5P that show all key dependencies, but can't find it on the site.

Any help would be great, thanks.

otacke's picture

otacke

Wed, 03/19/2025 - 22:16

It's an n:m relationship: a content can have multiple tags, and a tag can be assigned to multiple contents. Ergo, you cannot sensibly use foreign keys directly. There must be a lookup table ... Well, *_h5p_contents_tags is what you're looking for.