dbo.Employees

Field Name	Type and Size	Default	Nullable
EmployeeID	int identity		NOT NULL
LastName	nvarchar(20)		NOT NULL
FirstName	nvarchar(10)		NOT NULL
Title	nvarchar(30)		NULL
TitleOfCourtesy	nvarchar(25)		NULL
BirthDate	datetime		NULL
HireDate	datetime		NULL
Address	nvarchar(60)		NULL
City	nvarchar(15)		NULL
Region	nvarchar(15)		NULL
PostalCode	nvarchar(10)		NULL
Country	nvarchar(15)		NULL
HomePhone	nvarchar(24)		NULL
Extension	nvarchar(4)		NULL
Photo	image		NULL
Notes	ntext		NULL
ReportsTo	int		NULL
PhotoPath	nvarchar(255)		NULL

Primary key for table 'dbo.Employees'

Primary Key Name	Fields
PK_Employees	EmployeeID

Foreign keys for table 'dbo.Employees', 1 item

Foreign	Primary
Employees.ReportsTo	Employees.EmployeeID

Indexes for table 'dbo.Employees', 3 items

Index Name	Clustered	Unique	Fields
PK_Employees	Yes	Yes	EmployeeID
LastName	No	No	LastName
PostalCode	No	No	PostalCode

Dependencies for table 'dbo.Employees', 3 items

Object Name	Type
dbo.CK_Birthdate	check cns
dbo.Employee Sales by Country	stored procedure
dbo.Invoices	view