Topic: Help with mapping...
I am looking at building a music based website and I wanted to use the mb database for importing artists, albums, and songs into my own database for use on the site.
I had a few questions about how I might map the data:
1) I've noticed that in the artist table the 'id' field isn't a unique identifier. Would it be better to use the artist_credit table to use as a basis for artists? Mainly b/c the 'id' field is a unique identifier and the artist_credit id maps to releases and tracks/recordings.
2) I've been using the track table for songs. Is the the advised way to extract songs or would the recording table be better fitted to do so. I assumed track would be better b/c contains the tracklist field which can be used to map the songs to the albums they belong to.
3) Which brings me to my third question, I've noticed that some of the track table records have tracklist id's that don't exist in the tracklist table, making it impossible(as far as I can see) to map the song to it's album. Does this mean those songs are singles? Or is there an issue with some of the track table records?