Person.BusinessEntityContact

Generated using SQL Data Dictionary demo version.

Table Person.BusinessEntityContact (909 rows)

Cross-reference table mapping stores, vendors, and employees to people

	Column	Data Type	Identity	Nullable	Default
PK, FK	BusinessEntityID	int
Primary key. Foreign key to BusinessEntity.BusinessEntityID.
PK, FK	PersonID	int
Primary key. Foreign key to Person.BusinessEntityID.
PK, FK	ContactTypeID	int
Primary key. Foreign key to ContactType.ContactTypeID.
UK	rowguid	uniqueidentifier			newid()
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
	ModifiedDate	datetime			getdate()
Date and time the record was last updated.

Indexes:

PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID
- (Primary Key)
- (Clustered)
Primary key (clustered) constraint
- BusinessEntityID
- PersonID
- ContactTypeID

AK_BusinessEntityContact_rowguid
- (Unique)
Unique nonclustered index. Used to support replication samples.
- rowguid

IX_BusinessEntityContact_ContactTypeID
Nonclustered index.
- ContactTypeID

IX_BusinessEntityContact_PersonID
Nonclustered index.
- PersonID

References:

Person.BusinessEntity
- BusinessEntityID

Person.ContactType
- ContactTypeID

Person.Person
- BusinessEntityID (PersonID)

Used by:

Function
dbo.ufnGetContactInformation
- BusinessEntityID
- ContactTypeID
- PersonID
View
Purchasing.vVendorWithContacts
- BusinessEntityID
- ContactTypeID
- PersonID
View
Sales.vStoreWithContacts
- BusinessEntityID
- ContactTypeID
- PersonID