HumanResources.EmployeeAddress Table

Information

NameEmployeeAddress
SchemaHumanResources
Row Count0
Data Size 
Index Size 
Reserved Size 
Unused Size 
Created29.3.2010. 21:58:18
Modified29.3.2010. 21:58:54

Extended Properties

NameTypeProperty NameValue
EmployeeAddressTABLEMS_DescriptionCross-reference table mapping employees to their address(es).

Columns

PKKeyIdentityNameData TypeAllow NullsCollationReferencesDefaultComputedCompute Expression
   EmployeeIDint  HumanResources.Employee.EmployeeID
 
 
 
   AddressIDint  Person.Address.AddressID
 
 
 
   rowguiduniqueidentifier   
(newid())
 
 
   ModifiedDatedatetime   
(getdate())
 
 

Indexes

NameTypePrimaryUniqueColumns
PK_EmployeeAddress_EmployeeID_AddressIDClustered  EmployeeID, AddressID
AK_EmployeeAddress_rowguidNonClustered  rowguid

Foreign Key Constraints

NameTypeReferenced Table
FK_EmployeeAddress_Address_AddressIDForeign keyPerson.Address
FK_EmployeeAddress_Employee_EmployeeIDForeign keyHumanResources.Employee

SQL Script

CREATE TABLE [HumanResources].[EmployeeAddress] (
    [EmployeeID] int NOT NULL,
    [AddressID] int NOT NULL,
    [rowguid] uniqueidentifier NOT NULL DEFAULT (newid()),
    [ModifiedDate] datetime NOT NULL DEFAULT (getdate())
);
CREATE UNIQUE INDEX [AK_EmployeeAddress_rowguid] on [HumanResources].[EmployeeAddress]([rowguid]);