Sales.Individual (table) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:33Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:13Z

Bot at 21:54, 28 December 2009

2009-12-28T21:54:39Z

Bot at 05:59, 30 November 2009

2009-11-30T05:59:23Z

Bot at 05:34, 30 November 2009

2009-11-30T05:34:45Z

Bot at 05:33, 30 November 2009

2009-11-30T05:33:36Z

Bot at 05:32, 30 November 2009

2009-11-30T05:32:03Z

Bot at 05:24, 30 November 2009

2009-11-30T05:24:28Z

Bot at 23:12, 26 November 2009

2009-11-26T23:12:52Z

Bot at 23:10, 26 November 2009

2009-11-26T23:10:15Z

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Table
 | Sales.Individual
@@ Line 8: / Line 8: @@
 | '''Description
 | Demographic data about customers that purchase Adventure Works products online.
 |}
 === Columns ===
@@ Line 20: / Line 18: @@
 | '''Default
 | '''Description
-−
 |- valign="top"
 | CustomerID
@@ Line 52: / Line 50: @@
 | '''Primary Key
 | '''Columns
-|-
+|- valign="top"
 | PK_Individual_CustomerID
 | CustomerID
@@ Line 63: / Line 61: @@
 | '''Type
 | '''Columns
-−
-|-
+|- valign="top"
 | PXML_Individual_Demographics
+|
 | Demographics
-|-
+|- valign="top"
 | XMLPATH_Individual_Demographics
+|
 | Demographics
-|-
+|- valign="top"
 | XMLPROPERTY_Individual_Demographics
+|
 | Demographics
-|-
+|- valign="top"
 | XMLVALUE_Individual_Demographics
+|
@@ Line 88: / Line 86: @@
 | '''Column
 | '''Referenced Column
-−
-|-
+|- valign="top"
 | [[Person.Contact_(table)|Person.Contact]]
 | ContactID
 | ContactID
-|-
+|- valign="top"
 | [[Sales.Customer_(table)|Sales.Customer]]
 | CustomerID
@@ Line 102: / Line 100: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
-| '''Triggers
+| '''Trigger
 | '''Type
-−
-|-
+|- valign="top"
 | iuIndividual
 | ON INSERT UPDATE
 |}
-	Trigger iuIndividual
+==== Trigger iuIndividual ====
 <pre>
 CREATE TRIGGER [Sales].[iuIndividual] ON [Sales].[Individual]
@@ Line 158: / Line 156: @@
 END;
 </pre>
-−
 === References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
@@ Line 169: / Line 167: @@
 | '''Child Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 176: / Line 174: @@
+|
+|
-|-
+|- valign="top"
 | Data Type
 | XML Schema Collection
-| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
+| [[Sales.IndividualSurveySchemaCollection_(xml schema collection)|Sales.IndividualSurveySchemaCollection]]
+|
+|
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 190: / Line 188: @@
 | Trigger
 | iuIndividual
-|-
+|- valign="top"
 | Select
 | Table
@@ Line 209: / Line 207: @@
 | '''Child Object
-|-
+|- valign="top"
 | Select
 | View
@@ Line 216: / Line 214: @@
+|
+|
-|-
+|- valign="top"
 | Select
 | View
@@ Line 223: / Line 221: @@
+|
+|
-|-
+|- valign="top"
 | Select
 | SQL table-valued-function
@@ Line 230: / Line 228: @@
+|
+|
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 237: / Line 235: @@
 | Trigger
 | iuIndividual
-|-
+|- valign="top"
 | Update
 | Table
@@ Line 244: / Line 242: @@
 | Trigger
 | iduSalesOrderDetail
-|-
+|- valign="top"
 | Select
 | Table

@@ Line 12: / Line 12: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 18: / Line 19: @@
 | '''Nullable
 | '''Default
-| '''Description / PK / Index
+| '''Description
 |- valign="top"
@@ Line 25: / Line 26: @@
 | not null
+|
-| Unique customer identification number. Foreign key to Customer.CustomerID.<br />PK_Individual_CustomerID
+| Unique customer identification number. Foreign key to Customer.CustomerID.
 |- valign="top"
 | ContactID
@@ Line 31: / Line 32: @@
 | not null
