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 asc 1 BillingAddress sort BillingCity sort BillingState sort BillingCountry sort BillingPostalCode sort Total Referenced by
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
14 17JackSmithjacksmith@microsoft.com 2009-03-04 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 1.98 InvoiceLine: InvoiceId - 2 rows
37 17JackSmithjacksmith@microsoft.com 2009-06-06 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 3.96 InvoiceLine: InvoiceId - 4 rows
59 17JackSmithjacksmith@microsoft.com 2009-09-08 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 5.94 InvoiceLine: InvoiceId - 6 rows
111 17JackSmithjacksmith@microsoft.com 2010-04-29 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 0.99 InvoiceLine: InvoiceId - 1 rows
232 17JackSmithjacksmith@microsoft.com 2011-10-21 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 1.98 InvoiceLine: InvoiceId - 2 rows
243 17JackSmithjacksmith@microsoft.com 2011-12-01 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 13.86 InvoiceLine: InvoiceId - 14 rows
298 17JackSmithjacksmith@microsoft.com 2012-07-31 00:00:00 +0000 UTC 1 Microsoft Way Redmond WA USA 98052-8300 10.91 InvoiceLine: InvoiceId - 9 rows
39 27PatrickGraypatrick.gray@aol.com 2009-06-10 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 8.91 InvoiceLine: InvoiceId - 9 rows
168 27PatrickGraypatrick.gray@aol.com 2011-01-15 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 1.98 InvoiceLine: InvoiceId - 2 rows
191 27PatrickGraypatrick.gray@aol.com 2011-04-19 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 3.96 InvoiceLine: InvoiceId - 4 rows
213 27PatrickGraypatrick.gray@aol.com 2011-07-22 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 5.94 InvoiceLine: InvoiceId - 6 rows
265 27PatrickGraypatrick.gray@aol.com 2012-03-11 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 0.99 InvoiceLine: InvoiceId - 1 rows
386 27PatrickGraypatrick.gray@aol.com 2013-09-02 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 1.98 InvoiceLine: InvoiceId - 2 rows
397 27PatrickGraypatrick.gray@aol.com 2013-10-13 00:00:00 +0000 UTC 1033 N Park Ave Tucson AZ USA 85719 13.86 InvoiceLine: InvoiceId - 14 rows
106 41MarcDuboismarc.dubois@hotmail.com 2010-04-11 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 1.98 InvoiceLine: InvoiceId - 2 rows
117 41MarcDuboismarc.dubois@hotmail.com 2010-05-22 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 13.86 InvoiceLine: InvoiceId - 14 rows
172 41MarcDuboismarc.dubois@hotmail.com 2011-01-20 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 8.91 InvoiceLine: InvoiceId - 9 rows
301 41MarcDuboismarc.dubois@hotmail.com 2012-08-26 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 1.98 InvoiceLine: InvoiceId - 2 rows
324 41MarcDuboismarc.dubois@hotmail.com 2012-11-28 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 3.96 InvoiceLine: InvoiceId - 4 rows
346 41MarcDuboismarc.dubois@hotmail.com 2013-03-02 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 5.94 InvoiceLine: InvoiceId - 6 rows
398 41MarcDuboismarc.dubois@hotmail.com 2013-10-21 00:00:00 +0000 UTC 11, Place Bellecour Lyon [null] France 69002 0.99 InvoiceLine: InvoiceId - 1 rows
20 54SteveMurraysteve.murray@yahoo.uk 2009-03-22 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 0.99 InvoiceLine: InvoiceId - 1 rows
141 54SteveMurraysteve.murray@yahoo.uk 2010-09-13 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 1.98 InvoiceLine: InvoiceId - 2 rows
152 54SteveMurraysteve.murray@yahoo.uk 2010-10-24 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 13.86 InvoiceLine: InvoiceId - 14 rows
207 54SteveMurraysteve.murray@yahoo.uk 2011-06-24 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 8.91 InvoiceLine: InvoiceId - 9 rows
336 54SteveMurraysteve.murray@yahoo.uk 2013-01-28 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 1.98 InvoiceLine: InvoiceId - 2 rows
359 54SteveMurraysteve.murray@yahoo.uk 2013-05-02 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 3.96 InvoiceLine: InvoiceId - 4 rows
381 54SteveMurraysteve.murray@yahoo.uk 2013-08-04 00:00:00 +0000 UTC 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH 5.94 InvoiceLine: InvoiceId - 6 rows
43 53PhilHughesphil.hughes@gmail.com 2009-07-06 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 1.98 InvoiceLine: InvoiceId - 2 rows
54 53PhilHughesphil.hughes@gmail.com 2009-08-16 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 13.86 InvoiceLine: InvoiceId - 14 rows
109 53PhilHughesphil.hughes@gmail.com 2010-04-16 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 8.91 InvoiceLine: InvoiceId - 9 rows
238 53PhilHughesphil.hughes@gmail.com 2011-11-21 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 1.98 InvoiceLine: InvoiceId - 2 rows
261 53PhilHughesphil.hughes@gmail.com 2012-02-23 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 3.96 InvoiceLine: InvoiceId - 4 rows
283 53PhilHughesphil.hughes@gmail.com 2012-05-27 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 5.94 InvoiceLine: InvoiceId - 6 rows
335 53PhilHughesphil.hughes@gmail.com 2013-01-15 00:00:00 +0000 UTC 113 Lupus St London [null] United Kingdom SW1V 3EN 0.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
91 22HeatherLeacockhleacock@gmail.com 2010-02-08 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 1.98 InvoiceLine: InvoiceId - 2 rows
114 22HeatherLeacockhleacock@gmail.com 2010-05-13 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 3.96 InvoiceLine: InvoiceId - 4 rows
136 22HeatherLeacockhleacock@gmail.com 2010-08-15 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 5.94 InvoiceLine: InvoiceId - 6 rows
188 22HeatherLeacockhleacock@gmail.com 2011-04-05 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 0.99 InvoiceLine: InvoiceId - 1 rows
309 22HeatherLeacockhleacock@gmail.com 2012-09-26 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 3.98 InvoiceLine: InvoiceId - 2 rows
320 22HeatherLeacockhleacock@gmail.com 2012-11-06 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 13.86 InvoiceLine: InvoiceId - 14 rows
375 22HeatherLeacockhleacock@gmail.com 2013-07-07 00:00:00 +0000 UTC 120 S Orange Ave Orlando FL USA 32801 8.91 InvoiceLine: InvoiceId - 9 rows
99 3FrançoisTremblayftremblay@gmail.com 2010-03-11 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 3.98 InvoiceLine: InvoiceId - 2 rows
110 3FrançoisTremblayftremblay@gmail.com 2010-04-21 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 13.86 InvoiceLine: InvoiceId - 14 rows
165 3FrançoisTremblayftremblay@gmail.com 2010-12-20 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 8.91 InvoiceLine: InvoiceId - 9 rows
294 3FrançoisTremblayftremblay@gmail.com 2012-07-26 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 1.98 InvoiceLine: InvoiceId - 2 rows
317 3FrançoisTremblayftremblay@gmail.com 2012-10-28 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 3.96 InvoiceLine: InvoiceId - 4 rows
339 3FrançoisTremblayftremblay@gmail.com 2013-01-30 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 5.94 InvoiceLine: InvoiceId - 6 rows
391 3FrançoisTremblayftremblay@gmail.com 2013-09-20 00:00:00 +0000 UTC 1498 rue Bélanger Montréal QC Canada H2G 1A7 0.99 InvoiceLine: InvoiceId - 1 rows
13 16FrankHarrisfharris@google.com 2009-02-19 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 0.99 InvoiceLine: InvoiceId - 1 rows
134 16FrankHarrisfharris@google.com 2010-08-13 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 1.98 InvoiceLine: InvoiceId - 2 rows
145 16FrankHarrisfharris@google.com 2010-09-23 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 13.86 InvoiceLine: InvoiceId - 14 rows
200 16FrankHarrisfharris@google.com 2011-05-24 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 8.91 InvoiceLine: InvoiceId - 9 rows
329 16FrankHarrisfharris@google.com 2012-12-28 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 1.98 InvoiceLine: InvoiceId - 2 rows
352 16FrankHarrisfharris@google.com 2013-04-01 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 3.96 InvoiceLine: InvoiceId - 4 rows
374 16FrankHarrisfharris@google.com 2013-07-04 00:00:00 +0000 UTC 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 5.94 InvoiceLine: InvoiceId - 6 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
18 31MarthaSilkmarthasilk@gmail.com 2009-03-09 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 8.91 InvoiceLine: InvoiceId - 9 rows
147 31MarthaSilkmarthasilk@gmail.com 2010-10-14 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 1.98 InvoiceLine: InvoiceId - 2 rows
170 31MarthaSilkmarthasilk@gmail.com 2011-01-16 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 3.96 InvoiceLine: InvoiceId - 4 rows
192 31MarthaSilkmarthasilk@gmail.com 2011-04-20 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 5.94 InvoiceLine: InvoiceId - 6 rows
244 31MarthaSilkmarthasilk@gmail.com 2011-12-09 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 0.99 InvoiceLine: InvoiceId - 1 rows
365 31MarthaSilkmarthasilk@gmail.com 2013-06-01 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 1.98 InvoiceLine: InvoiceId - 2 rows
376 31MarthaSilkmarthasilk@gmail.com 2013-07-12 00:00:00 +0000 UTC 194A Chain Lake Drive Halifax NS Canada B3S 1C5 13.86 InvoiceLine: InvoiceId - 14 rows
11 52EmmaJonesemma_jones@hotmail.com 2009-02-06 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 8.91 InvoiceLine: InvoiceId - 9 rows
140 52EmmaJonesemma_jones@hotmail.com 2010-09-13 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 1.98 InvoiceLine: InvoiceId - 2 rows
163 52EmmaJonesemma_jones@hotmail.com 2010-12-16 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 3.96 InvoiceLine: InvoiceId - 4 rows
185 52EmmaJonesemma_jones@hotmail.com 2011-03-20 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 5.94 InvoiceLine: InvoiceId - 6 rows
237 52EmmaJonesemma_jones@hotmail.com 2011-11-08 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 0.99 InvoiceLine: InvoiceId - 1 rows
358 52EmmaJonesemma_jones@hotmail.com 2013-05-01 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 1.98 InvoiceLine: InvoiceId - 2 rows
369 52EmmaJonesemma_jones@hotmail.com 2013-06-11 00:00:00 +0000 UTC 202 Hoxton Street London [null] United Kingdom N1 5LH 13.86 InvoiceLine: InvoiceId - 14 rows
70 26RichardCunninghamricunningham@hotmail.com 2009-11-07 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 1.98 InvoiceLine: InvoiceId - 2 rows
93 26RichardCunninghamricunningham@hotmail.com 2010-02-09 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 3.96 InvoiceLine: InvoiceId - 4 rows
115 26RichardCunninghamricunningham@hotmail.com 2010-05-14 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 5.94 InvoiceLine: InvoiceId - 6 rows
167 26RichardCunninghamricunningham@hotmail.com 2011-01-02 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 0.99 InvoiceLine: InvoiceId - 1 rows
288 26RichardCunninghamricunningham@hotmail.com 2012-06-25 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 1.98 InvoiceLine: InvoiceId - 2 rows
299 26RichardCunninghamricunningham@hotmail.com 2012-08-05 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 23.86 InvoiceLine: InvoiceId - 14 rows
354 26RichardCunninghamricunningham@hotmail.com 2013-04-05 00:00:00 +0000 UTC 2211 W Berry Street Fort Worth TX USA 76110 8.91 InvoiceLine: InvoiceId - 9 rows
49 30EdwardFrancisedfrancis@yachoo.ca 2009-08-06 00:00:00 +0000 UTC 230 Elgin Street Ottawa ON Canada K2P 1L7 1.98 InvoiceLine: InvoiceId - 2 rows
72 30EdwardFrancisedfrancis@yachoo.ca 2009-11-08 00:00:00 +0000 UTC 230 Elgin Street Ottawa ON Canada K2P 1L7 3.96 InvoiceLine: InvoiceId - 4 rows
Sort
Reset Sort Order
BillingAddress 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