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 asc 1 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
1 Adams Andrew General Manager [null] 1962-02-18 00:00:00 +0000 UTC 2002-08-14 00:00:00 +0000 UTC 11120 Jasper Ave NW Edmonton AB Canada T5K 2N1 +1 (780) 428-9482 +1 (780) 428-3457 andrew@chinookcorp.com Customer: SupportRepId - 0 rows
Employee: ReportsTo - 2 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
7 King Robert IT Staff 6MitchellMichaelIT Managermichael@chinookcorp.com 1970-05-29 00:00:00 +0000 UTC 2004-01-02 00:00:00 +0000 UTC 590 Columbia Boulevard West Lethbridge AB Canada T1K 5N8 +1 (403) 456-9986 +1 (403) 456-8485 robert@chinookcorp.com Customer: SupportRepId - 0 rows
Employee: ReportsTo - 0 rows
8 Callahan Laura IT Staff 6MitchellMichaelIT Managermichael@chinookcorp.com 1968-01-09 00:00:00 +0000 UTC 2004-03-04 00:00:00 +0000 UTC 923 7 ST NW Lethbridge AB Canada T1H 1Y8 +1 (403) 467-3351 +1 (403) 467-8772 laura@chinookcorp.com Customer: SupportRepId - 0 rows
Employee: ReportsTo - 0 rows
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
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
4 Park Margaret Sales Support Agent 2EdwardsNancySales Managernancy@chinookcorp.com 1947-09-19 00:00:00 +0000 UTC 2003-05-03 00:00:00 +0000 UTC 683 10 Street SW Calgary AB Canada T2P 5G3 +1 (403) 263-4423 +1 (403) 263-4289 margaret@chinookcorp.com Customer: SupportRepId - 20 rows
Employee: ReportsTo - 0 rows
5 Johnson Steve Sales Support Agent 2EdwardsNancySales Managernancy@chinookcorp.com 1965-03-03 00:00:00 +0000 UTC 2003-10-17 00:00:00 +0000 UTC 7727B 41 Ave Calgary AB Canada T3B 1Y7 1 (780) 836-9987 1 (780) 836-9543 steve@chinookcorp.com Customer: SupportRepId - 18 rows
Employee: ReportsTo - 0 rows
Sort
Reset Sort Order
Title Ascending
Page
No earlier pages
No more pages
8 rows in table
8 rows shown
Showing rows 1 to end

Display
Switch to card view
^ top