Difference between revisions of "Sales.IndividualSurveySchemaCollection (xml schema collection)"
| Line 54: | Line 54: | ||
</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.IndividualSurveySchemaCollection | ||
| + | |- | ||
| + | |||
| + | | '''Description | ||
| + | | Collection of XML schemas for the Demographics column in the Sales.Individual table. | ||
| + | |- | ||
| + | |||
| + | |} | ||
| + | |||
| + | <pre> | ||
| + | <?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> | </xsd:schema> | ||
</pre> | </pre> | ||
Revision as of 23:28, 26 November 2009
wikibot
| xmlschemacollection | Sales.IndividualSurveySchemaCollection |
<?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>
automatically generated
| 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>
