9rows
18 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
EmployeeID | INTEGER | no | PK | — |
LastName | TEXT | yes | — | — |
FirstName | TEXT | yes | — | — |
Title | TEXT | yes | — | — |
TitleOfCourtesy | TEXT | yes | — | — |
BirthDate | DATE | yes | — | — |
HireDate | DATE | yes | — | — |
Address | TEXT | yes | — | — |
City | TEXT | yes | — | — |
Region | TEXT | yes | — | — |
PostalCode | TEXT | yes | — | — |
Country | TEXT | yes | — | — |
HomePhone | TEXT | yes | — | — |
Extension | TEXT | yes | — | — |
Photo | BLOB | yes | — | — |
Notes | TEXT | yes | — | — |
ReportsTo | INTEGER | yes | — | Employees.EmployeeID |
PhotoPath | TEXT | yes | — | — |
Data preview
Sample records
| EmployeeID | LastName | FirstName | Title | TitleOfCourtesy | BirthDate | HireDate |
|---|---|---|---|---|---|---|
| 1 | Davolio | Nancy | Sales Representative | Ms. | 1968-12-08 | 2012-05-01 |
| 2 | Fuller | Andrew | Vice President, Sales | Dr. | 1972-02-19 | 2012-08-14 |
| 3 | Leverling | Janet | Sales Representative | Ms. | 1983-08-30 | 2012-04-01 |
| 4 | Peacock | Margaret | Sales Representative | Mrs. | 1957-09-19 | 2013-05-03 |
| 5 | Buchanan | Steven | Sales Manager | Mr. | 1975-03-04 | 2013-10-17 |
| 6 | Suyama | Michael | Sales Representative | Mr. | 1983-07-02 | 2013-10-17 |
| 7 | King | Robert | Sales Representative | Mr. | 1980-05-29 | 2014-01-02 |
| 8 | Callahan | Laura | Inside Sales Coordinator | Ms. | 1978-01-09 | 2014-03-05 |
Interactive explorer