Latest revision |
Your text |
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 95: |
Line 5: |
| | '''xmlschemacollection | | | '''xmlschemacollection |
| | Sales.IndividualSurveySchemaCollection | | | Sales.IndividualSurveySchemaCollection |
− | |- valign="top"
| |
− | | '''Description
| |
− | | Collection of XML schemas for the Demographics column in the Sales.Individual table.
| |
| |- | | |- |
| |} | | |} |
| | | |
| <pre> | | <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> |
− | <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]]
| |
− |
| |
− | |}
| |