Share via


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.