SQL Schema Explorer by Tim Abell

sqlite-chinook

Invoice

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 InvoiceId INTEGER NOT NULL InvoiceLine(InvoiceId) IPK_Invoice
CustomerId INTEGER NOT NULL Customer(CustomerId) IFK_InvoiceCustomerId
InvoiceDate DATETIME NOT NULL
BillingAddress NVARCHAR(70) Nullable
BillingCity NVARCHAR(40) Nullable
BillingState NVARCHAR(40) Nullable
BillingCountry NVARCHAR(40) Nullable
BillingPostalCode NVARCHAR(10) Nullable
Total NUMERIC(10,2) NOT NULL

Foreign Keys

Outbound

From To
CustomerId Customer(CustomerId)

Inbound

From To
InvoiceLine(InvoiceId) InvoiceId

Indexes

Name Columns Unique
IFK_InvoiceCustomerId CustomerId
IPK_Invoice InvoiceId Unique

Data

Skip to Data Controls Show just the data
sort InvoiceId sort CustomerId sort InvoiceDate sort BillingAddress asc 1 BillingCity sort BillingState sort BillingCountry sort BillingPostalCode sort Total Referenced by
32 48JohannesVan der Bergjohavanderberg@yahoo.nl 2009-05-10 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 8.91 InvoiceLine: InvoiceId - 9 rows
161 48JohannesVan der Bergjohavanderberg@yahoo.nl 2010-12-15 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 1.98 InvoiceLine: InvoiceId - 2 rows
184 48JohannesVan der Bergjohavanderberg@yahoo.nl 2011-03-19 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 3.96 InvoiceLine: InvoiceId - 4 rows
206 48JohannesVan der Bergjohavanderberg@yahoo.nl 2011-06-21 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 8.94 InvoiceLine: InvoiceId - 6 rows
258 48JohannesVan der Bergjohavanderberg@yahoo.nl 2012-02-09 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 0.99 InvoiceLine: InvoiceId - 1 rows
379 48JohannesVan der Bergjohavanderberg@yahoo.nl 2013-08-02 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 1.98 InvoiceLine: InvoiceId - 2 rows
390 48JohannesVan der Bergjohavanderberg@yahoo.nl 2013-09-12 00:00:00 +0000 UTC Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 13.86 InvoiceLine: InvoiceId - 14 rows
23 59PujaSrivastavapuja_srivastava@yahoo.in 2009-04-05 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 3.96 InvoiceLine: InvoiceId - 4 rows
45 59PujaSrivastavapuja_srivastava@yahoo.in 2009-07-08 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 5.94 InvoiceLine: InvoiceId - 6 rows
97 59PujaSrivastavapuja_srivastava@yahoo.in 2010-02-26 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 1.99 InvoiceLine: InvoiceId - 1 rows
218 59PujaSrivastavapuja_srivastava@yahoo.in 2011-08-20 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 1.98 InvoiceLine: InvoiceId - 2 rows
229 59PujaSrivastavapuja_srivastava@yahoo.in 2011-09-30 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 13.86 InvoiceLine: InvoiceId - 14 rows
284 59PujaSrivastavapuja_srivastava@yahoo.in 2012-05-30 00:00:00 +0000 UTC 3,Raj Bhavan Road Bangalore [null] India 560001 8.91 InvoiceLine: InvoiceId - 9 rows
7 38NiklasSchrödernschroder@surfeu.de 2009-02-01 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 1.98 InvoiceLine: InvoiceId - 2 rows
29 36HannahSchneiderhannah.schneider@yahoo.de 2009-05-05 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 1.98 InvoiceLine: InvoiceId - 2 rows
30 38NiklasSchrödernschroder@surfeu.de 2009-05-06 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 3.96 InvoiceLine: InvoiceId - 4 rows
40 36HannahSchneiderhannah.schneider@yahoo.de 2009-06-15 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 13.86 InvoiceLine: InvoiceId - 14 rows
52 38NiklasSchrödernschroder@surfeu.de 2009-08-08 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 5.94 InvoiceLine: InvoiceId - 6 rows
95 36HannahSchneiderhannah.schneider@yahoo.de 2010-02-13 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 8.91 InvoiceLine: InvoiceId - 9 rows
104 38NiklasSchrödernschroder@surfeu.de 2010-03-29 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 0.99 InvoiceLine: InvoiceId - 1 rows
224 36HannahSchneiderhannah.schneider@yahoo.de 2011-09-20 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 1.98 InvoiceLine: InvoiceId - 2 rows
225 38NiklasSchrödernschroder@surfeu.de 2011-09-20 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 1.98 InvoiceLine: InvoiceId - 2 rows
236 38NiklasSchrödernschroder@surfeu.de 2011-10-31 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 13.86 InvoiceLine: InvoiceId - 14 rows
247 36HannahSchneiderhannah.schneider@yahoo.de 2011-12-23 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 3.96 InvoiceLine: InvoiceId - 4 rows
269 36HannahSchneiderhannah.schneider@yahoo.de 2012-03-26 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 5.94 InvoiceLine: InvoiceId - 6 rows
291 38NiklasSchrödernschroder@surfeu.de 2012-06-30 00:00:00 +0000 UTC Barbarossastraße 19 Berlin [null] Germany 10779 8.91 InvoiceLine: InvoiceId - 9 rows
321 36HannahSchneiderhannah.schneider@yahoo.de 2012-11-14 00:00:00 +0000 UTC Tauentzienstraße 8 Berlin [null] Germany 10789 0.99 InvoiceLine: InvoiceId - 1 rows
9 42WyattGirardwyatt.girard@yahoo.fr 2009-02-02 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 3.96 InvoiceLine: InvoiceId - 4 rows
31 42WyattGirardwyatt.girard@yahoo.fr 2009-05-07 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 5.94 InvoiceLine: InvoiceId - 6 rows
83 42WyattGirardwyatt.girard@yahoo.fr 2009-12-26 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 0.99 InvoiceLine: InvoiceId - 1 rows
204 42WyattGirardwyatt.girard@yahoo.fr 2011-06-19 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 3.98 InvoiceLine: InvoiceId - 2 rows
215 42WyattGirardwyatt.girard@yahoo.fr 2011-07-30 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 13.86 InvoiceLine: InvoiceId - 14 rows
270 42WyattGirardwyatt.girard@yahoo.fr 2012-03-29 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 8.91 InvoiceLine: InvoiceId - 9 rows
399 42WyattGirardwyatt.girard@yahoo.fr 2013-11-03 00:00:00 +0000 UTC 9, Place Louis Barthou Bordeaux [null] France 33000 1.98 InvoiceLine: InvoiceId - 2 rows
5 23JohnGordonjohngordon22@yahoo.com 2009-01-11 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 13.86 InvoiceLine: InvoiceId - 14 rows
60 23JohnGordonjohngordon22@yahoo.com 2009-09-11 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 8.91 InvoiceLine: InvoiceId - 9 rows
189 23JohnGordonjohngordon22@yahoo.com 2011-04-18 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 1.98 InvoiceLine: InvoiceId - 2 rows
212 23JohnGordonjohngordon22@yahoo.com 2011-07-21 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 3.96 InvoiceLine: InvoiceId - 4 rows
234 23JohnGordonjohngordon22@yahoo.com 2011-10-23 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 5.94 InvoiceLine: InvoiceId - 6 rows
286 23JohnGordonjohngordon22@yahoo.com 2012-06-12 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 0.99 InvoiceLine: InvoiceId - 1 rows
407 23JohnGordonjohngordon22@yahoo.com 2013-12-04 00:00:00 +0000 UTC 69 Salem Street Boston MA USA 2113 1.98 InvoiceLine: InvoiceId - 2 rows
35 13FernandaRamosfernadaramos4@uol.com.br 2009-06-05 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 1.98 InvoiceLine: InvoiceId - 2 rows
58 13FernandaRamosfernadaramos4@uol.com.br 2009-09-07 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 3.96 InvoiceLine: InvoiceId - 4 rows
80 13FernandaRamosfernadaramos4@uol.com.br 2009-12-10 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 5.94 InvoiceLine: InvoiceId - 6 rows
132 13FernandaRamosfernadaramos4@uol.com.br 2010-07-31 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 0.99 InvoiceLine: InvoiceId - 1 rows
253 13FernandaRamosfernadaramos4@uol.com.br 2012-01-22 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 1.98 InvoiceLine: InvoiceId - 2 rows
264 13FernandaRamosfernadaramos4@uol.com.br 2012-03-03 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 13.86 InvoiceLine: InvoiceId - 14 rows
319 13FernandaRamosfernadaramos4@uol.com.br 2012-11-01 00:00:00 +0000 UTC Qe 7 Bloco G Brasília DF Brazil 71020-677 8.91 InvoiceLine: InvoiceId - 9 rows
3 8DaanPeetersdaan_peeters@apple.be 2009-01-03 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 5.94 InvoiceLine: InvoiceId - 6 rows
55 8DaanPeetersdaan_peeters@apple.be 2009-08-24 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 0.99 InvoiceLine: InvoiceId - 1 rows
176 8DaanPeetersdaan_peeters@apple.be 2011-02-15 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 1.98 InvoiceLine: InvoiceId - 2 rows
187 8DaanPeetersdaan_peeters@apple.be 2011-03-28 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 13.86 InvoiceLine: InvoiceId - 14 rows
242 8DaanPeetersdaan_peeters@apple.be 2011-11-26 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 8.91 InvoiceLine: InvoiceId - 9 rows
371 8DaanPeetersdaan_peeters@apple.be 2013-07-02 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 1.98 InvoiceLine: InvoiceId - 2 rows
394 8DaanPeetersdaan_peeters@apple.be 2013-10-04 00:00:00 +0000 UTC Grétrystraat 63 Brussels [null] Belgium 1000 3.96 InvoiceLine: InvoiceId - 4 rows
85 45LadislavKovácsladislav_kovacs@apple.hu 2010-01-08 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 1.98 InvoiceLine: InvoiceId - 2 rows
96 45LadislavKovácsladislav_kovacs@apple.hu 2010-02-18 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 21.86 InvoiceLine: InvoiceId - 14 rows
151 45LadislavKovácsladislav_kovacs@apple.hu 2010-10-19 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 8.91 InvoiceLine: InvoiceId - 9 rows
280 45LadislavKovácsladislav_kovacs@apple.hu 2012-05-25 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 1.98 InvoiceLine: InvoiceId - 2 rows
303 45LadislavKovácsladislav_kovacs@apple.hu 2012-08-27 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 3.96 InvoiceLine: InvoiceId - 4 rows
325 45LadislavKovácsladislav_kovacs@apple.hu 2012-11-29 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 5.94 InvoiceLine: InvoiceId - 6 rows
377 45LadislavKovácsladislav_kovacs@apple.hu 2013-07-20 00:00:00 +0000 UTC Erzsébet krt. 58. Budapest [null] Hungary H-1073 0.99 InvoiceLine: InvoiceId - 1 rows
119 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2010-06-12 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 1.98 InvoiceLine: InvoiceId - 2 rows
142 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2010-09-14 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 3.96 InvoiceLine: InvoiceId - 4 rows
164 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2010-12-17 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 5.94 InvoiceLine: InvoiceId - 6 rows
216 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2011-08-07 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 0.99 InvoiceLine: InvoiceId - 1 rows
337 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2013-01-28 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 1.98 InvoiceLine: InvoiceId - 2 rows
348 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2013-03-10 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 13.86 InvoiceLine: InvoiceId - 14 rows
403 56DiegoGutiérrezdiego.gutierrez@yahoo.ar 2013-11-08 00:00:00 +0000 UTC 307 Macacha Güemes Buenos Aires [null] Argentina 1106 8.91 InvoiceLine: InvoiceId - 9 rows
92 24FrankRalstonfralston@gmail.com 2010-02-08 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 1.98 InvoiceLine: InvoiceId - 2 rows
103 24FrankRalstonfralston@gmail.com 2010-03-21 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 15.86 InvoiceLine: InvoiceId - 14 rows
158 24FrankRalstonfralston@gmail.com 2010-11-19 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 8.91 InvoiceLine: InvoiceId - 9 rows
287 24FrankRalstonfralston@gmail.com 2012-06-25 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 1.98 InvoiceLine: InvoiceId - 2 rows
310 24FrankRalstonfralston@gmail.com 2012-09-27 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 7.96 InvoiceLine: InvoiceId - 4 rows
332 24FrankRalstonfralston@gmail.com 2012-12-30 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 5.94 InvoiceLine: InvoiceId - 6 rows
384 24FrankRalstonfralston@gmail.com 2013-08-20 00:00:00 +0000 UTC 162 E Superior Street Chicago IL USA 60611 0.99 InvoiceLine: InvoiceId - 1 rows
56 9KaraNielsenkara.nielsen@jubii.dk 2009-09-06 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 1.98 InvoiceLine: InvoiceId - 2 rows
79 9KaraNielsenkara.nielsen@jubii.dk 2009-12-09 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 3.96 InvoiceLine: InvoiceId - 4 rows
101 9KaraNielsenkara.nielsen@jubii.dk 2010-03-13 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 5.94 InvoiceLine: InvoiceId - 6 rows
153 9KaraNielsenkara.nielsen@jubii.dk 2010-11-01 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 0.99 InvoiceLine: InvoiceId - 1 rows
274 9KaraNielsenkara.nielsen@jubii.dk 2012-04-24 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 1.98 InvoiceLine: InvoiceId - 2 rows
285 9KaraNielsenkara.nielsen@jubii.dk 2012-06-04 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 13.86 InvoiceLine: InvoiceId - 14 rows
340 9KaraNielsenkara.nielsen@jubii.dk 2013-02-02 00:00:00 +0000 UTC Sønder Boulevard 51 Copenhagen [null] Denmark 1720 8.91 InvoiceLine: InvoiceId - 9 rows
15 19TimGoyertgoyer@apple.com 2009-03-04 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 1.98 InvoiceLine: InvoiceId - 2 rows
26 19TimGoyertgoyer@apple.com 2009-04-14 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 13.86 InvoiceLine: InvoiceId - 14 rows
81 19TimGoyertgoyer@apple.com 2009-12-13 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 8.91 InvoiceLine: InvoiceId - 9 rows
210 19TimGoyertgoyer@apple.com 2011-07-20 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 1.98 InvoiceLine: InvoiceId - 2 rows
233 19TimGoyertgoyer@apple.com 2011-10-22 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 3.96 InvoiceLine: InvoiceId - 4 rows
255 19TimGoyertgoyer@apple.com 2012-01-24 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 5.94 InvoiceLine: InvoiceId - 6 rows
307 19TimGoyertgoyer@apple.com 2012-09-13 00:00:00 +0000 UTC 1 Infinite Loop Cupertino CA USA 95014 1.99 InvoiceLine: InvoiceId - 1 rows
120 58ManojPareekmanoj.pareek@rediff.com 2010-06-12 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 1.98 InvoiceLine: InvoiceId - 2 rows
131 58ManojPareekmanoj.pareek@rediff.com 2010-07-23 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 13.86 InvoiceLine: InvoiceId - 14 rows
186 58ManojPareekmanoj.pareek@rediff.com 2011-03-23 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 8.91 InvoiceLine: InvoiceId - 9 rows
315 58ManojPareekmanoj.pareek@rediff.com 2012-10-27 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 1.98 InvoiceLine: InvoiceId - 2 rows
338 58ManojPareekmanoj.pareek@rediff.com 2013-01-29 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 3.96 InvoiceLine: InvoiceId - 4 rows
360 58ManojPareekmanoj.pareek@rediff.com 2013-05-03 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 5.94 InvoiceLine: InvoiceId - 6 rows
412 58ManojPareekmanoj.pareek@rediff.com 2013-12-22 00:00:00 +0000 UTC 12,Community Centre Delhi [null] India 110017 1.99 InvoiceLine: InvoiceId - 1 rows
84 43IsabelleMercierisabelle_mercier@apple.fr 2010-01-08 00:00:00 +0000 UTC 68, Rue Jouvence Dijon [null] France 21000 1.98 InvoiceLine: InvoiceId - 2 rows
107 43IsabelleMercierisabelle_mercier@apple.fr 2010-04-12 00:00:00 +0000 UTC 68, Rue Jouvence Dijon [null] France 21000 3.96 InvoiceLine: InvoiceId - 4 rows
129 43IsabelleMercierisabelle_mercier@apple.fr 2010-07-15 00:00:00 +0000 UTC 68, Rue Jouvence Dijon [null] France 21000 5.94 InvoiceLine: InvoiceId - 6 rows
Sort
Reset Sort Order
BillingCity Ascending
Page
No earlier pages
Next Page >
412 rows in table
100 rows shown
Showing rows 1 to 100

Display
Switch to card view
^ top