product sales.dsv

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

                        <xs:maxLength value="5" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="SizeUnitMeasureCode" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="SizeUnitMeasureCode" msprop:design-time-name="f41a8e47-9f2b-4b4d-a26e-4e972b270e27" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="1" msprop:stats_AvgWidth="2" msprop:DbColumnName="SizeUnitMeasureCode" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="3" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="WeightUnitMeasureCode" msprop:stats_StDevWidth="0.3493521" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="WeightUnitMeasureCode" msprop:design-time-name="440624e5-10e3-4e5e-96c3-6072682d2add" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1.858537" msprop:DbColumnName="WeightUnitMeasureCode" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="3" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Weight" msprop:stats_StDevWidth="0.7046338" msprop:stats_AvgScale="1.478049" msprop:stats_UniqueValuePercent="61" msprop:FriendlyName="Weight" msprop:design-time-name="42f72db8-1fdc-48d2-be3a-2247d2d9e508" msprop:stats_StDevScale="0.7894874" msprop:stats_MaxWidth="7" msprop:stats_UniqueValueCount="127" msprop:stats_MaxScale="2" msprop:stats_AvgWidth="4.760976" msprop:DbColumnName="Weight" type="xs:decimal" minOccurs="0" />
                  <xs:element name="DaysToManufacture" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="0" msprop:FriendlyName="DaysToManufacture" msprop:design-time-name="3ffeb5df-d1db-44d9-8717-5f02868657dd" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="DaysToManufacture" type="xs:int" />
                  <xs:element name="ProductLine" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="ProductLine" msprop:design-time-name="22fbec88-9a77-44d8-a6de-473d21b580e4" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="ProductLine" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Class" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="1" msprop:FriendlyName="Class" msprop:design-time-name="aa70c089-80c2-4509-a469-a8aabc938261" 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="cc8e3c9b-d478-423e-8e94-b56ed5969c90" 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="0f462c80-395c-41de-bc70-4e3032270743" 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="dc2bab2e-a7a3-46f6-ac49-8e845bc46f4e" 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:stats_UniqueValuePercent="0" msprop:DbColumnName="SellStartDate" msprop:design-time-name="6ef7d3dc-56aa-4ad2-bd0f-b20e7810fb4e" msprop:FriendlyName="SellStartDate" msprop:stats_UniqueValueCount="4" type="xs:dateTime" />
                  <xs:element name="SellEndDate" msprop:stats_UniqueValuePercent="2" msprop:DbColumnName="SellEndDate" msprop:design-time-name="3a9cd234-4ce6-475f-b667-574d9059cdba" msprop:FriendlyName="SellEndDate" msprop:stats_UniqueValueCount="2" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="DiscontinuedDate" msprop:stats_UniqueValuePercent="0" msprop:DbColumnName="DiscontinuedDate" msprop:design-time-name="081e9d45-665f-470e-81bf-44a5faab8c31" msprop:FriendlyName="DiscontinuedDate" 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="e7da3390-eec0-453b-ad8f-7a6e265168ff" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="504" 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="088f8cd0-6f06-424d-976d-319c4282cbc4" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="2" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Production_ProductCategory" msprop:FriendlyName="ProductCategory" msprop:DbSchemaName="Production" msprop:DbTableName="ProductCategory" msprop:design-time-name="c1ba17da-6d8a-4937-a908-ec379fa2e6f9" msprop:TableType="Table" msprop:stats_RowCount="4">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductCategoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductCategoryID" msprop:design-time-name="02dedfd3-8b72-45a2-b204-c41f906f8981" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="ProductCategoryID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="2.645751" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Name" msprop:design-time-name="2ece3147-5505-41f2-a63e-a6b39d23772b" msprop:stats_MaxWidth="11" msprop:stats_UniqueValueCount="4" 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="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="cddb0647-c647-4164-9505-e92f55db3f87" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:stats_UniqueValuePercent="25" msprop:DbColumnName="ModifiedDate" msprop:design-time-name="02e6efe8-6072-4b0a-851b-e9168c597c40" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Production_ProductSubcategory" msprop:FriendlyName="ProductSubcategory" msprop:DbSchemaName="Production" msprop:DbTableName="ProductSubcategory" msprop:design-time-name="41a120d6-028b-473d-a9be-c8d971eddc0a" msprop:TableType="Table" msprop:stats_RowCount="37">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="ProductSubcategoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:stats_StDevWidth="0.4349588" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="ProductSubcategoryID" msprop:design-time-name="f5b680d0-d5a8-4e6b-b2e6-70f16c4f011d" msprop:stats_MaxWidth="2" msprop:stats_UniqueValueCount="37" msprop:stats_AvgWidth="1.756757" msprop:DbColumnName="ProductSubcategoryID" type="xs:int" />
                  <xs:element name="ProductCategoryID" msprop:stats_StDevWidth="0" msprop:stats_UniqueValuePercent="10" msprop:FriendlyName="ProductCategoryID" msprop:design-time-name="62d972b8-90e2-4772-b5a9-dd1e14595d34" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="4" msprop:stats_AvgWidth="1" msprop:DbColumnName="ProductCategoryID" type="xs:int" />
                  <xs:element name="Name" msprop:stats_StDevWidth="3.6726" msprop:stats_UniqueValuePercent="100" msprop:FriendlyName="Name" msprop:design-time-name="f65ef9ad-9fca-4b91-b23e-3fd3d048ac5b" msprop:stats_MaxWidth="17" msprop:stats_UniqueValueCount="37" msprop:stats_AvgWidth="8.891891" msprop:DbColumnName="Name">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </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="919facdb-40c8-4a23-b8c6-0a1b6bb34f74" msprop:stats_MaxWidth="36" msprop:stats_UniqueValueCount="37" msprop:stats_AvgWidth="36" msprop:DbColumnName="rowguid" type="xs:string" />
                  <xs:element name="ModifiedDate" msprop:stats_UniqueValuePercent="2" msprop:DbColumnName="ModifiedDate" msprop:design-time-name="c41346d7-95ca-4f6e-8568-655414da5e1a" msprop:FriendlyName="ModifiedDate" msprop:stats_UniqueValueCount="1" type="xs:dateTime" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="Sales_SalesOrderHeader" msprop:FriendlyName="SalesOrderHeader" msprop:DbSchemaName="Sales" msprop:DbTableName="SalesOrderHeader" msprop:design-time-name="784e22cf-9190-4c81-9933-d729e9dd2486" msprop:TableType="Table" msprop:stats_RowCount="31465">
              <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="2dfc6f9f-5b6e-4d95-b90a-f96afcb96564" 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="e3e688bf-e89c-4402-a92e-b2ab27f0109f" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="2" msprop:stats_AvgWidth="1" msprop:DbColumnName="RevisionNumber" type="xs:unsignedByte" />
                  <xs:element name="OrderDate" msprop:stats_UniqueValuePercent="3" msprop:DbColumnName="OrderDate" msprop:design-time-name="707a96a8-002c-42fe-ae4a-213c6cd3580b" msprop:FriendlyName="OrderDate" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                  <xs:element name="DueDate" msprop:stats_UniqueValuePercent="3" msprop:DbColumnName="DueDate" msprop:design-time-name="1a8a8263-6a61-408b-a07d-3d66f4aa453e" msprop:FriendlyName="DueDate" msprop:stats_UniqueValueCount="1124" type="xs:dateTime" />
                  <xs:element name="ShipDate" msprop:stats_UniqueValuePercent="3" msprop:DbColumnName="ShipDate" msprop:design-time-name="4a34cf25-a6e0-4db4-a1ce-f51d9c41b591" msprop:FriendlyName="ShipDate" 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="da50171d-6394-4d75-862f-05b4923c4eb0" msprop:stats_MaxWidth="1" msprop:stats_UniqueValueCount="1" msprop:stats_AvgWidth="1" msprop:DbColumnName="Status" type="xs:unsignedByte" />
                  <xs:element name="OnlineOrderFlag" msprop:stats_UniqueValuePercent="0" msprop:DbColumnName="OnlineOrderFlag" msprop:design-time-name="abcf1ced-8754-4991-9f26-734a825e9401" msprop:FriendlyName="OnlineOrderFlag" 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="8c2b978a-a4ff-43d6-bc8a-6d0e7bed401c" 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="06a83d8e-b0de-49ce-b6ba-682ee10d0e4f" 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="dcca796d-136f-4e13-8077-208ec8cfd1ea" 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="9862b165-9ab3-4733-a4ca-1fba01ce44f5" 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="623194ad-9468-4bf6-b020-e5ec544c3f70" 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="42396b8e-74eb-4f8f-bbce-804287e1037e" 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="17b0dd07-7888-4958-8fce-766ac763c981" 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="58796374-a1ec-4f02-b961-155574b89d95" 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="89ca62fd-da2d-498d-918a-72b5cfd51fef" 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="ff5013c2-91a7-4c2e-a3bf-2b0ad137f4bc" 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="f71c9e8f-66ec-4586-822d-6328cd247ece" 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="b66bbe36-fd54-4ea3-ad6d-c50a639a8962" 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>