Address

Copy from table to class by script

Package Logical datamodel example
Author Bert Dingemans
Alias --
Stereotypes --

Attributes

Name Type Cardinality Description
AddressID String 1 - 1Primary key for Address records.
AddressLine1 String 1 - 1First street address line.
AddressLine2 String 1 - 1Second street address line.
City String 1 - 1Name of the city.
StateProvinceID String 1 - 1Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode String 1 - 1Postal code for the street address.
SpatialLocation String 1 - 1Latitude and longitude of this address.
rowguid String 1 - 1ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate String 1 - 1Date and time the record was last updated.

Mappings

NameSourceSource attributeTargetTarget attribute
AddressID AddressAddressIDAddressAddressID
AddressLine1 AddressAddressLine1AddressAddressLine1
AddressLine2 AddressAddressLine2AddressAddressLine2
City AddressCityAddressCity
StateProvinceID AddressStateProvinceIDAddressStateProvinceID
PostalCode AddressPostalCodeAddressPostalCode
SpatialLocation AddressSpatialLocationAddressSpatialLocation
rowguid AddressrowguidAddressrowguid
ModifiedDate AddressModifiedDateAddressModifiedDate

Diagrams

Linked elements

Conceptual datamodel example

Logical datamodel example

Physical datamodel example