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.