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
1532 Pura Elegancia 124Cafezinho 1MPEG audio file 16World João Suplicy 284107 9632269 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1533 Choramingando 124Cafezinho 1MPEG audio file 16World João Suplicy 190484 6400532 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1534 Por Merecer 124Cafezinho 1MPEG audio file 16World João Suplicy 230582 7764601 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1535 No Futuro 124Cafezinho 1MPEG audio file 16World João Suplicy 182308 6056200 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1536 Voce Inteira 124Cafezinho 1MPEG audio file 16World João Suplicy 241084 8077282 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1537 Cuando A Noite Vai Chegando 124Cafezinho 1MPEG audio file 16World João Suplicy 270628 9081874 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1538 Naquele Dia 124Cafezinho 1MPEG audio file 16World João Suplicy 251768 8452654 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1539 Equinocio 124Cafezinho 1MPEG audio file 16World João Suplicy 269008 8871455 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1540 Papelão 124Cafezinho 1MPEG audio file 16World João Suplicy 213263 7257390 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1541 Cuando Eu For Pro Ceu 124Cafezinho 1MPEG audio file 16World João Suplicy 118804 3948371 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1542 Do Nosso Amor 124Cafezinho 1MPEG audio file 16World João Suplicy 203415 6774566 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1543 Borogodo 124Cafezinho 1MPEG audio file 16World João Suplicy 208457 7104588 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1544 Cafezinho 124Cafezinho 1MPEG audio file 16World João Suplicy 180924 6031174 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1545 Enquanto O Dia Não Vem 124Cafezinho 1MPEG audio file 16World João Suplicy 220891 7248336 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1957 Kir Royal 161Demorou... 1MPEG audio file 16World Mônica Marianno 234788 7706552 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1958 O Que Vai Em Meu Coração 161Demorou... 1MPEG audio file 16World Mônica Marianno 255373 8366846 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1959 Aos Leões 161Demorou... 1MPEG audio file 16World Mônica Marianno 234684 7790574 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1960 Dois Índios 161Demorou... 1MPEG audio file 16World Mônica Marianno 219271 7213072 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1961 Noite Negra 161Demorou... 1MPEG audio file 16World Mônica Marianno 206811 6819584 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1962 Beijo do Olhar 161Demorou... 1MPEG audio file 16World Mônica Marianno 252682 8369029 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1963 É Fogo 161Demorou... 1MPEG audio file 16World Mônica Marianno 194873 6501520 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1964 Já Foi 161Demorou... 1MPEG audio file 16World Mônica Marianno 245681 8094872 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1965 Só Se For Pelo Cabelo 161Demorou... 1MPEG audio file 16World Mônica Marianno 238288 8006345 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1966 No Clima 161Demorou... 1MPEG audio file 16World Mônica Marianno 249495 8362040 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1967 A Moça e a Chuva 161Demorou... 1MPEG audio file 16World Mônica Marianno 274625 8929357 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
1968 Demorou! 161Demorou... 1MPEG audio file 16World Mônica Marianno 39131 1287083 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
3351 Din Din Wo (Little Child) 263Muso Ko 5AAC audio file 16World Habib Koité 285837 4615841 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
3354 I Ka Barra (Your Work) 263Muso Ko 5AAC audio file 16World Habib Koité 300605 4855457 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
Filter
Clear Filter
GenreId 16
Page
No earlier pages
No more pages
3503 rows in table
28 rows for this filter
28 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top