+|
-| Identifies the customer in the Contact table. Foreign key to Contact.ContactID.<br />
+| Identifies the customer in the Contact table. Foreign key to Contact.ContactID.
 |- valign="top"
 | Demographics
@@ Line 37: / Line 38: @@
 | 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
+| Personal information such as hobbies, and income collected from online shoppers. Used for sales analysis.
 |- valign="top"
 | ModifiedDate
@@ Line 43: / Line 44: @@
 | not null
 | (getdate())
-| Date and time the record was last updated.<br />
+| Date and time the record was last updated.
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 64: / Line 99: @@
 |}
+=== Triggers ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 75: / Line 110: @@
 |}
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 85: / Line 169: @@
 | '''Child Object
 |-
 | Data Type
@@ Line 108: / Line 199: @@
 |}
+=== Dependencies ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 161: / Line 252: @@
 | iStore
 |}

@@ Line 5: / Line 5: @@
 | '''Table
 | Sales.Individual
 |-
 |}
@@ Line 15: / Line 18: @@
 | '''Nullable
 | '''Default
-| '''PK
+| '''Description / PK / Index
-|-
+|- valign="top"
 | CustomerID
 | int
 | not null
+|
-| PK_Individual_CustomerID
+| Unique customer identification number. Foreign key to Customer.CustomerID.<br />PK_Individual_CustomerID
+|- valign="top"
 | ContactID
 | int
 | not null
+|
+| Identifies the customer in the Contact table. Foreign key to Contact.ContactID.<br />
+|- valign="top"
 | Demographics
 | xml
 | 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
 | datetime
 | not null
 | (getdate())
+| Date and time the record was last updated.<br />
 |}
@@ Line 76: / Line 74: @@
 | ON INSERT UPDATE
 |}
 == automatically generated ==

@@ Line 83: / Line 83: @@
 | Sales.Individual
 |- valign="top"
 | '''Description
 | Demographic data about customers that purchase Adventure Works products online.
 |-
 |}

@@ Line 167: / Line 167: @@
 | Schema
 | Schema
-| [[Sales_(schema)|false.Sales]]
+| [[Sales_(schema)|Sales]]
+|
@@ Line 174: / Line 174: @@
 | Data Type
 | XML Schema Collection
-| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|true.IndividualSurveySchemaCollection]]
+| [[Sales.IndividualSurveySchemaCollection_(xml_schema_collection)|Sales.IndividualSurveySchemaCollection]]
+|
@@ Line 181: / Line 181: @@
 | Update
 | Table
-| [[Sales.Individual_(table)|true.Individual]]
+| [[Sales.Individual_(table)|Sales.Individual]]
 | Trigger
@@ Line 188: / Line 188: @@
 | Select
 | Table
-| [[Sales.Store_(table)|true.Store]]
+| [[Sales.Store_(table)|Sales.Store]]
 | Trigger
@@ Line 207: / Line 207: @@
 | Select
 | View
-| [[Sales.vIndividualCustomer_(view)|true.vIndividualCustomer]]
+| [[Sales.vIndividualCustomer_(view)|Sales.vIndividualCustomer]]
+|
@@ Line 214: / Line 214: @@
 | Select
 | View
-| [[Sales.vIndividualDemographics_(view)|true.vIndividualDemographics]]
+| [[Sales.vIndividualDemographics_(view)|Sales.vIndividualDemographics]]
+|
@@ Line 221: / Line 221: @@
 | Select
 | SQL table-valued-function
-| [[dbo.ufnGetContactInformation_(function)|true.ufnGetContactInformation]]
+| [[dbo.ufnGetContactInformation_(function)|dbo.ufnGetContactInformation]]
+|
@@ Line 228: / Line 228: @@
 | Update
 | Table
-| [[Sales.Individual_(table)|true.Individual]]
+| [[Sales.Individual_(table)|Sales.Individual]]
 | Trigger
@@ Line 235: / Line 235: @@
 | Update
 | Table
-| [[Sales.SalesOrderDetail_(table)|true.SalesOrderDetail]]
+| [[Sales.SalesOrderDetail_(table)|Sales.SalesOrderDetail]]
 | Trigger
@@ Line 242: / Line 242: @@
 | Select
 | Table
-| [[Sales.Store_(table)|true.Store]]
+| [[Sales.Store_(table)|Sales.Store]]
 | Trigger
 | iStore
 |}