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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''Table | Sales.Individual |- |} {| border="1" cellpadding="5" cellspacing="0" style="...)
 
Line 45: Line 45:
 
| (getdate())
 
| (getdate())
 
|  
 
|  
 +
|
 +
|}
 +
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Relation
 +
| '''Column
 +
| '''Referenced Column
 +
 +
|-
 +
| [[Person.Contact_(table)|Person.Contact]]
 +
| ContactID
 +
| ContactID
 +
|-
 +
| [[Sales.Customer_(table)|Sales.Customer]]
 +
| CustomerID
 +
| CustomerID
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Triggers
 +
| '''Type
 +
 +
|-
 +
| iuIndividual
 +
| ON INSERT UPDATE
 +
|}
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''Table
 +
| Sales.Individual
 +
|-
 +
 +
| '''Description
 +
| Demographic data about customers that purchase Adventure Works products online.
 +
|-
 +
 +
|}
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''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.
 
|  
 
|  
 
|}
 
|}

Revision as of 00:26, 27 November 2009

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