8rows
15 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
EmployeeId | INTEGER | no | PK | — |
LastName | NVARCHAR(20) | no | — | — |
FirstName | NVARCHAR(20) | no | — | — |
Title | NVARCHAR(30) | yes | — | — |
ReportsTo | INTEGER | yes | — | Employee.EmployeeId |
BirthDate | DATETIME | yes | — | — |
HireDate | DATETIME | yes | — | — |
Address | NVARCHAR(70) | yes | — | — |
City | NVARCHAR(40) | yes | — | — |
State | NVARCHAR(40) | yes | — | — |
Country | NVARCHAR(40) | yes | — | — |
PostalCode | NVARCHAR(10) | yes | — | — |
Phone | NVARCHAR(24) | yes | — | — |
Fax | NVARCHAR(24) | yes | — | — |
Email | NVARCHAR(60) | yes | — | — |
Data preview
Sample records
| EmployeeId | LastName | FirstName | Title | ReportsTo | BirthDate | HireDate |
|---|---|---|---|---|---|---|
| 1 | Adams | Andrew | General Manager | NULL | 1962-02-18 00:00:00 | 2002-08-14 00:00:00 |
| 2 | Edwards | Nancy | Sales Manager | 1 | 1958-12-08 00:00:00 | 2002-05-01 00:00:00 |
| 3 | Peacock | Jane | Sales Support Agent | 2 | 1973-08-29 00:00:00 | 2002-04-01 00:00:00 |
| 4 | Park | Margaret | Sales Support Agent | 2 | 1947-09-19 00:00:00 | 2003-05-03 00:00:00 |
| 5 | Johnson | Steve | Sales Support Agent | 2 | 1965-03-03 00:00:00 | 2003-10-17 00:00:00 |
| 6 | Mitchell | Michael | IT Manager | 1 | 1973-07-01 00:00:00 | 2003-10-17 00:00:00 |
| 7 | King | Robert | IT Staff | 6 | 1970-05-29 00:00:00 | 2004-01-02 00:00:00 |
| 8 | Callahan | Laura | IT Staff | 6 | 1968-01-09 00:00:00 | 2004-03-04 00:00:00 |
Interactive explorer