Street address information for customers, employees, and vendors.

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


Name Type Cardinality Description
AddressID int 1 - 1Primary key for Address records.
AddressLine1 nvarchar 1 - 1First street address line.
AddressLine2 nvarchar 1 - 1Second street address line.
City nvarchar 1 - 1Name of the city.
StateProvinceID int 1 - 1Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode nvarchar 1 - 1Postal code for the street address.
SpatialLocation geography 1 - 1Latitude and longitude of this address.
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
AddressID AddressAddressIDAddressAddressID
AddressLine1 AddressAddressLine1AddressAddressLine1
AddressLine2 AddressAddressLine2AddressAddressLine2
City AddressCityAddressCity
StateProvinceID AddressStateProvinceIDAddressStateProvinceID
PostalCode AddressPostalCodeAddressPostalCode
SpatialLocation AddressSpatialLocationAddressSpatialLocation
rowguid AddressrowguidAddressrowguid
ModifiedDate AddressModifiedDateAddressModifiedDate


Physical example project

Linked elements

Logical datamodel example

Physical datamodel example