From MusicBrainz Wiki

Products > Database > DatabaseDocumentation > DatabaseSchema > Artists

[edit] Database Schema: Artists

See the Database Schema page for an overview of the MusicBrainz Database and links to pages which describe each parts of the schema in more detail (like this page).

• Each artist has one row in the artist table. There are two "special" artists: the Various Artists artist (id = ModDefs::VARTIST_ID), which is used to represent a release where the release artist is different than one or more of the track artists (see ReleaseArtistStyle), and the "Deleted Artist" (id = ModDefs::DARTIST_ID), which is used to maintain referential integrity when an artist is deleted (all the relations that pointed to the deleted artists are moved to the "deleted artist").
• artistalias stores one row for each entered alias (most artists don't have aliases). Each alias references a particular artist.
• artist_relation stores a one to many related artists (not AdvancedRelationships), but how similar these artists are to the current artist. This data is provided by Agent Arts.

Categories: To Be Reviewed | WikiDocs Page | Development