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 sort LastName sort Company sort Address sort City sort State sort Country sort PostalCode sort Phone sort Fax sort Email sort SupportRepId Referenced by
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Filter
Clear Filter
SupportRepId 4
Page
No earlier pages
No more pages
59 rows in table
20 rows for this filter
20 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top