adventure works dw.dsv

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

                      <xs:restriction base="xs:string">
                        <xs:maxLength value="120" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AddressLine2" msprop:FriendlyName="AddressLine2" msprop:DbColumnName="AddressLine2" msprop:design-time-name="d63db65e-afab-4719-b063-9ed0248389ad" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="120" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Phone" msprop:FriendlyName="Phone" msprop:DbColumnName="Phone" msprop:design-time-name="a868b477-a9ec-4a0b-b2a2-ca4738092750" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="20" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="DateFirstPurchase" msprop:FriendlyName="DateFirstPurchase" msprop:DbColumnName="DateFirstPurchase" msprop:design-time-name="1515ee20-52df-45a4-ab43-5d95b9a878ae" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="CommuteDistance" msprop:FriendlyName="CommuteDistance" msprop:DbColumnName="CommuteDistance" msprop:design-time-name="a78639f5-2b15-4462-8946-cda23a1a4df1" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsNorthAmerica" msprop:FriendlyName="IsNorthAmerica" msprop:DbColumnName="IsNorthAmerica" msprop:design-time-name="6d703b20-b56e-4901-aa2d-e33fccc5bdcc" type="xs:int" minOccurs="0" />
                  <xs:element name="IsPacific" msprop:FriendlyName="IsPacific" msprop:DbColumnName="IsPacific" msprop:design-time-name="46a059d5-9537-4310-b068-3afc943adf94" type="xs:int" minOccurs="0" />
                  <xs:element name="IsEurope" msprop:FriendlyName="IsEurope" msprop:DbColumnName="IsEurope" msprop:design-time-name="b5c22fab-2072-490e-98af-c9f03c3332e3" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeUnder30" msprop:FriendlyName="AgeUnder30" msprop:DbColumnName="AgeUnder30" msprop:design-time-name="01a14056-4606-49ae-93f7-67937089a0cd" type="xs:int" minOccurs="0" />
                  <xs:element name="Age30_35" msprop:FriendlyName="Age30_35" msprop:DbColumnName="Age30_35" msprop:design-time-name="a856a1c2-b36e-4e78-987f-bb3eb4881025" type="xs:int" minOccurs="0" />
                  <xs:element name="Age36_45" msprop:FriendlyName="Age36_45" msprop:DbColumnName="Age36_45" msprop:design-time-name="91b2fe6a-7d0a-4b40-a067-9d803364df3b" type="xs:int" minOccurs="0" />
                  <xs:element name="Age46_55" msprop:FriendlyName="Age46_55" msprop:DbColumnName="Age46_55" msprop:design-time-name="f7f1e32b-e4a2-4d14-9b45-c6d4120c000e" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeOver55" msprop:FriendlyName="AgeOver55" msprop:DbColumnName="AgeOver55" msprop:design-time-name="3d3ede2f-233c-40ca-8543-6866950153a6" type="xs:int" minOccurs="0" />
                  <xs:element name="AgeGroup" msprop:FriendlyName="AgeGroup" msprop:DbColumnName="AgeGroup" msprop:design-time-name="43e6fb39-97ff-4d23-b2f7-31ace18a6c33" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="9" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AgeSquared" msprop:FriendlyName="AgeSquared" msprop:DbColumnName="AgeSquared" msprop:design-time-name="f25ea2ba-4b0d-4d43-9892-4ebfb8d2edaa" type="xs:int" minOccurs="0" />
                  <xs:element name="NumOrders" msprop:FriendlyName="NumOrders" msprop:DbColumnName="NumOrders" msprop:design-time-name="630a3a14-c850-4fca-8fdf-0dadbcc5be93" type="xs:int" minOccurs="0" />
                  <xs:element name="IsOneTimeCustomer" msprop:FriendlyName="IsOneTimeCustomer" msprop:DbColumnName="IsOneTimeCustomer" msprop:design-time-name="46008485-dd72-4fbd-8559-8649976f2da7" type="xs:int" minOccurs="0" />
                  <xs:element name="Recency" msprop:FriendlyName="Recency" msprop:DbColumnName="Recency" msprop:design-time-name="ccc80fc1-5755-406e-8ecb-4c859b06d482" type="xs:int" minOccurs="0" />
                  <xs:element name="IsWithin12Months" msprop:FriendlyName="IsWithin12Months" msprop:DbColumnName="IsWithin12Months" msprop:design-time-name="c9f161cb-fe2c-426a-94b1-509cffb80025" type="xs:int" minOccurs="0" />
                  <xs:element name="Is13_18Months" msprop:FriendlyName="Is13_18Months" msprop:DbColumnName="Is13_18Months" msprop:design-time-name="3b03370f-08bd-4b29-828d-9ac550b327f5" type="xs:int" minOccurs="0" />
                  <xs:element name="Is19_24Months" msprop:FriendlyName="Is19_24Months" msprop:DbColumnName="Is19_24Months" msprop:design-time-name="fbe32b2a-59be-4b0f-b2fa-4bd359c8f603" type="xs:int" minOccurs="0" />
                  <xs:element name="IsMoreThan24Months" msprop:FriendlyName="IsMoreThan24Months" msprop:DbColumnName="IsMoreThan24Months" msprop:design-time-name="192539b4-7a3c-427f-bad2-0bcdbae18565" type="xs:int" minOccurs="0" />
                  <xs:element name="RecencyGroup" msprop:FriendlyName="RecencyGroup" msprop:DbColumnName="RecencyGroup" msprop:design-time-name="689fe206-7218-462a-8ab6-4e4ffc13cec2" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="19" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumberOfProducts" msprop:FriendlyName="NumberOfProducts" msprop:DbColumnName="NumberOfProducts" msprop:design-time-name="ef50fd6c-cf3c-473f-b607-cc21c9dd81da" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdSquared" msprop:FriendlyName="NumProdSquared" msprop:DbColumnName="NumProdSquared" msprop:design-time-name="b4e0c01f-7b57-44c4-a929-694fcb6de76a" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdGroup" msprop:FriendlyName="NumProdGroup" msprop:DbColumnName="NumProdGroup" msprop:design-time-name="e7c2515a-b548-460e-9361-0895bd22871c" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsFewerThan5" msprop:FriendlyName="IsFewerThan5" msprop:DbColumnName="IsFewerThan5" msprop:design-time-name="05a99a49-7566-4f84-ac3e-479ed5158f93" type="xs:int" minOccurs="0" />
                  <xs:element name="NumProdHiLo" msprop:FriendlyName="NumProdHiLo" msprop:DbColumnName="NumProdHiLo" msprop:design-time-name="821fb170-27b1-4043-8af8-2760d869e13e" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="11" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumProdLast12" msprop:FriendlyName="NumProdLast12" msprop:DbColumnName="NumProdLast12" msprop:design-time-name="201b3c1e-b5f6-40e4-ae73-f6b137a1f4f8" type="xs:int" minOccurs="0" />
                  <xs:element name="Tenure" msprop:FriendlyName="Tenure" msprop:DbColumnName="Tenure" msprop:design-time-name="ebe35ee0-690b-4540-bf42-223488559c62" type="xs:int" minOccurs="0" />
                  <xs:element name="IsNewCustomer" msprop:FriendlyName="IsNewCustomer" msprop:DbColumnName="IsNewCustomer" msprop:design-time-name="82239ffc-f401-45bf-bf3c-d5e1789d5f7d" type="xs:int" minOccurs="0" />
                  <xs:element name="NewCustomerGroup" msprop:FriendlyName="NewCustomerGroup" msprop:DbColumnName="NewCustomerGroup" msprop:design-time-name="1513bca4-4cc3-479d-a21b-ff7217a2298f" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="11" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumBikes" msprop:FriendlyName="NumBikes" msprop:DbColumnName="NumBikes" msprop:design-time-name="6dd2aaee-a159-46d2-a4c7-aab8f56ffbe4" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueBikes" msprop:FriendlyName="RevenueBikes" msprop:DbColumnName="RevenueBikes" msprop:design-time-name="9dde6293-cffb-44ed-a14c-29e5543b626d" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitBikes" msprop:FriendlyName="ProfitBikes" msprop:DbColumnName="ProfitBikes" msprop:design-time-name="7a449d81-260f-438d-b794-49c86a80f239" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumComponents" msprop:FriendlyName="NumComponents" msprop:DbColumnName="NumComponents" msprop:design-time-name="a47da74f-f3aa-478f-8abe-585f756a4445" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueComponents" msprop:FriendlyName="RevenueComponents" msprop:DbColumnName="RevenueComponents" msprop:design-time-name="552b1ef6-f5f9-4a23-96ff-cad81d657bb2" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitComponents" msprop:FriendlyName="ProfitComponents" msprop:DbColumnName="ProfitComponents" msprop:design-time-name="72a7c704-bf09-4236-bfa5-dd52c9924c50" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumClothing" msprop:FriendlyName="NumClothing" msprop:DbColumnName="NumClothing" msprop:design-time-name="d3e84799-1987-4f3b-842a-4147a45f0989" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueClothing" msprop:FriendlyName="RevenueClothing" msprop:DbColumnName="RevenueClothing" msprop:design-time-name="229919fc-89b6-4a98-95ee-536ad3b4a5ea" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitClothing" msprop:FriendlyName="ProfitClothing" msprop:DbColumnName="ProfitClothing" msprop:design-time-name="6955060a-1dd2-484b-ac42-0d91589dd00c" type="xs:decimal" minOccurs="0" />
                  <xs:element name="NumAccessories" msprop:FriendlyName="NumAccessories" msprop:DbColumnName="NumAccessories" msprop:design-time-name="49aac3c4-0e80-4c25-9e40-6b89716bab50" type="xs:int" minOccurs="0" />
                  <xs:element name="RevenueAccessories" msprop:FriendlyName="RevenueAccessories" msprop:DbColumnName="RevenueAccessories" msprop:design-time-name="77ae80ed-544a-4fad-b84c-7ceb868786d2" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitAccessories" msprop:FriendlyName="ProfitAccessories" msprop:DbColumnName="ProfitAccessories" msprop:design-time-name="93743e8b-5848-4c6e-8654-30fe9af59b88" type="xs:decimal" minOccurs="0" />
                  <xs:element name="IsBikeBuyer" msprop:FriendlyName="IsBikeBuyer" msprop:DbColumnName="IsBikeBuyer" msprop:design-time-name="e46a67ce-9ac6-453e-8069-2ebd7a01cae0" type="xs:int" minOccurs="0" />
                  <xs:element name="IsComponentBuyer" msprop:FriendlyName="IsComponentBuyer" msprop:DbColumnName="IsComponentBuyer" msprop:design-time-name="0fac4cf9-0985-4e50-afef-51fa9d111fce" type="xs:int" minOccurs="0" />
                  <xs:element name="IsClothingBuyer" msprop:FriendlyName="IsClothingBuyer" msprop:DbColumnName="IsClothingBuyer" msprop:design-time-name="676d021a-69c2-4da7-89c0-567933e47872" type="xs:int" minOccurs="0" />
                  <xs:element name="IsAccessoryBuyer" msprop:FriendlyName="IsAccessoryBuyer" msprop:DbColumnName="IsAccessoryBuyer" msprop:design-time-name="62fae43a-fcad-472e-b291-3d2440918518" type="xs:int" minOccurs="0" />
                  <xs:element name="BikeBuyer" msprop:FriendlyName="BikeBuyer" msprop:DbColumnName="BikeBuyer" msprop:design-time-name="407b7d1d-b4c6-467e-a0d5-4f1861975677" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ComponentBuyer" msprop:FriendlyName="ComponentBuyer" msprop:DbColumnName="ComponentBuyer" msprop:design-time-name="642a6d5d-fb12-4ffe-9cbd-acf65a1e12c9" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="ClothingBuyer" msprop:FriendlyName="ClothingBuyer" msprop:DbColumnName="ClothingBuyer" msprop:design-time-name="c384dd4b-7d94-4305-910c-05b34e28640f" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AccessoryBuyer" msprop:FriendlyName="AccessoryBuyer" msprop:DbColumnName="AccessoryBuyer" msprop:design-time-name="b672e73a-aabf-4ee3-95a1-ebf582916af0" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Revenue" msprop:FriendlyName="Revenue" msprop:DbColumnName="Revenue" msprop:design-time-name="4c2d26e8-95de-44d5-81c2-25468e37dc66" type="xs:decimal" minOccurs="0" />
                  <xs:element name="IsHighProfit" msprop:FriendlyName="IsHighProfit" msprop:DbColumnName="IsHighProfit" msprop:design-time-name="4cb24253-0a44-4bc8-9991-7fdec0d67356" type="xs:int" minOccurs="0" />
                  <xs:element name="ProfitPerOrder" msprop:FriendlyName="ProfitPerOrder" msprop:DbColumnName="ProfitPerOrder" msprop:design-time-name="079a4d7b-b6b5-4aa0-8c96-77522e17aeb1" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitPerMonth" msprop:FriendlyName="ProfitPerMonth" msprop:DbColumnName="ProfitPerMonth" msprop:design-time-name="56774ed9-7808-49b6-ac87-4f1683ba43bb" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitMargin" msprop:FriendlyName="ProfitMargin" msprop:DbColumnName="ProfitMargin" msprop:design-time-name="00bcdcd3-6ff7-4ea2-94cc-231fd5bdd32e" type="xs:decimal" minOccurs="0" />
                  <xs:element name="RatioRevenueToTenure" msprop:FriendlyName="RatioRevenueToTenure" msprop:DbColumnName="RatioRevenueToTenure" msprop:design-time-name="48378610-2c32-40ec-9e53-98574b9a9242" type="xs:decimal" minOccurs="0" />