HumanResources.EmployeeAddress Table

Description

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

Properties

Creation Date	08/01/2010 08:40
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	290
Data Space Used	16.00 KB
Index Space Used	32.00 KB

Columns

Column Name	Description	Datatype	Length	Default
EmployeeID	Primary key. Foreign key to Employee.EmployeeID.	int	4
AddressID	Primary key. Foreign key to Address.AddressID.	int	4
rowguid	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	uniqueidentifier	16	(newid())
ModifiedDate	Date and time the record was last updated.	datetime	4	(getdate())

Indexes

Index	Description	Primary	Unique
AK_EmployeeAddress_rowguid	Unique nonclustered index. Used to support replication samples.
PK_EmployeeAddress_EmployeeID_AddressID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_EmployeeAddress_Address_AddressID	Foreign key constraint referencing Address.AddressID.
FK_EmployeeAddress_Employee_EmployeeID	Foreign key constraint referencing Employee.EmployeeID.

Objects that depend on HumanResources.EmployeeAddress

	Database Object	Object Type	Description	Dep Level
	HumanResources.vEmployee	View	Employee names and addresses.	1
	Sales.vSalesPerson	View	Sales representiatives (names and addresses) and their sales-related information.	1

Objects that HumanResources.EmployeeAddress depends on

Database Object	Object Type	Description	Dep Level
Person.Address	Table	Street address information for customers, employees, and vendors.	1
Person.Contact	Table	Names of each employee, customer contact, and vendor contact.	2
Person.CountryRegion	Table	Lookup table containing the ISO standard codes for countries and regions.	3
HumanResources.Employee	Table	Employee information such as salary, department, and title.	1
dbo.Name	User Defined Data Type		3
dbo.NameStyle	User Defined Data Type		3
dbo.Phone	User Defined Data Type		3
Sales.SalesTerritory	Table	Sales territory lookup table.	3
Person.StateProvince	Table	State and province lookup table.	2

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [HumanResources].[EmployeeAddress](
	[EmployeeID] [int] NOT NULL,
	[AddressID] [int] NOT NULL,
	[rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_EmployeeAddress_EmployeeID_AddressID] PRIMARY KEY CLUSTERED 
(
	[EmployeeID] ASC,
	[AddressID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

ALTER TABLE [HumanResources].[EmployeeAddress]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeAddress_Address_AddressID] FOREIGN KEY([AddressID])
REFERENCES [Address] ([AddressID])
ALTER TABLE [HumanResources].[EmployeeAddress] CHECK CONSTRAINT [FK_EmployeeAddress_Address_AddressID]
ALTER TABLE [HumanResources].[EmployeeAddress]  WITH CHECK ADD  CONSTRAINT [FK_EmployeeAddress_Employee_EmployeeID] FOREIGN KEY([EmployeeID])
REFERENCES [Employee] ([EmployeeID])
ALTER TABLE [HumanResources].[EmployeeAddress] CHECK CONSTRAINT [FK_EmployeeAddress_Employee_EmployeeID]
ALTER TABLE [HumanResources].[EmployeeAddress] ADD  CONSTRAINT [DF_EmployeeAddress_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [HumanResources].[EmployeeAddress] ADD  CONSTRAINT [DF_EmployeeAddress_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]

Related Objects