SQL Schema Explorer by Tim Abell

sqlite-chinook

Track

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 TrackId INTEGER NOT NULL InvoiceLine(TrackId) PlaylistTrack(TrackId) IPK_Track
Name NVARCHAR(200) NOT NULL
AlbumId INTEGER Nullable Album(AlbumId) IFK_TrackAlbumId
MediaTypeId INTEGER NOT NULL MediaType(MediaTypeId) IFK_TrackMediaTypeId
GenreId INTEGER Nullable Genre(GenreId) IFK_TrackGenreId
Composer NVARCHAR(220) Nullable
Milliseconds INTEGER NOT NULL
Bytes INTEGER Nullable
UnitPrice NUMERIC(10,2) NOT NULL

Foreign Keys

Outbound

From To
MediaTypeId MediaType(MediaTypeId)
GenreId Genre(GenreId)
AlbumId Album(AlbumId)

Inbound

From To
InvoiceLine(TrackId) TrackId
PlaylistTrack(TrackId) TrackId

Indexes

Name Columns Unique
IFK_TrackMediaTypeId MediaTypeId
IFK_TrackGenreId GenreId
IFK_TrackAlbumId AlbumId
IPK_Track TrackId Unique

Data

Skip to Data Controls Show just the data
sort TrackId sort Name sort AlbumId sort MediaTypeId sort GenreId sort Composer sort Milliseconds sort Bytes sort UnitPrice Referenced by
63 Desafinado 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 185338 5990473 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
64 Garota De Ipanema 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 285048 9348428 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
65 Samba De Uma Nota Só (One Note Samba) 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 137273 4535401 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
66 Por Causa De Você 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 169900 5536496 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
67 Ligia 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 251977 8226934 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
68 Fotografia 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 129227 4198774 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
69 Dindi (Dindi) 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 253178 8149148 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
70 Se Todos Fossem Iguais A Você (Instrumental) 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 134948 4393377 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
71 Falando De Amor 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 219663 7121735 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
72 Angela 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 169508 5574957 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
73 Corcovado (Quiet Nights Of Quiet Stars) 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 205662 6687994 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
74 Outra Vez 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 126511 4110053 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
75 O Boto (Bôto) 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 366837 12089673 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
76 Canta, Canta Mais 8Warner 25 Anos 1MPEG audio file 2Jazz [null] 271856 8719426 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 8
Page
No earlier pages
No more pages
3503 rows in table
14 rows for this filter
14 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top