SQL Schema Explorer by Tim Abell

sqlite-chinook

Customer

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 CustomerId INTEGER NOT NULL Invoice(CustomerId) IPK_Customer
FirstName NVARCHAR(40) NOT NULL
LastName NVARCHAR(20) NOT NULL
Company NVARCHAR(80) Nullable
Address NVARCHAR(70) Nullable
City NVARCHAR(40) Nullable
State NVARCHAR(40) Nullable
Country NVARCHAR(40) Nullable
PostalCode NVARCHAR(10) Nullable
Phone NVARCHAR(24) Nullable
Fax NVARCHAR(24) Nullable
Email NVARCHAR(60) NOT NULL
SupportRepId INTEGER Nullable Employee(EmployeeId) IFK_CustomerSupportRepId

Foreign Keys

Outbound

From To
SupportRepId Employee(EmployeeId)

Inbound

From To
Invoice(CustomerId) CustomerId

Indexes

Name Columns Unique
IFK_CustomerSupportRepId SupportRepId
IPK_Customer CustomerId Unique

Data

Skip to Data Controls Show just the data
sort CustomerId sort FirstName asc 1 LastName sort Company sort Address sort City sort State sort Country sort PostalCode sort Phone sort Fax sort Email sort SupportRepId Referenced by
12 Roberto Almeida Riotur Praça Pio X, 119 Rio de Janeiro RJ Brazil 20040-020 +55 (21) 2271-7000 +55 (21) 2271-7070 roberto.almeida@riotur.gov.br 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
28 Julia Barnett [null] 302 S 700 E Salt Lake City UT USA 84102 +1 (801) 531-7272 [null] jubarnett@gmail.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
39 Camille Bernard [null] 4, Rue Milton Paris [null] France 75009 +33 01 49 70 65 65 [null] camille.bernard@yahoo.fr 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
18 Michelle Brooks [null] 627 Broadway New York NY USA 10012-2612 +1 (212) 221-3546 +1 (212) 221-4679 michelleb@aol.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
29 Robert Brown [null] 796 Dundas Street West Toronto ON Canada M6J 1V1 +1 (416) 363-8888 [null] robbrown@shaw.ca 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
21 Kathy Chase [null] 801 W 4th Street Reno NV USA 89503 +1 (775) 223-7665 [null] kachase@hotmail.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
26 Richard Cunningham [null] 2211 W Berry Street Fort Worth TX USA 76110 +1 (817) 924-7272 [null] ricunningham@hotmail.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
41 Marc Dubois [null] 11, Place Bellecour Lyon [null] France 69002 +33 04 78 30 30 30 [null] marc.dubois@hotmail.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
34 João Fernandes [null] Rua da Assunção 53 Lisbon [null] Portugal [null] +351 (213) 466-111 [null] jfernandes@yahoo.pt 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
30 Edward Francis [null] 230 Elgin Street Ottawa ON Canada K2P 1L7 +1 (613) 234-3322 [null] edfrancis@yachoo.ca 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
42 Wyatt Girard [null] 9, Place Louis Barthou Bordeaux [null] France 33000 +33 05 56 96 96 96 [null] wyatt.girard@yahoo.fr 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
1 Luís Gonçalves Embraer - Empresa Brasileira de Aeronáutica S.A. Av. Brigadeiro Faria Lima, 2170 São José dos Campos SP Brazil 12227-000 +55 (12) 3923-5555 +55 (12) 3923-5566 luisg@embraer.com.br 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
23 John Gordon [null] 69 Salem Street Boston MA USA 2113 +1 (617) 522-1333 [null] johngordon22@yahoo.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
19 Tim Goyer Apple Inc. 1 Infinite Loop Cupertino CA USA 95014 +1 (408) 996-1010 +1 (408) 996-1011 tgoyer@apple.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
27 Patrick Gray [null] 1033 N Park Ave Tucson AZ USA 85719 +1 (520) 622-4200 [null] patrick.gray@aol.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
7 Astrid Gruber [null] Rotenturmstraße 4, 1010 Innere Stadt Vienne [null] Austria 1010 +43 01 5134505 [null] astrid.gruber@apple.at 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
56 Diego Gutiérrez [null] 307 Macacha Güemes Buenos Aires [null] Argentina 1106 +54 (0)11 4311 4333 [null] diego.gutierrez@yahoo.ar 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
4 Bjørn Hansen [null] Ullevålsveien 14 Oslo [null] Norway 0171 +47 22 44 22 22 [null] bjorn.hansen@yahoo.no 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
16 Frank Harris Google Inc. 1600 Amphitheatre Parkway Mountain View CA USA 94043-1351 +1 (650) 253-0000 +1 (650) 253-0000 fharris@google.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
6 Helena Holý [null] Rilská 3174/6 Prague [null] Czech Republic 14300 +420 2 4177 0449 [null] hholy@gmail.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
53 Phil Hughes [null] 113 Lupus St London [null] United Kingdom SW1V 3EN +44 020 7976 5722 [null] phil.hughes@gmail.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
44 Terhi Hämäläinen [null] Porthaninkatu 9 Helsinki [null] Finland 00530 +358 09 870 2000 [null] terhi.hamalainen@apple.fi 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
51 Joakim Johansson [null] Celsiusg. 9 Stockholm [null] Sweden 11230 +46 08-651 52 52 [null] joakim.johansson@yahoo.se 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
52 Emma Jones [null] 202 Hoxton Street London [null] United Kingdom N1 5LH +44 020 7707 0707 [null] emma_jones@hotmail.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
45 Ladislav Kovács [null] Erzsébet krt. 58. Budapest [null] Hungary H-1073 [null] [null] ladislav_kovacs@apple.hu 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
2 Leonie Köhler [null] Theodor-Heuss-Straße 34 Stuttgart [null] Germany 70174 +49 0711 2842222 [null] leonekohler@surfeu.de 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
22 Heather Leacock [null] 120 S Orange Ave Orlando FL USA 32801 +1 (407) 999-7788 [null] hleacock@gmail.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
40 Dominique Lefebvre [null] 8, Rue Hanovre Paris [null] France 75002 +33 01 47 42 71 71 [null] dominiquelefebvre@gmail.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
47 Lucas Mancini [null] Via Degli Scipioni, 43 Rome RM Italy 00192 +39 06 39733434 [null] lucas.mancini@yahoo.it 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
10 Eduardo Martins Woodstock Discos Rua Dr. Falcão Filho, 155 São Paulo SP Brazil 01007-010 +55 (11) 3033-5446 +55 (11) 3033-4564 eduardo@woodstock.com.br 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
43 Isabelle Mercier [null] 68, Rue Jouvence Dijon [null] France 21000 +33 03 80 73 66 99 [null] isabelle_mercier@apple.fr 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
20 Dan Miller [null] 541 Del Medio Avenue Mountain View CA USA 94040-111 +1 (650) 644-3358 [null] dmiller@comcast.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
32 Aaron Mitchell [null] 696 Osborne Street Winnipeg MB Canada R3L 2B9 +1 (204) 452-6452 [null] aaronmitchell@yahoo.ca 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
54 Steve Murray [null] 110 Raeburn Pl Edinburgh [null] United Kingdom EH4 1HH +44 0131 315 3300 [null] steve.murray@yahoo.uk 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
50 Enrique Muñoz [null] C/ San Bernardo 85 Madrid [null] Spain 28015 +34 914 454 454 [null] enrique_munoz@yahoo.es 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
9 Kara Nielsen [null] Sønder Boulevard 51 Copenhagen [null] Denmark 1720 +453 3331 9991 [null] kara.nielsen@jubii.dk 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
46 Hugh O'Reilly [null] 3 Chatham Street Dublin Dublin Ireland [null] +353 01 6792424 [null] hughoreilly@apple.ie 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
58 Manoj Pareek [null] 12,Community Centre Delhi [null] India 110017 +91 0124 39883988 [null] manoj.pareek@rediff.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
8 Daan Peeters [null] Grétrystraat 63 Brussels [null] Belgium 1000 +32 02 219 03 03 [null] daan_peeters@apple.be 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
15 Jennifer Peterson Rogers Canada 700 W Pender Street Vancouver BC Canada V6C 1G8 +1 (604) 688-2255 +1 (604) 688-8756 jenniferp@rogers.ca 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
14 Mark Philips Telus 8210 111 ST NW Edmonton AB Canada T6G 2C7 +1 (780) 434-4554 +1 (780) 434-5565 mphilips12@shaw.ca 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
24 Frank Ralston [null] 162 E Superior Street Chicago IL USA 60611 +1 (312) 332-3232 [null] fralston@gmail.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
13 Fernanda Ramos [null] Qe 7 Bloco G Brasília DF Brazil 71020-677 +55 (61) 3363-5547 +55 (61) 3363-7855 fernadaramos4@uol.com.br 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
11 Alexandre Rocha Banco do Brasil S.A. Av. Paulista, 2022 São Paulo SP Brazil 01310-200 +55 (11) 3055-3278 +55 (11) 3055-8131 alero@uol.com.br 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
57 Luis Rojas [null] Calle Lira, 198 Santiago [null] Chile [null] +56 (0)2 635 4444 [null] luisrojas@yahoo.cl 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
35 Madalena Sampaio [null] Rua dos Campeões Europeus de Viena, 4350 Porto [null] Portugal [null] +351 (225) 022-448 [null] masampaio@sapo.pt 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
36 Hannah Schneider [null] Tauentzienstraße 8 Berlin [null] Germany 10789 +49 030 26550280 [null] hannah.schneider@yahoo.de 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
38 Niklas Schröder [null] Barbarossastraße 19 Berlin [null] Germany 10779 +49 030 2141444 [null] nschroder@surfeu.de 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
31 Martha Silk [null] 194A Chain Lake Drive Halifax NS Canada B3S 1C5 +1 (902) 450-0450 [null] marthasilk@gmail.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
17 Jack Smith Microsoft Corporation 1 Microsoft Way Redmond WA USA 98052-8300 +1 (425) 882-8080 +1 (425) 882-8081 jacksmith@microsoft.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
59 Puja Srivastava [null] 3,Raj Bhavan Road Bangalore [null] India 560001 +91 080 22289999 [null] puja_srivastava@yahoo.in 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 6 rows
25 Victor Stevens [null] 319 N. Frances Street Madison WI USA 53703 +1 (608) 257-0597 [null] vstevens@yahoo.com 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
33 Ellie Sullivan [null] 5112 48 Street Yellowknife NT Canada X1A 1N6 +1 (867) 920-2233 [null] ellie.sullivan@shaw.ca 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
55 Mark Taylor [null] 421 Bourke Street Sidney NSW Australia 2010 +61 (02) 9332 3633 [null] mark.taylor@yahoo.au 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
3 François Tremblay [null] 1498 rue Bélanger Montréal QC Canada H2G 1A7 +1 (514) 721-4711 [null] ftremblay@gmail.com 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
48 Johannes Van der Berg [null] Lijnbaansgracht 120bg Amsterdam VV Netherlands 1016 +31 020 6223130 [null] johavanderberg@yahoo.nl 5JohnsonSteveSales Support Agentsteve@chinookcorp.com Invoice: CustomerId - 7 rows
5 František Wichterlová JetBrains s.r.o. Klanova 9/506 Prague [null] Czech Republic 14700 +420 2 4172 5555 +420 2 4172 5555 frantisekw@jetbrains.com 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
49 Stanisław Wójcik [null] Ordynacka 10 Warsaw [null] Poland 00-358 +48 22 828 37 39 [null] stanisław.wójcik@wp.pl 4ParkMargaretSales Support Agentmargaret@chinookcorp.com Invoice: CustomerId - 7 rows
37 Fynn Zimmermann [null] Berger Straße 10 Frankfurt [null] Germany 60316 +49 069 40598889 [null] fzimmermann@yahoo.de 3PeacockJaneSales Support Agentjane@chinookcorp.com Invoice: CustomerId - 7 rows
Sort
Reset Sort Order
LastName Ascending
Page
No earlier pages
No more pages
59 rows in table
59 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top