adventure works dw.dsv

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

                  <xs:element name="RatioNumProdToTenure" msprop:FriendlyName="RatioNumProdToTenure" msprop:DbColumnName="RatioNumProdToTenure" msprop:design-time-name="4aac8b97-5389-40fd-9461-2b2dd0a85905" type="xs:decimal" minOccurs="0" />
                  <xs:element name="RatioProfitToTenure" msprop:FriendlyName="RatioProfitToTenure" msprop:DbColumnName="RatioProfitToTenure" msprop:design-time-name="9f19d2ad-72f2-4037-963f-6d9c1fc6cb5c" type="xs:decimal" minOccurs="0" />
                  <xs:element name="ProfitCategory" msdata:ReadOnly="true" msprop:design-time-name="ec279d28-eb7f-47ba-bcbb-bb31abbb8cb9" msprop:DbColumnName="ProfitCategory" msprop:ComputedColumnExpression="Case &#xD;&#xA;  When Profit&gt;1077 Then 'High'&#xD;&#xA;  Else 'Low'&#xD;&#xA;End" msprop:Description="High profit customers in the top quartile of profit" msprop:IsLogical="True">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="4" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_TestingCustomers" msprop:FriendlyName="TestingCustomers" msprop:DbSchemaName="dbo" msprop:DbTableName="TestingCustomers" msprop:design-time-name="351552f9-09f7-492a-a24a-3773a71a9e58" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerKey" msprop:FriendlyName="CustomerKey" msprop:DbColumnName="CustomerKey" msprop:design-time-name="6ce8fc18-2626-42dc-9279-1e937f9d3705" type="xs:int" />
                  <xs:element name="Region" msprop:FriendlyName="Region" msprop:DbColumnName="Region" msprop:design-time-name="a5b158ff-a3bc-4e5b-a930-559fbb82d88d" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Age" msprop:FriendlyName="Age" msprop:DbColumnName="Age" msprop:design-time-name="087c40cb-374a-4038-adc2-ee9561bf0004" type="xs:int" minOccurs="0" />
                  <xs:element name="IncomeGroup" msprop:FriendlyName="IncomeGroup" msprop:DbColumnName="IncomeGroup" msprop:design-time-name="65d70f41-5c04-4303-8a67-c8bf3fde8119" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="8" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Profit" msprop:FriendlyName="Profit" msprop:DbColumnName="Profit" msprop:design-time-name="beb4a7ff-7443-459a-973b-19fed8338a4a" type="xs:decimal" minOccurs="0" />
                  <xs:element name="GeographyKey" msprop:FriendlyName="GeographyKey" msprop:DbColumnName="GeographyKey" msprop:design-time-name="7d9a7048-76a3-4339-9d15-d529e2b76e4c" type="xs:int" minOccurs="0" />
                  <xs:element name="CustomerAlternateKey" msprop:FriendlyName="CustomerAlternateKey" msprop:DbColumnName="CustomerAlternateKey" msprop:design-time-name="bf704650-69a4-4b80-836b-df68efc1f9e3" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Title" msprop:FriendlyName="Title" msprop:DbColumnName="Title" msprop:design-time-name="3b9b92de-227d-4324-9032-7a5507da0394" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="8" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="FirstName" msprop:FriendlyName="FirstName" msprop:DbColumnName="FirstName" msprop:design-time-name="5d64f5e8-bfb4-451a-ade5-6bc173b07ed9" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="MiddleName" msprop:FriendlyName="MiddleName" msprop:DbColumnName="MiddleName" msprop:design-time-name="cfe452b9-4fc8-4300-916d-bd31926ebf49" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="LastName" msprop:FriendlyName="LastName" msprop:DbColumnName="LastName" msprop:design-time-name="df1cd57a-9dad-42c7-b497-4c829f1fff4f" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NameStyle" msprop:FriendlyName="NameStyle" msprop:DbColumnName="NameStyle" msprop:design-time-name="3d1513fe-1e25-4b33-bce1-cdbf1a4d6aa1" type="xs:boolean" minOccurs="0" />
                  <xs:element name="BirthDate" msprop:FriendlyName="BirthDate" msprop:DbColumnName="BirthDate" msprop:design-time-name="e724edb3-125e-4b7a-a1a6-148e2aa4d80d" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="MaritalStatus" msprop:FriendlyName="MaritalStatus" msprop:DbColumnName="MaritalStatus" msprop:design-time-name="556c695e-2a98-47a9-8c15-605482472712" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsMarried" msprop:FriendlyName="IsMarried" msprop:DbColumnName="IsMarried" msprop:design-time-name="f9082dcc-92e5-4ccf-802a-69e28ced5f34" type="xs:int" minOccurs="0" />
                  <xs:element name="Suffix" msprop:FriendlyName="Suffix" msprop:DbColumnName="Suffix" msprop:design-time-name="50ccedb1-95a7-41a6-9b03-3c94ac1caa78" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="10" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="Gender" msprop:FriendlyName="Gender" msprop:DbColumnName="Gender" msprop:design-time-name="4be87c06-c941-4ad5-bb49-9744803b46c7" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsMale" msprop:FriendlyName="IsMale" msprop:DbColumnName="IsMale" msprop:design-time-name="88f9aa90-ead4-4677-add2-f224b7e057cb" type="xs:int" minOccurs="0" />
                  <xs:element name="EmailAddress" msprop:FriendlyName="EmailAddress" msprop:DbColumnName="EmailAddress" msprop:design-time-name="14bee63e-fb3c-4013-8cc7-6193bca26613" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="YearlyIncome" msprop:FriendlyName="YearlyIncome" msprop:DbColumnName="YearlyIncome" msprop:design-time-name="e7c26f03-783e-4414-980a-582f09c21c89" type="xs:decimal" minOccurs="0" />
                  <xs:element name="HasModerateIncome" msprop:FriendlyName="HasModerateIncome" msprop:DbColumnName="HasModerateIncome" msprop:design-time-name="5bf1983d-8a13-4c03-b782-abc2dcaa920a" type="xs:int" minOccurs="0" />
                  <xs:element name="HasHighIncome" msprop:FriendlyName="HasHighIncome" msprop:DbColumnName="HasHighIncome" msprop:design-time-name="d5adbd47-b7b7-4901-bc76-c80e451149a2" type="xs:int" minOccurs="0" />
                  <xs:element name="HasKids" msprop:FriendlyName="HasKids" msprop:DbColumnName="HasKids" msprop:design-time-name="49ff9f3e-6dbf-46c1-9228-bd61b98494c2" type="xs:int" minOccurs="0" />
                  <xs:element name="TotalChildren" msprop:FriendlyName="TotalChildren" msprop:DbColumnName="TotalChildren" msprop:design-time-name="f531132f-cdc9-4bea-b673-92e018338cdb" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="NumberChildrenAtHome" msprop:FriendlyName="NumberChildrenAtHome" msprop:DbColumnName="NumberChildrenAtHome" msprop:design-time-name="7671fc25-b333-43e6-aecd-0bc253e03982" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="HasKidsAtHome" msprop:FriendlyName="HasKidsAtHome" msprop:DbColumnName="HasKidsAtHome" msprop:design-time-name="1ea2fea7-7129-43a1-899c-c59584457148" type="xs:int" minOccurs="0" />
                  <xs:element name="EnglishEducation" msprop:FriendlyName="EnglishEducation" msprop:DbColumnName="EnglishEducation" msprop:design-time-name="97aa8b52-d58f-4f36-b48e-337c329a9b7e" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="40" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsHSGrad" msprop:FriendlyName="IsHSGrad" msprop:DbColumnName="IsHSGrad" msprop:design-time-name="c99e3952-1124-436c-8e01-e9c1eeac43a9" type="xs:int" minOccurs="0" />
                  <xs:element name="IsHSOnlyGrad" msprop:FriendlyName="IsHSOnlyGrad" msprop:DbColumnName="IsHSOnlyGrad" msprop:design-time-name="c65cedbf-36e3-40fe-a693-78e675762b1e" type="xs:int" minOccurs="0" />
                  <xs:element name="IsCollegeGrad" msprop:FriendlyName="IsCollegeGrad" msprop:DbColumnName="IsCollegeGrad" msprop:design-time-name="40911576-36dc-4d82-a7e1-9e3658f101ae" type="xs:int" minOccurs="0" />
                  <xs:element name="EnglishOccupation" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="3ffd325b-1c0a-4b3b-8021-07db0282ad3a" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="100" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="IsProfessional" msprop:FriendlyName="IsProfessional" msprop:DbColumnName="IsProfessional" msprop:design-time-name="8ab5078c-5eb1-463a-b1cb-32debab28461" type="xs:int" minOccurs="0" />
                  <xs:element name="IsManual" msprop:FriendlyName="IsManual" msprop:DbColumnName="IsManual" msprop:design-time-name="d37de6a5-43d6-4e4a-bdcc-8999b23adcb8" type="xs:int" minOccurs="0" />
                  <xs:element name="IsClerical" msprop:FriendlyName="IsClerical" msprop:DbColumnName="IsClerical" msprop:design-time-name="30bb2091-ae95-4f9c-ac25-6ad6b95d0d90" type="xs:int" minOccurs="0" />
                  <xs:element name="IsManagement" msprop:FriendlyName="IsManagement" msprop:DbColumnName="IsManagement" msprop:design-time-name="7b5b47da-052b-4485-9c46-5991bef4c004" type="xs:int" minOccurs="0" />
                  <xs:element name="IsSkilledManual" msprop:FriendlyName="IsSkilledManual" msprop:DbColumnName="IsSkilledManual" msprop:design-time-name="f776313a-32fb-41c5-964a-6ffa94789676" type="xs:int" minOccurs="0" />
                  <xs:element name="IsHomeOwner" msprop:FriendlyName="IsHomeOwner" msprop:DbColumnName="IsHomeOwner" msprop:design-time-name="83edda45-e73f-44eb-925c-673c3fc0f454" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>