Person.EmailAddress Table

Description

Where to send a person email.

Properties

Creation Date	27/10/2017 14:33
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	19972
Data Space Used	1,992.00 KB
Index Space Used	1,504.00 KB

Columns

Column Name	Description	Datatype	Length	Default
BusinessEntityID	Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID	Integer	4
EmailAddressID	Primary key. ID of this email address.	Integer	4
EmailAddress	E-mail address for the person.	VarWChar	50
rowguid	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.	GUID	16	(newid())
ModifiedDate	Date and time the record was last updated.	DBTimeStamp	4	(getdate())

Indexes

Index	Description	Primary	Unique
IX_EmailAddress_EmailAddress	Nonclustered index.
PK_EmailAddress_BusinessEntityID_EmailAddressID	Primary key (clustered) constraint

Relationships

Relationship	Description
FK_EmailAddress_Person_BusinessEntityID	Foreign key constraint referencing Person.BusinessEntityID.

Objects that depend on Person.EmailAddress

Database Object	Object Type	Description	Dep Level
HumanResources.vEmployee	View	Employee names and addresses.	1
Sales.vIndividualCustomer	View	Individual customers (names and addresses) that purchase Adventure Works Cycles products online.	1
Sales.vSalesPerson	View	Sales representiatives (names and addresses) and their sales-related information.	1
Sales.vStoreWithContacts	View	Stores (including store contacts) that sell Adventure Works Cycles products to consumers.	1
Purchasing.vVendorWithContacts	View	Vendor (company) names and the names of vendor employees to contact.	1

Objects that Person.EmailAddress depends on

Database Object	Object Type	Description	Dep Level
Person.BusinessEntity	Table	Source of the ID that connects vendors, customers, and employees with address and contact information.	2
dbo.Name	User Defined Data Type		2
dbo.NameStyle	User Defined Data Type		2
Person.Person	Table	Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.	1

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
CREATE TABLE [Person].[EmailAddress](
    [BusinessEntityID] [int] NOT NULL,
    [EmailAddressID] [int] IDENTITY(1,1) NOT NULL,
    [EmailAddress] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
    [rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
    [ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_EmailAddress_BusinessEntityID_EmailAddressID] PRIMARY KEY CLUSTERED 
(
    [BusinessEntityID] ASC,
    [EmailAddressID] 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 [Person].[EmailAddress] ADD  CONSTRAINT [DF_EmailAddress_rowguid]  DEFAULT (newid()) FOR [rowguid]
ALTER TABLE [Person].[EmailAddress] ADD  CONSTRAINT [DF_EmailAddress_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
ALTER TABLE [Person].[EmailAddress]  WITH CHECK ADD  CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID] FOREIGN KEY([BusinessEntityID])
REFERENCES [Person].[Person] ([BusinessEntityID])
ALTER TABLE [Person].[EmailAddress] CHECK CONSTRAINT [FK_EmailAddress_Person_BusinessEntityID]

Related Objects

Person Schema
AdventureWorks Database