Difference between revisions of "Person.Contact (table)"

From dbscript Online Help
Jump to: navigation, search
Line 158: Line 158:
 
| ContactID
 
| ContactID
 
|}
 
|}
−
 
 
== automatically generated ==
 
== automatically generated ==
  
Line 180: Line 179:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description
+
| '''Description / PK / Index
−
| '''PK / Index
 
 
 
 
|-
 
|-
Line 188: Line 186:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Contact records.
+
| Primary key for Contact records.PK_Contact_ContactID
−
| PK_Contact_ContactID
 
 
|-
 
|-
 
| NameStyle
 
| NameStyle
Line 196: Line 193:
 
| (0)
 
| (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.
 
| 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
 
| Title
Line 203: Line 199:
 
|  
 
|  
 
| A courtesy title. For example, Mr. or Ms.
 
| A courtesy title. For example, Mr. or Ms.
−
|
 
 
|-
 
|-
 
| FirstName
 
| FirstName
Line 210: Line 205:
 
|  
 
|  
 
| First name of the person.
 
| First name of the person.
−
|
 
 
|-
 
|-
 
| MiddleName
 
| MiddleName
Line 217: Line 211:
 
|  
 
|  
 
| Middle name or middle initial of the person.
 
| Middle name or middle initial of the person.
−
|
 
 
|-
 
|-
 
| LastName
 
| LastName
Line 224: Line 217:
 
|  
 
|  
 
| Last name of the person.
 
| Last name of the person.
−
|
 
 
|-
 
|-
 
| Suffix
 
| Suffix
Line 231: Line 223:
 
|  
 
|  
 
| Surname suffix. For example, Sr. or Jr.
 
| Surname suffix. For example, Sr. or Jr.
−
|
 
 
|-
 
|-
 
| EmailAddress
 
| EmailAddress
Line 237: Line 228:
 
| null
 
| null
 
|  
 
|  
−
| E-mail address for the person.
+
| E-mail address for the person.IX_Contact_EmailAddress
−
| IX_Contact_EmailAddress
 
 
|-
 
|-
 
| EmailPromotion
 
| EmailPromotion
Line 245: Line 235:
 
| (0)
 
| (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.  
 
| 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
Line 252: Line 241:
 
|  
 
|  
 
| Phone number associated with the person.
 
| Phone number associated with the person.
−
|
 
 
|-
 
|-
 
| PasswordHash
 
| PasswordHash
Line 259: Line 247:
 
|  
 
|  
 
| Password for the e-mail account.
 
| Password for the e-mail account.
−
|
 
 
|-
 
|-
 
| PasswordSalt
 
| PasswordSalt
Line 266: Line 253:
 
|  
 
|  
 
| Random value concatenated with the password string before the password is hashed.
 
| Random value concatenated with the password string before the password is hashed.
−
|
 
 
|-
 
|-
 
| AdditionalContactInfo
 
| AdditionalContactInfo
Line 272: Line 258:
 
| null
 
| null
 
|  
 
|  
−
| Additional contact information about the person stored in xml format.  
+
| Additional contact information about the person stored in xml format. PXML_Contact_AddContact
−
| PXML_Contact_AddContact
 
 
|-
 
|-
 
| rowguid
 
| rowguid
Line 279: Line 264:
 
| not null
 
| not null
 
| (NEWID())
 
| (NEWID())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.AK_Contact_rowguid
−
| AK_Contact_rowguid
 
 
|-
 
|-
 
| ModifiedDate
 
| ModifiedDate
Line 287: Line 271:
 
| (GETDATE())
 
| (GETDATE())
 
| Date and time the record was last updated.
 
| Date and time the record was last updated.
−
|
 
 
|}
 
|}
  
Line 322: Line 305:
 
| ContactID
 
| ContactID
 
| ContactID
 
| ContactID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referenced Object
 +
| '''Object Type
 +
| '''Dependency Type
 +
 +
|-
 +
| [[dbo.Name_(type)|dbo.Name]]
 +
| Type
 +
| Data Type
 +
|-
 +
| [[dbo.NameStyle_(type)|dbo.NameStyle]]
 +
| Type
 +
| Data Type
 +
|-
 +
| [[dbo.Phone_(type)|dbo.Phone]]
 +
| Type
 +
| Data Type
 +
|-
 +
| [[Person.AdditionalContactInfoSchemaCollection_(xml_schema_collection)|Person.AdditionalContactInfoSchemaCollection]]
 +
| XML Schema Collection
 +
| Data Type
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[HumanResources.vEmployee_(view)|HumanResources.vEmployee]]
 +
| View
 +
| Select
 +
|-
 +
| [[HumanResources.vEmployeeDepartment_(view)|HumanResources.vEmployeeDepartment]]
 +
| View
 +
| Select
 +
|-
 +
| [[HumanResources.vEmployeeDepartmentHistory_(view)|HumanResources.vEmployeeDepartmentHistory]]
 +
| View
 +
| Select
 +
|-
 +
| [[Person.vAdditionalContactInfo_(view)|Person.vAdditionalContactInfo]]
 +
| View
 +
| Select
 +
|-
 +
| [[Purchasing.vVendor_(view)|Purchasing.vVendor]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vSalesPerson_(view)|Sales.vSalesPerson]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vSalesPersonSalesByFiscalYears_(view)|Sales.vSalesPersonSalesByFiscalYears]]
 +
| View
 +
| Select
 +
|-
 +
| [[Sales.vStoreWithDemographics_(view)|Sales.vStoreWithDemographics]]
 +
| View
 +
| Select
 +
|-
 +
| [[dbo.uspGetEmployeeManagers_(procedure)|dbo.uspGetEmployeeManagers]]
 +
| Procedure
 +
| Select
 +
|-
 +
| [[dbo.uspGetManagerEmployees_(procedure)|dbo.uspGetManagerEmployees]]
 +
| Procedure
 +
| Select
 +
|-
 +
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 +
| SQL table-valued-function
 +
| Select
 
|}
 
|}

Revision as of 23:52, 26 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


Referenced Object Object Type Dependency Type
dbo.Name Type Data Type
dbo.NameStyle Type Data Type
dbo.Phone Type Data Type
Person.AdditionalContactInfoSchemaCollection XML Schema Collection Data Type


Referencing Object Object Type Reference Type
HumanResources.vEmployee View Select
HumanResources.vEmployeeDepartment View Select
HumanResources.vEmployeeDepartmentHistory View Select
Person.vAdditionalContactInfo View Select
Purchasing.vVendor View Select
Sales.vIndividualCustomer View Select
Sales.vSalesPerson View Select
Sales.vSalesPersonSalesByFiscalYears View Select
Sales.vStoreWithDemographics View Select
dbo.uspGetEmployeeManagers Procedure Select
dbo.uspGetManagerEmployees Procedure Select
dbo.ufnGetContactInformation SQL table-valued-function Select
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.Contact_(table)&oldid=1178"