View Definition: playlist_entries
→ Data
Source Diagram
classDiagram
class tracks_item["tracks.item"]
class playlist_tracks_item["playlist_tracks.item"]
playlist_tracks_item --> tracks_item : track_id
Definition
From
playlist_tracks
Join
| To |
On (left = right) |
As |
Pre-join where |
Flatten |
| tracks |
track_id = id |
track_matches |
|
{of: track_matches, as: track, preserve_empty: false} |
Select
| Item |
As |
| playlist_id |
playlist_id |
| position |
position |
| track |
track |
Shape
Type: playlist_entries.item
| id |
type |
required |
validation |
metadata |
playlist_id |
string |
yes |
|
{description: Id of the playlist this entry belongs to.} |
position |
integer |
yes |
|
{description: 1-indexed playback position within the playlist.} |
track |
object |
yes |
|
|
track.id |
string |
yes |
|
|
track.title |
string |
yes |
|
{description: Track title.} |
track.album_id |
string |
yes |
|
{description: Id of the album this track appears on.} |
track.track_no |
integer |
yes |
|
{description: 'Position of the track within the album, 1-indexed.'} |
track.duration_sec |
integer |
|
|
{description: Duration in whole seconds.} |