Element

Title

Person

Package Name

Logical datamodel example

Description

Copy from table to class by script

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDString11Primary key for Person records.
PersonTypeString11Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStyleBoolean110 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
TitleString11A courtesy title. For example, Mr. or Ms.
FirstNameString11First name of the person.
MiddleNameString11Middle name or middle initial of the person.
LastNameString11Last name of the person.
SuffixString11Surname suffix. For example, Sr. or Jr.
EmailPromotionString110 = Contact does not wish to receive e-mail promotions, 1 = Contact does wish to receive e-mail promotions from AdventureWorks, 2 = Contact does wish to receive e-mail promotions from AdventureWorks and selected partners.
AdditionalContactInfoString11Additional contact information about the person stored in xml format.
DemographicsString11Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
rowguidString11ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.
ModifiedDateString11Date and time the record was last updated.


Display in diagrams

Linked elements