Person.Contact (table)

wikibot

Table	Person.Contact
Description	Names of each employee, customer contact, and vendor contact.

Columns

Column	Data Type	Nullable	Default	Description
ContactID	int	not null		Primary key for Contact records.
NameStyle	dbo.NameStyle	not null	((0))	0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Title	nvarchar(8)	null		A courtesy title. For example, Mr. or Ms.
FirstName	dbo.Name	not null		First name of the person.
MiddleName	dbo.Name	null		Middle name or middle initial of the person.
LastName	dbo.Name	not null		Last name of the person.
Suffix	nvarchar(10)	null		Surname suffix. For example, Sr. or Jr.
EmailAddress	nvarchar(50)	null		E-mail address for the person.
EmailPromotion	int	not null	((0))	0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
Phone	dbo.Phone	null		Phone number associated with the person.
PasswordHash	varchar(128)	not null		Password for the e-mail account.
PasswordSalt	varchar(10)	not null		Random value concatenated with the password string before the password is hashed.
AdditionalContactInfo	xml	null		Additional contact information about the person stored in xml format.
rowguid	uniqueidentifier	not null	(newid())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	not null	(getdate())	Date and time the record was last updated.

Primary Key

Primary Key	Columns
PK_Contact_ContactID	ContactID

Indexes

Index	Type	Columns
AK_Contact_rowguid	Unique	rowguid
IX_Contact_EmailAddress		EmailAddress
PXML_Contact_AddContact		AdditionalContactInfo

Check Constraints

Check Constraint	Expression	Description
CK_Contact_EmailPromotion	([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))	Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)

Detail Tables

Detail Table	Column	Referencing Column
Sales.ContactCreditCard	ContactID	ContactID
HumanResources.Employee	ContactID	ContactID
Sales.Individual	ContactID	ContactID
Sales.SalesOrderHeader	ContactID	ContactID
Sales.StoreContact	ContactID	ContactID
Purchasing.VendorContact	ContactID	ContactID

References

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Data Type	Type	dbo.NameStyle
Data Type	Type	dbo.Phone
Schema	Schema	Person
Data Type	XML Schema Collection	Person.AdditionalContactInfoSchemaCollection

Dependencies

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployee
Select	View	HumanResources.vEmployeeDepartment
Select	View	HumanResources.vEmployeeDepartmentHistory
Select	View	Person.vAdditionalContactInfo
Select	View	Purchasing.vVendor
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vSalesPerson
Select	View	Sales.vSalesPersonSalesByFiscalYears
Select	View	Sales.vStoreWithDemographics
Select	Procedure	dbo.uspGetEmployeeManagers
Select	Procedure	dbo.uspGetManagerEmployees
Select	SQL table-valued-function	dbo.ufnGetContactInformation

automatically generated

Table	Person.Contact
Description	Names of each employee, customer contact, and vendor contact.

Column	Data Type	Nullable	Default	Description / PK / Index
ContactID	int	not null		Primary key for Contact records. PK_Contact_ContactID
NameStyle	NameStyle	not null	(0)	0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Title	nvarchar(8)	null		A courtesy title. For example, Mr. or Ms.
FirstName	Name	not null		First name of the person.
MiddleName	Name	null		Middle name or middle initial of the person.
LastName	Name	not null		Last name of the person.
Suffix	nvarchar(10)	null		Surname suffix. For example, Sr. or Jr.
EmailAddress	nvarchar(50)	null		E-mail address for the person. IX_Contact_EmailAddress
EmailPromotion	int	not null	(0)	0 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
Phone	Phone	null		Phone number associated with the person.
PasswordHash	varchar(128)	not null		Password for the e-mail account.
PasswordSalt	varchar(10)	not null		Random value concatenated with the password string before the password is hashed.
AdditionalContactInfo	XML	null		Additional contact information about the person stored in xml format. PXML_Contact_AddContact
rowguid	uniqueidentifier	not null	(NEWID())	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_Contact_rowguid
ModifiedDate	datetime	not null	(GETDATE())	Date and time the record was last updated.

Detail Table	Column	Referencing Column
Sales.ContactCreditCard	ContactID	ContactID
HumanResources.Employee	ContactID	ContactID
Sales.Individual	ContactID	ContactID
Sales.SalesOrderHeader	ContactID	ContactID
Sales.StoreContact	ContactID	ContactID
Purchasing.VendorContact	ContactID	ContactID

Dependency Type	Object Type	Referenced Object
Data Type	Type	dbo.Name
Data Type	Type	dbo.NameStyle
Data Type	Type	dbo.Phone
Schema	Schema	Person
Data Type	XML Schema Collection	Person.AdditionalContactInfoSchemaCollection

Reference Type	Object Type	Referencing Object
Select	View	HumanResources.vEmployee
Select	View	HumanResources.vEmployeeDepartment
Select	View	HumanResources.vEmployeeDepartmentHistory
Select	View	Person.vAdditionalContactInfo
Select	View	Purchasing.vVendor
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vSalesPerson
Select	View	Sales.vSalesPersonSalesByFiscalYears
Select	View	Sales.vStoreWithDemographics
Select	Procedure	dbo.uspGetEmployeeManagers
Select	Procedure	dbo.uspGetManagerEmployees
Select	SQL table-valued-function	dbo.ufnGetContactInformation