Page History: HumanResources EmployeeAddress (table)

Compare Page Revisions

wikibot ¶

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.