Person.Contact (table)

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