AddressType

Types of addresses stored in the Address table.

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

Attributes

Name	Type	Cardinality	Description
AddressTypeID	int	1 - 1	Primary key for AddressType records.
Name	nvarchar	1 - 1	Address type description. For example, Billing, Home, or Shipping.
rowguid	uniqueidentifier	1 - 1	ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate	datetime	1 - 1	Date and time the record was last updated.

Mappings

Name	Source	Source attribute	Target	Target attribute
AddressTypeID	AddressType	AddressTypeID	AddressType	AddressTypeID
Name	AddressType	Name	AddressType	Name
rowguid	AddressType	rowguid	AddressType	rowguid
ModifiedDate	AddressType	ModifiedDate	AddressType	ModifiedDate

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

BusinessEntityAddress FK