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
11Brazilian Music 215Sozinho
11Brazilian Music 219Odara
11Brazilian Music 220A Luz De Tieta
11Brazilian Music 228Vai Passar
11Brazilian Music 230Bye, Bye Brasil
11Brazilian Music 236A Banda
11Brazilian Music 391Garota De Ipanema
11Brazilian Music 393Tarde Em Itapoã
11Brazilian Music 501Grito De Alerta
11Brazilian Music 504O Que É O Que É ?
11Brazilian Music 516Voce e Linda
11Brazilian Music 523Sampa
11Brazilian Music 730Malandragem
11Brazilian Music 738Admirável Gado Novo
11Brazilian Music 852Meu Bem-Querer
11Brazilian Music 858Esquinas
11Brazilian Music 864Samurai
11Brazilian Music 867Açai
11Brazilian Music 874Sina
11Brazilian Music 877O Bêbado e a Equilibrista
11Brazilian Music 885Fascinação
11Brazilian Music 888Madalena
11Brazilian Music 1088Palco (Live)
11Brazilian Music 1093Quanta (Live)
11Brazilian Music 1099A Novidade (Live)
11Brazilian Music 1105A Novidade
11Brazilian Music 1514Selassiê
11Brazilian Music 1518Filho Maravilha
11Brazilian Music 1519Taj Mahal
11Brazilian Music 1916Coração De Estudante
11Brazilian Music 1921Nos Bailes Da Vida
11Brazilian Music 1928Maria, Maria
11Brazilian Music 2752Chocolate
11Brazilian Music 2753Azul Da Cor Do Mar
11Brazilian Music 2754O Descobridor Dos Sete Mares
11Brazilian Music 2758Não Vou Ficar
11Brazilian Music 2767Gostava Tanto De Você
11Brazilian Music 2768Você
11Brazilian Music 2769Não Quero Dinheiro
Filter
Clear Filter
PlaylistId 11
Page
No earlier pages
No more pages
8715 rows in table
39 rows for this filter
39 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top