Person.Contact

Table: 'Person.Contact'

15 fields. 577 bytes.

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

Field NameData TypeSizeOriginal TypeDefaultNullableDescriptionCheck
ContactIDint identity int Not nullPrimary key for Contact records. 
NameStyleNameStyle bit(0)Not null0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order. 
Titlenvarchar8  NullA courtesy title. For example, Mr. or Ms. 
FirstNameName nvarchar(50) Not nullFirst name of the person. 
MiddleNameName nvarchar(50) NullMiddle name or middle initial of the person. 
LastNameName nvarchar(50) Not nullLast name of the person. 
Suffixnvarchar10  NullSurname suffix. For example, Sr. or Jr. 
EmailAddressnvarchar50  NullE-mail address for the person. 
EmailPromotionint  (0)Not null0 = 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))
PhonePhone nvarchar(25) NullPhone number associated with the person. 
PasswordHashvarchar40  Not nullPassword for the e-mail account. 
PasswordSaltvarchar10  Not nullRandom value concatenated with the password string before the password is hashed. 
AdditionalContactInfoxml   NullAdditional contact information about the person stored in xml format.  
rowguiduniqueidentifier  newid()Not nullROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. 
ModifiedDatedatetime  getdate()Not nullDate and time the record was last updated. 

Extended Properties

Object TypeObject NameProperty NameProperty Value
TABLEContactAuthorMike Filony

Primary key for table 'Person.Contact'

Primary Key NameField Name
PK_Contact_ContactIDContactID
There are no Foreign Keys for this table.

Indexes for table 'Person.Contact', 3 items

Index NameDescriptionClusteredUniqueFields
PK_Contact_ContactIDClustered index created by a primary key constraint.YesYesContactID
AK_Contact_rowguidnonclustered, unique located on PRIMARYNoYesrowguid
IX_Contact_EmailAddressNonclustered index.NoNoEmailAddress

Triggers for table 'Person.Contact', 1 item

NameDescriptionTypeEnabled
uContactAFTER 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 NameTypeField Name
dbo.ufnGetContactInformationtable functionN/A
dbo.uspGetEmployeeManagersstored procedureN/A
dbo.uspGetManagerEmployeesstored procedureN/A
HumanResources.vEmployeeviewN/A
HumanResources.vEmployeeDepartmentviewN/A
HumanResources.vEmployeeDepartmentHistoryviewN/A
Person.CK_Contact_EmailPromotioncheck cnsN/A
Person.uContacttriggerN/A
Person.vAdditionalContactInfoviewN/A
Purchasing.vVendorviewN/A
Sales.vIndividualCustomerviewN/A
Sales.vSalesPersonviewN/A
Sales.vSalesPersonSalesByFiscalYearsviewN/A
Sales.vStoreWithDemographicsviewN/A