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.