HumanResources.EmployeeAddress (table)

wikibot

Table

HumanResources.EmployeeAddress

Column	Data Type	Nullable	Default	PK	Index
EmployeeID	int	not null		PK_EmployeeAddress_EmployeeID_AddressID
AddressID	int	not null		PK_EmployeeAddress_EmployeeID_AddressID
rowguid	uniqueidentifier	not null	(newid())		AK_EmployeeAddress_rowguid
ModifiedDate	datetime	not null	(getdate())

Relation	Column	Referenced Column
Person.Address	AddressID	AddressID
HumanResources.Employee	EmployeeID	EmployeeID

automatically generated

Table	HumanResources.EmployeeAddress
Description	Cross-reference table mapping employees to their address(es).

Column	Data Type	Nullable	Default	Description	PK / Index
EmployeeID	int	not null		Primary key. Foreign key to Employee.EmployeeID.	PK_EmployeeAddress_EmployeeID_AddressID
AddressID	int	not null		Primary key. Foreign key to Address.AddressID.	PK_EmployeeAddress_EmployeeID_AddressID
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	AK_EmployeeAddress_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Relation	Column	Referenced Column
Person.Address	AddressID	AddressID
HumanResources.Employee	EmployeeID	EmployeeID