Element

Title

Person

Package Name

Physical datamodel example

Description

Human beings involved with AdventureWorks: employees, customer contacts, and vendor contacts.

Attributes

NameTypeMincardMaxcardDescription
BusinessEntityIDint11Primary key for Person records.
PersonTypenchar11Primary type of person: SC = Store Contact, IN = Individual (retail) customer, SP = Sales person, EM = Employee (non-sales), VC = Vendor contact, GC = General contact
NameStylebit110 = The data in FirstName and LastName are stored in western style (first name, last name) order. 1 = Eastern style (last name, first name) order.
Titlenvarchar11A courtesy title. For example, Mr. or Ms.
FirstNamenvarchar11First name of the person.
MiddleNamenvarchar11Middle name or middle initial of the person.
LastNamenvarchar11Last name of the person.
Suffixnvarchar11Surname suffix. For example, Sr. or Jr.
EmailPromotionint110 = 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.
AdditionalContactInfoxml11Additional contact information about the person stored in xml format.
Demographicsxml11Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
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