# Xml Schema: IndividualSurveySchemaCollection

## Properties

Property | Value
--- | ---
Name | IndividualSurveySchemaCollection
ID | 65537
Schema | Person
Owner | dbo
Modify Date | 8/8/2010 5:21:45 PM
Create Date | 8/8/2010 5:21:45 PM

## Extended Properties

Name | Value
--- | ---
MS_Description | Collection of XML schemas for the Demographics column in the Person.Person table.

## [IndividualSurveySchemaCollection] is used in the following columns

Schema | Object | Column
--- | --- | ---
Person | Person | Demographics

## [IndividualSurveySchemaCollection] is used in the following parameters

Xml Collection is not used in any parameters

## Xml Namespaces

ID | Name
--- | ---
1 | http://schemas.microsoft.com/sqlserver/2004/07/adventure-works/IndividualSurvey

## Permissions

No object level permissions defined.

## Objects that depend on [IndividualSurveySchemaCollection]

- Person.IndividualSurveySchemaCollection
  - Person.Person
    - HumanResources.Employee
      - Sales.SalesPerson
        - Sales.Store
          - Sales.Customer
            - Sales.SalesOrderHeader
              - Sales.SalesOrderDetail
                - Sales.iduSalesOrderDetail
                - Sales.ufn_SalesByStore
              - Sales.vSalesPersonSalesByFiscalYears
              - Sales.uSalesOrderHeader
              - Sales.SalesOrderHeaderSalesReason
            - dbo.ufnGetContactInformation
            - Sales.vIndividualCustomer
          - Sales.vStoreWithAddresses
          - Sales.vStoreWithContacts
          - Sales.vStoreWithDemographics
        - Sales.vSalesPerson
        - Sales.SalesPersonQuotaHistory
        - Sales.SalesTerritoryHistory
      - Purchasing.PurchaseOrderHeader
        - Purchasing.PurchaseOrderDetail
          - Purchasing.iPurchaseOrderDetail
          - Purchasing.uPurchaseOrderDetail
        - Purchasing.uPurchaseOrderHeader
      - Production.Document
        - Production.ProductDocument
      - HumanResources.EmployeeDepartmentHistory
        - HumanResources.vEmployeeDepartment
        - HumanResources.vEmployeeDepartmentHistory
      - HumanResources.EmployeePayHistory
        - HumanResources.uspUpdateEmployeeHireInfo
      - HumanResources.JobCandidate
        - dbo.uspSearchCandidateResumes
        - HumanResources.vJobCandidate
        - HumanResources.vJobCandidateEducation
        - HumanResources.vJobCandidateEmployment
      - dbo.vMobiEmployee
        - dbo.uMobiEmployeeTrg
      - HumanResources.dEmployee
      - dbo.uspGetEmployeeManagers
      - dbo.uspGetManagerEmployees
      - HumanResources.uspUpdateEmployeeLogin
      - HumanResources.uspUpdateEmployeePersonalInfo
      - HumanResources.vEmployee
    - Person.BusinessEntityContact
      - Purchasing.vVendorWithContacts
    - Person.EmailAddress
    - Person.PersonPhone
    - Sales.vPersonDemographics
    - Person.Password
    - Person.iuPerson
    - Sales.PersonCreditCard
    - Person.vAdditionalContactInfo

## Objects on which [IndividualSurveySchemaCollection] depends

- Person.IndividualSurveySchemaCollection

## SQL

Script
CREATE XML SCHEMA COLLECTION [Person].[IndividualSurveySchemaCollection] AS N'<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>' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Collection of XML schemas for the Demographics column in the Person.Person table.' , @level0type=N'SCHEMA',@level0name=N'Person', @level1type=N'XML SCHEMA COLLECTION',@level1name=N'IndividualSurveySchemaCollection'

#### See also

List of Xml Collections