EmailAddress

Copy from table to class by script

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

Attributes

Name	Type	Cardinality	Description
BusinessEntityID	String	1 - 1	Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
EmailAddressID	String	1 - 1	Primary key. ID of this email address.
EmailAddress	String	1 - 1	E-mail address for the person.
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
BusinessEntityID	EmailAddress	BusinessEntityID	EmailAddress	BusinessEntityID
EmailAddressID	EmailAddress	EmailAddressID	EmailAddress	EmailAddressID
EmailAddress	EmailAddress	EmailAddress	EmailAddress	EmailAddress
rowguid	EmailAddress	rowguid	EmailAddress	rowguid
ModifiedDate	EmailAddress	ModifiedDate	EmailAddress	ModifiedDate
BusinessEntityID	Lookup_EmailAddress	BusinessEntityID	EmailAddress	BusinessEntityID
EmailAddressID	Lookup_EmailAddress	EmailAddressID	EmailAddress	EmailAddressID
EmailAddress	Lookup_EmailAddress	EmailAddress	EmailAddress	EmailAddress

Diagrams

Data Mapping

Data mapping is an example diagram of a data mapping in the IDEA implementation This implementation can be used in for example an ETL process but also for documenting the data flows and transformations in message transformation process or component.