Skip to content

Song additional artists

One other artist credited on a song.

This page is the dictionary for the table. It holds the definition and purpose of every field, and it is where a field is changed.

Fields

Field Key Type Required Allowed values or link Definition Purpose Notes
Song SONG_ADDITIONAL_ARTISTS.SONG Link to one row Yes Row of Songs A link to the Songs row. Says which song the credit belongs to.
Artist SONG_ADDITIONAL_ARTISTS.ARTIST Link to one row Yes Row of Artists A link to the credited artist (feat., with). Credits an artist in the tags without putting the name in a file name.
Position SONG_ADDITIONAL_ARTISTS.POSITION Whole number Yes The place of the credit, counted from 1, after the song's main performer. Keeps the order of the ARTISTS tag.

Constraints

What the database enforces on each field, beyond its type. A field that is not listed has no default, no uniqueness, no range and no reference. Every field marked Required is NOT NULL.

Field Default Unique Range or pattern Refers to
Song core_Songs
Artist core_Artists
Position 1 or more

Rules across fields:

  • A song and artist pair appears once.
  • The song's own performer (Track_Artist) is never repeated here.

The table is core_Song_Additional_Artists. Every link refuses a missing target and refuses the deletion of a row that another row still points to.