Employees Table

Description

Employees' names, titles, and personal information.

Fields

Name	Type	Attributes	Default	Description
EmployeeID	int	Auto Increment		Number automatically assigned to new employee.
LastName	nvarchar(20)
FirstName	nvarchar(10)
Title	nvarchar(30)	Nullable		Employee's title.
TitleOfCourtesy	nvarchar(25)	Nullable		Title used in salutations.
BirthDate	datetime	Nullable
HireDate	datetime	Nullable
Address	nvarchar(60)	Nullable		Street or post-office box.
City	nvarchar(15)	Nullable
Region	nvarchar(15)	Nullable		State or province.
PostalCode	nvarchar(10)	Nullable
Country	nvarchar(15)	Nullable
HomePhone	nvarchar(24)	Nullable		Phone number includes country code or area code.
Extension	nvarchar(4)	Nullable		Internal telephone extension number.
Photo	image	Nullable		Picture of employee.
Notes	ntext	Nullable		General information about employee's background.
ReportsTo	int	Nullable		Employee's supervisor.
PhotoPath	nvarchar(255)	Nullable

Indexes

Name	Columns	Unique
LastName	LastName	no
PostalCode	PostalCode	no

Relationships

See Also

Tables | Views | Stored Procedures