EmployeeAddress Table (AdventureWorks)
Maps employees in the Employee table to their address in the Address table.
EmployeeAddress Table Definition
The EmployeeAddress table is contained in the HumanResources schema.
| Column | Data type | Nullability | Description |
|---|---|---|---|
EmployeeID |
int |
Not null |
Employee identification number. Foreign key to Employee.EmployeeID. |
AddressID |
int |
Not null |
Employee address identification number. Foreign key to Address.AddressID. |
rowguid |
uniqueidentifier ROWGUIDCOL |
Not null |
ROWGUIDCOL number that uniquely identifies the row. Used to support a merge replication sample. |
ModifiedDate |
datetime |
Not null |
Date and time the row was last updated. |
See Also
Reference
Employee Table (AdventureWorks)
Address Table (AdventureWorks)
Other Resources
AdventureWorks Data Dictionary