Uploaded image for project: 'MusicBrainz Server'
  1. MusicBrainz Server
  2. MBS-10055

Refactor ISRC and ISWC tables to have one entry per ISRC/ISWC

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Schema Change
    • Labels:
      None

      Description

      Currently our ISWC and ISRC tables store ISWC-work and ISRC-recording pairs, respectively. This means that even though we have pages such as https://musicbrainz.org/isrc/USSM19932777 (that can list multiple codes), there isn't one DB row nor one DB id for this ISRC.

      This is blocking MBS-7406 and would in general make our DB structure match the way we actually think about and use the codes.

      We should move the work and recording association out of the ISRC and ISWC tables, and onto their own iswc_work and isrc_recording tables.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                reosarevok Nicolás Tamargo
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Packages

                  Version Package