Entity Definition: playlist_tracks

→ Data

Type Diagram

classDiagram
    class playlist_tracks_item["playlist_tracks.item"] {
          *playlist_id : string [FK]
          *track_id : string [FK]
          *position : integer
    }
    class tracks_item["tracks.item"]
    class playlists_item["playlists.item"]
        playlist_tracks_item --> playlists_item : playlist_id
        playlist_tracks_item --> tracks_item : track_id

Entity: playlist_tracks

Type: playlist_tracks.item

metadata

description: Membership link between a playlist and a track. The position field gives
  playback order within the playlist. Stored as an array (not a map) because no entry
  has a natural single-field key.

attributes

id type required references validation metadata
playlist_id string yes playlists.id {description: Id of the playlist this entry belongs to.}
track_id string yes tracks.id {description: Id of the track included in the playlist.}
position integer yes {description: 1-indexed playback position within the playlist.}