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