Sales.IndividualSurveySchemaCollection (xml schema collection) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:35Z

Bot at 22:11, 2 February 2010

2010-02-02T22:11:33Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:16Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:25Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:38Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:04Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:09Z

Bot at 22:28, 26 November 2009

2009-11-26T22:28:17Z

Bot at 22:04, 3 January 2009

2009-01-03T22:04:48Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''xmlschemacollection | Sales.IndividualSurveySchemaCollection |- |}

 
2009-01-03T12:35:49Z
New page: == wikibot ==  {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''xmlschemacollection | Sales.IndividualSurveySchemaCollection |- |}  <pre> <xsd:schema ...
New page
== wikibot ==



{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"

|-

| '''xmlschemacollection

| Sales.IndividualSurveySchemaCollection

|-

|}



<pre>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" elementFormDefault="qualified"><xsd:element name="IndividualSurvey"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="TotalPurchaseYTD" type="xsd:decimal" minOccurs="0" /><xsd:element name="DateFirstPurchase" type="xsd:date" minOccurs="0" /><xsd:element name="BirthDate" type="xsd:date" minOccurs="0" /><xsd:element name="MaritalStatus" type="xsd:string" minOccurs="0" /><xsd:element name="YearlyIncome" type="t:SalaryType" minOccurs="0" /><xsd:element name="Gender" type="xsd:string" minOccurs="0" /><xsd:element name="TotalChildren" type="xsd:int" minOccurs="0" /><xsd:element name="NumberChildrenAtHome" type="xsd:int" minOccurs="0" /><xsd:element name="Education" type="xsd:string" minOccurs="0" /><xsd:element name="Occupation" type="xsd:string" minOccurs="0" /><xsd:element name="HomeOwnerFlag" type="xsd:string" minOccurs="0" /><xsd:element name="NumberCarsOwned" type="xsd:int" minOccurs="0" /><xsd:element name="Hobby" type="xsd:string" minOccurs="0" maxOccurs="unbounded" /><xsd:element name="CommuteDistance" type="t:MileRangeType" minOccurs="0" /><xsd:element name="Comments" type="xsd:string" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:simpleType name="MileRangeType"><xsd:restriction base="xsd:string"><xsd:enumeration value="0-1 Miles" /><xsd:enumeration value="1-2 Miles" /><xsd:enumeration value="2-5 Miles" /><xsd:enumeration value="5-10 Miles" /><xsd:enumeration value="10+ Miles" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="SalaryType"><xsd:restriction base="xsd:string"><xsd:enumeration value="0-25000" /><xsd:enumeration value="25001-50000" /><xsd:enumeration value="50001-75000" /><xsd:enumeration value="75001-100000" /><xsd:enumeration value="greater than 100000" /></xsd:restriction></xsd:simpleType></xsd:schema>

</pre>

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''XML Schema Collection
 | Sales.IndividualSurveySchemaCollection
@@ Line 8: / Line 8: @@
 | '''Description
 | Collection of XML schemas for the Demographics column in the Sales.Individual table.
 |}
 === Source ===
@@ Line 69: / Line 67: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 83: / Line 81: @@
 | '''Referencing Object
-|-
+|- valign="top"
 | Data Type
 | Table

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''xmlschemacollection
+| '''XML Schema Collection
 | Sales.IndividualSurveySchemaCollection
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 <?xml version="1.0" encoding="utf-8"?>
@@ Line 60: / Line 62: @@
 </pre>
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 73: / Line 89: @@
 |}

@@ Line 63: / Line 63: @@
 | Sales.IndividualSurveySchemaCollection
 |- valign="top"
 | '''Description
 | Collection of XML schemas for the Demographics column in the Sales.Individual table.
 |-
 |}

@@ Line 118: / Line 118: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 131: / Line 132: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Sales.Individual_(table)|Sales.Individual]]
-| Table
 |}

@@ Line 62: / Line 62: @@
 | '''xmlschemacollection
 | Sales.IndividualSurveySchemaCollection
-|-
+|- valign="top"
 | '''Description
@@ Line 114: / Line 114: @@
 </xsd:schema>
 </pre>
@@ Line 121: / Line 134: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.Individual_(table)|Sales.Individual]]

@@ Line 56: / Line 56: @@
 </xsd:schema>
 </pre>
 == automatically generated ==
@@ Line 115: / Line 114: @@
 </xsd:schema>
 </pre>