foodmartsale dw.dsv

来自「SQL SERVER 2005数据挖掘与商务智能完全解决方案随书光盘,作者：朱德」· DSV 代码 · 共 692 行 · 第 1/4 页

            </xs:element>
            <xs:element name="dbo_store" msprop:FriendlyName="store" msprop:DbSchemaName="dbo" msprop:DbTableName="store" msprop:design-time-name="794c155f-153e-451a-98eb-0021332ddb0a" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="store_id" msprop:FriendlyName="store_id" msprop:DbColumnName="store_id" msprop:design-time-name="63fa5d48-e2ba-4ae2-aa48-ea02e6c5c535" type="xs:int" />
                  <xs:element name="store_type" msprop:FriendlyName="store_type" msprop:DbColumnName="store_type" msprop:design-time-name="9260f31d-1b86-4eaa-9451-fc7731e8d1e5" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="region_id" msprop:FriendlyName="region_id" msprop:DbColumnName="region_id" msprop:design-time-name="025d6c57-d676-495b-90a8-3afa4adddb78" type="xs:int" minOccurs="0" />
                  <xs:element name="store_name" msprop:FriendlyName="store_name" msprop:DbColumnName="store_name" msprop:design-time-name="1aadcb52-8a2b-4ec3-b5ac-b6307332f041" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_number" msprop:FriendlyName="store_number" msprop:DbColumnName="store_number" msprop:design-time-name="a6c348f6-9c59-4ecc-abb4-66758aad8111" type="xs:double" minOccurs="0" />
                  <xs:element name="store_street_address" msprop:FriendlyName="store_street_address" msprop:DbColumnName="store_street_address" msprop:design-time-name="15625416-ace6-448f-9ebf-446c855cac6d" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_city" msprop:FriendlyName="store_city" msprop:DbColumnName="store_city" msprop:design-time-name="124d74f8-8f10-4df6-baef-f75ff37cc369" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_state" msprop:FriendlyName="store_state" msprop:DbColumnName="store_state" msprop:design-time-name="416cefe9-af79-4421-b8f1-598081cfdc58" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_postal_code" msprop:FriendlyName="store_postal_code" msprop:DbColumnName="store_postal_code" msprop:design-time-name="168c5215-4e04-4bfa-9d1f-d78d235ceba8" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_country" msprop:FriendlyName="store_country" msprop:DbColumnName="store_country" msprop:design-time-name="4f60cca7-0175-425e-84ee-b77283fb9e99" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="50" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_manager" msprop:FriendlyName="store_manager" msprop:DbColumnName="store_manager" msprop:design-time-name="c36f12f8-4c44-4399-a986-3212cf9bd46c" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_phone" msprop:FriendlyName="store_phone" msprop:DbColumnName="store_phone" msprop:design-time-name="b0eb6bc1-fb21-4156-a034-ac5c3515b4ca" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="store_fax" msprop:FriendlyName="store_fax" msprop:DbColumnName="store_fax" msprop:design-time-name="a7f79149-32e9-4b44-a851-e38d91fea4ee" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="first_opened_date" msprop:FriendlyName="first_opened_date" msprop:DbColumnName="first_opened_date" msprop:design-time-name="c497a204-a994-49bf-8549-db12ec1ee898" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="last_remodel_date" msprop:FriendlyName="last_remodel_date" msprop:DbColumnName="last_remodel_date" msprop:design-time-name="9f607310-aa22-4bd6-8a51-3b998d7036e3" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="lease_sqft" msprop:FriendlyName="lease_sqft" msprop:DbColumnName="lease_sqft" msprop:design-time-name="e47a02e7-b1ba-45b4-bc27-663ccfbaf5b5" type="xs:double" minOccurs="0" />
                  <xs:element name="store_sqft" msprop:FriendlyName="store_sqft" msprop:DbColumnName="store_sqft" msprop:design-time-name="180e1220-ca5e-4015-a516-e27339847da8" type="xs:double" minOccurs="0" />
                  <xs:element name="grocery_sqft" msprop:FriendlyName="grocery_sqft" msprop:DbColumnName="grocery_sqft" msprop:design-time-name="d6d62a65-9660-4888-98f8-f8b668656003" type="xs:double" minOccurs="0" />
                  <xs:element name="frozen_sqft" msprop:FriendlyName="frozen_sqft" msprop:DbColumnName="frozen_sqft" msprop:design-time-name="3bb71d70-22af-4ba3-81f6-f839b7f96637" type="xs:double" minOccurs="0" />
                  <xs:element name="meat_sqft" msprop:FriendlyName="meat_sqft" msprop:DbColumnName="meat_sqft" msprop:design-time-name="36bd6630-3344-44da-9406-80507d1a7830" type="xs:double" minOccurs="0" />
                  <xs:element name="coffee_bar" msprop:FriendlyName="coffee_bar" msprop:DbColumnName="coffee_bar" msprop:design-time-name="69c4e8c8-37c9-4081-aec2-8d1f2cced030" type="xs:boolean" />
                  <xs:element name="video_store" msprop:FriendlyName="video_store" msprop:DbColumnName="video_store" msprop:design-time-name="6d0d2d27-4f6b-40d1-b60b-f1e3caba8e6f" type="xs:boolean" />
                  <xs:element name="salad_bar" msprop:FriendlyName="salad_bar" msprop:DbColumnName="salad_bar" msprop:design-time-name="e99d7f74-dd2d-47f2-862a-295b343037c7" type="xs:boolean" />
                  <xs:element name="prepared_food" msprop:FriendlyName="prepared_food" msprop:DbColumnName="prepared_food" msprop:design-time-name="586fbcd6-ea5e-4c21-9613-d3046c4ffc3a" type="xs:boolean" />
                  <xs:element name="florist" msprop:FriendlyName="florist" msprop:DbColumnName="florist" msprop:design-time-name="a1d761a0-b33a-445e-ad6c-f21af8eea4bb" type="xs:boolean" />
                </xs:sequence>
              </xs:complexType>
            </xs:element>
            <xs:element name="dbo_time_by_day" msprop:FriendlyName="time_by_day" msprop:DbSchemaName="dbo" msprop:DbTableName="time_by_day" msprop:design-time-name="640f2725-296d-4dc4-ba5a-ac419dd3f096" msprop:TableType="Table">
              <xs:complexType>
                <xs:sequence>
                  <xs:element name="time_id" msprop:FriendlyName="time_id" msprop:DbColumnName="time_id" msprop:design-time-name="24e2c77a-80f0-4b09-bed2-3adb38e7c636" type="xs:int" />
                  <xs:element name="the_date" msprop:FriendlyName="the_date" msprop:DbColumnName="the_date" msprop:design-time-name="f1bf3a8e-af79-4c08-b3cc-8e8385318022" type="xs:dateTime" minOccurs="0" />
                  <xs:element name="the_day" msprop:FriendlyName="the_day" msprop:DbColumnName="the_day" msprop:design-time-name="b9d10d6b-e7f6-4210-b677-b8440d328dd4" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="the_month" msprop:FriendlyName="the_month" msprop:DbColumnName="the_month" msprop:design-time-name="af51dd5b-652a-464f-ad58-4f85d737fdde" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="15" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="the_year" msprop:FriendlyName="the_year" msprop:DbColumnName="the_year" msprop:design-time-name="dcd39dcc-82da-4474-87b4-ccd5422d36e0" type="xs:short" minOccurs="0" />
                  <xs:element name="day_of_month" msprop:FriendlyName="day_of_month" msprop:DbColumnName="day_of_month" msprop:design-time-name="a50d007a-e990-470b-9116-fe521bfadd83" type="xs:short" minOccurs="0" />
                  <xs:element name="week_of_year" msprop:FriendlyName="week_of_year" msprop:DbColumnName="week_of_year" msprop:design-time-name="815e9747-2918-46d9-9f46-403a1efd4fb7" type="xs:double" minOccurs="0" />
                  <xs:element name="month_of_year" msprop:FriendlyName="month_of_year" msprop:DbColumnName="month_of_year" msprop:design-time-name="c93846a6-4046-4f6c-a29b-ef27f2d5b41f" type="xs:short" minOccurs="0" />
                  <xs:element name="quarter" msprop:FriendlyName="quarter" msprop:DbColumnName="quarter" msprop:design-time-name="9bcaf5e0-66dc-4d42-9238-6499e59bd655" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="2" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                  <xs:element name="fiscal_period" msprop:FriendlyName="fiscal_period" msprop:DbColumnName="fiscal_period" msprop:design-time-name="2aef556e-fc19-4169-a087-a630a0c8ca26" minOccurs="0">
                    <xs:simpleType>
                      <xs:restriction base="xs:string">
                        <xs:maxLength value="255" />
                      </xs:restriction>
                    </xs:simpleType>
                  </xs:element>
                </xs:sequence>
              </xs:complexType>
            </xs:element>
          </xs:choice>
        </xs:complexType>
        <xs:unique name="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_customer" />
          <xs:field xpath="customer_id" />
        </xs:unique>
        <xs:unique name="dbo_product_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_product" />
          <xs:field xpath="product_id" />
        </xs:unique>
        <xs:unique name="dbo_product_class_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_product_class" />
          <xs:field xpath="product_class_id" />
        </xs:unique>
        <xs:unique name="dbo_promotion_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_promotion" />
          <xs:field xpath="promotion_id" />
        </xs:unique>
        <xs:unique name="dbo_store_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_store" />
          <xs:field xpath="store_id" />
        </xs:unique>
        <xs:unique name="dbo_time_by_day_Constraint1" msdata:ConstraintName="Constraint1" msprop:IsLogical="True" msdata:PrimaryKey="true">
          <xs:selector xpath=".//dbo_time_by_day" />
          <xs:field xpath="time_id" />
        </xs:unique>
      </xs:element>
      <xs:annotation>
        <xs:appinfo>
          <msdata:Relationship name="sales_fact_1998-time_by_day" msdata:parent="dbo_time_by_day" msdata:child="dbo_sales_fact_1998" msdata:parentkey="time_id" msdata:childkey="time_id" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="sales_fact_1998-promotion" msdata:parent="dbo_promotion" msdata:child="dbo_sales_fact_1998" msdata:parentkey="promotion_id" msdata:childkey="promotion_id" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="sales_fact_1998-store" msdata:parent="dbo_store" msdata:child="dbo_sales_fact_1998" msdata:parentkey="store_id" msdata:childkey="store_id" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="sales_fact_1998-customer" msdata:parent="dbo_customer" msdata:child="dbo_sales_fact_1998" msdata:parentkey="customer_id" msdata:childkey="customer_id" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="product-product_class" msdata:parent="dbo_product_class" msdata:child="dbo_product" msdata:parentkey="product_class_id" msdata:childkey="product_class_id" msprop:Description="" msprop:IsLogical="True" />
          <msdata:Relationship name="sales_fact_1998-product" msdata:parent="dbo_product" msdata:child="dbo_sales_fact_1998" msdata:parentkey="product_id" msdata:childkey="product_id" 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>