Sales.StoreSurveySchemaCollection (xml schema collection) - Revision history

Bot at 22:17, 23 June 2010

2010-06-23T22:17:57Z

Bot at 22:11, 2 February 2010

2010-02-02T22:11:59Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:22Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:32Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:45Z

Bot at 05:26, 30 November 2009

2009-11-30T05:26:11Z

Bot at 22:59, 26 November 2009

2009-11-26T22:59:15Z

Bot at 22:28, 26 November 2009

2009-11-26T22:28:23Z

Bot at 22:04, 3 January 2009

2009-01-03T22:04:53Z

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

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



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

|-

| '''xmlschemacollection

| Sales.StoreSurveySchemaCollection

|-

|}



<pre>

<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:t="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" elementFormDefault="qualified"><xsd:element name="StoreSurvey"><xsd:complexType><xsd:complexContent><xsd:restriction base="xsd:anyType"><xsd:sequence><xsd:element name="ContactName" type="xsd:string" minOccurs="0" /><xsd:element name="JobTitle" type="xsd:string" minOccurs="0" /><xsd:element name="AnnualSales" type="xsd:decimal" minOccurs="0" /><xsd:element name="AnnualRevenue" type="xsd:decimal" minOccurs="0" /><xsd:element name="BankName" type="xsd:string" minOccurs="0" /><xsd:element name="BusinessType" type="t:BusinessType" minOccurs="0" /><xsd:element name="YearOpened" type="xsd:gYear" minOccurs="0" /><xsd:element name="Specialty" type="t:SpecialtyType" minOccurs="0" /><xsd:element name="SquareFeet" type="xsd:float" minOccurs="0" /><xsd:element name="Brands" type="t:BrandType" minOccurs="0" /><xsd:element name="Internet" type="t:InternetType" minOccurs="0" /><xsd:element name="NumberEmployees" type="xsd:int" minOccurs="0" /><xsd:element name="Comments" type="xsd:string" minOccurs="0" /></xsd:sequence></xsd:restriction></xsd:complexContent></xsd:complexType></xsd:element><xsd:simpleType name="BrandType"><xsd:restriction base="xsd:string"><xsd:enumeration value="AW" /><xsd:enumeration value="2" /><xsd:enumeration value="3" /><xsd:enumeration value="4+" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="BusinessType"><xsd:restriction base="xsd:string"><xsd:enumeration value="BM" /><xsd:enumeration value="BS" /><xsd:enumeration value="D" /><xsd:enumeration value="OS" /><xsd:enumeration value="SGS" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="InternetType"><xsd:restriction base="xsd:string"><xsd:enumeration value="56kb" /><xsd:enumeration value="ISDN" /><xsd:enumeration value="DSL" /><xsd:enumeration value="T1" /><xsd:enumeration value="T2" /><xsd:enumeration value="T3" /></xsd:restriction></xsd:simpleType><xsd:simpleType name="SpecialtyType"><xsd:restriction base="xsd:string"><xsd:enumeration value="Family" /><xsd:enumeration value="Kids" /><xsd:enumeration value="BMX" /><xsd:enumeration value="Touring" /><xsd:enumeration value="Road" /><xsd:enumeration value="Mountain" /><xsd:enumeration value="All" /></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.StoreSurveySchemaCollection
@@ Line 8: / Line 8: @@
 | '''Description
 | Collection of XML schemas for the Demographics column in the Sales.Store table.
 |}
 === Source ===
@@ Line 87: / Line 85: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Schema
 | Schema
@@ Line 101: / Line 99: @@
 | '''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.StoreSurveySchemaCollection
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 <?xml version="1.0" encoding="utf-8"?>
@@ Line 78: / Line 80: @@
 </pre>
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 91: / Line 107: @@
 |}

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

@@ Line 157: / Line 157: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referenced Object
 |-
 | Schema
 | Schema
 |}
@@ Line 170: / Line 171: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
 | '''Referencing Object
 |-
 | [[Sales.Store_(table)|Sales.Store]]
-| Table
 |}

@@ Line 80: / Line 80: @@
 | '''xmlschemacollection
 | Sales.StoreSurveySchemaCollection
-|-
+|- valign="top"
 | '''Description
@@ Line 153: / Line 153: @@
 </xsd:schema>
 </pre>
@@ Line 160: / Line 173: @@
 | '''Object Type
 | '''Reference Type
-−
 |-
 | [[Sales.Store_(table)|Sales.Store]]

@@ Line 74: / Line 74: @@
 </xsd:schema>
 </pre>
 == automatically generated ==
@@ Line 154: / Line 153: @@
 </xsd:schema>
 </pre>