Difference between revisions of "Sales.IndividualSurveySchemaCollection (xml schema collection)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''xmlschemacollection | Sales.IndividualSurveySchemaCollection |- |} <pre> <xsd:schema ...)
 
 
(8 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''XML Schema Collection
 +
| Sales.IndividualSurveySchemaCollection
 +
|- valign="top"
 +
| '''Description
 +
| Collection of XML schemas for the Demographics column in the Sales.Individual table.
 +
|}
 +
 +
=== Source ===
 +
<pre>
 +
<?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/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>
 +
 +
=== 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.Individual_(table)|Sales.Individual]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 95:
 
| '''xmlschemacollection
 
| '''xmlschemacollection
 
| Sales.IndividualSurveySchemaCollection
 
| Sales.IndividualSurveySchemaCollection
 +
|- valign="top"
 +
| '''Description
 +
| Collection of XML schemas for the Demographics column in the Sales.Individual table.
 
|-
 
|-
 
|}
 
|}
  
 
<pre>
 
<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>
+
<?xml version="1.0" encoding="UTF-8"?>
 +
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 +
  <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: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:element name="IndividualSurvey">
 +
    <xsd:complexType>
 +
      <xsd:sequence>
 +
        <xsd:element name="TotalPurchaseYTD" type="xsd:decimal" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="DateFirstPurchase" type="xsd:date" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="BirthDate" type="xsd:date" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="MaritalStatus" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="YearlyIncome" type="SalaryType" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="Gender" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="TotalChildren" type="xsd:int" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="NumberChildrenAtHome" type="xsd:int" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="Education" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="Occupation" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="HomeOwnerFlag" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="NumberCarsOwned" type="xsd:int" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="Hobby" type="xsd:string" minOccurs="0" maxOccurs="unbounded" />
 +
        <xsd:element name="CommuteDistance" type="MileRangeType" minOccurs="0" maxOccurs="1" />
 +
        <xsd:element name="Comments" type="xsd:string" minOccurs="0" maxOccurs="1" />
 +
      </xsd:sequence>
 +
    </xsd:complexType>
 +
  </xsd:element>
 +
</xsd:schema>
 
</pre>
 
</pre>
 +
 +
 +
{| 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.Individual_(table)|Sales.Individual]]
 +
 +
|}

Latest revision as of 23:17, 23 June 2010

wikibot[edit]

XML Schema Collection Sales.IndividualSurveySchemaCollection
Description Collection of XML schemas for the Demographics column in the Sales.Individual table.

Source[edit]

<?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/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>

References[edit]

Dependency Type Object Type Referenced Object
Schema Schema Sales

Dependencies[edit]

Reference Type Object Type Referencing Object
Data Type Table Sales.Individual


automatically generated[edit]

xmlschemacollection Sales.IndividualSurveySchemaCollection
Description Collection of XML schemas for the Demographics column in the Sales.Individual table. 
<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey" elementFormDefault="qualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <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: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:element name="IndividualSurvey">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element name="TotalPurchaseYTD" type="xsd:decimal" minOccurs="0" maxOccurs="1" />
        <xsd:element name="DateFirstPurchase" type="xsd:date" minOccurs="0" maxOccurs="1" />
        <xsd:element name="BirthDate" type="xsd:date" minOccurs="0" maxOccurs="1" />
        <xsd:element name="MaritalStatus" type="xsd:string" minOccurs="0" maxOccurs="1" />
        <xsd:element name="YearlyIncome" type="SalaryType" minOccurs="0" maxOccurs="1" />
        <xsd:element name="Gender" type="xsd:string" minOccurs="0" maxOccurs="1" />
        <xsd:element name="TotalChildren" type="xsd:int" minOccurs="0" maxOccurs="1" />
        <xsd:element name="NumberChildrenAtHome" type="xsd:int" minOccurs="0" maxOccurs="1" />
        <xsd:element name="Education" type="xsd:string" minOccurs="0" maxOccurs="1" />
        <xsd:element name="Occupation" type="xsd:string" minOccurs="0" maxOccurs="1" />
        <xsd:element name="HomeOwnerFlag" type="xsd:string" minOccurs="0" maxOccurs="1" />
        <xsd:element name="NumberCarsOwned" type="xsd:int" minOccurs="0" maxOccurs="1" />
        <xsd:element name="Hobby" type="xsd:string" minOccurs="0" maxOccurs="unbounded" />
        <xsd:element name="CommuteDistance" type="MileRangeType" minOccurs="0" maxOccurs="1" />
        <xsd:element name="Comments" type="xsd:string" minOccurs="0" maxOccurs="1" />
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>


Dependency Type Object Type Referenced Object
Schema Schema Sales


Reference Type Object Type Referencing Object
Data Type Table Sales.Individual
Retrieved from "http://dbshelp.devio.at/index.php?title=Sales.IndividualSurveySchemaCollection_(xml_schema_collection)&oldid=2667"