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
877 O Bêbado e a Equilibrista 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 223059 7306143 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
878 O Mestre-Sala dos Mares 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 186226 6180414 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
879 Atrás da Porta 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 166608 5432518 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
880 Dois Pra Lá, Dois Pra Cá 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 263026 8684639 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
881 Casa no Campo 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 170788 5531841 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
882 Romaria 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 242834 7968525 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
883 Alô, Alô, Marciano 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 241397 8137254 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
884 Me Deixas Louca 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 214831 6888030 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
885 Fascinação 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 180793 5793959 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
886 Saudosa Maloca 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 278125 9059416 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
887 As Aparências Enganam 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 247379 8014346 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
888 Madalena 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 157387 5243721 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
889 Maria Rosa 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 232803 7592504 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
890 Aprendendo A Jogar 71Elis Regina-Minha História 1MPEG audio file 7Latin [null] 290664 9391041 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
Filter
Clear Filter
AlbumId 71
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