2 album_artist_link
Anna Schumaker edited this page 2023-05-10 13:25:26 -04:00

The album_artist_link table is used to link albums to their associated artist. This is needed so collaboration albums can show up nested under each of their corresponding artists in the UI.

Columns

Name Type Description
artistid INTEGER The artistid of one of the album's album artists
albumid INTEGER The albumid of the album

The album_artists_view

The album_artists_view is intended to be used for filtering the Artist / Album / Medium tree so an artist can be marked as "visible" if they have a matching album or medium.

Column Description
artistid The artistid of the artist
artist The name of the artist
albumid The albumid of the album
album The name of the album (or "" if name is NULL)
mediumid The mediumid of the medium
medium The name of the medium (or "" if name is NULL)