HumanResources.EmployeeAddress

Table: 'HumanResources.EmployeeAddress'

4 fields. 40 bytes.

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

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
EmployeeID	int				Not null	Primary key. Foreign key to Employee.EmployeeID.
AddressID	int				Not null	Primary key. Foreign key to Address.AddressID.
rowguid	uniqueidentifier			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.EmployeeAddress'

Primary Key Name	Field Names
PK_EmployeeAddress_EmployeeID_AddressID	EmployeeID, AddressID

Foreign keys for table 'HumanResources.EmployeeAddress', 2 items

Foreign	Primary	Key Name
EmployeeAddress.EmployeeID	Employee.EmployeeID	FK_EmployeeAddress_Employee_EmployeeID
EmployeeAddress.AddressID	Address.AddressID	FK_EmployeeAddress_Address_AddressID

Indexes for table 'HumanResources.EmployeeAddress', 2 items

Index Name	Description	Clustered	Unique	Fields
PK_EmployeeAddress_EmployeeID_AddressID	Clustered index created by a primary key constraint.	Yes	Yes	EmployeeID, AddressID
AK_EmployeeAddress_rowguid	Unique nonclustered index. Used to support replication samples.	No	Yes	rowguid

Triggers for table 'HumanResources.EmployeeAddress', 1 item

Name	Description	Type	Enabled
uEmployeeAddress	AFTER UPDATE trigger setting the ModifiedDate column in the EmployeeAddress table to the current date.	after Update	Yes

Dependencies for table 'HumanResources.EmployeeAddress', 3 items

Object Name	Type	Field Name
HumanResources.uEmployeeAddress	trigger	N/A
HumanResources.vEmployee	view	N/A
Sales.vSalesPerson	view	N/A