product sales.dsv

来自「< SQL Server2005程序设计>」· DSV 代码 · 共 515 行 · 第 1/4 页

                  </xs:element>
                  <xs:element name="CurrencyRateID" msprop:stats_StDevWidth="0.5522838" msprop:stats_UniqueValuePercent="17" msprop:FriendlyName="CurrencyRateID" msprop:design-time-name="084025f1-80df-49c3-a1ca-ee9458ca5e4e" 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="9395768f-6ccd-445b-992f-8210692b16ab" 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="8d6a2482-84b2-480d-bcd4-23d76d98cf07" 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="26f43265-b919-459f-884c-cca57748b17f" 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="34e3c1fb-2f0a-44b7-b649-bb263c90d476" 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="52f79cb9-e8c0-4526-abfb-43691e0e4367" 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="e3a0c8ff-40be-4514-976c-e161cf985f1d" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="31465" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:stats_UniqueValuePercent="3" msprop:DbColumnName="ModifiedDate" msprop:design-time-name="f770d5d6-61fc-406e-9692-74e26e4667f6" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_SalesOrderDetail" msprop:FriendlyName="SalesOrderDetail" msprop:DbSchemaName="Sales" msprop:DbTableName="SalesOrderDetail" msprop:design-time-name="f8b4d54c-1a56-4af0-ba9d-f5ef2da7b249" msprop:TableType="Table" msprop:stats_RowCount="121317">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="SalesOrderID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="25" msprop:FriendlyName="SalesOrderID" msprop:design-time-name="c43e0338-cccd-43cf-a4e5-83a68d4d7132" msprop:stats_MaxWidth="5" msprop:stats_UniqueValueCount="25689" msprop:stats_AvgWidth="5" msprop:DbColumnName="SalesOrderID" type="xs:int" />
                  <xs:element name="SalesOrderDetailID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.4513839" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesOrderDetailID" msprop:design-time-name="d8a8c5a7-dce0-4da7-a3b4-092975cd9d2f" msprop:stats_MaxWidth="6" msprop:stats_UniqueValueCount="100000" msprop:stats_AvgWidth="5.13713" msprop:DbColumnName="SalesOrderDetailID" type="xs:int" />
                  <xs:element name="CarrierTrackingNumber" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="5" msprop:FriendlyName="CarrierTrackingNumber" msprop:design-time-name="03c1b073-87de-4c12-a916-aa925346c6f4" msprop:stats_MaxWidth="12" msprop:stats_UniqueValueCount="2909" msprop:stats_AvgWidth="12" msprop:DbColumnName="CarrierTrackingNumber" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="25" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="OrderQty" msprop:stats_StDevWidth="0.1558516" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="OrderQty" msprop:design-time-name="f3c5cd3b-4d77-4e23-b1fd-a8dccc5b72c9" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="41" msprop:stats_AvgWidth="1.02491" msprop:DbColumnName="OrderQty" type="xs:short" />
                  <xs:element name="ProductID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="ProductID" msprop:design-time-name="0ebf7509-5a66-41ed-93fc-8afc5d7760fa" msprop:stats_MaxWidth="3" msprop:stats_UniqueValueCount="266" msprop:stats_AvgWidth="3" msprop:DbColumnName="ProductID" type="xs:int" />
                  <xs:element name="SpecialOfferID" msprop:stats_StDevWidth="0.1005279" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="SpecialOfferID" msprop:design-time-name="4f8ac781-4025-4d8f-a8d9-f943542a9e05" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="12" msprop:stats_AvgWidth="1.01021" msprop:DbColumnName="SpecialOfferID" type="xs:int" />
                  <xs:element name="UnitPrice" msprop:stats_StDevWidth="0.9937427" msprop:stats_AvgScale="1.86898" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="UnitPrice" msprop:design-time-name="d9a67867-ed1d-40b8-bc37-804e8d78ab63" msprop:stats_StDevScale="0.3984411" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="286" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="5.38353" msprop:DbColumnName="UnitPrice" type="xs:decimal" />
                  <xs:element name="UnitPriceDiscount" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0.03783" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="UnitPriceDiscount" msprop:design-time-name="e24bac56-9cce-48ab-8034-85498ff01e41" msprop:stats_StDevScale="0.2256976" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="9" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="4" msprop:DbColumnName="UnitPriceDiscount" type="xs:decimal" />
                  <xs:element name="LineTotal" msdata:ReadOnly="true" msprop:stats_StDevWidth="1.075074" msprop:stats_AvgScale="2.43524" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="LineTotal" msprop:design-time-name="b8d8213a-f663-4cf7-b406-f42da93f195b" msprop:stats_StDevScale="0.9201927" msprop:stats_MaxWidth="12" msprop:stats_UniqueValueCount="1464" msprop:stats_MaxScale="6" msprop:stats_AvgWidth="9.58937" msprop:DbColumnName="LineTotal" type="xs:decimal" />
                  <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="f304a50f-c4e6-46f7-bae0-75f76bf39109" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="100000" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:stats_UniqueValuePercent="0" msprop:DbColumnName="ModifiedDate" msprop:design-time-name="1ed3341b-0d3e-42c0-8de0-4be6ed87eab9" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="804" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_SalesTerritory" msprop:FriendlyName="SalesTerritory" msprop:DbSchemaName="Sales" msprop:DbTableName="SalesTerritory" msprop:design-time-name="1db03982-fd96-4327-bcf9-90cc7cdf0d98" msprop:TableType="Table" msprop:stats_RowCount="10">
              <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="d572703a-0b1d-4064-9564-549c5a10ae77" 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="d642ec0b-985c-48fb-9708-e6453666efb4" 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="eed97024-7909-45df-88b8-a6d14e01c882" 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="f8194d89-f9c8-41cd-8632-c855d8c94302" 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>
                  </xs:element>
                  <xs:element name="SalesYTD" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="1.9" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesYTD" msprop:design-time-name="16191190-197f-4b6f-871a-8320d01c3fe4" msprop:stats_StDevScale="0.3162278" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="10" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="10" msprop:DbColumnName="SalesYTD" type="xs:decimal" />
                  <xs:element name="SalesLastYear" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="1.8" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="SalesLastYear" msprop:design-time-name="b4374e18-d6db-43a9-9a08-879f8b8f6558" msprop:stats_StDevScale="0.421637" msprop:stats_MaxWidth="10" msprop:stats_UniqueValueCount="10" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="10" msprop:DbColumnName="SalesLastYear" type="xs:decimal" />
                  <xs:element name="CostYTD" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0" msprop:stats_UniqueValuePercent="10" msprop:FriendlyName="CostYTD" msprop:design-time-name="47aa517b-b7b9-4c16-81ab-7413de0556f6" msprop:stats_StDevScale="0" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="1" msprop:stats_MaxScale="0" msprop:stats_AvgWidth="4" msprop:DbColumnName="CostYTD" type="xs:decimal" />
                  <xs:element name="CostLastYear" msprop:stats_StDevWidth="0" msprop:stats_AvgScale="0" msprop:stats_UniqueValuePercent="10" msprop:FriendlyName="CostLastYear" msprop:design-time-name="075f2e88-7b77-48a0-95cd-a1c138e4027e" msprop:stats_StDevScale="0" msprop:stats_MaxWidth="4" msprop:stats_UniqueValueCount="1" msprop:stats_MaxScale="0" msprop:stats_AvgWidth="4" msprop:DbColumnName="CostLastYear" type="xs:decimal" />
                  <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="cbc471c5-0ca5-4fe2-91a7-45df40ea6509" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="10" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:stats_UniqueValuePercent="10" msprop:DbColumnName="ModifiedDate" msprop:design-time-name="c08ed6b2-4e7a-4992-a3a4-75d36257c70d" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_Product" />
          <xs:field xpath="ProductID" />
        </xs:unique>
        <xs:unique name="Production_ProductCategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_ProductCategory" />
          <xs:field xpath="ProductCategoryID" />
        </xs:unique>
        <xs:unique name="Production_ProductSubcategory_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Production_ProductSubcategory" />
          <xs:field xpath="ProductSubcategoryID" />
        </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_SalesOrderDetail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
          <xs:selector xpath=".//Sales_SalesOrderDetail" />
          <xs:field xpath="SalesOrderID" />
          <xs:field xpath="SalesOrderDetailID" />
        </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:keyref name="FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID" refer="Sales_SalesOrderHeader_Constraint1">
          <xs:selector xpath=".//Sales_SalesOrderDetail" />
          <xs:field xpath="SalesOrderID" />
        </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_ProductSubcategory_ProductCategory_ProductCategoryID" refer="Production_ProductCategory_Constraint1">
          <xs:selector xpath=".//Production_ProductSubcategory" />
          <xs:field xpath="ProductCategoryID" />
        </xs:keyref>
        <xs:keyref name="FK_Product_ProductSubcategory_ProductSubcategoryID" refer="Production_ProductSubcategory_Constraint1">
          <xs:selector xpath=".//Production_Product" />
          <xs:field xpath="ProductSubcategoryID" />
        </xs:keyref>
      </xs:element>
      <xs:annotation>
        <xs:appinfo>
          <msdata:Relationship name="SalesOrderDetail-Product" msdata:parent="Production_Product" msdata:child="Sales_SalesOrderDetail" msdata:parentkey="ProductID" msdata:childkey="ProductID" msprop:Description="" msprop:IsLogical="True" />
        </xs:appinfo>
      </xs:annotation>
    </xs:schema>
    <diffgr:diffgram xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:diffgr="urn:schemas-microsoft-com:xml-diffgram-v1" />
  </Schema>
</DataSourceView>