View Definition: albums_by_genre
→ Data
Source Diagram
classDiagram
class albums_item["albums.item"]
Definition
From
albums
Grouped by
genre_id (as albums)
Select
| Item |
As |
| genre_id |
id |
| genre_id |
genre_id |
| albums |
albums |
Shape
Type: albums_by_genre.item
| id |
type |
required |
validation |
metadata |
id |
string |
|
|
{description: Id of the album's primary genre.} |
genre_id |
string |
|
|
{description: Id of the album's primary genre.} |
albums |
albums_by_genre.item.albums.item[] |
yes |
|
|
Type: albums_by_genre.item.albums.item
| id |
type |
required |
validation |
metadata |
id |
string |
yes |
|
|
title |
string |
yes |
|
{description: Album title.} |
artist_id |
string |
yes |
|
{description: Id of the artist who released this album.} |
label_id |
string |
|
|
{description: Id of the label that released this album.} |
genre_id |
string |
|
|
{description: Id of the album's primary genre.} |
year |
integer |
yes |
|
{description: Year of release.} |
is_live |
boolean |
|
|
{description: 'True for concert recordings, false (or omitted) for studio albums.'} |
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.} |
cover |
string |
|
|
{description: 'Id of the cover-art blob (a contents-relative path, extension included). Optional - only some albums ship cover art.'} |