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
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
Filter
Clear Filter
ReportsTo 6
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