modeldemo.dsv

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DSV 代码 · 共 413 行 · 第 1/4 页

                  </xs:element>
                  <xs:element name="Class" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="Class" msprop:design-time-name="d21e64e1-4078-4753-a3ee-fa94cc3de6e5" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="3" msprop:stats_AvgWidth="1" msprop:DbColumnName="Class" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Style" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="Style" msprop:design-time-name="93a4261f-a049-48b0-b33b-fda026829d2b" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="3" msprop:stats_AvgWidth="1" msprop:DbColumnName="Style" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ProductSubcategoryID" msprop:stats_StDevWidth="0.4892951" msprop:stats_UniqueValuePercent="12" msprop:FriendlyName="ProductSubcategoryID" msprop:design-time-name="2397d602-4af6-4c63-91f9-6557dfaa38b8" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="37" msprop:stats_AvgWidth="1.60678" msprop:DbColumnName="ProductSubcategoryID" type="xs:int" minOccurs="0" />
                  <xs:element name="ProductModelID" msprop:stats_StDevWidth="0.5425087" msprop:stats_UniqueValuePercent="40" msprop:FriendlyName="ProductModelID" msprop:design-time-name="0edcec59-bb36-4c80-9b03-e32e9e09b809" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="119" msprop:stats_AvgWidth="1.891525" msprop:DbColumnName="ProductModelID" type="xs:int" minOccurs="0" />
                  <xs:element name="SellStartDate" msprop:FriendlyName="SellStartDate" msprop:DbColumnName="SellStartDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="f43b8645-56cd-4e1a-91aa-57986c106a96" msprop:stats_UniqueValueCount="4" type="xs:dateTime" />
                  <xs:element name="SellEndDate" msprop:FriendlyName="SellEndDate" msprop:DbColumnName="SellEndDate" msprop:stats_UniqueValuePercent="2" msprop:design-time-name="602b3ac0-1217-4357-9ce6-09a52ecf3553" msprop:stats_UniqueValueCount="2" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="DiscontinuedDate" msprop:FriendlyName="DiscontinuedDate" msprop:DbColumnName="DiscontinuedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="4841ef23-2705-42ea-88ae-573fd11780f6" msprop:stats_UniqueValueCount="0" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="rowguid" msdata:DataType="System.Guid, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="rowguid" msprop:design-time-name="043db304-e6bd-49b2-ad95-e080bdf48a2e" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="504" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="f3004ed0-379f-4253-9687-92aced37d9cf" msprop:stats_UniqueValueCount="2" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_Customer" />
          <xs:field xpath="CustomerID" />
        </xs:unique>
        <xs:unique name="Sales_Store_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_Store" />
          <xs:field xpath="CustomerID" />
        </xs:unique>
        <xs:unique name="Sales_Individual_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_Individual" />
          <xs:field xpath="CustomerID" />
        </xs:unique>
        <xs:unique name="Sales_CustomerAddress_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_CustomerAddress" />
          <xs:field xpath="CustomerID" />
          <xs:field xpath="AddressID" />
        </xs:unique>
        <xs:unique name="Sales_SalesOrderHeader_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_SalesOrderHeader" />
          <xs:field xpath="SalesOrderID" />
        </xs:unique>
        <xs:unique name="Sales_SalesTerritory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_SalesTerritory" />
          <xs:field xpath="TerritoryID" />
        </xs:unique>
        <xs:unique name="Production_ProductProductPhoto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_ProductProductPhoto" />
          <xs:field xpath="ProductID" />
          <xs:field xpath="ProductPhotoID" />
        </xs:unique>
        <xs:unique name="Production_ProductPhoto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_ProductPhoto" />
          <xs:field xpath="ProductPhotoID" />
        </xs:unique>
        <xs:unique name="Production_Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_Product" />
          <xs:field xpath="ProductID" />
        </xs:unique>
        <xs:keyref name="FK_ProductProductPhoto_Product_ProductID" refer="Production_Product_Constraint1">
          <xs:selector xpath=".//Production_ProductProductPhoto" />
          <xs:field xpath="ProductID" />
        </xs:keyref>
        <xs:keyref name="FK_ProductProductPhoto_ProductPhoto_ProductPhotoID" refer="Production_ProductPhoto_Constraint1">
          <xs:selector xpath=".//Production_ProductProductPhoto" />
          <xs:field xpath="ProductPhotoID" />
        </xs:keyref>
        <xs:keyref name="FK_SalesOrderHeader_Customer_CustomerID" refer="Constraint1">
          <xs:selector xpath=".//Sales_SalesOrderHeader" />
          <xs:field xpath="CustomerID" />
        </xs:keyref>
        <xs:keyref name="FK_SalesOrderHeader_SalesTerritory_TerritoryID" refer="Sales_SalesTerritory_Constraint1">
          <xs:selector xpath=".//Sales_SalesOrderHeader" />
          <xs:field xpath="TerritoryID" />
        </xs:keyref>
        <xs:keyref name="FK_CustomerAddress_Customer_CustomerID" refer="Constraint1">
          <xs:selector xpath=".//Sales_CustomerAddress" />
          <xs:field xpath="CustomerID" />
        </xs:keyref>
        <xs:keyref name="FK_Individual_Customer_CustomerID" refer="Constraint1">
          <xs:selector xpath=".//Sales_Individual" />
          <xs:field xpath="CustomerID" />
        </xs:keyref>
        <xs:keyref name="FK_Store_Customer_CustomerID" refer="Constraint1">
          <xs:selector xpath=".//Sales_Store" />
          <xs:field xpath="CustomerID" />
        </xs:keyref>
        <xs:keyref name="FK_Customer_SalesTerritory_TerritoryID" refer="Sales_SalesTerritory_Constraint1">
          <xs:selector xpath=".//Sales_Customer" />
          <xs:field xpath="TerritoryID" />
        </xs:keyref>
      </xs:element>
    </xs:schema>
  </Schema>
</DataSourceView>