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