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

Display
Switch to card view
^ top