Person.EmailAddress - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	EmailAddress
Module	People

Where to send a person email.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.Person	Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID References: Person.Person
	2		EmailAddressID	int		Identity		Primary key. ID of this email address.
Primary key. ID of this email address. Identity
	3		EmailAddress	nvarchar(50)				E-mail address for the person.
E-mail address for the person.
	4		rowguid	uniqueidentifier		Default: newid()		ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. Default: newid()
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.EmailAddress		Person.Person	Person.EmailAddress.BusinessEntityID = Person.Person.BusinessEntityID	FK_EmailAddress_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.
Person.EmailAddress.BusinessEntityID = Person.Person.BusinessEntityID Name: FK_EmailAddress_Person_BusinessEntityID Foreign key constraint referencing Person.BusinessEntityID.

Unique keys

	Key name	Columns	Description
	PK_EmailAddress_BusinessEntityID_EmailAddressID	BusinessEntityID, EmailAddressID	Primary key (clustered) constraint
Primary key (clustered) constraint

Uses

Name
Person.EmailAddress
Person.Person

Used by

Name
Person.EmailAddress
HumanResources.vEmployee
Purchasing.vVendorWithContacts
Sales.vIndividualCustomer
Sales.vSalesPerson
Sales.vStoreWithContacts

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56