SQL Schema Explorer by Tim Abell

sqlite-chinook

Employee

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 EmployeeId INTEGER NOT NULL Customer(SupportRepId) Employee(ReportsTo) IPK_Employee
LastName NVARCHAR(20) NOT NULL
FirstName NVARCHAR(20) NOT NULL
Title NVARCHAR(30) Nullable
ReportsTo INTEGER Nullable Employee(EmployeeId) IFK_EmployeeReportsTo
BirthDate DATETIME Nullable
HireDate DATETIME 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) Nullable

Foreign Keys

Outbound

From To
ReportsTo Employee(EmployeeId)

Inbound

From To
Customer(SupportRepId) EmployeeId
Employee(ReportsTo) EmployeeId

Indexes

Name Columns Unique
IFK_EmployeeReportsTo ReportsTo
IPK_Employee EmployeeId Unique

Data

Skip to Data Controls Show just the data
sort EmployeeId sort LastName sort FirstName sort Title sort ReportsTo sort BirthDate sort HireDate sort Address sort City sort State sort Country sort PostalCode sort Phone sort Fax sort Email Referenced by
3 Peacock Jane Sales Support Agent 2EdwardsNancySales Managernancy@chinookcorp.com 1973-08-29 00:00:00 +0000 UTC 2002-04-01 00:00:00 +0000 UTC 1111 6 Ave SW Calgary AB Canada T2P 5M5 +1 (403) 262-3443 +1 (403) 262-6712 jane@chinookcorp.com Customer: SupportRepId - 21 rows
Employee: ReportsTo - 0 rows
Filter
Clear Filter
EmployeeId 3
Page
No earlier pages
No more pages
8 rows in table
1 row for this filter
1 row shown
Showing rows 1 to end

Display
Switch to card view
^ top