AdventureWorks

Basic Index   Expanded Index

Table Name:Person.Contact
Description:Names of each employee, customer contact, and vendor contact.
Primary Keys:ContactID
FieldTypeDefaultsNulls?Comments
ContactIDint - IdentityNoneNoPrimary key for Contact records.
NameStylebit((0))No0 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Titlenvarchar (8)NoneYesA courtesy title. For example, Mr. or Ms.
FirstNamenvarchar (50)NoneNoFirst name of the person.
MiddleNamenvarchar (50)NoneYesMiddle name or middle initial of the person.
LastNamenvarchar (50)NoneNoLast name of the person.
Suffixnvarchar (10)NoneYesSurname suffix. For example, Sr. or Jr.
EmailAddressnvarchar (50)NoneYesE-mail address for the person.
EmailPromotionint((0))No0 = 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.
Phonenvarchar (25)NoneYesPhone number associated with the person.
PasswordHashvarchar (128)NoneNoPassword for the e-mail account.
PasswordSaltvarchar (10)NoneNoRandom value concatenated with the password string before the password is hashed.
AdditionalContactInfoxmlNoneYesAdditional contact information about the person stored in xml format.
rowguiduniqueidentifier(newid())NoROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime(getdate())NoDate and time the record was last updated.

IndexClustered?Unique?Fields
PK_Contact_ContactIDYesYesContactID
AK_Contact_rowguidNoYesrowguid
IX_Contact_EmailAddressNoNoEmailAddress

Check ConstraintText
CK_Contact_EmailPromotion([EmailPromotion]>=(0) AND [EmailPromotion]<=(2))

No internal foreign key constraints
Primary Key as Foreign Key ConstraintAffected TableAffected Field
FK_ContactCreditCard_Contact_ContactIDSales.ContactCreditCardContactID
FK_Employee_Contact_ContactIDHumanResources.EmployeeContactID
FK_Individual_Contact_ContactIDSales.IndividualContactID
FK_SalesOrderHeader_Contact_ContactIDSales.SalesOrderHeaderContactID
FK_StoreContact_Contact_ContactIDSales.StoreContactContactID
FK_VendorContact_Contact_ContactIDPurchasing.VendorContactContactID

No triggers