Physical name  Employees   
Logical nameEmployees
Attributes18
Description 

PKPhysical nameDatatypeFK Ref.
EmployeeIDINT 
 LastNameNVARCHAR (20) 
 FirstNameNVARCHAR (10) 
 TitleNVARCHAR (30) 
 TitleOfCourtesyNVARCHAR (25) 
 BirthDateDATETIME 
 HireDateDATETIME 
 AddressNVARCHAR (60) 
 CityNVARCHAR (15) 
 RegionNVARCHAR (15) 
 PostalCodeNVARCHAR (10) 
 CountryNVARCHAR (15) 
 HomePhoneNVARCHAR (24) 
 ExtensionNVARCHAR (4) 
 PhotoIMAGE 
 NotesNTEXT 
 ReportsToINTEmployees.EmployeeID [FK_Emp_Emp]
 PhotoPathNVARCHAR (255) 

Indexes
LastName LastNameASC
PostalCode PostalCodeASC

ReferencesReferenced by
Employees [FK_Emp_Emp]   Employees [FK_Emp_Emp]
Orders [FK_Orders_Employees]
EmployeeTerritories [FK_EmpTer_Emp]