SQL Schema Explorer by Tim Abell

sqlite-chinook

Playlist

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 PlaylistTrack(PlaylistId) IPK_Playlist
Name NVARCHAR(120) Nullable

Foreign Keys

Inbound

From To
PlaylistTrack(PlaylistId) PlaylistId

Indexes

Name Columns Unique
IPK_Playlist PlaylistId Unique

Data

Skip to Data Controls Show just the data
sort PlaylistId sort Name Referenced by
1 Music PlaylistTrack: PlaylistId - 3290 rows
2 Movies PlaylistTrack: PlaylistId - 0 rows
3 TV Shows PlaylistTrack: PlaylistId - 213 rows
4 Audiobooks PlaylistTrack: PlaylistId - 0 rows
5 90’s Music PlaylistTrack: PlaylistId - 1477 rows
6 Audiobooks PlaylistTrack: PlaylistId - 0 rows
7 Movies PlaylistTrack: PlaylistId - 0 rows
8 Music PlaylistTrack: PlaylistId - 3290 rows
9 Music Videos PlaylistTrack: PlaylistId - 1 rows
10 TV Shows PlaylistTrack: PlaylistId - 213 rows
11 Brazilian Music PlaylistTrack: PlaylistId - 39 rows
12 Classical PlaylistTrack: PlaylistId - 75 rows
13 Classical 101 - Deep Cuts PlaylistTrack: PlaylistId - 25 rows
14 Classical 101 - Next Steps PlaylistTrack: PlaylistId - 25 rows
15 Classical 101 - The Basics PlaylistTrack: PlaylistId - 25 rows
16 Grunge PlaylistTrack: PlaylistId - 15 rows
17 Heavy Metal Classic PlaylistTrack: PlaylistId - 26 rows
18 On-The-Go 1 PlaylistTrack: PlaylistId - 1 rows
Page
No earlier pages
No more pages
18 rows in table
18 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top