Person.Contact

Table: 'Person.Contact'

15 fields. 577 bytes.

Names of each employee, customer contact, and vendor contact.

Field Name	Data Type	Size	Original Type	Default	Nullable	Description	Check
ContactID	int identity		int		Not null	Primary key for Contact records.
NameStyle	NameStyle		bit	(0)	Not null	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		nvarchar(50)		Not null	First name of the person.
MiddleName	Name		nvarchar(50)		Null	Middle name or middle initial of the person.
LastName	Name		nvarchar(50)		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			(0)	Not null	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.	([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
Phone	Phone		nvarchar(25)		Null	Phone number associated with the person.
PasswordHash	varchar	40			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			newid()	Not null	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime			getdate()	Not null	Date and time the record was last updated.

Extended Properties

Object Type	Object Name	Property Name	Property Value
TABLE	Contact	Author	Mike Filony

Primary key for table 'Person.Contact'

Primary Key Name	Field Name
PK_Contact_ContactID	ContactID

There are no Foreign Keys for this table.

Indexes for table 'Person.Contact', 3 items

Index Name	Description	Clustered	Unique	Fields
PK_Contact_ContactID	Clustered index created by a primary key constraint.	Yes	Yes	ContactID
AK_Contact_rowguid	nonclustered, unique located on PRIMARY	No	Yes	rowguid
IX_Contact_EmailAddress	Nonclustered index.	No	No	EmailAddress

Triggers for table 'Person.Contact', 1 item

Name	Description	Type	Enabled
uContact	AFTER UPDATE trigger setting the ModifiedDate column in the Contact table to the current date.	after Update	Yes

Dependencies for table 'Person.Contact', 14 items

Object Name	Type	Field Name
dbo.ufnGetContactInformation	table function	N/A
dbo.uspGetEmployeeManagers	stored procedure	N/A
dbo.uspGetManagerEmployees	stored procedure	N/A
HumanResources.vEmployee	view	N/A
HumanResources.vEmployeeDepartment	view	N/A
HumanResources.vEmployeeDepartmentHistory	view	N/A
Person.CK_Contact_EmailPromotion	check cns	N/A
Person.uContact	trigger	N/A
Person.vAdditionalContactInfo	view	N/A
Purchasing.vVendor	view	N/A
Sales.vIndividualCustomer	view	N/A
Sales.vSalesPerson	view	N/A
Sales.vSalesPersonSalesByFiscalYears	view	N/A
Sales.vStoreWithDemographics	view	N/A