Welcome Guest, you are in: <root> • Login

Page History: Sales Individual (table)

Compare Page Revisions

4 3 2 1 0 Current 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: 2010/01/09 18:02

wikibot ¶

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.

Relation	Column	Referenced Column
Person.Contact	ContactID	ContactID
Sales.Customer	CustomerID	CustomerID

Triggers	Type
iuIndividual	ON INSERT UPDATE

Dependency Type	Object Type	Referenced Object	Child Type	Child Object
Data Type	XML Schema Collection	Sales.IndividualSurveySchemaCollection
Update	Table	Sales.Individual	Trigger	iuIndividual
Select	Table	Sales.Store	Trigger	iuIndividual

Reference Type	Object Type	Referencing Object	Child Type	Child Object
Select	View	Sales.vIndividualCustomer
Select	View	Sales.vIndividualDemographics
Select	SQL table-valued-function	dbo.ufnGetContactInformation
Update	Table	Sales.Individual	Trigger	iuIndividual
Update	Table	Sales.SalesOrderDetail	Trigger	iduSalesOrderDetail
Select	Table	Sales.Store	Trigger	iStore