Element

Title

BusinessEntityContact

Package Name

Physical datamodel example

Description

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

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDint11Primary key. Foreign key to BusinessEntity.BusinessEntityID.
PersonIDint11Primary key. Foreign key to Person.BusinessEntityID.
ContactTypeIDint11Primary key. Foreign key to ContactType.ContactTypeID.
rowguiduniqueidentifier11ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime11Date and time the record was last updated.


Display in diagrams

Linked elements