Sales.Individual (table)

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

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

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