Telephone number and type of a person.

Package Physical datamodel example
Author Bert Dingemans
Alias --
Stereotypes table


Name Type Cardinality Description
BusinessEntityID int 1 - 1Business entity identification number. Foreign key to Person.BusinessEntityID.
PhoneNumber nvarchar 1 - 1Telephone number identification number.
PhoneNumberTypeID int 1 - 1Kind of phone number. Foreign key to PhoneNumberType.PhoneNumberTypeID.
ModifiedDate datetime 1 - 1Date and time the record was last updated.


NameSourceSource attributeTargetTarget attribute
BusinessEntityID PersonPhoneBusinessEntityIDPersonPhoneBusinessEntityID
PhoneNumber PersonPhonePhoneNumberPersonPhonePhoneNumber
PhoneNumberTypeID PersonPhonePhoneNumberTypeIDPersonPhonePhoneNumberTypeID
ModifiedDate PersonPhoneModifiedDatePersonPhoneModifiedDate


Physical example project

Linked elements

Logical datamodel example

Physical datamodel example