Talk:MusicBrainz Database/Schema

From MusicBrainz Wiki
Revision as of 19:43, 8 July 2009 by (talk)
Jump to navigationJump to search

One work in several tracks?

Could you clarify how one work can be split up in several tracks like in classical works? pronik 08:57, 7 April 2009 (UTC)

Let's say you have work "A" and tracks "A1", "A2", "A3", then you simply add ARs between A1->A, A2->A and A3->A. LukasLalinsky 09:13, 7 April 2009 (UTC)
What about order and work part <-> track relationship? How do we know that A2 is the second part of A? pronik 11:32, 7 April 2009 (UTC)
We don't, that's a known limitation and it's meant to be solved by the next version (something like, where you explicitly specify the attribute (part number, symphony number, anything defined by the work type). LukasLalinsky 11:35, 7 April 2009 (UTC)


  • Is it a good idea to rename 'modpending' to 'editpending', to catch up with current terminology? --zout 07:55, 21 April 2009 (UTC)


  • Is it possible to have ARs for release groups that do not apply to specific discs? I have a box set with previously released albums. The box set has liner notes unique to the box. --zout 23:36, 25 April 2009 (UTC)
No, release groups actually won't know anything about discs. Some box sets will still be tricky to represent in the database. Lukáš Lalinský 06:44, 29 April 2009 (UTC)
With 'discs', I meant 'albums'. Am not yet familiar with the correct terminology. My case: I have releases Bob Dylan and Live at The Gaslight 1962 (and 8 other albums) in a box set. That box set has liner notes only available in that box set. Can I link an AR to the writer of the liner notes for the box set only? --zout 11:24, 29 April 2009 (UTC)
  • Is it possible to have more than one label/catalog number combination for a single release event? And are separate catalog numbers for discs supported? --zout 23:36, 25 April 2009 (UTC)
Yes, one release can have multiple label/catalog number pairs. And yes, these pairs will be linked to release mediums, which will effectively allow for this. Lukáš Lalinský 06:44, 29 April 2009 (UTC)
  • Why do we have a table called track and a table called recording? What purpose do they serve?
I think the NGS page explains it well. Lukáš Lalinský 19:45, 7 July 2009 (UTC)
  • Why does the recording table have an artist_credit that is not an FK and track does as well, but there its not an FK? Is this a graph error?
Error in the diagram, it's fixed now. Lukáš Lalinský 19:45, 7 July 2009 (UTC)
  • Why do both recording and track have an artist_credit and name?
Because that's what humans tend to use as identifiers. :) They normally wouldn't know "b98ee5f2-0b07-4da6-913c-acfe19d4578d", but they mostly likely do know what "Thriller by Michael Jackson" is. That's for recordings. I think it's obvious why tracks need to have artist credits and names. Lukáš Lalinský 19:45, 7 July 2009 (UTC)