History talk:Next Generation Schema/Release Editor

Open questions about the schema:

• 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)

(Can we please move this discussion to Talk:Next Generation Schema? Lukáš Lalinský 19:45, 7 July 2009 (UTC))