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

From dbscript Online Help
Jump to: navigation, search
Line 18: Line 18:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''Description / PK / Index
+
| '''Description
 
 
 
|- valign="top"
 
|- valign="top"
Line 25: Line 25:
 
| not null
 
| not null
 
|  
 
|  
−
| Primary key for Contact records.<br />PK_Contact_ContactID
+
| Primary key for Contact records.
 
|- valign="top"
 
|- valign="top"
 
| NameStyle
 
| NameStyle
Line 31: Line 31:
 
| not null
 
| not null
 
| ((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.<br />
+
| 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"
 
|- valign="top"
 
| Title
 
| Title
Line 37: Line 37:
 
| null
 
| null
 
|  
 
|  
−
| A courtesy title. For example, Mr. or Ms.<br />
+
| A courtesy title. For example, Mr. or Ms.
 
|- valign="top"
 
|- valign="top"
 
| FirstName
 
| FirstName
Line 43: Line 43:
 
| not null
 
| not null
 
|  
 
|  
−
| First name of the person.<br />
+
| First name of the person.
 
|- valign="top"
 
|- valign="top"
 
| MiddleName
 
| MiddleName
Line 49: Line 49:
 
| null
 
| null
 
|  
 
|  
−
| Middle name or middle initial of the person.<br />
+
| Middle name or middle initial of the person.
 
|- valign="top"
 
|- valign="top"
 
| LastName
 
| LastName
Line 55: Line 55:
 
| not null
 
| not null
 
|  
 
|  
−
| Last name of the person.<br />
+
| Last name of the person.
 
|- valign="top"
 
|- valign="top"
 
| Suffix
 
| Suffix
Line 61: Line 61:
 
| null
 
| null
 
|  
 
|  
−
| Surname suffix. For example, Sr. or Jr.<br />
+
| Surname suffix. For example, Sr. or Jr.
 
|- valign="top"
 
|- valign="top"
 
| EmailAddress
 
| EmailAddress
Line 67: Line 67:
 
| null
 
| null
 
|  
 
|  
−
| E-mail address for the person.<br />IX_Contact_EmailAddress
+
| E-mail address for the person.
 
|- valign="top"
 
|- valign="top"
 
| EmailPromotion
 
| EmailPromotion
Line 73: Line 73:
 
| not null
 
| not null
 
| ((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. <br />
+
| 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"
 
|- valign="top"
 
| Phone
 
| Phone
Line 79: Line 79:
 
| null
 
| null
 
|  
 
|  
−
| Phone number associated with the person.<br />
+
| Phone number associated with the person.
 
|- valign="top"
 
|- valign="top"
 
| PasswordHash
 
| PasswordHash
Line 85: Line 85:
 
| not null
 
| not null
 
|  
 
|  
−
| Password for the e-mail account.<br />
+
| Password for the e-mail account.
 
|- valign="top"
 
|- valign="top"
 
| PasswordSalt
 
| PasswordSalt
Line 91: Line 91:
 
| not null
 
| not null
 
|  
 
|  
−
| Random value concatenated with the password string before the password is hashed.<br />
+
| Random value concatenated with the password string before the password is hashed.
 
|- valign="top"
 
|- valign="top"
 
| AdditionalContactInfo
 
| AdditionalContactInfo
Line 97: Line 97:
 
| null
 
| null
 
|  
 
|  
−
| Additional contact information about the person stored in xml format. <br />PXML_Contact_AddContact
+
| Additional contact information about the person stored in xml format.  
 
|- valign="top"
 
|- valign="top"
 
| rowguid
 
| rowguid
Line 103: Line 103:
 
| not null
 
| not null
 
| (newid())
 
| (newid())
−
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.<br />AK_Contact_rowguid
+
| ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
 
|- valign="top"
 
|- valign="top"
 
| ModifiedDate
 
| ModifiedDate
Line 109: Line 109:
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
| Date and time the record was last updated.<br />
+
| Date and time the record was last updated.
 
|}
 
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Primary Key
 +
| '''Columns
 +
|-
 +
| PK_Contact_ContactID
 +
| ContactID
 +
|}
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Index
 +
| '''Type
 +
| '''Columns
 +
 +
|-
 +
| AK_Contact_rowguid
 +
| Unique
 +
| rowguid
 +
|-
 +
| IX_Contact_EmailAddress
 +
|
 +
| EmailAddress
 +
|-
 +
| PXML_Contact_AddContact
 +
|
 +
| AdditionalContactInfo
 +
|}
  
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Check Constraint
 +
| '''Expression
 +
| '''Description
 +
 +
|-
 +
| CK_Contact_EmailPromotion
 +
| ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))
 +
| Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)
 +
|}
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"

Revision as of 22:36, 2 February 2010

wikibot

Table Person.Contact
Description Names of each employee, customer contact, and vendor contact.


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 Columns
PK_Contact_ContactID ContactID
Index Type Columns
AK_Contact_rowguid Unique rowguid
IX_Contact_EmailAddress EmailAddress
PXML_Contact_AddContact AdditionalContactInfo
Check Constraint Expression Description
CK_Contact_EmailPromotion ([EmailPromotion]>=(0) AND [EmailPromotion]<=(2)) Check constraint [EmailPromotion] >= (0) AND [EmailPromotion] <= (2)
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
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


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
Retrieved from "http://dbshelp.devio.at/index.php?title=Person.Contact_(table)&oldid=2060"