Individual Table (AdventureWorks)

Contains demographic data about customers that purchase Adventure Works Cycles products online. The customer names are stored in the Contact table.

Individual Table Definition

The Individual table is contained in the Sales schema.

Column Data type Nullability Description

CustomerID

int

Not null

Unique customer identification number. Foreign key to Customer.CustomerID.

ContactID

int

Not null

Identifies the customer in the Contact table. Foreign key to Contact.ContactID.

Demographics

xml

Null

Personal information, such as hobbies and income that is collected from online shoppers and used for sales analysis. For more information, see About the Individual.Demographics xml Column.

ModifiedDate

datetime

Not null

Date and time the row was last updated.

See Also

Reference

Contact Table (AdventureWorks)
Customer Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)

Other Resources

AdventureWorks Data Dictionary

Help and Information

Getting SQL Server 2005 Assistance