Difference between revisions of "Sales.StoreSurveySchemaCollection (xml schema collection)"
| Line 72: | Line 72: | ||
</xsd:restriction> | </xsd:restriction> | ||
</xsd:simpleType> | </xsd:simpleType> | ||
| + | </xsd:schema> | ||
| + | </pre> | ||
| + | |||
| + | == automatically generated == | ||
| + | |||
| + | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
| + | |- | ||
| + | | '''xmlschemacollection | ||
| + | | Sales.StoreSurveySchemaCollection | ||
| + | |- | ||
| + | |||
| + | | '''Description | ||
| + | | Collection of XML schemas for the Demographics column in the Sales.Store table. | ||
| + | |- | ||
| + | |||
| + | |} | ||
| + | |||
| + | <pre> | ||
| + | <?xml version="1.0" encoding="UTF-8"?> | ||
| + | <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" elementFormDefault="qualified" attributeFormDefault="unqualified"> | ||
| + | <!-- BM=Bicycle manu BS=bicyle store OS=online store SGS=sporting goods store D=Discount Store --> | ||
| + | <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> | ||
| + | <!-- BMX=BMX Racing --> | ||
| + | <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> | ||
| + | <!-- AW=AdventureWorks only 2= AdvWorks+1 other brand other brand --> | ||
| + | <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="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:element name="StoreSurvey"> | ||
| + | <xsd:complexType> | ||
| + | <xsd:sequence> | ||
| + | <xsd:element name="ContactName" type="xsd:string" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="JobTitle" type="xsd:string" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="AnnualSales" type="xsd:decimal" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="AnnualRevenue" type="xsd:decimal" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="BankName" type="xsd:string" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="BusinessType" type="BusinessType" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="YearOpened" type="xsd:gYear" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="Specialty" type="SpecialtyType" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="SquareFeet" type="xsd:float" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="Brands" type="BrandType" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="Internet" type="InternetType" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="NumberEmployees" type="xsd:int" minOccurs="0" maxOccurs="1" /> | ||
| + | <xsd:element name="Comments" type="xsd:string" minOccurs="0" maxOccurs="1" /> | ||
| + | </xsd:sequence> | ||
| + | </xsd:complexType> | ||
| + | </xsd:element> | ||
</xsd:schema> | </xsd:schema> | ||
</pre> | </pre> | ||
Revision as of 23:28, 26 November 2009
wikibot
| xmlschemacollection | Sales.StoreSurveySchemaCollection |
<?xml version="1.0" encoding="utf-8"?>
<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>
automatically generated
| xmlschemacollection | Sales.StoreSurveySchemaCollection |
| Description | Collection of XML schemas for the Demographics column in the Sales.Store table. |
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/StoreSurvey" elementFormDefault="qualified" attributeFormDefault="unqualified">
<!-- BM=Bicycle manu BS=bicyle store OS=online store SGS=sporting goods store D=Discount Store -->
<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>
<!-- BMX=BMX Racing -->
<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>
<!-- AW=AdventureWorks only 2= AdvWorks+1 other brand other brand -->
<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="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:element name="StoreSurvey">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="ContactName" type="xsd:string" minOccurs="0" maxOccurs="1" />
<xsd:element name="JobTitle" type="xsd:string" minOccurs="0" maxOccurs="1" />
<xsd:element name="AnnualSales" type="xsd:decimal" minOccurs="0" maxOccurs="1" />
<xsd:element name="AnnualRevenue" type="xsd:decimal" minOccurs="0" maxOccurs="1" />
<xsd:element name="BankName" type="xsd:string" minOccurs="0" maxOccurs="1" />
<xsd:element name="BusinessType" type="BusinessType" minOccurs="0" maxOccurs="1" />
<xsd:element name="YearOpened" type="xsd:gYear" minOccurs="0" maxOccurs="1" />
<xsd:element name="Specialty" type="SpecialtyType" minOccurs="0" maxOccurs="1" />
<xsd:element name="SquareFeet" type="xsd:float" minOccurs="0" maxOccurs="1" />
<xsd:element name="Brands" type="BrandType" minOccurs="0" maxOccurs="1" />
<xsd:element name="Internet" type="InternetType" minOccurs="0" maxOccurs="1" />
<xsd:element name="NumberEmployees" type="xsd:int" minOccurs="0" maxOccurs="1" />
<xsd:element name="Comments" type="xsd:string" minOccurs="0" maxOccurs="1" />
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
