IDEA & WPP Community
Home
Search
Keywords
ArchiMate search
Advanced search
Startpages
What is IDEA?
Conceptual demo
Logical
Physical
Data catalogue
About the WPP
All startpages
Overview
Packages
Diagrams
Conceptual Business entities
Conceptual Data entities
Logical entities
Extra
Exploring
Matrix on Package
Matrix on Diagram
Glossary
Charts
Release notes
Participant
Participate
Login
Contact
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 - 1
Primary key for Address records.
AddressLine1
String
1 - 1
First street address line.
AddressLine2
String
1 - 1
Second street address line.
City
String
1 - 1
Name of the city.
StateProvinceID
String
1 - 1
Unique identification number for the state or province. Foreign key to StateProvince table.
PostalCode
String
1 - 1
Postal code for the street address.
SpatialLocation
String
1 - 1
Latitude and longitude of this address.
rowguid
String
1 - 1
ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDate
String
1 - 1
Date and time the record was last updated.
Mappings
Name
Source
Source attribute
Target
Target attribute
AddressID
Address
AddressID
Address
AddressID
AddressLine1
Address
AddressLine1
Address
AddressLine1
AddressLine2
Address
AddressLine2
Address
AddressLine2
City
Address
City
Address
City
StateProvinceID
Address
StateProvinceID
Address
StateProvinceID
PostalCode
Address
PostalCode
Address
PostalCode
SpatialLocation
Address
SpatialLocation
Address
SpatialLocation
rowguid
Address
rowguid
Address
rowguid
ModifiedDate
Address
ModifiedDate
Address
ModifiedDate
Diagrams
Logical model example project
Linked elements
Conceptual datamodel example
Address trace
Logical datamodel example
BusinessEntityAddress FK
Physical datamodel example
Address
Address trace