Employees (Created 8/6/2000 1:34:04 AM)
Description: This table contains all of the employees.
Key | ID | Name | Data Type | Size(Precision,Scale) | Nulls | Default
|  | EmployeeID | int | 0 |  |
| The primary key for each employee.
|  | LastName | nvarchar | 20 |  |
| The employee's last name.
|  | FirstName | nvarchar | 10 |  |
| The employee's first name.
|  | Title | nvarchar | 30 |  |
| The employee's title.
|  | TitleOfCourtesy | nvarchar | 25 |  |
| The employee's title of courtesy.
|  | BirthDate | datetime | 0 |  |
| The employee's date of birth.
|  | HireDate | datetime | 0 |  |
| The employee's date of hire.
|  | Address | nvarchar | 60 |  |
| The employee's street address.
|  | City | nvarchar | 15 |  |
| The employee's city.
|  | Region | nvarchar | 15 |  |
| The employee's region.
|  | PostalCode | nvarchar | 10 |  |
| The employee's postal code.
|  | Country | nvarchar | 15 |  |
| The employee's country.
|  | HomePhone | nvarchar | 24 |  |
| The employee's home phone number.
|  | Extension | nvarchar | 4 |  |
| The employee's extension.
|  | Photo | image | 2147483647 |  |
| The employee's photo.
|  | Notes | ntext | 1073741823 |  |
| Notes about the employee.
|  | ReportsTo | int | 0 |  |
| Who the employee reports to.
|  | PhotoPath | nvarchar | 255 |  |
| The path to the employee's photo.