Types of addresses stored in the Address table.

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


Name Type Cardinality Description
AddressTypeID int 1 - 1Primary key for AddressType records.
Name nvarchar 1 - 1Address type description. For example, Billing, Home, or Shipping.
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
AddressTypeID AddressTypeAddressTypeIDAddressTypeAddressTypeID
Name AddressTypeNameAddressTypeName
rowguid AddressTyperowguidAddressTyperowguid
ModifiedDate AddressTypeModifiedDateAddressTypeModifiedDate


Physical example project

Linked elements

Logical datamodel example

Physical datamodel example