ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
Sales.StoreSurveySchemaCollection_(xml schema collection)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''XML Schema Collection''' | Sales.StoreSurveySchemaCollection |- valign="top" | '''Description''' | Collection of XML schemas for the Demographics column in the Sales.Store table. |} === Source === {{{{<nowiki> <?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> </nowiki>}}}} === References === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- valign="top" | Schema | Schema | [[Sales_(schema)|Sales]] |} === Dependencies === {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- valign="top" | Data Type | Table | [[Sales.Store_(table)|Sales.Store]] |} == automatically generated == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''xmlschemacollection''' | Sales.StoreSurveySchemaCollection |- valign="top" | '''Description''' | Collection of XML schemas for the Demographics column in the Sales.Store table. |- |} {{{{<nowiki> <?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> </nowiki>}}}} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Dependency Type''' | '''Object Type''' | '''Referenced Object''' |- | Schema | Schema | [[Sales_(schema)|Sales]] |} {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- style="background:silver" | '''Reference Type''' | '''Object Type''' | '''Referencing Object''' |- | Data Type | Table | [[Sales.Store_(table)|Sales.Store]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.