Individual Table (AdventureWorks)
Contains demographic data about customers that purchase Adventure Works Cycles products online. The customer names are stored in the Contact table.
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. |
Contact Table (AdventureWorks)
Customer Table (AdventureWorks)
SalesOrderHeader Table (AdventureWorks)