← All tables and views
AdventureWorks OLTP table
HumanResources.Employee
Employee information such as salary, department, and title.
290rows
16 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
BusinessEntityID | INTEGER | no | PK | Person.Person.BusinessEntityID |
NationalIDNumber | TEXT | no | — | — |
LoginID | TEXT | no | — | — |
OrganizationNode | BLOB | yes | — | — |
OrganizationLevel | INTEGER | yes | — | — |
JobTitle | TEXT | no | — | — |
BirthDate | TEXT | no | — | — |
MaritalStatus | TEXT | no | — | — |
Gender | TEXT | no | — | — |
HireDate | TEXT | no | — | — |
SalariedFlag | INTEGER | no | — | — |
VacationHours | INTEGER | no | — | — |
SickLeaveHours | INTEGER | no | — | — |
CurrentFlag | INTEGER | no | — | — |
rowguid | TEXT | no | — | — |
ModifiedDate | TEXT | no | — | — |
Keys and unique indexes
Physical SQLite metadataPrimary key is declared above.
Additional unique keys
HumanResources_Employee_AK_Employee_LoginIDLoginIDHumanResources_Employee_AK_Employee_NationalIDNumberNationalIDNumberHumanResources_Employee_AK_Employee_rowguidrowguid3 unique indexes inspected
HumanResources_Employee_AK_Employee_LoginIDLoginIDCREATE UNIQUE INDEX "HumanResources_Employee_AK_Employee_LoginID" ON "HumanResources.Employee" ("LoginID")HumanResources_Employee_AK_Employee_NationalIDNumberNationalIDNumberCREATE UNIQUE INDEX "HumanResources_Employee_AK_Employee_NationalIDNumber" ON "HumanResources.Employee" ("NationalIDNumber")HumanResources_Employee_AK_Employee_rowguidrowguidCREATE UNIQUE INDEX "HumanResources_Employee_AK_Employee_rowguid" ON "HumanResources.Employee" ("rowguid")Data preview
Sample records
| BusinessEntityID | NationalIDNumber | LoginID | OrganizationNode | OrganizationLevel | JobTitle | BirthDate |
|---|---|---|---|---|---|---|
| 1 | 295847284 | adventure-works\ken0 | NULL | NULL | Chief Executive Officer | 1969-01-29 |
| 2 | 245797967 | adventure-works\terri0 | WA== | 1 | Vice President of Engineering | 1971-08-01 |
| 3 | 509647174 | adventure-works\roberto0 | WsA= | 2 | Engineering Manager | 1974-11-12 |
| 4 | 112457891 | adventure-works\rob0 | WtY= | 3 | Senior Tool Designer | 1974-12-23 |
| 5 | 695256908 | adventure-works\gail0 | Wto= | 3 | Design Engineer | 1952-09-27 |
| 6 | 998320692 | adventure-works\jossef0 | Wt4= | 3 | Design Engineer | 1959-03-11 |
| 7 | 134969118 | adventure-works\dylan0 | WuE= | 3 | Research and Development Manager | 1987-02-24 |
| 8 | 811994146 | adventure-works\diane1 | WuFY | 4 | Research and Development Engineer | 1986-06-05 |
Interactive explorer