ScrewTurn Wiki

Edit

wikibot

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

Edit

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.

Edit

Primary Key

Primary KeyColumns
PK_Contact_ContactIDContactID

Edit

Indexes

IndexTypeColumns
AK_Contact_rowguidUniquerowguid
IX_Contact_EmailAddress EmailAddress
PXML_Contact_AddContact AdditionalContactInfo

Edit

Check Constraints

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

Edit

Detail Tables

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

Edit

References

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

Edit

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

Edit

automatically generated

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
NameStyleNameStylenot 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.
FirstNameNamenot null First name of the person.
MiddleNameNamenull Middle name or middle initial of the person.
LastNameNamenot 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.
PhonePhonenull 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
SchemaSchemaPerson
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 2.0.36. Some of the icons created by FamFamFam.