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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Filter
Clear Filter
SupportRepId 5
Page
No earlier pages
No more pages
59 rows in table
18 rows for this filter
18 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top