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
PersonPhone
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
Business entity identification number. Foreign key to Person.BusinessEntityID.
PhoneNumber
String
1 - 1
Telephone number identification number.
PhoneNumberTypeID
String
1 - 1
Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
ModifiedDate
String
1 - 1
Date and time the record was last updated.
Mappings
Name
Source
Source attribute
Target
Target attribute
BusinessEntityID
PersonPhone
BusinessEntityID
PersonPhone
BusinessEntityID
PhoneNumber
PersonPhone
PhoneNumber
PersonPhone
PhoneNumber
PhoneNumberTypeID
PersonPhone
PhoneNumberTypeID
PersonPhone
PhoneNumberTypeID
ModifiedDate
PersonPhone
ModifiedDate
PersonPhone
ModifiedDate
Diagrams
Logical model example project
Linked elements
Conceptual datamodel example
PersonPhone trace
Logical datamodel example
Person FK
Physical datamodel example
PersonPhone
PersonPhone trace