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
123 Quadrant 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 261851 8538199 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
124 Snoopy's search-Red baron 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 456071 15075616 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
125 Spanish moss-"A sound portrait"-Spanish moss 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 248084 8217867 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
126 Moon germs 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 294060 9714812 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
127 Stratus 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 582086 19115680 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
128 The pleasant pheasant 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 318066 10630578 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
129 Solo-Panhandler 13The Best Of Billy Cobham 1MPEG audio file 2Jazz Billy Cobham 246151 8230661 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
130 Do what cha wanna 13The Best Of Billy Cobham 1MPEG audio file 2Jazz George Duke 274155 9018565 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
456 Heart of the Night 38Heart of the Night 1MPEG audio file 2Jazz [null] 273737 9098263 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
457 De La Luz 38Heart of the Night 1MPEG audio file 2Jazz [null] 315219 10518284 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
458 Westwood Moon 38Heart of the Night 1MPEG audio file 2Jazz [null] 295627 9765802 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
459 Midnight 38Heart of the Night 1MPEG audio file 2Jazz [null] 266866 8851060 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
460 Playtime 38Heart of the Night 1MPEG audio file 2Jazz [null] 273580 9070880 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
461 Surrender 38Heart of the Night 1MPEG audio file 2Jazz [null] 287634 9422926 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
462 Valentino's 38Heart of the Night 1MPEG audio file 2Jazz [null] 296124 9848545 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
463 Believe 38Heart of the Night 1MPEG audio file 2Jazz [null] 310778 10317185 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
464 As We Sleep 38Heart of the Night 1MPEG audio file 2Jazz [null] 316865 10429398 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
465 When Evening Falls 38Heart of the Night 1MPEG audio file 2Jazz [null] 298135 9863942 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
466 J Squared 38Heart of the Night 1MPEG audio file 2Jazz [null] 288757 9480777 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
467 Best Thing 38Heart of the Night 1MPEG audio file 2Jazz [null] 274259 9069394 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
597 Now's The Time 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 197459 6358868 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
598 Jeru 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 193410 6222536 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
599 Compulsion 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 345025 11254474 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
600 Tempus Fugit 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 231784 7548434 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
601 Walkin' 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 807392 26411634 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
602 'Round Midnight 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 357459 11590284 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
603 Bye Bye Blackbird 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 476003 15549224 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
604 New Rhumba 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 277968 9018024 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
605 Generique 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 168777 5437017 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
606 Summertime 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 200437 6461370 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
607 So What 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 564009 18360449 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
608 The Pan Piper 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 233769 7593713 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
609 Someday My Prince Will Come 48The Essential Miles Davis [Disc 1] 1MPEG audio file 2Jazz Miles Davis 544078 17890773 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
610 My Funny Valentine (Live) 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 907520 29416781 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
611 E.S.P. 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 330684 11079866 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
612 Nefertiti 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 473495 15478450 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
613 Petits Machins (Little Stuff) 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 487392 16131272 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
614 Miles Runs The Voodoo Down 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 843964 27967919 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
615 Little Church (Live) 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 196101 6273225 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
616 Black Satin 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 316682 10529483 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
617 Jean Pierre (Live) 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 243461 7955114 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
618 Time After Time 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 220734 7292197 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
619 Portia 49The Essential Miles Davis [Disc 2] 1MPEG audio file 2Jazz Miles Davis 378775 12520126 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
624 Jeepers Creepers 51Up An' Atom 1MPEG audio file 2Jazz [null] 185965 5991903 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
625 Blue Rythm Fantasy 51Up An' Atom 1MPEG audio file 2Jazz [null] 348212 11204006 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
626 Drum Boogie 51Up An' Atom 1MPEG audio file 2Jazz [null] 191555 6185636 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
627 Let Me Off Uptown 51Up An' Atom 1MPEG audio file 2Jazz [null] 187637 6034685 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
628 Leave Us Leap 51Up An' Atom 1MPEG audio file 2Jazz [null] 182726 5898810 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
629 Opus No.1 51Up An' Atom 1MPEG audio file 2Jazz [null] 179800 5846041 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
630 Boogie Blues 51Up An' Atom 1MPEG audio file 2Jazz [null] 204199 6603153 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
631 How High The Moon 51Up An' Atom 1MPEG audio file 2Jazz [null] 201430 6529487 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
632 Disc Jockey Jump 51Up An' Atom 1MPEG audio file 2Jazz [null] 193149 6260820 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
633 Up An' Atom 51Up An' Atom 1MPEG audio file 2Jazz [null] 179565 5822645 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
634 Bop Boogie 51Up An' Atom 1MPEG audio file 2Jazz [null] 189596 6093124 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
635 Lemon Drop 51Up An' Atom 1MPEG audio file 2Jazz [null] 194089 6287531 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
636 Coronation Drop 51Up An' Atom 1MPEG audio file 2Jazz [null] 176222 5899898 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
637 Overtime 51Up An' Atom 1MPEG audio file 2Jazz [null] 163030 5432236 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
638 Imagination 51Up An' Atom 1MPEG audio file 2Jazz [null] 289306 9444385 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
639 Don't Take Your Love From Me 51Up An' Atom 1MPEG audio file 2Jazz [null] 282331 9244238 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
640 Midget 51Up An' Atom 1MPEG audio file 2Jazz [null] 217025 7257663 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
641 I'm Coming Virginia 51Up An' Atom 1MPEG audio file 2Jazz [null] 280163 9209827 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
642 Payin' Them Dues Blues 51Up An' Atom 1MPEG audio file 2Jazz [null] 198556 6536918 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
643 Jungle Drums 51Up An' Atom 1MPEG audio file 2Jazz [null] 199627 6546063 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
644 Showcase 51Up An' Atom 1MPEG audio file 2Jazz [null] 201560 6697510 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
645 Swedish Schnapps 51Up An' Atom 1MPEG audio file 2Jazz [null] 191268 6359750 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
842 Roll Call 68Outbreak 1MPEG audio file 2Jazz Jim Beard 321358 10653494 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
843 Otay 68Outbreak 1MPEG audio file 2Jazz John Scofield, Robert Aries, Milton Chambers and Gary Grainger 423653 14176083 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
844 Groovus Interruptus 68Outbreak 1MPEG audio file 2Jazz Jim Beard 319373 10602166 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
845 Paris On Mine 68Outbreak 1MPEG audio file 2Jazz Jon Herington 368875 12059507 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
846 In Time 68Outbreak 1MPEG audio file 2Jazz Sylvester Stewart 368953 12287103 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
847 Plan B 68Outbreak 1MPEG audio file 2Jazz Dean Brown, Dennis Chambers & Jim Beard 272039 9032315 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
848 Outbreak 68Outbreak 1MPEG audio file 2Jazz Jim Beard & Jon Herington 659226 21685807 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
849 Baltimore, DC 68Outbreak 1MPEG audio file 2Jazz John Scofield 346932 11394473 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 2 rows
850 Talkin Loud and Saying Nothin 68Outbreak 1MPEG audio file 2Jazz James Brown & Bobby Byrd 360411 11994859 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1102 Doce De Carnaval (Candy All) 87Quanta Gente Veio ver--Bônus De Carnaval 1MPEG audio file 2Jazz [null] 356101 11998470 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1103 Lamento De Carnaval 87Quanta Gente Veio ver--Bônus De Carnaval 1MPEG audio file 2Jazz [null] 294530 9819276 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 2 rows
1104 Pretinha 87Quanta Gente Veio ver--Bônus De Carnaval 1MPEG audio file 2Jazz [null] 265273 8914579 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 2 rows
1188 Colibri 93Blue Moods 1MPEG audio file 2Jazz Richard Bull 361012 12055329 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
1189 Love Is The Colour 93Blue Moods 1MPEG audio file 2Jazz R. Carless 251585 8419165 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
1190 Magnetic Ocean 93Blue Moods 1MPEG audio file 2Jazz Patrick Claher/Richard Bull 321123 10720741 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
1191 Deep Waters 93Blue Moods 1MPEG audio file 2Jazz Richard Bull 396460 13075359 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
1192 L'Arc En Ciel De Miles 93Blue Moods 1MPEG audio file 2Jazz Kevin Robinson/Richard Bull 242390 8053997 0.99 InvoiceLine: TrackId - 2 rows
PlaylistTrack: TrackId - 3 rows
1193 Gypsy 93Blue Moods 1MPEG audio file 2Jazz Kevin Robinson 330997 11083374 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
1194 Journey Into Sunlight 93Blue Moods 1MPEG audio file 2Jazz Jean Paul Maunick 249756 8241177 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
1195 Sunchild 93Blue Moods 1MPEG audio file 2Jazz Graham Harvey 259970 8593143 0.99 InvoiceLine: TrackId - 0 rows
PlaylistTrack: TrackId - 3 rows
1196 Millenium 93Blue Moods 1MPEG audio file 2Jazz Maxton Gig Beesley Jnr. 379167 12511939 0.99 InvoiceLine: TrackId - 1 rows
PlaylistTrack: TrackId - 3 rows
Filter
Clear Filter
GenreId 2
Page
No earlier pages
Next Page >
3503 rows in table
130 rows for this filter
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top