Release event country

MusicBrainz Development
,
1

I see that release_country and release_unknown_country give the release event information. But there’s no country table. There’s a country_area table, but it only has a single field, which is area. Is that simply to join to the area table and get only countries, and the country field in release_country is actually the id from area?

Also… I see that you have a css file with all the country flags in it that you use to display the flag next to the name of the country. But where do you pull the country abbreviation from? I don’t see that in any of the tables.

2

Correct, country_area just defines which area IDs are countries. The comments in CreateTables.sql will tell you which tables are referenced by each column.

The country abbreviations come the code column of the iso_3166_1 table.

3 Likes