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 asc 1 Composer sort Milliseconds sort Bytes sort UnitPrice Referenced by
2 Balls to the Wall 2Balls to the Wall 2Protected AAC audio file 1Rock [null] 342562 5510424 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
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
131 Intro/ Low Down 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 323683 10642901 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
132 13 Years Of Grief 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 246987 8137421 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
133 Stronger Than Death 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 300747 9869647 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
134 All For You 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 235833 7726948 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
135 Super Terrorizer 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 319373 10513905 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
136 Phoney Smile Fake Hellos 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 273606 9011701 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
137 Lost My Better Half 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 284081 9355309 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
138 Bored To Tears 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 247327 8130090 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
139 A.N.D.R.O.T.A.Z. 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 266266 8574746 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
140 Born To Booze 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 282122 9257358 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
141 World Of Trouble 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 359157 11820932 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
142 No More Tears 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 555075 18041629 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
143 The Begining... At Last 14Alcohol Fueled Brewtality Live! [Disc 1] 1MPEG audio file 3Metal [null] 365662 11965109 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
144 Heart Of Gold 15Alcohol Fueled Brewtality Live! [Disc 2] 1MPEG audio file 3Metal [null] 194873 6417460 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
145 Snowblind 15Alcohol Fueled Brewtality Live! [Disc 2] 1MPEG audio file 3Metal [null] 420022 13842549 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
146 Like A Bird 15Alcohol Fueled Brewtality Live! [Disc 2] 1MPEG audio file 3Metal [null] 276532 9115657 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
147 Blood In The Wall 15Alcohol Fueled Brewtality Live! [Disc 2] 1MPEG audio file 3Metal [null] 284368 9359475 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
148 The Beginning...At Last 15Alcohol Fueled Brewtality Live! [Disc 2] 1MPEG audio file 3Metal [null] 271960 8975814 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
149 Black Sabbath 16Black Sabbath 1MPEG audio file 3Metal [null] 382066 12440200 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
150 The Wizard 16Black Sabbath 1MPEG audio file 3Metal [null] 264829 8646737 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
151 Behind The Wall Of Sleep 16Black Sabbath 1MPEG audio file 3Metal [null] 217573 7169049 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
152 N.I.B. 16Black Sabbath 1MPEG audio file 3Metal [null] 368770 12029390 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
153 Evil Woman 16Black Sabbath 1MPEG audio file 3Metal [null] 204930 6655170 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
154 Sleeping Village 16Black Sabbath 1MPEG audio file 3Metal [null] 644571 21128525 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
155 Warning 16Black Sabbath 1MPEG audio file 3Metal [null] 212062 6893363 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
166 Smoked Pork 18Body Count 1MPEG audio file 4Alternative & Punk [null] 47333 1549074 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
167 Body Count's In The House 18Body Count 1MPEG audio file 4Alternative & Punk [null] 204251 6715413 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
168 Now Sports 18Body Count 1MPEG audio file 4Alternative & Punk [null] 4884 161266 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
169 Body Count 18Body Count 1MPEG audio file 4Alternative & Punk [null] 317936 10489139 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
170 A Statistic 18Body Count 1MPEG audio file 4Alternative & Punk [null] 6373 211997 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
171 Bowels Of The Devil 18Body Count 1MPEG audio file 4Alternative & Punk [null] 223216 7324125 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
172 The Real Problem 18Body Count 1MPEG audio file 4Alternative & Punk [null] 11650 387360 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
173 KKK Bitch 18Body Count 1MPEG audio file 4Alternative & Punk [null] 173008 5709631 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
174 D Note 18Body Count 1MPEG audio file 4Alternative & Punk [null] 95738 3067064 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
175 Voodoo 18Body Count 1MPEG audio file 4Alternative & Punk [null] 300721 9875962 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
176 The Winner Loses 18Body Count 1MPEG audio file 4Alternative & Punk [null] 392254 12843821 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
177 There Goes The Neighborhood 18Body Count 1MPEG audio file 4Alternative & Punk [null] 350171 11443471 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
178 Oprah 18Body Count 1MPEG audio file 4Alternative & Punk [null] 6635 224313 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
179 Evil Dick 18Body Count 1MPEG audio file 4Alternative & Punk [null] 239020 7828873 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
180 Body Count Anthem 18Body Count 1MPEG audio file 4Alternative & Punk [null] 166426 5463690 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
181 Momma's Gotta Die Tonight 18Body Count 1MPEG audio file 4Alternative & Punk [null] 371539 12122946 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
182 Freedom Of Speech 18Body Count 1MPEG audio file 4Alternative & Punk [null] 281234 9337917 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
223 Sozinho (Hitmakers Classic Mix) 22Sozinho Remix Ao Vivo 1MPEG audio file 7Latin [null] 436636 14462072 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
224 Sozinho (Hitmakers Classic Radio Edit) 22Sozinho Remix Ao Vivo 1MPEG audio file 7Latin [null] 195004 6455134 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
225 Sozinho (Caêdrum 'n' Bass) 22Sozinho Remix Ao Vivo 1MPEG audio file 7Latin [null] 328071 10975007 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
226 Carolina 23Minha Historia 1MPEG audio file 7Latin [null] 163056 5375395 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
227 Essa Moça Ta Diferente 23Minha Historia 1MPEG audio file 7Latin [null] 167235 5568574 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
228 Vai Passar 23Minha Historia 1MPEG audio file 7Latin [null] 369763 12359161 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
229 Samba De Orly 23Minha Historia 1MPEG audio file 7Latin [null] 162429 5431854 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
230 Bye, Bye Brasil 23Minha Historia 1MPEG audio file 7Latin [null] 283402 9499590 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
231 Atras Da Porta 23Minha Historia 1MPEG audio file 7Latin [null] 189675 6132843 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
232 Tatuagem 23Minha Historia 1MPEG audio file 7Latin [null] 172120 5645703 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
233 O Que Será (À Flor Da Terra) 23Minha Historia 1MPEG audio file 7Latin [null] 167288 5574848 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
234 Morena De Angola 23Minha Historia 1MPEG audio file 7Latin [null] 186801 6373932 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
235 Apesar De Você 23Minha Historia 1MPEG audio file 7Latin [null] 234501 7886937 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
236 A Banda 23Minha Historia 1MPEG audio file 7Latin [null] 132493 4349539 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
237 Minha Historia 23Minha Historia 1MPEG audio file 7Latin [null] 182256 6029673 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
238 Com Açúcar E Com Afeto 23Minha Historia 1MPEG audio file 7Latin [null] 175386 5846442 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
239 Brejo Da Cruz 23Minha Historia 1MPEG audio file 7Latin [null] 214099 7270749 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
240 Meu Caro Amigo 23Minha Historia 1MPEG audio file 7Latin [null] 260257 8778172 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
241 Geni E O Zepelim 23Minha Historia 1MPEG audio file 7Latin [null] 317570 10342226 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
242 Trocando Em Miúdos 23Minha Historia 1MPEG audio file 7Latin [null] 169717 5461468 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
243 Vai Trabalhar Vagabundo 23Minha Historia 1MPEG audio file 7Latin [null] 139154 4693941 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
244 Gota D'água 23Minha Historia 1MPEG audio file 7Latin [null] 153208 5074189 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
245 Construção / Deus Lhe Pague 23Minha Historia 1MPEG audio file 7Latin [null] 383059 12675305 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
269 Banditismo Por Uma Questa 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 307095 10251097 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
270 Banditismo Por Uma Questa 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 243644 8147224 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
271 Rios Pontes & Overdrives 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 286720 9659152 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
272 Cidade 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 216346 7241817 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
273 Praiera 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 183640 6172781 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
274 Samba Makossa 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 271856 9095410 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
275 Da Lama Ao Caos 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 251559 8378065 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
276 Maracatu De Tiro Certeiro 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 88868 2901397 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
277 Salustiano Song 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 215405 7183969 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
278 Antene Se 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 248372 8253618 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
279 Risoflora 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 105586 3536938 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
280 Lixo Do Mangue 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 193253 6534200 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
281 Computadores Fazem Arte 25Da Lama Ao Caos 1MPEG audio file 7Latin [null] 404323 13702771 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
313 Noite Do Prazer 28Na Pista 1MPEG audio file 7Latin [null] 311353 10309980 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
314 À Francesa 28Na Pista 1MPEG audio file 7Latin [null] 244532 8150846 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
315 Cada Um Cada Um (A Namoradeira) 28Na Pista 1MPEG audio file 7Latin [null] 253492 8441034 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
316 Linha Do Equador 28Na Pista 1MPEG audio file 7Latin [null] 244715 8123466 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
317 Amor Demais 28Na Pista 1MPEG audio file 7Latin [null] 254040 8420093 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
318 Férias 28Na Pista 1MPEG audio file 7Latin [null] 264202 8731945 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
319 Gostava Tanto De Você 28Na Pista 1MPEG audio file 7Latin [null] 230452 7685326 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
Sort
Reset Sort Order
Composer Ascending
Page
No earlier pages
Next Page >
3503 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top