7
albums
Anna Schumaker edited this page 2023-05-10 16:57:10 -04:00
Table of Contents
The albums table holds information for album playlists.
Columns
| Name | Type | Description |
|---|---|---|
| albumid | INTEGER | The unique id of a singe album |
| propertyid | INTEGER | The rowid of this album's properties |
| name | TEXT | The name of this album |
| artist | TEXT | The name of the album artist for this album |
| release | TEXT | The release date of the album |
| cover | PATH | The path of this album's cover.jpg file |
| mbid | TEXT | The MusicBrainz ID of this album |
Triggers
| Name | When | Description |
|---|---|---|
| albums_insert_trigger | After insert | Create a new row in the playlist_properties table |
| albums_delete_trigger | After delete | Delete this albums's entry in the playlist_properties table |
The albums_view
The albums_view joins the albums table with the playlist_properties table so the application can use one query to access all the relevant state for each album.
| Column | Description |
|---|---|
| albumid | The albumid of this album |
| propertyid | The rowid of the playlist_properties for this album |
| name | The name of this album |
| mbid | The MusicBrainz ID of this album |
| artist | The name of the album artist for this album |
| release | The release date of the album |
| cover | The path of this album's cover.jpg file |
| active | The active state of this album |
| loop | The loop state of this album |
| shuffle | The shuffle state of this album |
| sort_order | The sort order of this album |
| current_trackid | The current trackid of this album |
The album_tracks_view
The album_tracks_view joins the albums table with the tracks, media, and libraries tables to form a list of tracks that belong to each album, but are not being deleted.
| Column | Description |
|---|---|
| trackid | The trackid of the track |
| albumid | The albumid of this album |