HumanResources.EmployeeAddress

Table: 'HumanResources.EmployeeAddress'

4 fields. 40 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
EmployeeIDint   Not nullPrimary key. Foreign key to Employee.EmployeeID. 
AddressIDint   Not nullPrimary key. Foreign key to Address.AddressID. 
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

The object has no extended properties.

Primary key for table 'HumanResources.EmployeeAddress'

Primary Key NameField Names
PK_EmployeeAddress_EmployeeID_AddressIDEmployeeID, AddressID

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

ForeignPrimaryKey Name
EmployeeAddress.EmployeeIDEmployee.EmployeeIDFK_EmployeeAddress_Employee_EmployeeID
EmployeeAddress.AddressIDAddress.AddressIDFK_EmployeeAddress_Address_AddressID

Indexes for table 'HumanResources.EmployeeAddress', 2 items

Index NameDescriptionClusteredUniqueFields
PK_EmployeeAddress_EmployeeID_AddressIDClustered index created by a primary key constraint.YesYesEmployeeID, AddressID
AK_EmployeeAddress_rowguidUnique nonclustered index. Used to support replication samples.NoYesrowguid

Triggers for table 'HumanResources.EmployeeAddress', 1 item

NameDescriptionTypeEnabled
uEmployeeAddressAFTER 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 NameTypeField Name
HumanResources.uEmployeeAddresstriggerN/A
HumanResources.vEmployeeviewN/A
Sales.vSalesPersonviewN/A