Sales.Individual (table)

From dbscript Online Help
Revision as of 06:32, 30 November 2009 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

Table Sales.Individual


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())


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


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.


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
Schema Schema .Sales
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