View Definition: tracks_with_artist

→ Data

Source Diagram

classDiagram
    class artists_item["artists.item"]
    class albums_item["albums.item"]
    class tracks_item["tracks.item"]
            tracks_item --> albums_item : album_id
            albums_item --> artists_item : artist_id

Definition

From

tracks

Join

To On (left = right) As Pre-join where Flatten
albums album_id = id album_matches {of: album_matches, as: album, preserve_empty: false}
artists album.artist_id = id album.artist_matches {of: album.artist_matches, as: album.artist, preserve_empty: false}

Select

Item As
id id
title title
album album

Shape

Type: tracks_with_artist.item

id type required validation metadata
id string yes
title string yes {description: Track title.}
album object yes
album.id string yes
album.title string yes {description: Album title.}
album.artist_id string yes {description: Id of the artist who released this album.}
album.label_id string {description: Id of the label that released this album.}
album.genre_id string {description: Id of the album's primary genre.}
album.year integer yes {description: Year of release.}
album.is_live boolean {description: 'True for concert recordings, false (or omitted) for studio albums.'}
album.liner_notes string {description: Id of the prose record holding this album's liner notes (a contents-relative path without extension). Optional - only some albums have liner notes.}
album.cover string {description: 'Id of the cover-art blob (a contents-relative path, extension included). Optional - only some albums ship cover art.'}
album.artist object yes
album.artist.id string yes
album.artist.name string yes {description: Display name of the artist or band.}
album.artist.country string {description: 'Primary country of operation (free-form, e.g. "Japan").'}
album.artist.formed_year integer {description: Year the act was formed.}
album.artist.bio string {description: Short prose description shown on the artist's page.}
album.artist.members tracks_with_artist.item.album.artist.members.item[] {description: 'Current line-up, keyed by a short slug. Optional - an artist with no settled line-up may omit it or leave it empty.'}

Type: tracks_with_artist.item.album.artist.members.item

id type required validation metadata
id string yes
name string yes {description: Display name of the member.}
instrument string {description: 'Primary instrument or role within the group (e.g. "guitar", "vocals").'}