Object type: Table

Cross-reference table mapping employees to their address(es).

Columns 

Name	Data type	Nullable	Description
EmployeeID	int	No	Primary key. Foreign key to Employee.EmployeeID.
AddressID	int	No	Primary key. Foreign key to Address.AddressID.
rowguid	uniqueidentifier	No	Default value: NEWID() ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	No	Default value: GETDATE() Date and time the record was last updated.

Constraints 

Name	Type	Columns	Description
DF_EmployeeAddress_rowguid	DEFAULT	rowguid	Value: NEWID() Default constraint value of NEWID()
DF_EmployeeAddress_ModifiedDate	DEFAULT	ModifiedDate	Value: GETDATE() Default constraint value of GETDATE()
PK_EmployeeAddress_EmployeeID_AddressID	PRIMARY KEY	EmployeeID AddressID	Clustered index created by a primary key constraint.
FK_EmployeeAddress_Address_AddressID	FOREIGN KEY	AddressID	Reference table: Person.Address Foreign key constraint referencing Address.AddressID.
FK_EmployeeAddress_Employee_EmployeeID	FOREIGN KEY	EmployeeID	Reference table: HumanResources.Employee Foreign key constraint referencing Employee.EmployeeID.

Indices 

Name	Description
AK_EmployeeAddress_rowguid	Unique nonclustered index. Used to support replication samples.

Triggers 

Name	Description
HumanResources.uEmployeeAddress	AFTER UPDATE trigger setting the ModifiedDate column in the EmployeeAddress table to the current date.

Accessed by 

Name	Description
HumanResources.vEmployee	Employee names and addresses.
Sales.vSalesPerson	Sales representiatives (names and addresses) and their sales-related information.

Modified by 

Name	Description
HumanResources.uEmployeeAddress	AFTER UPDATE trigger setting the ModifiedDate column in the EmployeeAddress table to the current date.

Applies to

Tables | User

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation