Difference between revisions of "Person.Contact (table)"
| Line 317: | Line 317: | ||
| Data Type | | Data Type | ||
| Type | | Type | ||
| − | | [[dbo.Name_(type)| | + | | [[dbo.Name_(type)|true.Name]] |
|- | |- | ||
| Data Type | | Data Type | ||
| Type | | Type | ||
| − | | [[dbo.NameStyle_(type)| | + | | [[dbo.NameStyle_(type)|true.NameStyle]] |
|- | |- | ||
| Data Type | | Data Type | ||
| Type | | Type | ||
| − | | [[dbo.Phone_(type)| | + | | [[dbo.Phone_(type)|true.Phone]] |
|- | |- | ||
| Schema | | Schema | ||
| Schema | | Schema | ||
| − | | [[Person_(schema)|.Person]] | + | | [[Person_(schema)|false.Person]] |
|- | |- | ||
| Data Type | | Data Type | ||
| XML Schema Collection | | XML Schema Collection | ||
| − | | [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)| | + | | [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|true.AdditionalContactInfoSchemaCollection]] |
|} | |} | ||
| Line 351: | Line 351: | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[HumanResources.vEmployee_(view)| | + | | [[HumanResources.vEmployee_(view)|true.vEmployee]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[HumanResources.vEmployeeDepartment_(view)| | + | | [[HumanResources.vEmployeeDepartment_(view)|true.vEmployeeDepartment]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[HumanResources.vEmployeeDepartmentHistory_(view)| | + | | [[HumanResources.vEmployeeDepartmentHistory_(view)|true.vEmployeeDepartmentHistory]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Person.vAdditionalContactInfo_(view)| | + | | [[Person.vAdditionalContactInfo_(view)|true.vAdditionalContactInfo]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Purchasing.vVendor_(view)| | + | | [[Purchasing.vVendor_(view)|true.vVendor]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Sales.vIndividualCustomer_(view)| | + | | [[Sales.vIndividualCustomer_(view)|true.vIndividualCustomer]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Sales.vSalesPerson_(view)| | + | | [[Sales.vSalesPerson_(view)|true.vSalesPerson]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Sales.vSalesPersonSalesByFiscalYears_(view)| | + | | [[Sales.vSalesPersonSalesByFiscalYears_(view)|true.vSalesPersonSalesByFiscalYears]] |
|- | |- | ||
| Select | | Select | ||
| View | | View | ||
| − | | [[Sales.vStoreWithDemographics_(view)| | + | | [[Sales.vStoreWithDemographics_(view)|true.vStoreWithDemographics]] |
|- | |- | ||
| Select | | Select | ||
| Procedure | | Procedure | ||
| − | | [[dbo.uspGetEmployeeManagers_(procedure)| | + | | [[dbo.uspGetEmployeeManagers_(procedure)|true.uspGetEmployeeManagers]] |
|- | |- | ||
| Select | | Select | ||
| Procedure | | Procedure | ||
| − | | [[dbo.uspGetManagerEmployees_(procedure)| | + | | [[dbo.uspGetManagerEmployees_(procedure)|true.uspGetManagerEmployees]] |
|- | |- | ||
| Select | | Select | ||
| SQL table-valued-function | | SQL table-valued-function | ||
| − | | [[dbo.ufnGetContactInformation_(function)| | + | | [[dbo.ufnGetContactInformation_(function)|true.ufnGetContactInformation]] |
|} | |} | ||
Revision as of 06:33, 30 November 2009
wikibot
| Table | Person.Contact |
| Column | Data Type | Nullable | Default | PK | Index |
| ContactID | int | not null | PK_Contact_ContactID | ||
| NameStyle | dbo.NameStyle | not null | ((0)) | ||
| Title | nvarchar(8) | null | |||
| FirstName | dbo.Name | not null | |||
| MiddleName | dbo.Name | null | |||
| LastName | dbo.Name | not null | |||
| Suffix | nvarchar(10) | null | |||
| EmailAddress | nvarchar(50) | null | IX_Contact_EmailAddress | ||
| EmailPromotion | int | not null | ((0)) | ||
| Phone | dbo.Phone | null | |||
| PasswordHash | varchar(128) | not null | |||
| PasswordSalt | varchar(10) | not null | |||
| AdditionalContactInfo | xml | null | PXML_Contact_AddContact | ||
| rowguid | uniqueidentifier | not null | (newid()) | AK_Contact_rowguid | |
| ModifiedDate | datetime | not null | (getdate()) |
| 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 |
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 | true.Name |
| Data Type | Type | true.NameStyle |
| Data Type | Type | true.Phone |
| Schema | Schema | false.Person |
| Data Type | XML Schema Collection | true.AdditionalContactInfoSchemaCollection |
| Reference Type | Object Type | Referencing Object |
| Select | View | true.vEmployee |
| Select | View | true.vEmployeeDepartment |
| Select | View | true.vEmployeeDepartmentHistory |
| Select | View | true.vAdditionalContactInfo |
| Select | View | true.vVendor |
| Select | View | true.vIndividualCustomer |
| Select | View | true.vSalesPerson |
| Select | View | true.vSalesPersonSalesByFiscalYears |
| Select | View | true.vStoreWithDemographics |
| Select | Procedure | true.uspGetEmployeeManagers |
| Select | Procedure | true.uspGetManagerEmployees |
| Select | SQL table-valued-function | true.ufnGetContactInformation |
