EmployeeAddress Table (AdventureWorks)

Maps employees in the Employee table to their address in the Address table.

EmployeeAddress Table Definition

The EmployeeAddress table is contained in the HumanResources schema.

Column	Data type	Nullability	Description
EmployeeID	int	Not null	Employee identification number. Foreign key to Employee.EmployeeID.
AddressID	int	Not null	Employee address identification number. Foreign key to Address.AddressID.
rowguid	uniqueidentifier ROWGUIDCOL	Not null	ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample.
ModifiedDate	datetime	Not null	Date and time the row was last updated.

See Also

Reference

Employee Table (AdventureWorks)

Address Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary