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/02/11 09:05


wikibot

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

Columns

ColumnData TypeNullableDefaultDescription
ContactIDintnot null Primary key for Contact records.
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.
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.
rowguiduniqueidentifiernot null(newid())ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetimenot null(getdate())Date and time the record was last updated.

Primary Key

Primary KeyColumns
PK_Contact_ContactIDContactID

Indexes

IndexTypeColumns
AK_Contact_rowguidUniquerowguid
IX_Contact_EmailAddress EmailAddress
PXML_Contact_AddContact AdditionalContactInfo

Check Constraints

Check ConstraintExpressionDescription
CK_Contact_EmailPromotion(EmailPromotion>=(0) AND EmailPromotion<=(2))Check constraint EmailPromotion >= (0) AND EmailPromotion <= (2)

Detail Tables

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

References

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

Dependencies

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.