Databases > Northwind > Tables > Employees

Northwind

Employees

Created: Modified:

Columns

  • EmployeeID
    [int] IDENTITY (1,1) NOT NULL
  • LastName
    [nvarchar](20) NOT NULL
  • FirstName
    [nvarchar](10) NOT NULL
  • Title
    [nvarchar](30) NULL
  • TitleOfCourtesy
    [nvarchar](25) NULL
  • BirthDate
    [datetime] NULL
    //
    CONSTRAINT
    ([BirthDate]<getdate())
  • 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

Indexes

  • PK_Employees
    UNIQUE CLUSTERED
    EmployeeID
  • LastName
    NONCLUSTERED
    LastName
  • PostalCode
    NONCLUSTERED
    PostalCode

Foreign Keys

  • FK_Employees_Employees
    Employees
    ReportsTo ⥱ EmployeeID

Sample Data

EmployeeID
LastName
FirstName
Title
TitleOfCourtesy
BirthDate
HireDate
Address
City
Region
PostalCode
Country
HomePhone
Extension
Photo
Notes
ReportsTo
PhotoPath
1
Davolio
Nancy
Sales Representative
Ms.
507 - 20th Ave. E.Apt. 2A
Seattle
WA
98122
USA
(206) 555-9857
5467
[image]
Education includes a BA in psychology from Colorado State University in 1970. She also completed "The Art of the Cold Call." Nancy is a member of Toastmasters International.
2
http://accweb/emmployees/davolio.bmp
2
Fuller
Andrew
Vice President, Sales
Dr.
908 W. Capital Way
Tacoma
WA
98401
USA
(206) 555-9482
3457
[image]
Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the University of Dallas in 1981. He is fluent in French and Italian and reads German. He joined the company as a sales representative, was promoted to sales manager in January 1992 and to vice president of sales in March 1993. Andrew is a member of the Sales Management Roundtable, the Seattle Chamber of Commerce, and the Pacific Rim Importers Association.
NULL
http://accweb/emmployees/fuller.bmp
3
Leverling
Janet
Sales Representative
Ms.
722 Moss Bay Blvd.
Kirkland
WA
98033
USA
(206) 555-3412
3355
[image]
Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate program in food retailing management. Janet was hired as a sales associate in 1991 and promoted to sales representative in February 1992.
2
http://accweb/emmployees/leverling.bmp
4
Peacock
Margaret
Sales Representative
Mrs.
4110 Old Redmond Rd.
Redmond
WA
98052
USA
(206) 555-8122
5176
[image]
Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American Institute of Culinary Arts (1966). She was assigned to the London office temporarily from July through November 1992.
2
http://accweb/emmployees/peacock.bmp
5
Buchanan
Steven
Sales Manager
Mr.
14 Garrett Hill
London
NULL
SW1 8JR
UK
(71) 555-4848
3453
[image]
Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon joining the company as a sales representative in 1992, he spent 6 months in an orientation program at the Seattle office and then returned to his permanent post in London. He was promoted to sales manager in March 1993. Mr. Buchanan has completed the courses "Successful Telemarketing" and "International Sales Management." He is fluent in French.
2
http://accweb/emmployees/buchanan.bmp
6
Suyama
Michael
Sales Representative
Mr.
Coventry House Miner Rd.
London
NULL
EC2 7JR
UK
(71) 555-7773
428
[image]
Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at Los Angeles (MBA, marketing, 1986). He has also taken the courses "Multi-Cultural Selling" and "Time Management for the Sales Professional." He is fluent in Japanese and can read and write French, Portuguese, and Spanish.
5
http://accweb/emmployees/davolio.bmp
7
King
Robert
Sales Representative
Mr.
Edgeham Hollow Winchester Way
London
NULL
RG1 9SP
UK
(71) 555-5598
465
[image]
Robert King served in the Peace Corps and traveled extensively before completing his degree in English at the University of Michigan in 1992, the year he joined the company. After completing a course entitled "Selling in Europe," he was transferred to the London office in March 1993.
5
http://accweb/emmployees/davolio.bmp
8
Callahan
Laura
Inside Sales Coordinator
Ms.
4726 - 11th Ave. N.E.
Seattle
WA
98105
USA
(206) 555-1189
2344
[image]
Laura received a BA in psychology from the University of Washington. She has also completed a course in business French. She reads and writes French.
2
http://accweb/emmployees/davolio.bmp
9
Dodsworth
Anne
Sales Representative
Ms.
7 Houndstooth Rd.
London
NULL
WG2 7LT
UK
(71) 555-4444
452
[image]
Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.
5
http://accweb/emmployees/davolio.bmp