BusinessEntityContact

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

Package Physical datamodel example
Author Bert Dingemans
Alias --
Stereotypes table

Attributes

Name Type Cardinality Description
BusinessEntityID int 1 - 1Primary key. Foreign key to BusinessEntity.BusinessEntityID.
PersonID int 1 - 1Primary key. Foreign key to Person.BusinessEntityID.
ContactTypeID int 1 - 1Primary key. Foreign key to ContactType.ContactTypeID.
rowguid uniqueidentifier 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate datetime 1 - 1Date and time the record was last updated.

Diagrams

Import Adventureworks Database

--

Linked elements

Physical datamodel example