adventure works dw.dsv

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

              <xs:complexType>
                <xs:sequence>
                  <xs:element name="CustomerKey" msprop:FriendlyName="CustomerKey" msprop:DbColumnName="CustomerKey" msprop:design-time-name="84d93eb1-65e6-4aa2-a6a3-252108894fdc" type="xs:int" />
                  <xs:element name="Region" msprop:FriendlyName="Region" msprop:DbColumnName="Region" msprop:design-time-name="b19d5d04-905b-4f9b-b19d-46f2340ee590" 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="6f7bea6a-1fe2-425a-91c1-9c616ca39b0a" type="xs:int" minOccurs="0" />
                  <xs:element name="IncomeGroup" msprop:FriendlyName="IncomeGroup" msprop:DbColumnName="IncomeGroup" msprop:design-time-name="423f11a7-2331-4bc5-8811-ef8d2b0f04d2" 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="6c3ae9a0-b5cc-4759-b62d-9627eb2c3435" type="xs:decimal" minOccurs="0" />
                  <xs:element name="GeographyKey" msprop:FriendlyName="GeographyKey" msprop:DbColumnName="GeographyKey" msprop:design-time-name="4635f847-5f7a-401f-b4c7-5482f384d94f" type="xs:int" minOccurs="0" />
                  <xs:element name="CustomerAlternateKey" msprop:FriendlyName="CustomerAlternateKey" msprop:DbColumnName="CustomerAlternateKey" msprop:design-time-name="8fd97623-12e9-42a6-8bf1-cbebec75f3b5" 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="3f9639be-2c3f-4fff-858e-ff09d493ce35" 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="9e416777-11a9-4ef7-86a7-940289bdba95" 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="74440f0d-958c-4fae-b574-7614cc7ca98b" 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="596b171c-c638-4af3-825c-aef8d6603fe0" 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="700439c9-2c7b-4b44-b7a3-c9627077ade1" type="xs:boolean" minOccurs="0" />
                  <xs:element name="BirthDate" msprop:FriendlyName="BirthDate" msprop:DbColumnName="BirthDate" msprop:design-time-name="b6dbabb6-556a-4c80-9b35-23526a0fc144" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="MaritalStatus" msprop:FriendlyName="MaritalStatus" msprop:DbColumnName="MaritalStatus" msprop:design-time-name="1ee88e73-843d-439a-ba73-6c02a54a0229" 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="b7b82d18-2084-4af8-8a61-0044b1ad134d" type="xs:int" minOccurs="0" />
                  <xs:element name="Suffix" msprop:FriendlyName="Suffix" msprop:DbColumnName="Suffix" msprop:design-time-name="e483ea33-49ce-4e3c-89a5-e55aeb5da945" 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="05ab42c1-dea1-4266-b80d-c7025821b86c" 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="cc0b94da-e46c-4d11-a9cb-51af7afef8bf" type="xs:int" minOccurs="0" />
                  <xs:element name="EmailAddress" msprop:FriendlyName="EmailAddress" msprop:DbColumnName="EmailAddress" msprop:design-time-name="9ed565ae-3275-4701-abd1-53bb077f1c73" 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="40c7ff2d-7fbf-418a-97fb-0ec7f8349fbe" type="xs:decimal" minOccurs="0" />
                  <xs:element name="HasModerateIncome" msprop:FriendlyName="HasModerateIncome" msprop:DbColumnName="HasModerateIncome" msprop:design-time-name="0079edb1-17fa-4c82-8a8b-03f6aa70b3db" type="xs:int" minOccurs="0" />
                  <xs:element name="HasHighIncome" msprop:FriendlyName="HasHighIncome" msprop:DbColumnName="HasHighIncome" msprop:design-time-name="c23bacb6-20e5-4394-96f8-a349650ba936" type="xs:int" minOccurs="0" />
                  <xs:element name="HasKids" msprop:FriendlyName="HasKids" msprop:DbColumnName="HasKids" msprop:design-time-name="9821e9ed-0e7b-4668-becb-f32093e438af" type="xs:int" minOccurs="0" />
                  <xs:element name="TotalChildren" msprop:FriendlyName="TotalChildren" msprop:DbColumnName="TotalChildren" msprop:design-time-name="02ec5148-8f46-4775-b15d-22d3667b2106" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="NumberChildrenAtHome" msprop:FriendlyName="NumberChildrenAtHome" msprop:DbColumnName="NumberChildrenAtHome" msprop:design-time-name="0dbb292d-cfad-4946-942f-c7bf99ad8ad2" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="HasKidsAtHome" msprop:FriendlyName="HasKidsAtHome" msprop:DbColumnName="HasKidsAtHome" msprop:design-time-name="b2c49c5e-77d7-48b2-844a-87511ce380a3" type="xs:int" minOccurs="0" />
                  <xs:element name="EnglishEducation" msprop:FriendlyName="EnglishEducation" msprop:DbColumnName="EnglishEducation" msprop:design-time-name="316582b1-aece-4879-844c-510270579d9c" 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="628a3ce9-99b4-47ba-b54a-2031c5daa000" type="xs:int" minOccurs="0" />
                  <xs:element name="IsHSOnlyGrad" msprop:FriendlyName="IsHSOnlyGrad" msprop:DbColumnName="IsHSOnlyGrad" msprop:design-time-name="0f4db21b-2e5f-4702-95f6-15e3693ecf8b" type="xs:int" minOccurs="0" />
                  <xs:element name="IsCollegeGrad" msprop:FriendlyName="IsCollegeGrad" msprop:DbColumnName="IsCollegeGrad" msprop:design-time-name="9ff0158c-510f-48d1-9bde-d4cfd334918c" type="xs:int" minOccurs="0" />
                  <xs:element name="EnglishOccupation" msprop:FriendlyName="EnglishOccupation" msprop:DbColumnName="EnglishOccupation" msprop:design-time-name="43ea3469-5393-4e9f-a1b3-1857bfa85e93" 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="bce9ed2e-b80d-407b-9885-e3305df7d1cc" type="xs:int" minOccurs="0" />
                  <xs:element name="IsManual" msprop:FriendlyName="IsManual" msprop:DbColumnName="IsManual" msprop:design-time-name="c985873b-4ff4-4afc-a326-021ad2f0b84a" type="xs:int" minOccurs="0" />
                  <xs:element name="IsClerical" msprop:FriendlyName="IsClerical" msprop:DbColumnName="IsClerical" msprop:design-time-name="005d0425-876a-46c0-a44b-66fe57fb7396" type="xs:int" minOccurs="0" />
                  <xs:element name="IsManagement" msprop:FriendlyName="IsManagement" msprop:DbColumnName="IsManagement" msprop:design-time-name="fdb8e888-c86a-42b5-996f-f6f185b95d7d" type="xs:int" minOccurs="0" />
                  <xs:element name="IsSkilledManual" msprop:FriendlyName="IsSkilledManual" msprop:DbColumnName="IsSkilledManual" msprop:design-time-name="56866696-2091-4dd4-a2cb-4dee267ae78a" type="xs:int" minOccurs="0" />
                  <xs:element name="IsHomeOwner" msprop:FriendlyName="IsHomeOwner" msprop:DbColumnName="IsHomeOwner" msprop:design-time-name="71ac2fbd-deb3-4067-a6f5-7e487a92506b" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="1" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="NumberCarsOwned" msprop:FriendlyName="NumberCarsOwned" msprop:DbColumnName="NumberCarsOwned" msprop:design-time-name="61b1c5a2-0b36-45a2-9a4d-d41e6a0000cf" type="xs:unsignedByte" minOccurs="0" />
                  <xs:element name="IsCarOwner" msprop:FriendlyName="IsCarOwner" msprop:DbColumnName="IsCarOwner" msprop:design-time-name="b320d86f-bd73-477f-8794-f0f2666cf606" type="xs:int" minOccurs="0" />
                  <xs:element name="NumberCarsOwnedGroup" msprop:FriendlyName="NumberCarsOwnedGroup" msprop:DbColumnName="NumberCarsOwnedGroup" msprop:design-time-name="f633ceba-6ec2-4201-8f1a-26049061acdc" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="7" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="AddressLine1" msprop:FriendlyName="AddressLine1" msprop:DbColumnName="AddressLine1" msprop:design-time-name="732124f6-3023-43ba-8445-ac0e21991b44" minOccurs="0">
                    <xs:simpleType>