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
2 Edwards Nancy Sales Manager 1AdamsAndrewGeneral Managerandrew@chinookcorp.com 1958-12-08 00:00:00 +0000 UTC 2002-05-01 00:00:00 +0000 UTC 825 8 Ave SW Calgary AB Canada T2P 2T3 +1 (403) 262-3443 +1 (403) 262-3322 nancy@chinookcorp.com Customer: SupportRepId - 0 rows
Employee: ReportsTo - 3 rows
6 Mitchell Michael IT Manager 1AdamsAndrewGeneral Managerandrew@chinookcorp.com 1973-07-01 00:00:00 +0000 UTC 2003-10-17 00:00:00 +0000 UTC 5827 Bowness Road NW Calgary AB Canada T3B 0C5 +1 (403) 246-9887 +1 (403) 246-9899 michael@chinookcorp.com Customer: SupportRepId - 0 rows
Employee: ReportsTo - 2 rows
Filter
Clear Filter
ReportsTo 1
Page
No earlier pages
No more pages
8 rows in table
2 rows for this filter
2 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top