Difference between revisions of "History:Next Generation Schema/Release Relationships Conversion"

From MusicBrainz Wiki
(Album--URL: relationships presumably added since this table was created)
Line 1: Line 1:
==Album--Album==
+
== Legend ==
 +
{|
 +
|-
 +
| style="background:lightblue" | To ReleaseGroup
 +
| style="background:lightgreen" | To Release
 +
|}
 +
 
 +
==Album-Album==
  
{| border="1"
+
{| width='80%'
 +
! AR Type
 +
!     Now    
 +
!     NGS    
 +
!     Comment    
 
|-
 
|-
|  DJ-mix  |album--album || release_group--release_group ||   
+
|  DJ-mix   
 +
Album-Album  
 +
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup ?   
 +
|   
 
|-
 
|-
|  earliest release  |album--album || |drop the link
+
|  earliest release   
 +
Album-Album  
 +
| align="center" style="background:lightgreen" | Release-Release  
 +
Link should be dropped
 
|-
 
|-
|  live performance  |album--album || release_group-release_group ?  |
+
|  live performance   
 +
Album-Album  
 +
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup ?   
 +
|
 
|-
 
|-
|  remaster  |album--album || release-release ||  will need manual fixing  
+
|  remaster   
 +
Album-Album  
 +
| align="center" style="background:lightgreen" | Release-Release ?   
 +
|  will need manual fixing  
 
|-
 
|-
|  cover  |album--album || release_group-release_group ||   
+
|  cover   
 +
Album-Album  
 +
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup  
 +
|   
 
|-
 
|-
|  transl-tracklisting  |album--album || release-release ||  partially automatic using release data  
+
|  transl-tracklisting   
 +
Album-Album  
 +
| align="center" style="background:lightgreen" | Release-Release  
 +
|  partially automatic using release data  
 
|-
 
|-
|  remix  |album--album || release_group-release_group ||   
+
|  remix   
 +
Album-Album  
 +
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup  
 +
|   
 
|-
 
|-
|  mashes up  |album--album || release_group-release_group ||   
+
|  mashes up   
 +
Album-Album  
 +
| align="center" style="background:lightblue" | ReleaseGroup-ReleaseGroup  
 +
|   
 
|-
 
|-
|  part of set  |album--album || |merge the (NGS) releases and drop the link, partially automatic using release data  
+
|  part of set   
 +
Album-Album  
 +
| align="center" style="background:lightgreen" | Release-Release  
 +
Merge the (NGS) releases, partially automatic using release data. Link should be dropped once manual fixing has been done.
 
|}
 
|}
  
  
  
==Album--Artist==
+
==Album-Artist==
  
