Difference between revisions of "Sales.Individual (table)"

From dbscript Online Help
Jump to: navigation, search
Line 5: Line 5:
 
| '''Table
 
| '''Table
 
| Sales.Individual
 
| Sales.Individual
 +
|- valign="top"
 +
| '''Description
 +
| Demographic data about customers that purchase Adventure Works products online.
 
|-
 
|-
 
|}
 
|}
Line 15: Line 18:
 
| '''Nullable
 
| '''Nullable
 
| '''Default
 
| '''Default
−
| '''PK
+
| '''Description / PK / Index
−
| '''Index
 
 
 
−
|-
+
|- valign="top"
 
| CustomerID
 
| CustomerID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
| PK_Individual_CustomerID
+
| Unique customer identification number. Foreign key to Customer.CustomerID.<br />PK_Individual_CustomerID
−
|
+
|- valign="top"
−
|-
 
 
| ContactID
 
| ContactID
 
| int
 
| int
 
| not null
 
| not null
 
|  
 
|  
−
|  
+
| Identifies the customer in the Contact table. Foreign key to Contact.ContactID.<br />
−
|
+
|- valign="top"
−
|-
 
 
| Demographics
 
| Demographics
 
| xml
 
| xml
 
| null
 
| null
 
|  
 
|  
−
|  
+
| Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.<br />PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics
−
| PXML_Individual_DemographicsXMLPATH_Individual_DemographicsXMLPROPERTY_Individual_DemographicsXMLVALUE_Individual_Demographics
+
|- valign="top"
−
|-
 
 
| ModifiedDate
 
| ModifiedDate
 
| datetime
 
| datetime
 
| not null
 
| not null
 
| (getdate())
 
| (getdate())
−
|  
+
| Date and time the record was last updated.<br />
−
|
 
 
|}
 
|}
  
Line 76: Line 74:
 
| ON INSERT UPDATE
 
| ON INSERT UPDATE
 
|}
 
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
| '''Child Type
 +
| '''Child Object
 +
 +
|-
 +
| Data Type
 +
| XML Schema Collection
 +
| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
 +
 +
|
 +
|
 +
|-
 +
| Update
 +
| Table
 +
| [[Sales.Individual_(table)|Sales.Individual]]
 +
 +
| Trigger
 +
| iuIndividual
 +
|-
 +
| Select
 +
| Table
 +
| [[Sales.Store_(table)|Sales.Store]]
 +
 +
| Trigger
 +
| iuIndividual
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Reference Type
 +
| '''Object Type
 +
| '''Referencing Object
 +
 +
| '''Child Type
 +
| '''Child Object
 +
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
 +
 +
|
 +
|
 +
|-
 +
| Select
 +
| View
 +
| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
 +
 +
|
 +
|
 +
|-
 +
| Select
 +
| SQL table-valued-function
 +
| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
 +
 +
|
 +
|
 +
|-
 +
| Update
 +
| Table
 +
| [[Sales.Individual_(table)|Sales.Individual]]
 +
 +
| Trigger
 +
| iuIndividual
 +
|-
 +
| Update
 +
| Table
 +
| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 +
 +
| Trigger
 +
| iduSalesOrderDetail
 +
|-
 +
| Select
 +
| Table
 +
| [[Sales.Store_(table)|Sales.Store]]
 +
 +
| Trigger
 +
| iStore
 +
|}
 +
 +
 +
 
== automatically generated ==
 
== automatically generated ==
  

Revision as of 22:54, 28 December 2009

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


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
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.Individual_(table)&oldid=1889"