10
artists
Anna Schumaker edited this page 2023-05-10 17:00:04 -04:00
Table of Contents
The artists table holds information for artist playlists.
Columns
| Name | Type | Description |
|---|---|---|
| artistid | INTEGER | The unique id of a singe artist |
| propertyid | INTEGER | The rowid of this artist's properties |
| name | TEXT | The name of this artist |
| mbid | TEXT | The MusicBrainz ID of this artist |
Triggers
| Name | When | Description |
|---|---|---|
| artists_insert_trigger | After insert | Create a new row in the playlist_properties table |
| artists_delete_trigger | After delete | Delete this artist's entry in the playlist_properties table |
The artists_view
The artists_view joins the artists table with the playlist_properties table so the application can use one query to access all the relevant state for each artist.
| Column | Description |
|---|---|
| artistid | The artistid of this artist |
| propertyid | The rowid of the playlist_properties for this artist |
| name | The name of this artist |
| mbid | The MusicBrainz ID of this artist |
| active | The active state of this artist |
| loop | The loop state of this artist |
| shuffle | The shuffle state of this artist |
| sort_order | The sort order of this artist |
| current_trackid | The current trackid of this artist |
The artists_tracks_view
The artists_tracks_view joins the artists table with the tracks, system_tracks, and libraries tables to form a list of tracks that belong to each artist, but are not being deleted.
| Column | Description |
|---|---|
| trackid | The trackid of the track |
| artistid | The artistid of this artist |