Cross-reference table mapping customers, vendors, and employees to their addresses.

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


Name Type Cardinality Description
BusinessEntityID int 1 - 1Primary key. Foreign key to BusinessEntity.BusinessEntityID.
AddressID int 1 - 1Primary key. Foreign key to Address.AddressID.
AddressTypeID int 1 - 1Primary key. Foreign key to AddressType.AddressTypeID.
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.


NameSourceSource attributeTargetTarget attribute
BusinessEntityID BusinessEntityAddressBusinessEntityIDBusinessEntityAddressBusinessEntityID
AddressID BusinessEntityAddressAddressIDBusinessEntityAddressAddressID
AddressTypeID BusinessEntityAddressAddressTypeIDBusinessEntityAddressAddressTypeID
rowguid BusinessEntityAddressrowguidBusinessEntityAddressrowguid
ModifiedDate BusinessEntityAddressModifiedDateBusinessEntityAddressModifiedDate


Physical example project

Linked elements