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

Mappings

NameSourceSource attributeTargetTarget attribute
AddressTypeID AddressTypeAddressTypeIDAddressTypeAddressTypeID
Name AddressTypeNameAddressTypeName
rowguid AddressTyperowguidAddressTyperowguid
ModifiedDate AddressTypeModifiedDateAddressTypeModifiedDate

Diagrams

Physical example project

Linked elements

Logical datamodel example

Physical datamodel example