Difference between revisions of "Person.Contact (table)"
| Line 2: | Line 2: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| − | |- | + | |- valign="top" |
| '''Table | | '''Table | ||
| Person.Contact | | Person.Contact | ||
| Line 8: | Line 8: | ||
| '''Description | | '''Description | ||
| Names of each employee, customer contact, and vendor contact. | | Names of each employee, customer contact, and vendor contact. | ||
| − | |||
|} | |} | ||
| − | |||
=== Columns === | === Columns === | ||
| Line 20: | Line 18: | ||
| '''Default | | '''Default | ||
| '''Description | | '''Description | ||
| − | + | ||
|- valign="top" | |- valign="top" | ||
| ContactID | | ContactID | ||
| Line 118: | Line 116: | ||
| '''Primary Key | | '''Primary Key | ||
| '''Columns | | '''Columns | ||
| − | |- | + | |- valign="top" |
| PK_Contact_ContactID | | PK_Contact_ContactID | ||
| ContactID | | ContactID | ||
| Line 129: | Line 127: | ||
| '''Type | | '''Type | ||
| '''Columns | | '''Columns | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| AK_Contact_rowguid | | AK_Contact_rowguid | ||
| Unique | | Unique | ||
| rowguid | | rowguid | ||
| − | |- | + | |- valign="top" |
| IX_Contact_EmailAddress | | IX_Contact_EmailAddress | ||
| | | | ||
| EmailAddress | | EmailAddress | ||
| − | |- | + | |- valign="top" |
| PXML_Contact_AddContact | | PXML_Contact_AddContact | ||
| | | | ||
| Line 150: | Line 148: | ||
| '''Expression | | '''Expression | ||
| '''Description | | '''Description | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| CK_Contact_EmailPromotion | | CK_Contact_EmailPromotion | ||
| ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) | | ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) | ||
| Line 163: | Line 161: | ||
| '''Column | | '''Column | ||
| '''Referencing Column | | '''Referencing Column | ||
| − | + | ||
| − | |- | + | |- valign="top" |
| [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | | [[Sales.ContactCreditCard_(table)|Sales.ContactCreditCard]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
| − | |- | + | |- valign="top" |
| [[HumanResources.Employee_(table)|HumanResources.Employee]] | | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
| − | |- | + | |- valign="top" |
| [[Sales.Individual_(table)|Sales.Individual]] | | [[Sales.Individual_(table)|Sales.Individual]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
| − | |- | + | |- valign="top" |
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | | [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
| − | |- | + | |- valign="top" |
| [[Sales.StoreContact_(table)|Sales.StoreContact]] | | [[Sales.StoreContact_(table)|Sales.StoreContact]] | ||
| ContactID | | ContactID | ||
| ContactID | | ContactID | ||
| − | |- | + | |- valign="top" |
| [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] | | [[Purchasing.VendorContact_(table)|Purchasing.VendorContact]] | ||
| ContactID | | ContactID | ||
| Line 197: | Line 195: | ||
| '''Referenced Object | | '''Referenced Object | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Type | | Type | ||
| [[dbo.Name_(type)|dbo.Name]] | | [[dbo.Name_(type)|dbo.Name]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Type | | Type | ||
| [[dbo.NameStyle_(type)|dbo.NameStyle]] | | [[dbo.NameStyle_(type)|dbo.NameStyle]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| Type | | Type | ||
| [[dbo.Phone_(type)|dbo.Phone]] | | [[dbo.Phone_(type)|dbo.Phone]] | ||
| − | |- | + | |- valign="top" |
| Schema | | Schema | ||
| Schema | | Schema | ||
| [[Person_(schema)|Person]] | | [[Person_(schema)|Person]] | ||
| − | |- | + | |- valign="top" |
| Data Type | | Data Type | ||
| XML Schema Collection | | XML Schema Collection | ||
| − | | [[Person.AdditionalContactInfoSchemaCollection_( | + | | [[Person.AdditionalContactInfoSchemaCollection_(xml schema collection)|Person.AdditionalContactInfoSchemaCollection]] |
|} | |} | ||
| Line 231: | Line 229: | ||
| '''Referencing Object | | '''Referencing Object | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | | [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] | | [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] | | [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] | | [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]] | | [[Purchasing.vVendor_(view)|Purchasing.vVendor]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] | | [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | | [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| View | | View | ||
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | | [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Procedure | | Procedure | ||
| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]] | | [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| Procedure | | Procedure | ||
| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]] | | [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]] | ||
| − | |- | + | |- valign="top" |
| Select | | Select | ||
| SQL table-valued-function | | SQL table-valued-function | ||
Revision as of 00:16, 24 June 2010
Contents
wikibot
| Table | Person.Contact |
| Description | Names of each employee, customer contact, and vendor contact. |
Columns
| Column | Data Type | Nullable | Default | Description |
| ContactID | int | not null | Primary key for Contact records. | |
| 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. |
| Title | nvarchar(8) | null | A courtesy title. For example, Mr. or Ms. | |
| FirstName | dbo.Name | not null | First name of the person. | |
| MiddleName | dbo.Name | null | Middle name or middle initial of the person. | |
| LastName | dbo.Name | not null | Last name of the person. | |
| Suffix | nvarchar(10) | null | Surname suffix. For example, Sr. or Jr. | |
| EmailAddress | nvarchar(50) | null | E-mail address for the person. | |
| 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. |
| Phone | dbo.Phone | null | Phone number associated with the person. | |
| PasswordHash | varchar(128) | not null | Password for the e-mail account. | |
| PasswordSalt | varchar(10) | not null | Random value concatenated with the password string before the password is hashed. | |
| AdditionalContactInfo | xml | null | Additional contact information about the person stored in xml format. | |
| rowguid | uniqueidentifier | not null | (newid()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |
Primary Key
| Primary Key | Columns |
| PK_Contact_ContactID | ContactID |
Indexes
| Index | Type | Columns |
| AK_Contact_rowguid | Unique | rowguid |
| IX_Contact_EmailAddress | EmailAddress | |
| PXML_Contact_AddContact | AdditionalContactInfo |
Check Constraints
| Check Constraint | Expression | Description |
| CK_Contact_EmailPromotion | ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) | Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2) |
Detail Tables
| Detail Table | Column | Referencing Column |
| Sales.ContactCreditCard | ContactID | ContactID |
| HumanResources.Employee | ContactID | ContactID |
| Sales.Individual | ContactID | ContactID |
| Sales.SalesOrderHeader | ContactID | ContactID |
| Sales.StoreContact | ContactID | ContactID |
| Purchasing.VendorContact | ContactID | ContactID |
References
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | dbo.Name |
| Data Type | Type | dbo.NameStyle |
| Data Type | Type | dbo.Phone |
| Schema | Schema | Person |
| Data Type | XML Schema Collection | Person.AdditionalContactInfoSchemaCollection |
Dependencies
| Reference Type | Object Type | Referencing Object |
| Select | View | HumanResources.vEmployee |
| Select | View | HumanResources.vEmployeeDepartment |
| Select | View | HumanResources.vEmployeeDepartmentHistory |
| Select | View | Person.vAdditionalContactInfo |
| Select | View | Purchasing.vVendor |
| Select | View | Sales.vIndividualCustomer |
| Select | View | Sales.vSalesPerson |
| Select | View | Sales.vSalesPersonSalesByFiscalYears |
| Select | View | Sales.vStoreWithDemographics |
| Select | Procedure | dbo.uspGetEmployeeManagers |
| Select | Procedure | dbo.uspGetManagerEmployees |
| Select | SQL table-valued-function | dbo.ufnGetContactInformation |
automatically generated
| Table | Person.Contact |
| Description | Names of each employee, customer contact, and vendor contact. |
| Column | Data Type | Nullable | Default | Description / PK / Index |
| ContactID | int | not null | Primary key for Contact records. 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. |
| Title | nvarchar(8) | null | A courtesy title. For example, Mr. or Ms. | |
| FirstName | Name | not null | First name of the person. | |
| MiddleName | Name | null | Middle name or middle initial of the person. | |
| LastName | Name | not null | Last name of the person. | |
| Suffix | nvarchar(10) | null | Surname suffix. For example, Sr. or Jr. | |
| EmailAddress | nvarchar(50) | null | E-mail address for the person. 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. |
| Phone | Phone | null | Phone number associated with the person. | |
| PasswordHash | varchar(128) | not null | Password for the e-mail account. | |
| PasswordSalt | varchar(10) | not null | Random value concatenated with the password string before the password is hashed. | |
| AdditionalContactInfo | XML | null | Additional contact information about the person stored in xml format. PXML_Contact_AddContact | |
| rowguid | uniqueidentifier | not null | (NEWID()) | ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample. AK_Contact_rowguid |
| ModifiedDate | datetime | not null | (GETDATE()) | Date and time the record was last updated. |
| Detail Table | Column | Referencing Column |
| Sales.ContactCreditCard | ContactID | ContactID |
| HumanResources.Employee | ContactID | ContactID |
| Sales.Individual | ContactID | ContactID |
| Sales.SalesOrderHeader | ContactID | ContactID |
| Sales.StoreContact | ContactID | ContactID |
| Purchasing.VendorContact | ContactID | ContactID |
| Dependency Type | Object Type | Referenced Object |
| Data Type | Type | dbo.Name |
| Data Type | Type | dbo.NameStyle |
| Data Type | Type | dbo.Phone |
| Schema | Schema | Person |
| Data Type | XML Schema Collection | Person.AdditionalContactInfoSchemaCollection |
| Reference Type | Object Type | Referencing Object |
| Select | View | HumanResources.vEmployee |
| Select | View | HumanResources.vEmployeeDepartment |
| Select | View | HumanResources.vEmployeeDepartmentHistory |
| Select | View | Person.vAdditionalContactInfo |
| Select | View | Purchasing.vVendor |
| Select | View | Sales.vIndividualCustomer |
| Select | View | Sales.vSalesPerson |
| Select | View | Sales.vSalesPersonSalesByFiscalYears |
| Select | View | Sales.vStoreWithDemographics |
| Select | Procedure | dbo.uspGetEmployeeManagers |
| Select | Procedure | dbo.uspGetManagerEmployees |
| Select | SQL table-valued-function | dbo.ufnGetContactInformation |
