Catatan
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba masuk atau mengubah direktori.
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba mengubah direktori.
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