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
Person_Temporal_History
--
Package
Physical datamodel example
Author
Bert Dingemans
Alias
--
Stereotypes
table
Attributes
Name
Type
Cardinality
Description
BusinessEntityID
int
1 - 1
--
PersonType
nchar
1 - 1
--
NameStyle
bit
1 - 1
--
Title
nvarchar
1 - 1
--
FirstName
nvarchar
1 - 1
--
MiddleName
nvarchar
1 - 1
--
LastName
nvarchar
1 - 1
--
Suffix
nvarchar
1 - 1
--
EmailPromotion
int
1 - 1
--
ValidFrom
datetime2
1 - 1
--
ValidTo
datetime2
1 - 1
--
Diagrams
Import Adventureworks Database