Column_name | Data type | Nullable | Default | Check | Key/index |
---|---|---|---|---|---|
EmployeeID | int | no | IDENTITY (1,1) | PK clust. | |
LastName | nvarchar(20) | no | Nonclust. | ||
FirstName | nvarchar(10) | no | |||
Title | nvarchar(30) | yes | |||
TitleOfCourtesy | nvarchar(25) | yes | |||
BirthDate | datetime | yes | yes1 | ||
HireDate | datetime | yes | |||
Address | nvarchar(60) | yes | |||
City | nvarchar(15) | yes | |||
Region | nvarchar(15) | yes | |||
PostalCode | nvarchar(10) | yes | Nonclust. | ||
Country | nvarchar(15) | yes | |||
HomePhone | nvarchar(24) | yes | |||
Extension | nvarchar(4) | yes | |||
Photo | image | yes | |||
Notes | ntext | yes | |||
ReportsTo | int | yes | FK Employees (EmployeeID) |
||
Photopath | nvarchar(255) | yes | |||
1The BirthDate CHECK constraint is defined as (BirthDate < GETDATE()). |
Note Some entries in the Address column of the Employees table contain newline characters that may affect the format of the result set columns.