I’m performing some music consolidation against the Musicbrainz Database dump mbdump.tar.bz2 and I’ve identifed most of the things I’m looking for, but what I can’t work out is how to link Genres to release groups.
There’s a table called genre which lists all the valid genres but I can’t find the associated table, and it’s not mentioned in the schema (https://musicbrainz.org/doc/MusicBrainz_Database/Schema).
I had seen reference to tags but there aren’t any tables named like that in the export (mbdump.tar.bz2). Maybe they’re not exported, or there’s another to download?
It looks like the release id (first column from mbdump.release_group) links to mbdump-derived.release_group_tag which in turn links to mbdump-derived.tag to give you the literal translation. My guess is that the Musicbrainz approved list of genres is from mbdump.genre.