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 asc 1 InvoiceDate sort BillingAddress sort BillingCity sort BillingState sort BillingCountry sort BillingPostalCode sort Total Referenced by
1 2LeonieKöhlerleonekohler@surfeu.de 2009-01-01 00:00:00 +0000 UTC Theodor-Heuss-Straße 34 Stuttgart [null] Germany 70174 1.98 InvoiceLine: InvoiceId - 2 rows
2 4BjørnHansenbjorn.hansen@yahoo.no 2009-01-02 00:00:00 +0000 UTC Ullevålsveien 14 Oslo [null] Norway 0171 3.96 InvoiceLine: InvoiceId - 4 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
4 14MarkPhilipsmphilips12@shaw.ca 2009-01-06 00:00:00 +0000 UTC 8210 111 ST NW Edmonton AB Canada T6G 2C7 8.91 InvoiceLine: InvoiceId - 9 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
6 37FynnZimmermannfzimmermann@yahoo.de 2009-01-19 00:00:00 +0000 UTC Berger Straße 10 Frankfurt [null] Germany 60316 0.99 InvoiceLine: InvoiceId - 1 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
8 40DominiqueLefebvredominiquelefebvre@gmail.com 2009-02-01 00:00:00 +0000 UTC 8, Rue Hanovre Paris [null] France 75002 1.98 InvoiceLine: InvoiceId - 2 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
10 46HughO'Reillyhughoreilly@apple.ie 2009-02-03 00:00:00 +0000 UTC 3 Chatham Street Dublin Dublin Ireland [null] 5.94 InvoiceLine: InvoiceId - 6 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
12 2LeonieKöhlerleonekohler@surfeu.de 2009-02-11 00:00:00 +0000 UTC Theodor-Heuss-Straße 34 Stuttgart [null] Germany 70174 13.86 InvoiceLine: InvoiceId - 14 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
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
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
16 21KathyChasekachase@hotmail.com 2009-03-05 00:00:00 +0000 UTC 801 W 4th Street Reno NV USA 89503 3.96 InvoiceLine: InvoiceId - 4 rows
17 25VictorStevensvstevens@yahoo.com 2009-03-06 00:00:00 +0000 UTC 319 N. Frances Street Madison WI USA 53703 5.94 InvoiceLine: InvoiceId - 6 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
19 40DominiqueLefebvredominiquelefebvre@gmail.com 2009-03-14 00:00:00 +0000 UTC 8, Rue Hanovre Paris [null] France 75002 13.86 InvoiceLine: InvoiceId - 14 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
21 55MarkTaylormark.taylor@yahoo.au 2009-04-04 00:00:00 +0000 UTC 421 Bourke Street Sidney NSW Australia 2010 1.98 InvoiceLine: InvoiceId - 2 rows
22 57LuisRojasluisrojas@yahoo.cl 2009-04-04 00:00:00 +0000 UTC Calle Lira, 198 Santiago [null] Chile [null] 1.98 InvoiceLine: InvoiceId - 2 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
24 4BjørnHansenbjorn.hansen@yahoo.no 2009-04-06 00:00:00 +0000 UTC Ullevålsveien 14 Oslo [null] Norway 0171 5.94 InvoiceLine: InvoiceId - 6 rows
25 10EduardoMartinseduardo@woodstock.com.br 2009-04-09 00:00:00 +0000 UTC Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 8.91 InvoiceLine: InvoiceId - 9 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
27 33EllieSullivanellie.sullivan@shaw.ca 2009-04-22 00:00:00 +0000 UTC 5112 48 Street Yellowknife NT Canada X1A 1N6 0.99 InvoiceLine: InvoiceId - 1 rows
28 34JoãoFernandesjfernandes@yahoo.pt 2009-05-05 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 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
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
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
33 57LuisRojasluisrojas@yahoo.cl 2009-05-15 00:00:00 +0000 UTC Calle Lira, 198 Santiago [null] Chile [null] 13.86 InvoiceLine: InvoiceId - 14 rows
34 12RobertoAlmeidaroberto.almeida@riotur.gov.br 2009-05-23 00:00:00 +0000 UTC Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 0.99 InvoiceLine: InvoiceId - 1 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
36 15JenniferPetersonjenniferp@rogers.ca 2009-06-05 00:00:00 +0000 UTC 700 W Pender Street Vancouver BC Canada V6C 1G8 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
38 21KathyChasekachase@hotmail.com 2009-06-07 00:00:00 +0000 UTC 801 W 4th Street Reno NV USA 89503 5.94 InvoiceLine: InvoiceId - 6 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
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
41 50EnriqueMuñozenrique_munoz@yahoo.es 2009-06-23 00:00:00 +0000 UTC C/ San Bernardo 85 Madrid [null] Spain 28015 0.99 InvoiceLine: InvoiceId - 1 rows
42 51JoakimJohanssonjoakim.johansson@yahoo.se 2009-07-06 00:00:00 +0000 UTC Celsiusg. 9 Stockholm [null] Sweden 11230 1.98 InvoiceLine: InvoiceId - 2 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
44 55MarkTaylormark.taylor@yahoo.au 2009-07-07 00:00:00 +0000 UTC 421 Bourke Street Sidney NSW Australia 2010 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
46 6HelenaHolýhholy@gmail.com 2009-07-11 00:00:00 +0000 UTC Rilská 3174/6 Prague [null] Czech Republic 14300 8.91 InvoiceLine: InvoiceId - 9 rows
47 15JenniferPetersonjenniferp@rogers.ca 2009-07-16 00:00:00 +0000 UTC 700 W Pender Street Vancouver BC Canada V6C 1G8 13.86 InvoiceLine: InvoiceId - 14 rows
48 29RobertBrownrobbrown@shaw.ca 2009-07-24 00:00:00 +0000 UTC 796 Dundas Street West Toronto ON Canada M6J 1V1 0.99 InvoiceLine: InvoiceId - 1 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
50 32AaronMitchellaaronmitchell@yahoo.ca 2009-08-06 00:00:00 +0000 UTC 696 Osborne Street Winnipeg MB Canada R3L 2B9 1.98 InvoiceLine: InvoiceId - 2 rows
51 34JoãoFernandesjfernandes@yahoo.pt 2009-08-07 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 3.96 InvoiceLine: InvoiceId - 4 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
53 44TerhiHämäläinenterhi.hamalainen@apple.fi 2009-08-11 00:00:00 +0000 UTC Porthaninkatu 9 Helsinki [null] Finland 00530 8.91 InvoiceLine: InvoiceId - 9 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
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
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
57 11AlexandreRochaalero@uol.com.br 2009-09-06 00:00:00 +0000 UTC Av. Paulista, 2022 São Paulo SP Brazil 01310-200 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
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
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
61 32AaronMitchellaaronmitchell@yahoo.ca 2009-09-16 00:00:00 +0000 UTC 696 Osborne Street Winnipeg MB Canada R3L 2B9 13.86 InvoiceLine: InvoiceId - 14 rows
62 46HughO'Reillyhughoreilly@apple.ie 2009-09-24 00:00:00 +0000 UTC 3 Chatham Street Dublin Dublin Ireland [null] 0.99 InvoiceLine: InvoiceId - 1 rows
63 47LucasMancinilucas.mancini@yahoo.it 2009-10-07 00:00:00 +0000 UTC Via Degli Scipioni, 43 Rome RM Italy 00192 1.98 InvoiceLine: InvoiceId - 2 rows
64 49StanisławWójcikstanisław.wójcik@wp.pl 2009-10-07 00:00:00 +0000 UTC Ordynacka 10 Warsaw [null] Poland 00-358 1.98 InvoiceLine: InvoiceId - 2 rows
65 51JoakimJohanssonjoakim.johansson@yahoo.se 2009-10-08 00:00:00 +0000 UTC Celsiusg. 9 Stockholm [null] Sweden 11230 3.96 InvoiceLine: InvoiceId - 4 rows
66 55MarkTaylormark.taylor@yahoo.au 2009-10-09 00:00:00 +0000 UTC 421 Bourke Street Sidney NSW Australia 2010 5.94 InvoiceLine: InvoiceId - 6 rows
67 2LeonieKöhlerleonekohler@surfeu.de 2009-10-12 00:00:00 +0000 UTC Theodor-Heuss-Straße 34 Stuttgart [null] Germany 70174 8.91 InvoiceLine: InvoiceId - 9 rows
68 11AlexandreRochaalero@uol.com.br 2009-10-17 00:00:00 +0000 UTC Av. Paulista, 2022 São Paulo SP Brazil 01310-200 13.86 InvoiceLine: InvoiceId - 14 rows
69 25VictorStevensvstevens@yahoo.com 2009-10-25 00:00:00 +0000 UTC 319 N. Frances Street Madison WI USA 53703 0.99 InvoiceLine: InvoiceId - 1 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
71 28JuliaBarnettjubarnett@gmail.com 2009-11-07 00:00:00 +0000 UTC 302 S 700 E Salt Lake City UT USA 84102 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
73 34JoãoFernandesjfernandes@yahoo.pt 2009-11-09 00:00:00 +0000 UTC Rua da Assunção 53 Lisbon [null] Portugal [null] 5.94 InvoiceLine: InvoiceId - 6 rows
74 40DominiqueLefebvredominiquelefebvre@gmail.com 2009-11-12 00:00:00 +0000 UTC 8, Rue Hanovre Paris [null] France 75002 8.91 InvoiceLine: InvoiceId - 9 rows
75 49StanisławWójcikstanisław.wójcik@wp.pl 2009-11-17 00:00:00 +0000 UTC Ordynacka 10 Warsaw [null] Poland 00-358 13.86 InvoiceLine: InvoiceId - 14 rows
76 4BjørnHansenbjorn.hansen@yahoo.no 2009-11-25 00:00:00 +0000 UTC Ullevålsveien 14 Oslo [null] Norway 0171 0.99 InvoiceLine: InvoiceId - 1 rows
77 5FrantišekWichterlováfrantisekw@jetbrains.com 2009-12-08 00:00:00 +0000 UTC Klanova 9/506 Prague [null] Czech Republic 14700 1.98 InvoiceLine: InvoiceId - 2 rows
78 7AstridGruberastrid.gruber@apple.at 2009-12-08 00:00:00 +0000 UTC Rotenturmstraße 4, 1010 Innere Stadt Vienne [null] Austria 1010 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
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
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
82 28JuliaBarnettjubarnett@gmail.com 2009-12-18 00:00:00 +0000 UTC 302 S 700 E Salt Lake City UT USA 84102 13.86 InvoiceLine: InvoiceId - 14 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
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
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
86 47LucasMancinilucas.mancini@yahoo.it 2010-01-09 00:00:00 +0000 UTC Via Degli Scipioni, 43 Rome RM Italy 00192 3.96 InvoiceLine: InvoiceId - 4 rows
87 51JoakimJohanssonjoakim.johansson@yahoo.se 2010-01-10 00:00:00 +0000 UTC Celsiusg. 9 Stockholm [null] Sweden 11230 6.94 InvoiceLine: InvoiceId - 6 rows
88 57LuisRojasluisrojas@yahoo.cl 2010-01-13 00:00:00 +0000 UTC Calle Lira, 198 Santiago [null] Chile [null] 17.91 InvoiceLine: InvoiceId - 9 rows
89 7AstridGruberastrid.gruber@apple.at 2010-01-18 00:00:00 +0000 UTC Rotenturmstraße 4, 1010 Innere Stadt Vienne [null] Austria 1010 18.86 InvoiceLine: InvoiceId - 14 rows
90 21KathyChasekachase@hotmail.com 2010-01-26 00:00:00 +0000 UTC 801 W 4th Street Reno NV USA 89503 0.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
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
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
94 30EdwardFrancisedfrancis@yachoo.ca 2010-02-10 00:00:00 +0000 UTC 230 Elgin Street Ottawa ON Canada K2P 1L7 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
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
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
98 1LuísGonçalvesluisg@embraer.com.br 2010-03-11 00:00:00 +0000 UTC Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 3.98 InvoiceLine: InvoiceId - 2 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
100 5FrantišekWichterlováfrantisekw@jetbrains.com 2010-03-12 00:00:00 +0000 UTC Klanova 9/506 Prague [null] Czech Republic 14700 3.96 InvoiceLine: InvoiceId - 4 rows
Sort
Reset Sort Order
InvoiceDate 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