Database reference - Nwind_new

Nwind_new - tables - Employees

Description

Employees' names, titles, and personal information.

Table properties

name	value
name	Employees
created	9/13/1995 10:51:32 AM
modified	8/16/2008 9:43:29 PM
row count	9

Columns

column	datatype	length	default	nulls	PK	FK	UQ	comment
EmployeeID	long	4		yes	yes	Orders.EmployeeID		Number automatically assigned to new employee.
LastName	text	20		no
FirstName	text	10		no
Title	text	30		yes				Employee's title.
TitleOfCourtesy	text	25		yes				Title used in salutations.
BirthDate	datetime	8		yes
HireDate	datetime	8		yes
Address	text	60		yes				Street or post-office box.
City	text	15		yes
Region	text	15		yes				State or province.
PostalCode	text	10		yes
Country	text	15		yes
HomePhone	text	24		yes				Phone number includes country code or area code.
Extension	text	4		yes				Internal telephone extension number.
Photo	OLE object	0		yes				Picture of employee.
Notes	memo	0		yes				General information about employee's background.
ReportsTo	long	4		yes				Employee's supervisor.

Indexes

name	description	column	comment
LastName	non-clustered, non-unique index on Employees	LastName
PostalCode	non-clustered, non-unique index on Employees	PostalCode
PrimaryKey	non-clustered, unique primary key on Employees	EmployeeID

References

name
Orders

Foreign key graph

OrdersEmployees

Foreign keys

name	columns	foreign columns	type	comment
EmployeesOrders	EmployeeID	Orders.EmployeeID

Check constraints

name	column	comment
ValidationRule BirthDate<Date()	BirthDate	Birth date can't be in the future.

Dependency graph

Employees LastNamePostalCodePrimaryKey~sq_cEmployees (page break)~sq_cReportsTo~sq_cEmployees~sq_cReportsTo~sq_cOrders~sq_cEmployeeID~sq_fEmployees~sq_fEmployees (page break)Employee Sales by Country

Objects that depend on Employees

name	object type	level
~sq_cEmployees (page break)~sq_cReportsTo	view	1
~sq_cEmployees~sq_cReportsTo	view	1
~sq_cOrders~sq_cEmployeeID	view	1
~sq_fEmployees	view	1
~sq_fEmployees (page break)	view	1
Employee Sales by Country	view	1

Sample rows

EmployeeID	LastName	FirstName	Title	TitleOfCourtesy	BirthDate	HireDate	Address	City	Region	PostalCode	Country	HomePhone	Extension	Photo	Notes	ReportsTo
1	Davolio	Nancy	Sales Representative	Ms.	12/8/1948 12:00:00 AM	5/1/1992 12:00:00 AM	507 - 20th Ave. E. Apt. 2A	Seattle	WA	98122	USA	(206) 555-9857	5467	System.Byte[]	Education includes a BA in psychology from Colorado State University in 1970. She also completed "T...	2
2	Fuller	Andrew	Vice President, Sales	Dr.	2/19/1952 12:00:00 AM	8/14/1992 12:00:00 AM	908 W. Capital Way	Tacoma	WA	98401	USA	(206) 555-9482	3457	System.Byte[]	Andrew received his BTS commercial in 1974 and a Ph.D. in international marketing from the Universit...	NULL
3	Leverling	Janet	Sales Representative	Ms.	8/30/1963 12:00:00 AM	4/1/1992 12:00:00 AM	722 Moss Bay Blvd.	Kirkland	WA	98033	USA	(206) 555-3412	3355	System.Byte[]	Janet has a BS degree in chemistry from Boston College (1984). She has also completed a certificate...	2
4	Peacock	Margaret	Sales Representative	Mrs.	9/19/1937 12:00:00 AM	5/3/1993 12:00:00 AM	4110 Old Redmond Rd.	Redmond	WA	98052	USA	(206) 555-8122	5176	System.Byte[]	Margaret holds a BA in English literature from Concordia College (1958) and an MA from the American ...	2
5	Buchanan	Steven	Sales Manager	Mr.	3/4/1955 12:00:00 AM	10/17/1993 12:00:00 AM	14 Garrett Hill	London	NULL	SW1 8JR	UK	(71) 555-4848	3453	System.Byte[]	Steven Buchanan graduated from St. Andrews University, Scotland, with a BSC degree in 1976. Upon jo...	2
6	Suyama	Michael	Sales Representative	Mr.	7/2/1963 12:00:00 AM	10/17/1993 12:00:00 AM	Coventry House Miner Rd.	London	NULL	EC2 7JR	UK	(71) 555-7773	428	System.Byte[]	Michael is a graduate of Sussex University (MA, economics, 1983) and the University of California at...	5
7	King	Robert	Sales Representative	Mr.	5/29/1960 12:00:00 AM	1/2/1994 12:00:00 AM	Edgeham Hollow Winchester Way	London	NULL	RG1 9SP	UK	(71) 555-5598	465	System.Byte[]	Robert King served in the Peace Corps and traveled extensively before completing his degree in Engli...	5
8	Callahan	Laura	Inside Sales Coordinator	Ms.	1/9/1958 12:00:00 AM	3/5/1994 12:00:00 AM	4726 - 11th Ave. N.E.	Seattle	WA	98105	USA	(206) 555-1189	2344	System.Byte[]	Laura received a BA in psychology from the University of Washington. She has also completed a cours...	2
9	Dodsworth	Anne	Sales Representative	Ms.	1/27/1966 12:00:00 AM	11/15/1994 12:00:00 AM	7 Houndstooth Rd.	London	NULL	WG2 7LT	UK	(71) 555-4444	452	System.Byte[]	Anne has a BA degree in English from St. Lawrence College. She is fluent in French and German.	5

Documentation generated by SqlSpec