Difference between revisions of "Sales.IndividualSurveySchemaCollection (xml schema collection)"
Line 118: | Line 118: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
+ | | '''Dependency Type | ||
+ | | '''Object Type | ||
| '''Referenced Object | | '''Referenced Object | ||
− | |||
− | |||
|- | |- | ||
− | |||
| Schema | | Schema | ||
| Schema | | Schema | ||
+ | | [[Sales_(schema)|Sales]] | ||
+ | |||
|} | |} | ||
Line 131: | Line 132: | ||
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
|- style="background:silver" | |- style="background:silver" | ||
+ | | '''Reference Type | ||
+ | | '''Object Type | ||
| '''Referencing Object | | '''Referencing Object | ||
− | |||
− | |||
|- | |- | ||
+ | | Data Type | ||
+ | | Table | ||
| [[Sales.Individual_(table)|Sales.Individual]] | | [[Sales.Individual_(table)|Sales.Individual]] | ||
− | + | ||
− | |||
|} | |} |
Revision as of 06:39, 30 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>
Dependency Type | Object Type | Referenced Object |
Schema | Schema | Sales |
Reference Type | Object Type | Referencing Object |
Data Type | Table | Sales.Individual |