modeldemo.dsv

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

                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="5a54d179-2d6f-4e42-80e3-9f5f4bb60f89" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_CustomerAddress" msprop:FriendlyName="CustomerAddress" msprop:DbTableName="CustomerAddress" msprop:DbSchemaName="Sales" msprop:stats_RowCount="19220" msprop:design-time-name="94ba1256-a399-4d66-8f2f-207b79ddd2a2" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerID" msprop:stats_StDevWidth="0.4151314" msprop:stats_UniqueValuePercent="99" msprop:FriendlyName="CustomerID" msprop:design-time-name="764184a1-ca0e-4944-8f50-c77baa82ca86" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19185" msprop:stats_AvgWidth="4.920031" msprop:DbColumnName="CustomerID" type="xs:int" />
                  <xs:element name="AddressID" msprop:stats_StDevWidth="0.3668411" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="AddressID" msprop:design-time-name="4b71f41d-358c-4a80-a9c2-0f9ee01acdc1" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19220" msprop:stats_AvgWidth="4.92872" msprop:DbColumnName="AddressID" type="xs:int" />
                  <xs:element name="AddressTypeID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="AddressTypeID" msprop:design-time-name="39173374-1395-46cb-86f9-5b1afa2dae57" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="3" msprop:stats_AvgWidth="1" msprop:DbColumnName="AddressTypeID" type="xs:int" />
                  <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="6f825fe6-03e1-42fa-96e2-78278bdb746f" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="19220" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="5" msprop:design-time-name="4cd91197-dfc6-49fb-a757-165d06ba3aa9" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_SalesOrderHeader" msprop:FriendlyName="SalesOrderHeader" msprop:DbTableName="SalesOrderHeader" msprop:DbSchemaName="Sales" msprop:stats_RowCount="31465" msprop:design-time-name="fb1bba75-d7b4-436e-8789-aff47798218d" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="SalesOrderID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesOrderID" msprop:design-time-name="30d05f28-243b-4891-901d-8c65b67764a1" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="31465" msprop:stats_AvgWidth="5" msprop:DbColumnName="SalesOrderID" type="xs:int" />
                  <xs:element name="RevisionNumber" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="RevisionNumber" msprop:design-time-name="9f7ab386-7d8b-435b-ad2f-42793e0ef6b2" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1" msprop:DbColumnName="RevisionNumber" type="xs:unsignedByte" />
                  <xs:element name="OrderDate" msprop:FriendlyName="OrderDate" msprop:DbColumnName="OrderDate" msprop:stats_UniqueValuePercent="3" msprop:design-time-name="5faee19a-55f5-4cf3-84ab-c2485a88d3d6" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                  <xs:element name="DueDate" msprop:FriendlyName="DueDate" msprop:DbColumnName="DueDate" msprop:stats_UniqueValuePercent="3" msprop:design-time-name="ff0bae8c-cb6c-4b12-8295-2650c76f8683" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                  <xs:element name="ShipDate" msprop:FriendlyName="ShipDate" msprop:DbColumnName="ShipDate" msprop:stats_UniqueValuePercent="3" msprop:design-time-name="af98d330-1d1f-43bf-b258-881e5ee1e8e5" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="Status" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="Status" msprop:design-time-name="1067f08e-c1ef-4861-8665-b17a2a2edeaa" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="1" msprop:stats_AvgWidth="1" msprop:DbColumnName="Status" type="xs:unsignedByte" />
                  <xs:element name="OnlineOrderFlag" msprop:FriendlyName="OnlineOrderFlag" msprop:DbColumnName="OnlineOrderFlag" msprop:stats_UniqueValuePercent="0" msprop:design-time-name="5b77a27c-0df6-497c-9b87-204d4daadba4" msprop:stats_UniqueValueCount="2" type="xs:boolean" />
                  <xs:element name="SalesOrderNumber" msdata:ReadOnly="true" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesOrderNumber" msprop:design-time-name="76072152-2fd2-49bf-845c-b989ced355c7" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="31465" msprop:stats_AvgWidth="7" msprop:DbColumnName="SalesOrderNumber">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="25" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="PurchaseOrderNumber" msprop:stats_StDevWidth="0.5800955" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="PurchaseOrderNumber" msprop:design-time-name="256de469-901b-417e-9898-e32ab04b9863" msprop:stats_MaxWidth="13" msprop:stats_UniqueValueCount="3806" msprop:stats_AvgWidth="12.46348" msprop:DbColumnName="PurchaseOrderNumber" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="25" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AccountNumber" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="AccountNumber" msprop:design-time-name="f2db81f2-dfc5-492e-ac17-aa8224fea562" msprop:stats_MaxWidth="14" msprop:stats_UniqueValueCount="19119" msprop:stats_AvgWidth="14" msprop:DbColumnName="AccountNumber" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CustomerID" msprop:stats_StDevWidth="0.7211791" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="CustomerID" msprop:design-time-name="c208a996-548a-4eee-8d82-756632187533" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19119" msprop:stats_AvgWidth="4.737836" msprop:DbColumnName="CustomerID" type="xs:int" />
                  <xs:element name="ContactID" msprop:stats_StDevWidth="0.7414796" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="ContactID" msprop:design-time-name="d84cb7fb-f8d6-47bc-a647-982aa589c8fc" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19119" msprop:stats_AvgWidth="4.335293" msprop:DbColumnName="ContactID" type="xs:int" />
                  <xs:element name="SalesPersonID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="SalesPersonID" msprop:design-time-name="5577abdc-71e3-4ea2-8f94-5e01d01d8866" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="17" msprop:stats_AvgWidth="3" msprop:DbColumnName="SalesPersonID" type="xs:int" minOccurs="0" />
                  <xs:element name="TerritoryID" msprop:stats_StDevWidth="0.3030527" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="TerritoryID" msprop:design-time-name="d2b0db0f-3568-4b9e-8e43-5252c83d3354" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="1.102304" msprop:DbColumnName="TerritoryID" type="xs:int" minOccurs="0" />
                  <xs:element name="BillToAddressID" msprop:stats_StDevWidth="0.6136582" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="BillToAddressID" msprop:design-time-name="4a1809f2-b219-40bf-9366-952254ecef17" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19119" msprop:stats_AvgWidth="4.777308" msprop:DbColumnName="BillToAddressID" type="xs:int" />
                  <xs:element name="ShipToAddressID" msprop:stats_StDevWidth="0.6223407" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="ShipToAddressID" msprop:design-time-name="7e67b305-c797-47f8-9baa-616c4a71b2f6" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="19119" msprop:stats_AvgWidth="4.774448" msprop:DbColumnName="ShipToAddressID" type="xs:int" />
                  <xs:element name="ShipMethodID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="ShipMethodID" msprop:design-time-name="e043a6b9-68a5-4271-9ef6-647245afb6c5" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1" msprop:DbColumnName="ShipMethodID" type="xs:int" />
                  <xs:element name="CreditCardID" msprop:stats_StDevWidth="0.6086217" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="CreditCardID" msprop:design-time-name="8c852fae-1a30-4816-a219-71126d81af79" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="18384" msprop:stats_AvgWidth="4.42932" msprop:DbColumnName="CreditCardID" type="xs:int" minOccurs="0" />
                  <xs:element name="CreditCardApprovalCode" msprop:stats_StDevWidth="0.6479914" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="CreditCardApprovalCode" msprop:design-time-name="9b7a41dc-3a2e-4fcf-8d72-15e8eed63245" msprop:stats_MaxWidth="15" msprop:stats_UniqueValueCount="30334" msprop:stats_AvgWidth="13.01203" msprop:DbColumnName="CreditCardApprovalCode" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CurrencyRateID" msprop:stats_StDevWidth="0.5522838" msprop:stats_UniqueValuePercent="17" msprop:FriendlyName="CurrencyRateID" msprop:design-time-name="0a07bb1a-d062-4f89-a092-83ae5ea95bd6" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="2514" msprop:stats_AvgWidth="4.490055" msprop:DbColumnName="CurrencyRateID" type="xs:int" minOccurs="0" />
                  <xs:element name="SubTotal" msprop:stats_StDevWidth="1.084073" msprop:stats_AvgScale="1.89563" msprop:stats_UniqueValuePercent="15" msprop:FriendlyName="SubTotal" msprop:design-time-name="d0eb4542-d257-4a4f-8bc2-72c7512d1992" msprop:stats_StDevScale="0.3274291" msprop:stats_MaxWidth="9" msprop:stats_UniqueValueCount="4745" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="6.107421" msprop:DbColumnName="SubTotal" type="xs:decimal" />
                  <xs:element name="TaxAmt" msprop:stats_StDevWidth="0.9816594" msprop:stats_AvgScale="1.685238" msprop:stats_UniqueValuePercent="15" msprop:FriendlyName="TaxAmt" msprop:design-time-name="f291002d-91ca-40c2-bd97-34092e4652ef" msprop:stats_StDevScale="0.4660681" msprop:stats_MaxWidth="8" msprop:stats_UniqueValueCount="4745" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.080629" msprop:DbColumnName="TaxAmt" type="xs:decimal" />
                  <xs:element name="Freight" msprop:stats_StDevWidth="0.7031525" msprop:stats_AvgScale="1.790847" msprop:stats_UniqueValuePercent="15" msprop:FriendlyName="Freight" msprop:design-time-name="17d64f2f-f0e5-4af1-9d38-dda576218269" msprop:stats_StDevScale="0.4141443" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="4744" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="4.704021" msprop:DbColumnName="Freight" type="xs:decimal" />
                  <xs:element name="TotalDue" msdata:ReadOnly="true" msprop:stats_StDevWidth="1.079954" msprop:stats_AvgScale="1.808072" msprop:stats_UniqueValuePercent="15" msprop:FriendlyName="TotalDue" msprop:design-time-name="e805f3d3-26cb-43de-883f-9fa9ac281fd8" msprop:stats_StDevScale="0.399591" msprop:stats_MaxWidth="9" msprop:stats_UniqueValueCount="4745" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="6.127253" msprop:DbColumnName="TotalDue" type="xs:decimal" />
                  <xs:element name="Comment" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="Comment" msprop:design-time-name="5f7e5321-3373-40dd-b74a-7557c082e8ca" msprop:stats_MaxWidth="0" msprop:stats_UniqueValueCount="0" msprop:stats_AvgWidth="0" msprop:DbColumnName="Comment" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="128" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <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="27aacc27-5b5f-4ab6-85d4-15b2e1c3b61f" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="31465" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:FriendlyName="ModifiedDate" msprop:DbColumnName="ModifiedDate" msprop:stats_UniqueValuePercent="3" msprop:design-time-name="5b6b0bef-aff7-4571-b102-6ec07507b688" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_SalesTerritory" msprop:FriendlyName="SalesTerritory" msprop:DbTableName="SalesTerritory" msprop:DbSchemaName="Sales" msprop:stats_RowCount="10" msprop:design-time-name="45a6e2b0-66e8-48f4-93c9-d7ceb9265e08" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="TerritoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.3162278" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="TerritoryID" msprop:design-time-name="19a6c8b8-adea-4ee9-9e00-b0e2077edb05" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="1.1" msprop:DbColumnName="TerritoryID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="2.321398" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Name" msprop:design-time-name="8da7aaaa-b846-4ff4-bbfa-460c32011458" msprop:stats_MaxWidth="14" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="8.5" msprop:DbColumnName="Name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="CountryRegionCode" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="60" msprop:FriendlyName="CountryRegionCode" msprop:design-time-name="05406222-a37e-479e-b073-32930cca7d13" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="6" msprop:stats_AvgWidth="2" msprop:DbColumnName="CountryRegionCode">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="3" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Group" msprop:stats_StDevWidth="3.497618" msprop:stats_UniqueValuePercent="30" msprop:FriendlyName="Group" msprop:design-time-name="bf5cb22d-772a-425e-b4d1-c0225a7bb580" msprop:stats_MaxWidth="13" msprop:stats_UniqueValueCount="3" msprop:stats_AvgWidth="10.3" msprop:DbColumnName="Group">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>