For reference: [http://musicbrainz.org/edit/relationships/link_types.html?type=album-artist current AR tree for album--artist] (with links to each AR type documentation)
+
For reference: [http://musicbrainz.org/edit/relationships/link_types.html?type=album-artist current AR tree for Album-Artist] (with links to each AR type documentation)
  
{| border="1"
+
{| width='80%'
 +
! AR Type
 +
!     Now    
 +
!     NGS    
 +
!     Comment    
 
|-
 
|-
|  compiler  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  compiler   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  mix-DJ  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  mix-DJ   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  performer (instrument or vocal) |album--artist || artist--release || add to all releases and manual fixing?   
+
|  performer (instrument or vocal)  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
| add to all releases and manual fixing?   
 
|-
 
|-
|  performing orchestra |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  performing orchestra  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  conductor |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  conductor  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  chorus master |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  chorus master  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  tribute |album--artist || artist--release_group ||  
+
|  tribute  
 +
Album-Artist  
 +
| align="center" style="background:lightblue" | Artist-ReleaseGroup
 +
|  
 
|-
 
|-
|  remixer |album--artist || artist--release ?  ||  add to all releases and manual fixing?
+
|  remixer  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
| Add to all releases and manual fixing?
 
|-
 
|-
|  samples from artist |album--artist || artist--release ||   
+
|  samples from artist  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|   
 
|-
 
|-
|  composer |album--artist ||    ||   
+
|  composer  
 +
Album-Artist  
 +
|     
 +
|   
 
|-
 
|-
|  librettist |album--artist ||    ||   
+
|  librettist  
 +
Album-Artist  
 +
|     
 +
|   
 
|-
 
|-
|  arranger, instrumentator & orchestrator |album--artist ||    ||   
+
|  arranger, instrumentator & orchestrator  
 +
Album-Artist  
 +
|     
 +
|   
 
|-
 
|-
|  lyricist |album--artist ||    ||   
+
|  lyricist  
 +
Album-Artist  
 +
|     
 +
|   
 
|-
 
|-
|  producer |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  producer  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  engineer (and all subtypes) |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  engineer (and all subtypes)  
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  legal representation  |album--artist || artist--release_group ||  
+
|  legal representation   
 +
Album-Artist  
 +
| align="center" style="background:lightblue" | Artist-ReleaseGroup  
 +
|  
 
|-
 
|-
|  booking  |album--artist || artist--release_group ||  
+
|  booking   
 +
Album-Artist  
 +
| align="center" style="background:lightblue" | Artist-ReleaseGroup  
 +
|  
 
|-
 
|-
|  artists and repertoire  |album--artist |||  
+
|  artists and repertoire   
 +
Album-Artist  
 +
|   
 +
|  
 
|-
 
|-
|  creative direction  |album--artist || artist--release_group ||  
+
|  creative direction   
 +
Album-Artist  
 +
| align="center" style="background:lightblue" | Artist-ReleaseGroup
 +
|  
 
|-
 
|-
|  art direction  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  art direction   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  design/illustration  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  design/illustration   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  graphic design  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  graphic design   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  photography  |album--artist || artist--release ||  add to all releases and manual fixing?
+
|  photography   
 +
Album-Artist  
 +
| align="center" style="background:lightgreen" | Artist-Release ?   
 +
|  add to all releases and manual fixing?
 
|-
 
|-
|  travel |album--artist || artist--release_group ||  
+
|  travel  
 +
Album-Artist  
 +
| align="center" style="background:lightblue" | Artist-ReleaseGroup  
 +
|  
 
|-
 
|-
|  publishing  |album--artist |||  
+
|  publishing   
 +
Album-Artist  
 +
|   
 +
|  
 
|-
 
|-
|  merchandise  |album--artist |||  
+
|  merchandise   
 +
Album-Artist  
 +
|   
 +
|  
 
|-
 
|-
|  liner notes  |album--artist |||  
+
|  liner notes   
 +
Album-Artist  
 +
|   
 +
|  
 
|}
 
|}
  
 
==Album--Label==
 
==Album--Label==
  
{| border="1"
+
{| width='80%'
 +
! AR Type
 +
!     Now    
 +
!     NGS    
 +
!     Comment    
 
|-
 
|-
|  publishing  |album--label ||  ?  
+
|  publishing   
 +
Album-Label  
 +
|  ?
 +
|
 
|}
 
|}
  
 
==Album--Track==
 
==Album--Track==
  
{| border="1"
+
{| width='80%'
 +
! AR Type
 +
!     Now    
 +
!     NGS    
 +
!     Comment    
 
|-
 
|-
|  samples material  |album--track ||  ?  
+
|  samples material   
 +
Album-Track  
 +
|  ?  
 +
|
 
|}
 
|}
  
==Album--URL==
+
==Album-URL==
  
{| border="1"
+
{| width='80%'
 +
! AR Type
 +
!     Now    
 +
!     NGS    
 +
!     Comment    
 
|-
 
|-
amazon asin  |album--url || release-url ||  partially automatic matching using barcodes  
+
Amazon asin   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
|  partially automatic matching using barcodes  
 
|-
 
|-
|  cover art link  |album--url || release-url |add to all releases and manual fixing?
+
|  cover art link   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
Add to all releases and manual fixing
 
|-
 
|-
|  review  |album--url || release_group--url ||  ok
+
|  review   
 +
Album-URL  
 +
| align="center" style="background:lightblue" | ReleaseGroup-URL  
 +
|  
 
|-
 
|-
|  purchase for mail-order  |album--url || release--url ||  add to all releases and manual fixing?  
+
|  purchase for mail-order   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
|  add to all releases and manual fixing?  
 
|-
 
|-
|  purchase for download  |album--url || release--url ||  add to all releases and manual fixing?  
+
|  purchase for download   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
|  add to all releases and manual fixing?  
 
|-
 
|-
|  download for free  |album--url || release--url ||  add to all releases and manual fixing?  
+
|  download for free   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
|  add to all releases and manual fixing?  
 
|-
 
|-
|  creative commons licensed download  |album--url || release--url ||  add to all releases and manual fixing?  
+
|  creative commons licensed download   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL  
 +
|  add to all releases and manual fixing?  
 
|-
 
|-
|  IMDb, ibdb, iobdb |album--url || release_group-url ||  ok  
+
|  IMDb, ibdb, iobdb  
 +
Album-URL  
 +
| align="center" style="background:lightblue" | ReleaseGroup-URL  
 +
|  ok  
 
|-
 
|-
|  wikipedia  |album--url || release_group--url ||  ok  
+
|  wikipedia   
 +
Album-URL  
 +
| align="center" style="background:lightblue" | ReleaseGroup-URL  
 +
|  ok  
 
|-
 
|-
 
| rowspan="2"| discogs   
 
| rowspan="2"| discogs   
| rowspan="2"| album--url  
+
| rowspan="2"| Album-URL  
| release--url for discogs.com/release/XXX urls  
+
| align="center" style="background:lightgreen" | Release-URL for discogs.com/release/XXX urls  
 
| partially automatic matching using label/cat#  
 
| partially automatic matching using label/cat#  
 
|-
 
|-
| release_group--url for discogs.com/master/XXX urls  
+
| align="center" style="background:lightblue" | ReleaseGroup-URL for discogs.com/master/XXX urls  
 
| ok
 
| ok
 
|-
 
|-
|  musicmoz  |album--url || release--url ||  add to all releases and manual fixing
+
|  musicmoz   
 +
Album-URL  
 +
| align="center" style="background:lightgreen" | Release-URL ?   
 +
|  add to all releases and manual fixing
 
|-
 
|-
| lyrics || album--url || ? || ?
+
| lyrics  
 +
| Album-URL
 +
| ?  
 +
| ?
 
|-
 
|-
| IMDb samples || album--url || ? || ?
+
| IMDb samples  
 +
| Album-URL
 +
| ?  
 +
| ?
 
|-
 
|-
| recording studio || album--url || ? || ?
+
| recording studio  
 +
| Album-URL
 +
| ?  
 +
| ?
 
|-
 
|-
| score || album--url || ? || ?
+
| score  
 +
| Album-URL
 +
| ?  
 +
| ?
 
|-
 
|-
| streaming music || album--url || ? || ?
+
| streaming music  
 +
| Album-URL
 +
| ?  
 +
| ?
 
|}
 
|}

Revision as of 23:55, 18 November 2010

Legend

To ReleaseGroup To Release

Album-Album

AR Type     Now         NGS         Comment    
DJ-mix Album-Album ReleaseGroup-ReleaseGroup ?
earliest release Album-Album Release-Release Link should be dropped
live performance Album-Album ReleaseGroup-ReleaseGroup ?
remaster Album-Album Release-Release ? will need manual fixing
cover Album-Album ReleaseGroup-ReleaseGroup
transl-tracklisting Album-Album Release-Release partially automatic using release data
remix Album-Album ReleaseGroup-ReleaseGroup
mashes up Album-Album ReleaseGroup-ReleaseGroup
part of set Album-Album Release-Release Merge the (NGS) releases, partially automatic using release data. Link should be dropped once manual fixing has been done.


Album-Artist

For reference: current AR tree for Album-Artist (with links to each AR type documentation)

AR Type     Now         NGS         Comment    
compiler Album-Artist Artist-Release ? add to all releases and manual fixing?
mix-DJ Album-Artist Artist-Release ? add to all releases and manual fixing?
performer (instrument or vocal) Album-Artist Artist-Release ? add to all releases and manual fixing?
performing orchestra Album-Artist Artist-Release ? add to all releases and manual fixing?
conductor Album-Artist Artist-Release ? add to all releases and manual fixing?
chorus master Album-Artist Artist-Release ? add to all releases and manual fixing?
tribute Album-Artist Artist-ReleaseGroup
remixer Album-Artist Artist-Release ? Add to all releases and manual fixing?
samples from artist Album-Artist Artist-Release ?
composer Album-Artist
librettist Album-Artist
arranger, instrumentator & orchestrator Album-Artist
lyricist Album-Artist
producer Album-Artist Artist-Release ? add to all releases and manual fixing?
engineer (and all subtypes) Album-Artist Artist-Release ? add to all releases and manual fixing?
legal representation Album-Artist Artist-ReleaseGroup
booking Album-Artist Artist-ReleaseGroup
artists and repertoire Album-Artist
creative direction Album-Artist Artist-ReleaseGroup
art direction Album-Artist Artist-Release ? add to all releases and manual fixing?
design/illustration Album-Artist Artist-Release ? add to all releases and manual fixing?
graphic design Album-Artist Artist-Release ? add to all releases and manual fixing?
photography Album-Artist Artist-Release ? add to all releases and manual fixing?
travel Album-Artist Artist-ReleaseGroup
publishing Album-Artist
merchandise Album-Artist
liner notes Album-Artist

Album--Label

AR Type     Now         NGS         Comment    
publishing Album-Label ?

Album--Track

AR Type     Now         NGS         Comment    
samples material Album-Track ?

Album-URL

AR Type     Now         NGS         Comment    
Amazon asin Album-URL Release-URL partially automatic matching using barcodes
cover art link Album-URL Release-URL Add to all releases and manual fixing
review Album-URL ReleaseGroup-URL
purchase for mail-order Album-URL Release-URL add to all releases and manual fixing?
purchase for download Album-URL Release-URL add to all releases and manual fixing?
download for free Album-URL Release-URL add to all releases and manual fixing?
creative commons licensed download Album-URL Release-URL add to all releases and manual fixing?
IMDb, ibdb, iobdb Album-URL ReleaseGroup-URL ok
wikipedia Album-URL ReleaseGroup-URL ok
discogs Album-URL Release-URL for discogs.com/release/XXX urls partially automatic matching using label/cat#
ReleaseGroup-URL for discogs.com/master/XXX urls ok
musicmoz Album-URL Release-URL ? add to all releases and manual fixing
lyrics Album-URL ? ?
IMDb samples Album-URL ? ?
recording studio Album-URL ? ?
score Album-URL ? ?
streaming music Album-URL ? ?