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
1Music 2461É Uma Partida De Futebol
590’s Music 2461É Uma Partida De Futebol
8Music 2461É Uma Partida De Futebol
Filter
Clear Filter
TrackId 2461
Page
No earlier pages
No more pages
8715 rows in table
3 rows for this filter
3 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top