Copy from table to class by script

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


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


NameSourceSource attributeTargetTarget attribute
BusinessEntityID EmailAddressBusinessEntityIDEmailAddressBusinessEntityID
EmailAddressID EmailAddressEmailAddressIDEmailAddressEmailAddressID
EmailAddress EmailAddressEmailAddressEmailAddressEmailAddress
rowguid EmailAddressrowguidEmailAddressrowguid
ModifiedDate EmailAddressModifiedDateEmailAddressModifiedDate
BusinessEntityID Lookup_EmailAddressBusinessEntityIDEmailAddressBusinessEntityID
EmailAddressID Lookup_EmailAddressEmailAddressIDEmailAddressEmailAddressID
EmailAddress Lookup_EmailAddressEmailAddressEmailAddressEmailAddress


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.


Mapping example of formfactory entities connected via mappings to the logical entities in the example repository

Logical model example project


Linked elements

Conceptual datamodel example

Example FormFactory entities

Logical datamodel example

Physical datamodel example