Element

Title

EmailAddress

Package Name

Physical datamodel example

Description

Where to send a person email.

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDint11Primary key. Person associated with this email address. Foreign key to Person.BusinessEntityID
EmailAddressIDint11Primary key. ID of this email address.
EmailAddressnvarchar11E-mail address for the person.
rowguiduniqueidentifier11ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDatedatetime11Date and time the record was last updated.


Display in diagrams

Linked elements

Logical datamodel example

Physical datamodel example