From dbscript Online Help
wikibot
Column
|
Data Type
|
Nullable
|
Default
|
PK
|
Index
|
CustomerID
|
int
|
not null
|
|
PK_Individual_CustomerID
|
|
ContactID
|
int
|
not null
|
|
|
|
Demographics
|
xml
|
null
|
|
|
PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics
|
ModifiedDate
|
datetime
|
not null
|
(getdate())
|
|
|
Triggers
|
Type
|
iuIndividual
|
ON INSERT UPDATE
|
automatically generated
Table
|
Sales.Individual
|
Description
|
Demographic data about customers that purchase Adventure Works products online.
|
Column
|
Data Type
|
Nullable
|
Default
|
Description
|
PK / Index
|
CustomerID
|
int
|
not null
|
|
Unique customer identification number. Foreign key to Customer.CustomerID.
|
PK_Individual_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 collected from online shoppers. Used for sales analysis.
|
PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics
|
ModifiedDate
|
datetime
|
not null
|
(GETDATE())
|
Date and time the record was last updated.
|
|
Triggers
|
Type
|
iuIndividual
|
ON INSERT UPDATE
|