ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Person.Contact_(table)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Table''' | Person.Contact |- valign="top" | '''Description''' | Names of each employee, customer contact, and vendor contact. |} === Columns === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description''' |- valign="top" | ContactID | int | not null | | Primary key for Contact records. |- valign="top" | NameStyle | dbo.NameStyle | not 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. |- valign="top" | Title | nvarchar(8) | null | | A courtesy title. For example, Mr. or Ms. |- valign="top" | FirstName | dbo.Name | not null | | First name of the person. |- valign="top" | MiddleName | dbo.Name | null | | Middle name or middle initial of the person. |- valign="top" | LastName | dbo.Name | not null | | Last name of the person. |- valign="top" | Suffix | nvarchar(10) | null | | Surname suffix. For example, Sr. or Jr. |- valign="top" | EmailAddress | nvarchar(50) | null | | E-mail address for the person. |- valign="top" | EmailPromotion | int | not 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. |- valign="top" | Phone | dbo.Phone | null | | Phone number associated with the person. |- valign="top" | PasswordHash | varchar(128) | not null | | Password for the e-mail account. |- valign="top" | PasswordSalt | varchar(10) | not null | | Random value concatenated with the password string before the password is hashed. |- valign="top" | AdditionalContactInfo | xml | null | | Additional contact information about the person stored in xml format. |- valign="top" | rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |- valign="top" | ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |} === Primary Key === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Primary Key''' | '''Columns''' |- valign="top" | PK_Contact_ContactID | ContactID |} === Indexes === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Index''' | '''Type''' | '''Columns''' |- valign="top" | AK_Contact_rowguid | Unique | rowguid |- valign="top" | IX_Contact_EmailAddress | | EmailAddress |- valign="top" | PXML_Contact_AddContact | | AdditionalContactInfo |} === Check Constraints === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Check Constraint''' | '''Expression''' | '''Description''' |- valign="top" | CK_Contact_EmailPromotion | ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) | Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2) |} === Detail Tables === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- valign="top" | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | ContactID | ContactID |- valign="top" | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ContactID | ContactID |- valign="top" | [[Sales.Individual_(table)|Sales.Individual]] | ContactID | ContactID |- valign="top" | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ContactID | ContactID |- valign="top" | [[Sales.StoreContact_(table)|Sales.StoreContact]] | ContactID | ContactID |- valign="top" | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] | ContactID | ContactID |} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- valign="top" | Data Type | Type | [[dbo.NameStyle_(type)|dbo.NameStyle]] |- valign="top" | Data Type | Type | [[dbo.Phone_(type)|dbo.Phone]] |- valign="top" | Schema | Schema | [[Person_(schema)|Person]] |- valign="top" | Data Type | XML Schema Collection | [[Person.AdditionalContactInfoSchemaCollection_(xml schema collection)|Person.AdditionalContactInfoSchemaCollection]] |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- valign="top" | Select | View | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] |- valign="top" | Select | View | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] |- valign="top" | Select | View | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] |- valign="top" | Select | View | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] |- valign="top" | Select | View | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] |- valign="top" | Select | View | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] |- valign="top" | Select | View | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] |- valign="top" | Select | View | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] |- valign="top" | Select | View | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] |- valign="top" | Select | Procedure | [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]] |- valign="top" | Select | Procedure | [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]] |- valign="top" | Select | SQL table-valued-function | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table''' | Person.Contact |- valign="top" | '''Description''' | Names of each employee, customer contact, and vendor contact. |- |- |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Column''' | '''Data Type''' | '''Nullable''' | '''Default''' | '''Description / PK / Index''' |- | ContactID | int | not null | | Primary key for Contact records.<br />PK_Contact_ContactID |- | NameStyle | NameStyle | not 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.<br /> |- | Title | nvarchar(8) | null | | A courtesy title. For example, Mr. or Ms.<br /> |- | FirstName | Name | not null | | First name of the person.<br /> |- | MiddleName | Name | null | | Middle name or middle initial of the person.<br /> |- | LastName | Name | not null | | Last name of the person.<br /> |- | Suffix | nvarchar(10) | null | | Surname suffix. For example, Sr. or Jr.<br /> |- | EmailAddress | nvarchar(50) | null | | E-mail address for the person.<br />IX_Contact_EmailAddress |- | EmailPromotion | int | not 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. <br /> |- | Phone | Phone | null | | Phone number associated with the person.<br /> |- | PasswordHash | varchar(128) | not null | | Password for the e-mail account.<br /> |- | PasswordSalt | varchar(10) | not null | | Random value concatenated with the password string before the password is hashed.<br /> |- | AdditionalContactInfo | XML | null | | Additional contact information about the person stored in xml format. <br />PXML_Contact_AddContact |- | rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Contact_rowguid |- | ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated.<br /> |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Detail Table''' | '''Column''' | '''Referencing Column''' |- | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | ContactID | ContactID |- | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ContactID | ContactID |- | [[Sales.Individual_(table)|Sales.Individual]] | ContactID | ContactID |- | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ContactID | ContactID |- | [[Sales.StoreContact_(table)|Sales.StoreContact]] | ContactID | ContactID |- | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] | ContactID | ContactID |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Data Type | Type | [[dbo.Name_(type)|dbo.Name]] |- | Data Type | Type | [[dbo.NameStyle_(type)|dbo.NameStyle]] |- | Data Type | Type | [[dbo.Phone_(type)|dbo.Phone]] |- | Schema | Schema | [[Person_(schema)|Person]] |- | Data Type | XML Schema Collection | [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|Person.AdditionalContactInfoSchemaCollection]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- | Select | View | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] |- | Select | View | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] |- | Select | View | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] |- | Select | View | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] |- | Select | View | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] |- | Select | View | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] |- | Select | View | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] |- | Select | View | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] |- | Select | View | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] |- | Select | Procedure | [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]] |- | Select | Procedure | [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]] |- | Select | SQL table-valued-function | [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.