Welcome Guest, you are in: Login

devio dbscript ScrewTurn Wiki

RSS RSS

Navigation





Search the wiki
»

PoweredBy

Page History: Person Contact (table)

Compare Page Revisions



« Older Revision - Back to Page History - Newer Revision »


Page Revision: 2010/01/09 17:45


wikibot

TablePerson.Contact
DescriptionNames of each employee, customer contact, and vendor contact.

ColumnData TypeNullableDefaultDescription / PK / Index
ContactIDintnot null Primary key for Contact records.
PK_Contact_ContactID
NameStyledbo.NameStylenot 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.
Titlenvarchar(8)null A courtesy title. For example, Mr. or Ms.
FirstNamedbo.Namenot null First name of the person.
MiddleNamedbo.Namenull Middle name or middle initial of the person.
LastNamedbo.Namenot null Last name of the person.
Suffixnvarchar(10)null Surname suffix. For example, Sr. or Jr.
EmailAddressnvarchar(50)null E-mail address for the person.
IX_Contact_EmailAddress
EmailPromotionintnot 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.
Phonedbo.Phonenull Phone number associated with the person.
PasswordHashvarchar(128)not null Password for the e-mail account.
PasswordSaltvarchar(10)not null Random value concatenated with the password string before the password is hashed.
AdditionalContactInfoxmlnull Additional contact information about the person stored in xml format.
PXML_Contact_AddContact
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
AK_Contact_rowguid
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.



Detail TableColumnReferencing Column
Sales.ContactCreditCardContactIDContactID
HumanResources.EmployeeContactIDContactID
Sales.IndividualContactIDContactID
Sales.SalesOrderHeaderContactIDContactID
Sales.StoreContactContactIDContactID
Purchasing.VendorContactContactIDContactID

Dependency TypeObject TypeReferenced Object
Data TypeTypedbo.Name
Data TypeTypedbo.NameStyle
Data TypeTypedbo.Phone
Data TypeXML Schema CollectionPerson.AdditionalContactInfoSchemaCollection

Reference TypeObject TypeReferencing Object
SelectViewHumanResources.vEmployee
SelectViewHumanResources.vEmployeeDepartment
SelectViewHumanResources.vEmployeeDepartmentHistory
SelectViewPerson.vAdditionalContactInfo
SelectViewPurchasing.vVendor
SelectViewSales.vIndividualCustomer
SelectViewSales.vSalesPerson
SelectViewSales.vSalesPersonSalesByFiscalYears
SelectViewSales.vStoreWithDemographics
SelectProceduredbo.uspGetEmployeeManagers
SelectProceduredbo.uspGetManagerEmployees
SelectSQL table-valued-functiondbo.ufnGetContactInformation

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam.