What table are external links in?

MusicBrainz Development
1

For an artist such as Megan Thee Stallion - Relationships - MusicBrainz, what table are those Wikidata, Wikipedia, etc., links actually stored in? Presumably they’re associated with the gid or the artist ID (1638056), but I can’t quite figure it out. Thanks!

2

Oh, I think I got it. They’re in the url table and can be found with something like:

select url.url from url, l_artist_url where l_artist_url.entity1=url.id AND entity0=1638056

2 Likes
3

Yes. The tables are documented in MusicBrainz Database / Schema - MusicBrainz and the relationship types in Artist-URL Relationship Types - MusicBrainz (where UUID matches gid column of the link_type table).