SQL Schema Explorer by Tim Abell

sqlite-chinook

Album

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 AlbumId INTEGER NOT NULL Track(AlbumId) IPK_Album
Title NVARCHAR(160) NOT NULL
ArtistId INTEGER NOT NULL Artist(ArtistId) IFK_AlbumArtistId

Foreign Keys

Outbound

From To
ArtistId Artist(ArtistId)

Inbound

From To
Track(AlbumId) AlbumId

Indexes

Name Columns Unique
IFK_AlbumArtistId ArtistId
IPK_Album AlbumId Unique

Data

Skip to Data Controls Show just the data
sort AlbumId sort Title sort ArtistId Referenced by
1 For Those About To Rock We Salute You 1AC/DC Track: AlbumId - 10 rows
2 Balls to the Wall 2Accept Track: AlbumId - 1 rows
3 Restless and Wild 2Accept Track: AlbumId - 3 rows
4 Let There Be Rock 1AC/DC Track: AlbumId - 8 rows
5 Big Ones 3Aerosmith Track: AlbumId - 15 rows
6 Jagged Little Pill 4Alanis Morissette Track: AlbumId - 13 rows
7 Facelift 5Alice In Chains Track: AlbumId - 12 rows
8 Warner 25 Anos 6Antônio Carlos Jobim Track: AlbumId - 14 rows
9 Plays Metallica By Four Cellos 7Apocalyptica Track: AlbumId - 8 rows
10 Audioslave 8Audioslave Track: AlbumId - 14 rows
11 Out Of Exile 8Audioslave Track: AlbumId - 12 rows
12 BackBeat Soundtrack 9BackBeat Track: AlbumId - 12 rows
13 The Best Of Billy Cobham 10Billy Cobham Track: AlbumId - 8 rows
14 Alcohol Fueled Brewtality Live! [Disc 1] 11Black Label Society Track: AlbumId - 13 rows
15 Alcohol Fueled Brewtality Live! [Disc 2] 11Black Label Society Track: AlbumId - 5 rows
16 Black Sabbath 12Black Sabbath Track: AlbumId - 7 rows
17 Black Sabbath Vol. 4 (Remaster) 12Black Sabbath Track: AlbumId - 10 rows
18 Body Count 13Body Count Track: AlbumId - 17 rows
19 Chemical Wedding 14Bruce Dickinson Track: AlbumId - 11 rows
20 The Best Of Buddy Guy - The Millenium Collection 15Buddy Guy Track: AlbumId - 11 rows
21 Prenda Minha 16Caetano Veloso Track: AlbumId - 18 rows
22 Sozinho Remix Ao Vivo 16Caetano Veloso Track: AlbumId - 3 rows
23 Minha Historia 17Chico Buarque Track: AlbumId - 34 rows
24 Afrociberdelia 18Chico Science & Nação Zumbi Track: AlbumId - 23 rows
25 Da Lama Ao Caos 18Chico Science & Nação Zumbi Track: AlbumId - 13 rows
26 Acústico MTV [Live] 19Cidade Negra Track: AlbumId - 17 rows
27 Cidade Negra - Hits 19Cidade Negra Track: AlbumId - 14 rows
28 Na Pista 20Cláudio Zoli Track: AlbumId - 10 rows
29 Axé Bahia 2001 21Various Artists Track: AlbumId - 14 rows
30 BBC Sessions [Disc 1] [Live] 22Led Zeppelin Track: AlbumId - 14 rows
31 Bongo Fury 23Frank Zappa & Captain Beefheart Track: AlbumId - 9 rows
32 Carnaval 2001 21Various Artists Track: AlbumId - 14 rows
33 Chill: Brazil (Disc 1) 24Marcos Valle Track: AlbumId - 17 rows
34 Chill: Brazil (Disc 2) 6Antônio Carlos Jobim Track: AlbumId - 17 rows
35 Garage Inc. (Disc 1) 50Metallica Track: AlbumId - 11 rows
36 Greatest Hits II 51Queen Track: AlbumId - 17 rows
37 Greatest Kiss 52Kiss Track: AlbumId - 20 rows
38 Heart of the Night 53Spyro Gyra Track: AlbumId - 12 rows
39 International Superhits 54Green Day Track: AlbumId - 21 rows
40 Into The Light 55David Coverdale Track: AlbumId - 12 rows
41 Meus Momentos 56Gonzaguinha Track: AlbumId - 14 rows
42 Minha História 57Os Mutantes Track: AlbumId - 14 rows
43 MK III The Final Concerts [Disc 1] 58Deep Purple Track: AlbumId - 7 rows
44 Physical Graffiti [Disc 1] 22Led Zeppelin Track: AlbumId - 6 rows
45 Sambas De Enredo 2001 21Various Artists Track: AlbumId - 14 rows
46 Supernatural 59Santana Track: AlbumId - 13 rows
47 The Best of Ed Motta 37Ed Motta Track: AlbumId - 14 rows
48 The Essential Miles Davis [Disc 1] 68Miles Davis Track: AlbumId - 13 rows
49 The Essential Miles Davis [Disc 2] 68Miles Davis Track: AlbumId - 10 rows
50 The Final Concerts (Disc 2) 58Deep Purple Track: AlbumId - 4 rows
51 Up An' Atom 69Gene Krupa Track: AlbumId - 22 rows
52 Vinícius De Moraes - Sem Limite 70Toquinho & Vinícius Track: AlbumId - 15 rows
53 Vozes do MPB 21Various Artists Track: AlbumId - 14 rows
54 Chronicle, Vol. 1 76Creedence Clearwater Revival Track: AlbumId - 20 rows
55 Chronicle, Vol. 2 76Creedence Clearwater Revival Track: AlbumId - 20 rows
56 Cássia Eller - Coleção Sem Limite [Disc 2] 77Cássia Eller Track: AlbumId - 15 rows
57 Cássia Eller - Sem Limite [Disc 1] 77Cássia Eller Track: AlbumId - 15 rows
58 Come Taste The Band 58Deep Purple Track: AlbumId - 9 rows
59 Deep Purple In Rock 58Deep Purple Track: AlbumId - 7 rows
60 Fireball 58Deep Purple Track: AlbumId - 7 rows
61 Knocking at Your Back Door: The Best Of Deep Purple in the 80's 58Deep Purple Track: AlbumId - 11 rows
62 Machine Head 58Deep Purple Track: AlbumId - 7 rows
63 Purpendicular 58Deep Purple Track: AlbumId - 12 rows
64 Slaves And Masters 58Deep Purple Track: AlbumId - 9 rows
65 Stormbringer 58Deep Purple Track: AlbumId - 9 rows
66 The Battle Rages On 58Deep Purple Track: AlbumId - 10 rows
67 Vault: Def Leppard's Greatest Hits 78Def Leppard Track: AlbumId - 16 rows
68 Outbreak 79Dennis Chambers Track: AlbumId - 9 rows
69 Djavan Ao Vivo - Vol. 02 80Djavan Track: AlbumId - 13 rows
70 Djavan Ao Vivo - Vol. 1 80Djavan Track: AlbumId - 13 rows
71 Elis Regina-Minha História 41Elis Regina Track: AlbumId - 14 rows
72 The Cream Of Clapton 81Eric Clapton Track: AlbumId - 18 rows
73 Unplugged 81Eric Clapton Track: AlbumId - 30 rows
74 Album Of The Year 82Faith No More Track: AlbumId - 12 rows
75 Angel Dust 82Faith No More Track: AlbumId - 14 rows
76 King For A Day Fool For A Lifetime 82Faith No More Track: AlbumId - 15 rows
77 The Real Thing 82Faith No More Track: AlbumId - 11 rows
78 Deixa Entrar 83Falamansa Track: AlbumId - 14 rows
79 In Your Honor [Disc 1] 84Foo Fighters Track: AlbumId - 10 rows
80 In Your Honor [Disc 2] 84Foo Fighters Track: AlbumId - 10 rows
81 One By One 84Foo Fighters Track: AlbumId - 11 rows
82 The Colour And The Shape 84Foo Fighters Track: AlbumId - 13 rows
83 My Way: The Best Of Frank Sinatra [Disc 1] 85Frank Sinatra Track: AlbumId - 24 rows
84 Roda De Funk 86Funk Como Le Gusta Track: AlbumId - 16 rows
85 As Canções de Eu Tu Eles 27Gilberto Gil Track: AlbumId - 14 rows
86 Quanta Gente Veio Ver (Live) 27Gilberto Gil Track: AlbumId - 15 rows
87 Quanta Gente Veio ver--Bônus De Carnaval 27Gilberto Gil Track: AlbumId - 3 rows
88 Faceless 87Godsmack Track: AlbumId - 12 rows
89 American Idiot 54Green Day Track: AlbumId - 13 rows
90 Appetite for Destruction 88Guns N' Roses Track: AlbumId - 12 rows
91 Use Your Illusion I 88Guns N' Roses Track: AlbumId - 16 rows
92 Use Your Illusion II 88Guns N' Roses Track: AlbumId - 14 rows
93 Blue Moods 89Incognito Track: AlbumId - 13 rows
94 A Matter of Life and Death 90Iron Maiden Track: AlbumId - 11 rows
95 A Real Dead One 90Iron Maiden Track: AlbumId - 12 rows
96 A Real Live One 90Iron Maiden Track: AlbumId - 11 rows
97 Brave New World 90Iron Maiden Track: AlbumId - 10 rows
98 Dance Of Death 90Iron Maiden Track: AlbumId - 11 rows
99 Fear Of The Dark 90Iron Maiden Track: AlbumId - 12 rows
100 Iron Maiden 90Iron Maiden Track: AlbumId - 9 rows
Page
No earlier pages
Next Page >
347 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top