Person.Contact (table)

wikibot

Table

Person.Contact

Column	Data Type	Nullable	Default	PK	Index
ContactID	int	not null		PK_Contact_ContactID
NameStyle	dbo.NameStyle	not null	((0))
Title	nvarchar(8)	null
FirstName	dbo.Name	not null
MiddleName	dbo.Name	null
LastName	dbo.Name	not null
Suffix	nvarchar(10)	null
EmailAddress	nvarchar(50)	null			IX_Contact_EmailAddress
EmailPromotion	int	not null	((0))
Phone	dbo.Phone	null
PasswordHash	varchar(128)	not null
PasswordSalt	varchar(10)	not null
AdditionalContactInfo	xml	null			PXML_Contact_AddContact
rowguid	uniqueidentifier	not null	(newid())		AK_Contact_rowguid
ModifiedDate	datetime	not null	(getdate())

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

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

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

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