SQL Schema Explorer by Tim Abell

sqlite-chinook

Artist

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 ArtistId INTEGER NOT NULL Album(ArtistId) IPK_Artist
Name NVARCHAR(120) Nullable

Foreign Keys

Inbound

From To
Album(ArtistId) ArtistId

Indexes

Name Columns Unique
IPK_Artist ArtistId Unique

Data

Skip to Data Controls Show just the data
sort ArtistId sort Name Referenced by
1 AC/DC Album: ArtistId - 2 rows
2 Accept Album: ArtistId - 2 rows
3 Aerosmith Album: ArtistId - 1 rows
4 Alanis Morissette Album: ArtistId - 1 rows
5 Alice In Chains Album: ArtistId - 1 rows
6 Antônio Carlos Jobim Album: ArtistId - 2 rows
7 Apocalyptica Album: ArtistId - 1 rows
8 Audioslave Album: ArtistId - 3 rows
9 BackBeat Album: ArtistId - 1 rows
10 Billy Cobham Album: ArtistId - 1 rows
11 Black Label Society Album: ArtistId - 2 rows
12 Black Sabbath Album: ArtistId - 2 rows
13 Body Count Album: ArtistId - 1 rows
14 Bruce Dickinson Album: ArtistId - 1 rows
15 Buddy Guy Album: ArtistId - 1 rows
16 Caetano Veloso Album: ArtistId - 2 rows
17 Chico Buarque Album: ArtistId - 1 rows
18 Chico Science & Nação Zumbi Album: ArtistId - 2 rows
19 Cidade Negra Album: ArtistId - 2 rows
20 Cláudio Zoli Album: ArtistId - 1 rows
21 Various Artists Album: ArtistId - 4 rows
22 Led Zeppelin Album: ArtistId - 14 rows
23 Frank Zappa & Captain Beefheart Album: ArtistId - 1 rows
24 Marcos Valle Album: ArtistId - 1 rows
25 Milton Nascimento & Bebeto Album: ArtistId - 0 rows
26 Azymuth Album: ArtistId - 0 rows
27 Gilberto Gil Album: ArtistId - 3 rows
28 João Gilberto Album: ArtistId - 0 rows
29 Bebel Gilberto Album: ArtistId - 0 rows
30 Jorge Vercilo Album: ArtistId - 0 rows
31 Baby Consuelo Album: ArtistId - 0 rows
32 Ney Matogrosso Album: ArtistId - 0 rows
33 Luiz Melodia Album: ArtistId - 0 rows
34 Nando Reis Album: ArtistId - 0 rows
35 Pedro Luís & A Parede Album: ArtistId - 0 rows
36 O Rappa Album: ArtistId - 1 rows
37 Ed Motta Album: ArtistId - 1 rows
38 Banda Black Rio Album: ArtistId - 0 rows
39 Fernanda Porto Album: ArtistId - 0 rows
40 Os Cariocas Album: ArtistId - 0 rows
41 Elis Regina Album: ArtistId - 1 rows
42 Milton Nascimento Album: ArtistId - 2 rows
43 A Cor Do Som Album: ArtistId - 0 rows
44 Kid Abelha Album: ArtistId - 0 rows
45 Sandra De Sá Album: ArtistId - 0 rows
46 Jorge Ben Album: ArtistId - 1 rows
47 Hermeto Pascoal Album: ArtistId - 0 rows
48 Barão Vermelho Album: ArtistId - 0 rows
49 Edson, DJ Marky & DJ Patife Featuring Fernanda Porto Album: ArtistId - 0 rows
50 Metallica Album: ArtistId - 10 rows
51 Queen Album: ArtistId - 3 rows
52 Kiss Album: ArtistId - 2 rows
53 Spyro Gyra Album: ArtistId - 2 rows
54 Green Day Album: ArtistId - 2 rows
55 David Coverdale Album: ArtistId - 1 rows
56 Gonzaguinha Album: ArtistId - 1 rows
57 Os Mutantes Album: ArtistId - 1 rows
58 Deep Purple Album: ArtistId - 11 rows
59 Santana Album: ArtistId - 3 rows
60 Santana Feat. Dave Matthews Album: ArtistId - 0 rows
61 Santana Feat. Everlast Album: ArtistId - 0 rows
62 Santana Feat. Rob Thomas Album: ArtistId - 0 rows
63 Santana Feat. Lauryn Hill & Cee-Lo Album: ArtistId - 0 rows
64 Santana Feat. The Project G&B Album: ArtistId - 0 rows
65 Santana Feat. Maná Album: ArtistId - 0 rows
66 Santana Feat. Eagle-Eye Cherry Album: ArtistId - 0 rows
67 Santana Feat. Eric Clapton Album: ArtistId - 0 rows
68 Miles Davis Album: ArtistId - 3 rows
69 Gene Krupa Album: ArtistId - 1 rows
70 Toquinho & Vinícius Album: ArtistId - 1 rows
71 Vinícius De Moraes & Baden Powell Album: ArtistId - 0 rows
72 Vinícius De Moraes Album: ArtistId - 1 rows
73 Vinícius E Qurteto Em Cy Album: ArtistId - 0 rows
74 Vinícius E Odette Lara Album: ArtistId - 0 rows
75 Vinicius, Toquinho & Quarteto Em Cy Album: ArtistId - 0 rows
76 Creedence Clearwater Revival Album: ArtistId - 2 rows
77 Cássia Eller Album: ArtistId - 2 rows
78 Def Leppard Album: ArtistId - 1 rows
79 Dennis Chambers Album: ArtistId - 1 rows
80 Djavan Album: ArtistId - 2 rows
81 Eric Clapton Album: ArtistId - 2 rows
82 Faith No More Album: ArtistId - 4 rows
83 Falamansa Album: ArtistId - 1 rows
84 Foo Fighters Album: ArtistId - 4 rows
85 Frank Sinatra Album: ArtistId - 1 rows
86 Funk Como Le Gusta Album: ArtistId - 1 rows
87 Godsmack Album: ArtistId - 1 rows
88 Guns N' Roses Album: ArtistId - 3 rows
89 Incognito Album: ArtistId - 1 rows
90 Iron Maiden Album: ArtistId - 21 rows
91 James Brown Album: ArtistId - 1 rows
92 Jamiroquai Album: ArtistId - 3 rows
93 JET Album: ArtistId - 1 rows
94 Jimi Hendrix Album: ArtistId - 1 rows
95 Joe Satriani Album: ArtistId - 1 rows
96 Jota Quest Album: ArtistId - 1 rows
97 João Suplicy Album: ArtistId - 1 rows
98 Judas Priest Album: ArtistId - 1 rows
99 Legião Urbana Album: ArtistId - 2 rows
100 Lenny Kravitz Album: ArtistId - 1 rows
Page
No earlier pages
Next Page >
275 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top