SQL Schema Explorer by Tim Abell

sqlite-chinook

PlaylistTrack

Nearest Tables

Tap a table in the diagram to jump straight to it. Tap & drag in a gap to pan around. Tap & drag a table to re-arrange the diagram.

Tap the "enable zoom" button, then use the mouse wheel to zoom in to where the mouse pointer is.

Customised table layout is not remembered. Refresh the page to reset the diagram.

Columns

Name Type Nulls Outbound Foreign Key Inbound Foreign Keys Indexes
Primary Key PlaylistId INTEGER NOT NULL Playlist(PlaylistId) IPK_PlaylistTrack
Primary Key TrackId INTEGER NOT NULL Track(TrackId) IFK_PlaylistTrackTrackId IPK_PlaylistTrack

Foreign Keys

Outbound

From To
TrackId Track(TrackId)
PlaylistId Playlist(PlaylistId)

Indexes

Name Columns Unique
IFK_PlaylistTrackTrackId TrackId
IPK_PlaylistTrack PlaylistId,TrackId Unique

Data

Skip to Data Controls Show just the data
sort PlaylistId sort TrackId
15Classical 101 - The Basics 3403Intoitus: Adorate Deum
15Classical 101 - The Basics 3404Miserere mei, Deus
15Classical 101 - The Basics 3405Canon and Gigue in D Major: I. Canon
15Classical 101 - The Basics 3406Concerto No. 1 in E Major, RV 269 "Spring": I. Allegro
15Classical 101 - The Basics 3407Concerto for 2 Violins in D Minor, BWV 1043: I. Vivace
15Classical 101 - The Basics 3408Aria Mit 30 Veränderungen, BWV 988 "Goldberg Variations": Aria
15Classical 101 - The Basics 3409Suite for Solo Cello No. 1 in G Major, BWV 1007: I. Prélude
15Classical 101 - The Basics 3410The Messiah: Behold, I Tell You a Mystery... The Trumpet Shall Sound
15Classical 101 - The Basics 3411Solomon HWV 67: The Arrival of the Queen of Sheba
15Classical 101 - The Basics 3412"Eine Kleine Nachtmusik" Serenade In G, K. 525: I. Allegro
15Classical 101 - The Basics 3413Concerto for Clarinet in A Major, K. 622: II. Adagio
15Classical 101 - The Basics 3414Symphony No. 104 in D Major "London": IV. Finale: Spiritoso
15Classical 101 - The Basics 3415Symphony No.5 in C Minor: I. Allegro con brio
15Classical 101 - The Basics 3416Ave Maria
15Classical 101 - The Basics 3417Nabucco: Chorus, "Va, Pensiero, Sull'ali Dorate"
15Classical 101 - The Basics 3418Die Walküre: The Ride of the Valkyries
15Classical 101 - The Basics 3419Requiem, Op.48: 4. Pie Jesu
15Classical 101 - The Basics 3420The Nutcracker, Op. 71a, Act II: Scene 14: Pas de deux: Dance of the Prince & the Sugar-Plum Fairy
15Classical 101 - The Basics 3421Nimrod (Adagio) from Variations On an Original Theme, Op. 36 "Enigma"
15Classical 101 - The Basics 3422Madama Butterfly: Un Bel Dì Vedremo
15Classical 101 - The Basics 3423Jupiter, the Bringer of Jollity
15Classical 101 - The Basics 3424Turandot, Act III, Nessun dorma!
15Classical 101 - The Basics 3425Adagio for Strings from the String Quartet, Op. 11
15Classical 101 - The Basics 3426Carmina Burana: O Fortuna
15Classical 101 - The Basics 3427Fanfare for the Common Man
Filter
Clear Filter
PlaylistId 15
Page
No earlier pages
No more pages
8715 rows in table
25 rows for this filter
25 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top