When an artist performs another artists song


#1

Hi there, I’ve been trying to find in the DB schema, where the relationship for ‘covers’ is, if there’s any.

For instance:

“Live and let die”, a song recorded by Guns N Roses, is included in the release “Use your Illusion I”, which is credited to Guns N Roses, same as all tracks. Check for example “select * from track where medium = 673520”

However, i couldn’t find anywhere the fact that that song, was originally written by Paul McCartney.

Am I failing to see it?
cheers

Fede


#2

The cover relationship is a recording-work relationship. You’ll have to create a work if none exists yet, add the writer(s) and link it to the original recording(s) (as recording of) and to the cover recordings (as cover recording of).