BusinessEntityAddress

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

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.
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.

Mappings

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

Diagrams

Import Adventureworks Database

--

Physical example project

Physical data model for the TFG Academy example. It shows a subset of the tables as they are included in the TFG Academy database. These three entities are used and expanded in the other two layers logically and conceptually.

Linked elements

Logical datamodel example

Physical datamodel example