Person.BusinessEntityContact - AdventureWorks

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	Person
Name	BusinessEntityContact
Module	People

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

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		BusinessEntityID	int			Person.BusinessEntity	Primary key. Foreign key to BusinessEntity.BusinessEntityID.
Primary key. Foreign key to BusinessEntity.BusinessEntityID. References: Person.BusinessEntity
	2		PersonID	int			Person.Person	Primary key. Foreign key to Person.BusinessEntityID.
Primary key. Foreign key to Person.BusinessEntityID. References: Person.Person
	3		ContactTypeID	int			Person.ContactType	Primary key. Foreign key to ContactType.ContactTypeID.
Primary key. Foreign key to ContactType.ContactTypeID. References: Person.ContactType
	4		rowguid	uniqueidentifier		Default: 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. Default: newid()
	5		ModifiedDate	datetime		Default: getdate()		Date and time the record was last updated.
Date and time the record was last updated. Default: getdate()

Relations

Foreign table		Primary table	Join	Title / Name / Description
Person.BusinessEntityContact		Person.BusinessEntity	Person.BusinessEntityContact.BusinessEntityID = Person.BusinessEntity.BusinessEntityID	FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.BusinessEntityContact.BusinessEntityID = Person.BusinessEntity.BusinessEntityID Name: FK_BusinessEntityContact_BusinessEntity_BusinessEntityID Foreign key constraint referencing BusinessEntity.BusinessEntityID.
Person.BusinessEntityContact		Person.ContactType	Person.BusinessEntityContact.ContactTypeID = Person.ContactType.ContactTypeID	FK_BusinessEntityContact_ContactType_ContactTypeID Foreign key constraint referencing ContactType.ContactTypeID.
Person.BusinessEntityContact.ContactTypeID = Person.ContactType.ContactTypeID Name: FK_BusinessEntityContact_ContactType_ContactTypeID Foreign key constraint referencing ContactType.ContactTypeID.
Person.BusinessEntityContact		Person.Person	Person.BusinessEntityContact.PersonID = Person.Person.BusinessEntityID	FK_BusinessEntityContact_Person_PersonID Foreign key constraint referencing Person.BusinessEntityID.
Person.BusinessEntityContact.PersonID = Person.Person.BusinessEntityID Name: FK_BusinessEntityContact_Person_PersonID Foreign key constraint referencing Person.BusinessEntityID.

Unique keys

	Key name	Columns	Description
	PK_BusinessEntityContact_BusinessEntityID_PersonID_ContactTypeID	BusinessEntityID, PersonID, ContactTypeID	Primary key (clustered) constraint
Primary key (clustered) constraint
	AK_BusinessEntityContact_rowguid	rowguid	Unique nonclustered index. Used to support replication samples.
Unique nonclustered index. Used to support replication samples.

Uses

Name
Person.BusinessEntityContact
Person.BusinessEntity
Person.ContactType
Person.Person

Used by

Name
Person.BusinessEntityContact
Purchasing.vVendorWithContacts
Sales.vStoreWithContacts
dbo.ufnGetContactInformation

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56